?? borrowsearchresults.jsp~19~
字號:
<%@ 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 Borrow 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>
<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="adduser.jsp">Adduser</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">Modifyuser</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="deleteuser.jsp">Deletuser</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="searchuser.jsp">Searchuser</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="addbook.jsp">Addbook</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 align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="deletebook.jsp">Deletebook</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\圖書館\loginlibrary4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="borrowsearch.jsp">Borrowsearch</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="search.jsp">Search</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="userpay.jsp">Userpay</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\圖書館\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="update.jsp">Update</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\圖書館\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="220" valign="top" bgcolor="#CCCCCC"> </td>
</tr>
</table></td>
<td height="449" align="left" valign="top"><table width="80%" border="1" align="center" cellpadding="10" cellspacing="1" >
<tr align="center">
<td height="50" colspan="2" class="style3"><%=Library.getbsid() %> Borrow Results </td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">Serial NO.:</td>
<td height="30" align="left" class="style4"><%=Library.getbsserialnumber() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">Sort NO.:</td>
<td height="30" align="left" class="style4"><%=Library.getbssortnumber() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">Title:</td>
<td height="30" align="left" class="style4"><%=Library.getbstitle() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">Borrow Date:</td>
<td height="30" align="left" class="style4"><%=Library.getbsborrowdata() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">SReturnDate:</td>
<td height="30" align="left" class="style4"><%=Library.getbsshouldreturndata() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">Return Date:</td>
<td height="30" align="left" class="style4"><%=Library.getbsreturndata() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">Overdate:</td>
<td height="30" align="left" class="style4"><%=Library.getbsoverdata() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">Fee:</td>
<td height="30" align="left" class="style4"><%=Library.getbsfee() %></td>
</tr>
<tr>
<td width="30%" height="30" align="right" class="style4">ReMoney:</td>
<td height="30" align="left" class="style4"><%=Library.getbsreturnmoney() %></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="previous" type="submit" id="previous" value="Previous"></td>
<td width="50%" align="center"><input name="next" type="submit" id="next" value="Next"></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{
String id = Library.getbsid();
Connection conn=Library.getConn();
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");
int number=Library.getnumber();
if(request.getParameter("next")!=null&&number<Library.getmaxnumber()){
++number;
Library.setnumber(number);
for(int i=1;i<=number;i++){
if(rs.next()){
Library.setbsserialnumber(rs.getString("serialnumber"));
Library.setbssortnumber(rs.getString("sortnumber"));
Library.setbstitle(rs.getString("title"));
Library.setbsborrowdata(rs.getString("borrowdata"));
Library.setbsshouldreturndata(rs.getString("shouldreturndata"));
Library.setbsreturndata(rs.getString("returndata"));
Library.setbsoverdata(rs.getString("overdata"));
Library.setbsfee(rs.getString("fee"));
Library.setbsreturnmoney(rs.getString("returnmoney"));}
}
rs.close();
response.sendRedirect("borrowsearchresults.jsp");
}
if(request.getParameter("previous")!=null&&number>1){
--number;
Statement stmt1=conn.createStatement();
ResultSet rs1 = stmt1.executeQuery("select * from borrowbook where id ='" + id + "'");
for(int i=1;i<=number;i++){
if(rs1.next()){
Library.setbsserialnumber(rs1.getString("serialnumber"));
Library.setbssortnumber(rs1.getString("sortnumber"));
Library.setbstitle(rs1.getString("title"));
Library.setbsborrowdata(rs1.getString("borrowdata"));
Library.setbsshouldreturndata(rs1.getString("shouldreturndata"));
Library.setbsreturndata(rs1.getString("returndata"));
Library.setbsoverdata(rs1.getString("overdata"));
Library.setbsfee(rs1.getString("fee"));
Library.setbsreturnmoney(rs1.getString("returnmoney"));}
}
rs1.close();
Library.setnumber(number);
response.sendRedirect("borrowsearchresults.jsp");
}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -