相关代码 |
|
Search Borrow
.style3 {font-size: 24px}
.style4 {font-size: 18px}
-->
Adduser
Modifyuser
Deletuser
Searchuser
Addbook
Deletebook
Borrowsearch
Search
Search Borrow
ID:
***
int number=0;
try{
if(request.getParameter("enter")!=null){
String id = request.getParameter("borrowsearchid");
Library.setbsid(id);
Connection conn=Library.getConn();
Statement stmt=conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");
// out.println("ID = " + id + " ");
while (rs.next()){
number++;
/* out.println("serialnumber = " + rs.getString("serialnumber") + " ");
out.println("sortnumber = " + rs.getString("sortnumber") + " ");
out.println("title = " + rs.getString("title") + " ");
out.println("borrowdata = " + rs.getString("borrowdata") + " ");
out.println("shouldreturndata = " + rs.getString("shouldreturndata") + " ");
out.println("returndata = " + rs.getString("returndata") + " ");
out.println("overdata = " + rs.getString("overdata") + " ");
out.println("fee = " + rs.getString("fee") + " ");
out.println("returnmoney = " + rs.getString("returnmoney") + " ");*/
}
Library.setmaxnumber(number);
if(Library.getmaxnumber()!=0){
Statement stmt1=conn.createStatement();
ResultSet rs1 = stmt1.executeQuery("select * from borrowbook where id ='" + id + "'");
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"));
Library.setnumber(1);}
}
response.sendRedirect("borrowsearchresults.jsp");
}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
相关资源 |
|