jsp测试连接mysql,用JSP测试MySQL数据库的准确连接

用JSP测试MySQL数据库的正确连接

//驱动程序名

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("
");

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("
");

}

out.print("
");

out.print("数据库操作成功，恭喜你");

rs.close();

statement.close();

connection.close();

%>