📄 executeorderby.jsp
字号:
<%@page contentType="text/html"%><%@page pageEncoding="GB2312"%><%@page import = "java.sql.*"%><html> <head><title>排序查询结果</title></head> <body> <font size="5" color="green">成绩排名</font> <hr> <table border="1"> <tr ><th>名次</th><th>姓名</th><th>语文</th></tr> <% Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection con = DriverManager.getConnection("jdbc:odbc:webData"); Statement smt = con.createStatement(); String sql = "SELECT Name,Chinese FROM grades ORDER BY chinese DESC"; ResultSet rs = smt.executeQuery(sql); int num=1; while(rs.next()){ out.println("<tr><td>" + num + "</td><td>" + rs.getString(1) + "</td>"+ "<td>" + rs.getInt(2) +"</td></tr>"); num++; } %> </table> </body></html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -