jsp连接SQL SERVER失败?
<% 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","820921");
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("student_math")+"</TD>");
out.print("<TD>"+rs.getInt("student_english")+"</TD>");
out.print("<TD>"+rs.getInt("student_chinese")+"</TD>");
out.print("</TR>");
}
out.print("/Table");
con.close();
}
catch(SQLException ee){}
%>
</BODY>
</HTML>
我已经添加数据源.