(请求各位了)JSP,我也不知道是哪里的原因
把下面的代码保存一个文件,然后在JSWDK下执行。为什么执行不了呢,提示:HTTP 500 - 内部服务器错误
但运行别的程序可以执行。请教各位了。我是初学者,想连通数据库,但一直连不上,所以学起来快没有兴趣了。帮帮小弟啦。多谢!!
<%@ 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","123");
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=100>"+"姓名");
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("</tabel>");
con.close();
}
catch(SQLException el){}
%>
</body>
</html>