📄 bookdetail.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
if(session.getAttribute("adlogin")!=null){
String adlogin = (String)session.getAttribute("adlogin");
if(!adlogin.endsWith("yes")){
response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
}
}else{
response.sendRedirect("../admin/login.jsp?errMsg=weidenglu" );
}
%>
<html>
<body>
<h1><blockquote>书籍信息如下</blockquote></h1>
<table width = 1000 height = 300 Align = "left">
<tr><th align = left>检索号</th><th align = left>书名</th><th align = left>作者</th><th align = left>出版社</th><th align = left>出版时间</th><th align = left>ISBN</th><th align = left>类别</th><th align = left>是否在馆</th><th align = left>备注信息</th></tr>
<%
String id = request.getParameter("id");
String findid = "";
String name = "";
String auther = "";
String publisher = "";
String publdata = "";
String price= "";
String isbn = "";
String isin = "";
String beizhu = "";
String kind = "";
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/library?user=root&password=linux&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select * from books,booktitle where books.isbn = '"+id+"'";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
name=rs.getString("name");
auther=rs.getString("auther");
publisher = rs.getString("publisher");
publdata = rs.getString("publdata");
price= rs.getString("price");
isbn = rs.getString("books.isbn");
isin = rs.getString("isin");
beizhu=rs.getString("beizhu");
kind = rs.getString("kind");
findid = rs.getString("findid");
if(isin.equals("yes")){
isin = "在馆";
}else{
isin ="不在";
}
//out.print(name+"<br>");
%>
<tr><td><%=findid %></td>
<td><%=name %></td>
<td><%=auther %></td>
<td><%=publisher %></td>
<td><%=publdata%></td>
<td><%=isbn %></td>
<td><%=kind %></td>
<td><%=isin %></td>
<td><%=beizhu %></td>
<td><a href= ./deletebook.jsp?id=<%=findid %>>删除书籍</a></td>
</tr>
<%}
%>
<tr><td><a href = ./searchbookresult.jsp>返回</a></td></tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -