关于JSP+Mysql的一个菜鸟问题
刚开始学在JSP中用JDBC访问MYSQL,想用SQL语句执行SELECT数据库中表单的内容,结果数据库连上了但页面中什么内容都没有显示(包括HTML也没有),请问这是怎么回事?
代码:
<%@ page contentType="text/html;charset=gbk" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.io.*" %>
<%
String driverName = "com.mysql.jdbc.Driver";
String userName = "root";
String userPasswd = "jing";
String dbName = "student";
String tableName = "studentInfo";
String url = "jdbc:mysql://localhost:3306/"+dbName+"?user="+userName+"&password="+userPasswd;
try
{
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection conn = DriverManager.getConnection(url);
Statement stmt = conn.createStatement();
String sql = "SELECT * FROM "+tableName;
ResultSet rs = stmt.executeQuery(sql);
ResultSetMetaData rmeta = rs.getMetaData();
int numColnums = rmeta.getColumnCount();
out.print("<center>");
out.print("<h3>数据记录显示</h3>");
out.print("<table border=1 width='80%' >");
out.print("<tr><th>学号</th><th>姓名</th><th>联系电话</th></tr>");
while(rs.next())
{
out.print("<tr><td>"+rs.getString(1)+"</td>");
out.print("<td>"+rs.getString(2)+"</td>");
out.print("<td>"+rs.getString(3)+"</td></tr>");
}
out.print("</table>");
out.print("</center>");
rs.close();
stmt.close();
conn.close();
}
catch(Exception e)
{
out.println("连接失败");
out.println(e.toString());
}
%>