📄 book.jsp
字号:
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*" %>
<html>
<head>
<title>图书一览</title>
</head>
<body>
<%
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String strConn="jdbc:odbc:sun";
conn=DriverManager.getConnection(strConn,"","");
Statement stmt=conn.createStatement();
ResultSet rs=stmt.executeQuery("SELECT * FROM book");
%>
<center><font size=5>本图书馆的所有藏书</font></center>
<table width="80%" height="50" border="6" align="center" bgcolor="#FFFFFF" frame="hsides" bordercolor="#9900FF">
<tr>
<th>图书编号</th>
<th>图书名称</th>
<th>作者</th>
<th>出版社</th>
<th>发行年</th>
<th>简介</th>
</tr>
<%
while(rs.next()){ String id = rs.getString("id");
%>
<tr>
<td nowrap><a href="book2.jsp?id=<%=id %>"><%=id%></a></td>
<td nowrap>《<%=rs.getString("name") %>》</td>
<td nowrap><%=rs.getString("zuozhe") %></td>
<td nowrap><%=rs.getString("chubanshe") %></td>
<td nowrap><%=rs.getString("faxingnian") %>年</td>
<td nowrap><%=rs.getString("jianjie") %></td>
</tr>
<%} %>
</table>
<%rs.close();stmt.close();conn.close(); %>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -