booksearch_jsp.java

这是一个图书馆管理系统的jsp代码

      out.write("  </table>\r\n");
      out.write("</form>-->\r\n");
      login.Library Library = null;
      synchronized (session) {
        Library = (login.Library) _jspx_page_context.getAttribute("Library", PageContext.SESSION_SCOPE);
        if (Library == null){
          Library = new login.Library();
          _jspx_page_context.setAttribute("Library", Library, PageContext.SESSION_SCOPE);
          out.write('\r');
          out.write('\n');
        }
      }
      out.write("\r\n");
      out.write("<center>\r\n");
      out.write("\r\n");

//java.util.Locale locale = request.getLocale();
//java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.LONG,locale);

if(request.getParameter("enter")!=null){
Library.setbookstitle(request.getParameter("title"));
response.sendRedirect("booksearchresults.jsp");}
/*try{
  int flag=0,flag1=0;String studentnumber="";
  String id=Library.getid();
//  String title=request.getParameter("title");
Connection conn=Library.getConn();
Statement stmt,stmt1;
stmt = conn.createStatement();
stmt1 = conn.createStatement();
ResultSet rs2 = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");
//ResultSet rs6 = pstmt1.executeQuery();
while(rs2.next()){//判断当前用户是否已经还清欠款，在borrowbook表中，flag=1代表为还清，flag=0代表还清
if(rs2.getString("returnmoney").equals("no")){
flag=1;
}
}
//out.println("<p>" + request.getParameter("title") + "</p>");
ResultSet rs3 = stmt.executeQuery("select * from user where id ='" + id + "'");
if(rs3.next()){
studentnumber = rs3.getString("studentnumber");
}
  if(request.getParameter("enter")!=null){
ResultSet rs = stmt.executeQuery("select * from book where title ='" + request.getParameter("title") + "'");
  while (rs.next()){//NO data found,是指rs.getString()中出现两个相同的,例rs.getString("id")出现两次；

    out.println("<p>serialnumber = " + rs.getString("serialnumber") + "&nbsp; </p>");
    out.println("<p>sortnumber = " + rs.getString("sortnumber") + "&nbsp; </p>");
    out.println("<p>title = " + rs.getString("title") + "&nbsp; </p>");
    out.println("<p>author1 = " + rs.getString("author1") + "&nbsp; </p>");
    out.println("<p>author2 = " + rs.getString("author2") + "&nbsp; </p>");
    out.println("<p>author3 = " + rs.getString("author3") + "&nbsp; </p>");
    out.println("<p>cover = " + rs.getString("cover") + "&nbsp; </p>");
    out.println("<p>bookconcern = " + rs.getString("bookconcern") + "&nbsp; </p>");
    out.println("<p>publicday = " + rs.getString("publicday") + "&nbsp; </p>");
    out.println("<p>isbn = " + rs.getString("isbn") + "&nbsp; </p>");
    out.println("<p>times = " + rs.getString("times") + "&nbsp; </p>");
    out.println("<p>prize = " + rs.getString("prize") + "&nbsp; </p>");
    out.println("<p>innumber = " + rs.getString("innumber") + "&nbsp; </p>");
    out.println("<p>outnumber = " + rs.getString("outnumber") + "&nbsp; </p>");

  }

}
else if(request.getParameter("borrow")!=null && request.getParameter("title")!=null && flag==0){

//  stmt = conn.createStatement();
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") + "'";


// stmt =conn .createStatement();
  stmt1.executeUpdate(newinbook);

  String newoutbook = "update book set outnumber ='" + (oldoutbook+1) +"' where title ='" + request.getParameter("title") + "'";


// stmt=conn.createStatement();
  stmt1.executeUpdate(newoutbook);
  out.println("<P>You succeed in borrowing this book.</p>");}else{response.sendRedirect("fail.jsp");
  }
//out.println("<p>" + request.getParameter("title") + "</p>");
//Statement stmt = conn.createStatement();
//ResultSet rs1 = stmt.executeQuery("select * from book where title ='" + request.getParameter("title") + "'");

//stmt = conn.createStatement();
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表中的值
//stmt=conn.createStatement();
   stmt1.execute(insertborrowbook);
}
  }else if(request.getParameter("return")!=null){

//stmt = conn.createStatement();
ResultSet rs4 = stmt.executeQuery("select * from borrowbook where id ='" + id + "' and title ='" + request.getParameter("title") + "' and returndata = '0'");

if(rs4.next()){//判断在borrowbook表中是否有当前用户指定书名的书的未还记录，即returndata="0"
 // int returndata=Integer.parseInt(rs4.getString("returndata"));
  /*  rs4.getString("title").equals(request.getParameter("title"));
    flag1=1;
    }
    if(flag1==1 && request.getParameter("title")!=null){*/
//  if(returndata==)

//stmt=conn.createStatement();
 /* 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'");
//一个用户不会有病到在一本书还没还的情况下，再借一本相同的书吧

//stmt = conn.createStatement();
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();}*/


      out.write("\r\n");
      out.write("</center>\r\n");
      out.write("</body>\r\n");
      out.write("</html>\r\n");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}