1. <%@ page contentType="text/html;charset=GB2312" %> 2. 3. <%@ page import="java.sql.*" %> 4. 5. <HTML> 6. 7. <BODY> 8. 9. <% 10. 11. Connection con; 12. 13. Statement sql; 14. 15. ResultSet rs; 16. 17. try{ 18. 19. Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 20. 21. } 22. 23. catch(ClassNotFoundException e){} 24. 25. try { 26. 27. con=DriverManager.getConnection("jdbc:odbc:sun","sa",""); 28. 29. sql=con.createStatement(); 30. 31. rs=sql.executeQuery("SELECT * FROM students"); 32. 33. out.print("<Table Border>"); 34. 35. out.print("<TR>"); 36. 37. out.print("<TH width=100>"+"学号"); 38. 39. out.print("<TH width=100>"+"姓名"); 40. 41. out.print("<TH width=50>"+"数学成绩"); 42. 43. out.print("<TH width=50>"+"英语成绩"); 44. 45. out.print("<TH width=50>"+"物理成绩"); 46. 47. out.print("</TR>"); 48. 49. while(rs.next()) 50. 51. { 52. 53. out.print("<TR>"); 54. 55. out.print("<TD >"+rs.getString(1)+"</TD>"); 56. 57. out.print("<TD >"+rs.getString(2)+"</TD>"); 58. 59. out.print("<TD >"+rs.getInt("数学成绩")+"</TD>"); 60. 61. out.print("<TD >"+rs.getInt("英语成绩")+"</TD>"); 62. 63. out.print("<TD >"+rs.getInt("物理成绩")+"</TD>"); 64. 65. out.print("</TR>") ; 66. 67. } 68. 69. out.print("</Table>"); 70. 71. con.close(); 72. 73. } 74. 75. catch(SQLException e1) {} 76. 77. %> 78. 79. </BODY> 80. 81. </HTML>