首先下载mysql-connector-java-5.1.10.zip
将里面的mysql-connector-java-5.1.10-bin.jar文件放入Tomcat 5.5\common\lib
重启Tomcat。
新建一个JSP文件
输入:
String url ="jdbc:mysql://localhost/表名?user=用户名&password=密码&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select * from 表单名";
ResultSet rs=stmt.executeQuery(query);
while(rs.next()){ String s=rs.getString("要查询的项,如username");
out.print(s+"
");
}
%>