Question

如何在jsp上查询并显示数据库mysql的数据表

Answer 1

在页面中写Java片段 比如:
<%
//驱动程序名
String driverName = "com.mysql.jdbc.Driver";
//数据库用户名
String userName = "自己的";
//密码
String userPasswd = "自己的";
//数据库名
String dbName = "自己的";
//表名
String tableName = "自己的";
//联结字符串
String url = "jdbc:mysql://localhost:3306/" + 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);
%>