大家看我这段代码,为什么显示不出来结果?
<%@ page contentType="text/html; charset=GB2312"%>
<%@ page import="java.sql.*"%>
<HTML>
<BODY>
<% Connection con;
Statement sql;
ResultSet rs;
try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch (ClassNotFoundException e){ }
try { con=DriverManager.getConnection("jdbc: odbc: sun","sa","sa");
sql=con.createStatement();
rs=sql.executeQuery("SELECT * FROM students");
out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=100>"+"学号");
out.print("<TH width=50>"+"姓名");
out.print("<TH width=100>"+"数学成绩");
out.print("<TH width=100>"+"英语成绩");
out.print("<TH width=100>"+"物理成绩");
out.print("<TR>");
while (rs.next())
{
out.print("<TR>");
out.print("<TD>"+rs.getString(1)+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getInt("数学成绩")+"</TD>");
out.print("<TD>"+rs.getInt("英语成绩")+"</TD>");
out.print("<TD>"+rs.getInt("物理成绩")+"</TD>");
out.print("<TR>");
}
out.print("</Table>");
con.close();
}
catch(SQLException e1) {}
%>
</BODY>
</HTML>
我用ODBC数据源建立了一个"sun"的数据源,并且也测试通过了。
不知道为什么,我http://localhost:8080/myJSP/Example5_1.jsp执行后,网页中显示空白,其他不连数据库的JSP程序运行都正常。