out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Sort NO.:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbsortnumber() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Title:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbtitle() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Author1:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbauthor1() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Author2:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbauthor2() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Author3:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbauthor3() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Cover:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbcover() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Book Conern:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbbookconcern() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Public Day:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbpublicday() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">ISBN:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbisbn() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Times:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbtimes() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">Prize:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbprize() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td width=\"30%\" height=\"20\" align=\"right\" class=\"style4\">In NO.:</td>\r\n");
      out.write("          <td height=\"20\" align=\"left\" class=\"style4\">");
      out.print(Library.getbinnumber() );
      out.write("</td>\r\n");
      out.write("        </tr>\r\n");
      out.write("        <tr>\r\n");
      out.write("          <td height=\"20\" 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=\"borrow\" type=\"submit\" id=\"borrow\" value=\"Borrow\"></td>\r\n");
      out.write("              <td width=\"50%\" align=\"center\"><input name=\"return\" type=\"submit\" id=\"return\" value=\"Return\"></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");

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 && Library.getbookstitle()!=null && flag==0){
ResultSet rs5 = stmt.executeQuery("select * from book where title ='" + Library.getbookstitle() + "'");
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 ='" + Library.getbookstitle() + "'";
  stmt1.executeUpdate(newinbook);
  String newoutbook = "update book set outnumber ='" + (oldoutbook+1) +"' where title ='" + Library.getbookstitle() + "'";
  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 +
   "','" + Library.getbookstitle() + "','" + 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 ='" + Library.getbookstitle() + "' 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 ='" + Library.getbookstitle() + "'and id ='" + id + "' and returndata = '0'");
//一個用戶不會有病到在一本書還沒還的情況下，再借一本相同的書吧
ResultSet rs6 = stmt.executeQuery("select * from book where title ='" + Library.getbookstitle() + "'");
 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 ='" + Library.getbookstitle() + "'";
  stmt1.executeUpdate(newinbook);
  String newoutbook = "update book set outnumber ='" + (oldoutbook-1) +"' where title ='" + Library.getbookstitle() + "'";
  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("\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);
    }
  }
}