?? booksearchresults.jsp~4~
字號:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>Search Book results</title>
<style type="text/css">
<!--
.style3 {font-size: 24px}
.style4 {font-size: 18px}
-->
</style></head>
<body>
<jsp:useBean id="Library" scope="session" class="login.Library">
</jsp:useBean>
<%
try{
Connection conn=Library.getConn();
Statement stmt;
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from book where title ='" + Library.getbookstitle() + "'");
while (rs.next()){
Library.setbserialnumber(rs.getString("serialnumber"));
Library.setbsortnumber(rs.getString("sortnumber"));
Library.setbtitle(rs.getString("title"));
Library.setbauthor1(rs.getString("author1"));
Library.setbauthor2(rs.getString("author2"));
Library.setbauthor3(rs.getString("author3"));
Library.setbcover(rs.getString("cover"));
Library.setbbookconcern(rs.getString("bookconcern"));
Library.setbpublicday(rs.getString("publicday"));
Library.setbisbn(rs.getString("isbn"));
Library.setbtimes(rs.getString("times"));
Library.setbprize(rs.getString("prize"));
Library.setbinnumber(rs.getString("innumber"));}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
<form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0">
<tr align="left" valign="top" bgcolor="#000000">
<td height="100" colspan="2"><table width="100%" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td bgcolor="#FFFFFF"><img src="F:\example\圖書館\login\library1.gif" width="699" height="100" alt=""></td>
</tr>
</table></td>
</tr>
<tr>
<td height="449" align="left" valign="top" bgcolor="#000000"><table width="99%" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top" bgcolor="#CCCCCC"><table width="70%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"> </td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"> <a href="userrights.jsp">UserRights</a> </td>
</tr>
<tr>
<td width="20" height="5" align="right"> </td>
<td width="130" height="5" align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="modifyuser.jsp">ModifyMessage</a></td>
</tr>
<tr>
<td width="20" height="5" align="right"> </td>
<td width="130" height="5" align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="booksearch.jsp">BookSearch</a></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="bookreturn.jsp">BookReturn</a></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="haveborrow.jsp">HaveBorrow</a></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
</table></td>
</tr>
<tr>
<td height="500" valign="top" bgcolor="#CCCCCC"> </td>
</tr>
</table></td>
<td height="449" align="left" valign="top"><table width="80%" border="1" align="center" cellpadding="8" cellspacing="1" >
<tr align="center">
<td height="30" colspan="2" class="style3">Search Book Results </td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Serial NO.:</td>
<td height="20" align="left" class="style4"><%=Library.getbserialnumber() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Sort NO.:</td>
<td height="20" align="left" class="style4"><%=Library.getbsortnumber() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Title:</td>
<td height="20" align="left" class="style4"><%=Library.getbtitle() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Author1:</td>
<td height="20" align="left" class="style4"><%=Library.getbauthor1() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Author2:</td>
<td height="20" align="left" class="style4"><%=Library.getbauthor2() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Author3:</td>
<td height="20" align="left" class="style4"><%=Library.getbauthor3() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Cover:</td>
<td height="20" align="left" class="style4"><%=Library.getbcover() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Book Conern:</td>
<td height="20" align="left" class="style4"><%=Library.getbbookconcern() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Public Day:</td>
<td height="20" align="left" class="style4"><%=Library.getbpublicday() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">ISBN:</td>
<td height="20" align="left" class="style4"><%=Library.getbisbn() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Times:</td>
<td height="20" align="left" class="style4"><%=Library.getbtimes() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">Prize:</td>
<td height="20" align="left" class="style4"><%=Library.getbprize() %></td>
</tr>
<tr>
<td width="30%" height="20" align="right" class="style4">In NO.:</td>
<td height="20" align="left" class="style4"><%=Library.getbinnumber() %></td>
</tr>
<tr>
<td height="20" colspan="2" align="right"><table width="60%" border="0" align="center" cellpadding="0" cellspacing="1">
<tr>
<td width="50%" align="center"><input name="borrow" type="submit" id="borrow" value="Borrow"></td>
<td width="50%" align="center"><input name="return" type="submit" id="return" value="Return"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td><img src="F:\example\圖書館\login/library2.png" width="573" height="40" alt=""></td>
</tr>
</table>
</form>
<%
try{
int flag=0,flag1=0;String studentnumber="";
String id=Library.getid();
Connection conn=Library.getConn();
Statement stmt,stmt1;
stmt = conn.createStatement();
stmt1 = conn.createStatement();
ResultSet rs2 = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");
while(rs2.next()){//判斷當前用戶是否已經還清欠款，在borrowbook表中，flag=1代表為還清，flag=0代表還清
if(rs2.getString("returnmoney").equals("no")){
flag=1;
}
}
ResultSet rs3 = stmt.executeQuery("select * from user where id ='" + id + "'");
if(rs3.next()){
studentnumber = rs3.getString("studentnumber");
}
if(request.getParameter("borrow")!=null && request.getParameter("title")!=null && flag==0){
ResultSet rs5 = stmt.executeQuery("select * from book where title ='" + request.getParameter("title") + "'");
if(rs5.next()){
int oldinbook = Integer.parseInt(rs5.getString("innumber"));
int oldoutbook = Integer.parseInt(rs5.getString("outnumber"));
String serialnumber=rs5.getString("serialnumber");
String sortnumber=rs5.getString("sortnumber");
if(oldinbook>0){//判斷該書有沒有庫存
String newinbook = "update book set innumber ='" + (oldinbook-1) +"' where title ='" + request.getParameter("title") + "'";
stmt1.executeUpdate(newinbook);
String newoutbook = "update book set outnumber ='" + (oldoutbook+1) +"' where title ='" + request.getParameter("title") + "'";
stmt1.executeUpdate(newoutbook);
//out.println("<P>You succeed in borrowing this book.</p>");
}else{response.sendRedirect("fail.jsp");
}
ResultSet rs7 = stmt.executeQuery("select * from administrator");
int nowtrailnumber=0;
while(rs7.next()){//從administrator表中獲得borrowbook中的關鍵字trailnumber，他不因為程序結束而重新復值；
nowtrailnumber=Integer.parseInt(rs7.getString("nowtrailnumber"));}
String insertborrowbook = "insert into borrowbook(trailnumber,serialnumber,sortnumber,title,id,studentnumber,borrowdata,shouldreturndata,returndata,overdata,fee,returnmoney) values('" + nowtrailnumber + "','" + serialnumber + "','" + sortnumber +
"','" + request.getParameter("title") + "','" + id + "','" + studentnumber + "','" + (new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay()) + "','" + (new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay() + 6) + "','0','0','0.00','yes')";
stmt1.execute("update administrator set nowtrailnumber ='"+(nowtrailnumber+1)+"'");//修改nowtrailnumber在administrator表中的值
stmt1.execute(insertborrowbook);
}
}else if(request.getParameter("return")!=null){
ResultSet rs4 = stmt.executeQuery("select * from borrowbook where id ='" + id + "' and title ='" + request.getParameter("title") + "' and returndata = '0'");
if(rs4.next()){//判斷在borrowbook表中是否有當前用戶指定書名的書的未還記錄，即returndata="0"
stmt1.executeUpdate("update borrowbook set returndata = '" + (new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay()) + "' where title ='" + request.getParameter("title") + "'and id ='" + id + "' and returndata = '0'");
//一個用戶不會有病到在一本書還沒還的情況下，再借一本相同的書吧
ResultSet rs6 = stmt.executeQuery("select * from book where title ='" + request.getParameter("title") + "'");
while(rs6.next()){
int oldinbook = Integer.parseInt(rs6.getString("innumber"));
int oldoutbook = Integer.parseInt(rs6.getString("outnumber"));
String newinbook = "update book set innumber ='" + (oldinbook+1) +"' where title ='" + request.getParameter("title") + "'";
stmt1.executeUpdate(newinbook);
String newoutbook = "update book set outnumber ='" + (oldoutbook-1) +"' where title ='" + request.getParameter("title") + "'";
stmt1.executeUpdate(newoutbook);
// out.println("<p>You succeed in returning this book.</p>");
}
}
}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -