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