📄 tushupaihang.jsp
字号:
<%@page contentType="text/html;charset=gbk" %><style type="text/css">
<!--
body {
background-image: url();
background-color: #FFCCFF;
}
.STYLE1 {
font-size: large;
font-weight: bold;
}
.STYLE2 {font-size: medium}
-->
</style>
<%@page import="java.sql.*" %>
<html>
<body>
<div> <font color="red"><b><big>图书被借排名</big></b><br>
名称
被借次数 </font></div>
</body>
</html>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=webapps/booksystem/db/bs.mdb;");
Statement sql=con.createStatement();
ResultSet rs=sql.executeQuery("select bookname,bookcount from books order by bookcount desc");
while(rs.next()){
String a,b;
out.print("<table border>");
out.print("<tr>");
a=rs.getString(1);
out.print("<td width=450>"+a+"</td>");
b=rs.getString(2);
out.print("<td width=50>"+b+"</td>");
out.print("</tr>");
out.print("</table>");
}
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -