📄 changebook.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" );
}
%>
<%String ErrMeg = request.getParameter("jieguo");
if(ErrMeg==null){
ErrMeg = " ";
}else if(ErrMeg.equals("failed1")){
ErrMeg = "没有输入信息";
}
%>
<html>
<body>
<%
String id = request.getParameter("id");
String name = "";
String auther = "";
String publisher = "";
String publdata = "";
String price= "";
String isbn = "";
String isin = "";
String beizhu = "";
String kind = "";
String findid="";
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");
if(isin.equals("yes")){
isin = "在馆";
}else{
isin = "不在";
}
//out.print(name+"<br>");
}
%>
<h1><blockquote>输入您要修改的信息</blockquote></h1>
<h3><blockquote><font color= red><%=ErrMeg %></font></blockquote></h3>
<form name = search action="../servlet/changeBookController" method="post">
<input type="hidden" name="id1" value = <%=isbn %> >
<input type="hidden" name="findid" value = <%=id %> >
<table width = 700 height = 500 Align = "left">
<tr><td>书名（原来）</td><td><%=name %></td><td>改为</td><td><input type="text" name="name" maxlength="100" size="30"></td></tr>
<tr><td>作者（原来）</td><td><%=auther %></td><td>改为</td><td><input type="text" name="auther" maxlength="100" size="30"></td></tr>
<tr><td>价格（原来）</td><td><%=price%></td><td>改为</td><td><input type="text" name="price" maxlength="100" size="30"></td></tr>
<tr><td>出版社（原来）</td><td><%=publisher %></td><td>改为</td><td><input type="text" name="publisher" maxlength="100" size="30"></td></tr>
<tr><td>出版时间（原来）</td><td><%=publdata%></td><td>改为</td><td><input type="text" name="publishdata" maxlength="100" size="30"></td></tr>
<tr><td>类别（原来）</td><td><%=kind %></td><td>改为</td><td><input type="text" name="kind" maxlength="100" size="30"></td></tr>
<tr><td>备注信息（原来）</td><td><%=beizhu %></td><td>改为</td><td><input type="text" name="beizhu" maxlength="100" size="30"></td></tr>
<tr><td><input type="submit" value=" 更改 " name="search"> </td><td><input type="reset" value=" 清 除 "></td></tr>
<tr><td><a href = ./searchbookresult.jsp>返回</a></td></tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -