📄 book2.jsp
字号:
<%@ page language="java" import="java.sql.*" pageEncoding="gbk"%>
<html>
<head>
<title>图书详细信心</title>
</head>
<body>
<%
request.setCharacterEncoding("gbk");
String id=request.getParameter("id");
Connection conn=null;
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String strConn="jdbc:odbc:sun";
conn=DriverManager.getConnection(strConn,"","");
Statement stmt=conn.createStatement();
String sql="SELECT * FROM book where id='"+id+"' ";
ResultSet rs=stmt.executeQuery(sql);
rs.next();
String bookname=rs.getString("name");
%>
<center><font size=5>有关<font color=red size=5>《<%=bookname %>》</font>的详细信息</font></center>
<table width="70%" height="50" border="6" align="center" bgcolor="#FFFFFF" frame="hsides" bordercolor="#9900FF">
<th>图书编号：</th>
<th>图书名称：</th>
<th>出版社：</th>
<th>发行年份：</th>
<th>图片：</th>
<tr>
<td nowrap align="center"><%=id %></td>
<td nowrap align="center">《<%=bookname %>》</td>
<td nowrap align="center"><%=rs.getString("chubanshe") %></td>
<td nowrap align="center"><%=rs.getString("faxingnian") %>年</td>
<td nowrap rowspan="2"><img src="<%=rs.getString("tupian") %>"></img></td></tr>
<tr><td nowrap colspan="4" valign="top"><b>详细介绍：</b><br><%=rs.getString("xiangxiziliao") %></td></tr>
</table>
<%rs.close();stmt.close();conn.close(); %>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -