borrowsearch_jsp.java

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

      out.write("              <td align=\"right\"><img src=\"F:\\example\\图书馆\\login/library3.png\" width=\"10\" height=\"10\" alt=\"\"></td>\r\n");
      out.write("              <td align=\"center\"><a href=\"userpay.jsp\">Userpay</a></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("            <tr>\r\n");
      out.write("              <td align=\"right\">&nbsp;</td>\r\n");
      out.write("              <td align=\"center\"><img src=\"F:\\example\\图书馆\\login/library4.png\" width=\"102\" height=\"5\" alt=\"\"></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("             <tr>\r\n");
      out.write("              <td align=\"right\"><img src=\"F:\\example\\图书馆\\login/library3.png\" width=\"10\" height=\"10\" alt=\"\"></td>\r\n");
      out.write("              <td align=\"center\"><a href=\"update.jsp\">Update</a></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("            <tr>\r\n");
      out.write("              <td align=\"right\">&nbsp;</td>\r\n");
      out.write("              <td align=\"center\"><img src=\"F:\\example\\图书馆\\login/library4.png\" width=\"102\" height=\"5\" alt=\"\"></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("\r\n");
      out.write("            <tr>\r\n");
      out.write("              <td width=\"20\" align=\"right\">&nbsp;</td>\r\n");
      out.write("              <td width=\"130\" align=\"center\">&nbsp;</td>\r\n");
      out.write("            </tr>\r\n");
      out.write("          </table></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"200\" valign=\"top\" bgcolor=\"#CCCCCC\">&nbsp;</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("      </table></td>\r\n");
      out.write("      <td height=\"449\" align=\"left\" valign=\"top\"><table width=\"80%\" border=\"1\" align=\"center\" cellpadding=\"10\" cellspacing=\"1\">\r\n");
      out.write("        <tr align=\"center\">\r\n");
      out.write("          <td height=\"50\" colspan=\"2\"><span class=\"style3\">Search Borrow </span></td>\r\n");
      out.write("          </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"37%\" height=\"30\" align=\"right\" ><span class=\"style4\">ID:</span></td>\r\n");
      out.write("          <td width=\"63%\" height=\"30\"><span class=\"style4\">\r\n");
      out.write("          <input name=\"borrowsearchid\" type=\"text\" id=\"borrowsearchid\" size=\"15\" maxlength=\"12\">\r\n");
      out.write("          ***</span></td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"30\" colspan=\"2\" align=\"right\">            <table width=\"60%\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"1\">\r\n");
      out.write("            <tr>\r\n");
      out.write("              <td width=\"50%\" align=\"center\"><input name=\"enter\" type=\"submit\" id=\"enter\" value=\"Enter\"></td>\r\n");
      out.write("              <td width=\"50%\" align=\"center\"><input name=\"reset\" type=\"reset\" id=\"reset\" value=\"Reset\"></td>\r\n");
      out.write("            </tr>\r\n");
      out.write("          </table></td>\r\n");
      out.write("          </tr>\r\n");
      out.write("      </table></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("    <tr>\r\n");
      out.write("      <td bgcolor=\"#666666\">&nbsp;</td>\r\n");
      out.write("      <td><img src=\"F:\\example\\图书馆\\login/library2.png\" width=\"573\" height=\"40\" alt=\"\"></td>\r\n");
      out.write("    </tr>\r\n");
      out.write("  </table>\r\n");
      out.write("</form>\r\n");
      out.write("\r\n");
      out.write("\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");

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("<p>ID = " + id + "&nbsp;&nbsp;&nbsp;</p>");
    while (rs.next()){
       number++;
 /*   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>borrowdata = " + rs.getString("borrowdata") + "&nbsp; </p>");
    out.println("<p>shouldreturndata = " + rs.getString("shouldreturndata") + "&nbsp; </p>");
    out.println("<p>returndata = " + rs.getString("returndata") + "&nbsp; </p>");
    out.println("<p>overdata = " + rs.getString("overdata") + "&nbsp; </p>");
    out.println("<p>fee = " + rs.getString("fee") + "&nbsp; </p>");
    out.println("<p>returnmoney = " + rs.getString("returnmoney") + "&nbsp; &nbsp;&nbsp;</p>");*/
  }


  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.setHeader("Location","borrowsearchresults.jsp");
response.sendRedirect("borrowsearchresults.jsp");
  }

}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);
    }
  }
}