用JSP测试MySQL数据库的正确连接
<%@ page language="java" contentType="text/html; charset=gb2312"%><%@ page import="com.mysql.jdbc.Driver"%><%@ page import="java.sql.*"%><%//驱动程序名String driverName = "com.mysql.jdbc.Driver";//数据库用户名String userName = "root";//密码String userPasswd = "admin";//数据库名String dbName = "footprint";//表名String tableName = "user";//联结字符串String url = "jdbc:mysql://localhost/" + dbName + "?user="+ userName + "&password=" + userPasswd;Class.forName("com.mysql.jdbc.Driver").newInstance();Connection connection = DriverManager.getConnection(url);Statement statement = connection.createStatement();String sql = "SELECT * FROM " + tableName;ResultSet rs = statement.executeQuery(sql);//获得数据结果集合ResultSetMetaData rmeta = rs.getMetaData();//确定数据集的列数，亦字段数int numColumns = rmeta.getColumnCount();// 输出每一个数据值out.print("id");out.print("|");out.print("name");out.print("|");out.print("password");out.print("|");out.print("detail");out.print("<br>");while (rs.next()) {out.print(rs.getInt(1) + " ");out.print("|");out.print(rs.getString(2));out.print("|");out.print(rs.getString(3));out.print("|");out.print(rs.getString(4));out.print("<br>");}out.print("<br>");out.print("数据库操作成功，恭喜你");rs.close();statement.close();connection.close();%>?