main_jsp.java

使用SQLserver实现数据库操作的图书管理系统。该系统直观大方

      out.write("                  <tr align=\"center\">\r\n                    <td width=\"6%\" height=\"25\">排名</td>\r\n    <td width=\"11%\">图书条形码</td>\r\n    <td width=\"17%\">图书名称</td>\r\n    <td width=\"15%\">图书类型</td>\r\n    <td width=\"16%\">书架</td>\r\n    <td width=\"14%\">出版社</td>\r\n    <td width=\"11%\">作者</td>\r\n    <td colspan=\"2\">定价(元)</td>\r\n                      </tr>\r\n");
if(coll_book!=null && !coll_book.isEmpty()){
	  Iterator it_book=coll_book.iterator();
	  int i=1;
  int degree=0;
  String bookname="";
  String typename="";
  String barcode_book="";
  String bookcase="";
  String pub="";
  String author="";
  String translator="";
  Float price=new Float(0);
	  while(it_book.hasNext()){
      BorrowForm borrowForm=(BorrowForm)it_book.next();
	bookname=chStr.toChinese(borrowForm.getBookName());
        barcode_book=borrowForm.getBookBarcode();
        typename=chStr.toChinese(borrowForm.getBookType());
	degree=borrowForm.getDegree();
	bookcase=chStr.toChinese(borrowForm.getBookcaseName());
        pub=chStr.toChinese(borrowForm.getPubName());
        author=chStr.toChinese(borrowForm.getAuthor());
        price=borrowForm.getPrice();

	
      out.write(" \r\n                  <tr>\r\n                    <td height=\"25\" align=\"center\">");
      out.print(i);
      out.write("</td>\r\n    <td style=\"padding:5px;\">&nbsp;");
      out.print(barcode_book);
      out.write("</td>\r\n    <td style=\"padding:5px;\">");
      out.print(bookname);
      out.write("</td>\r\n    <td style=\"padding:5px;\">");
      out.print(typename);
      out.write("</td>\r\n    <td align=\"center\">&nbsp;");
      out.print(bookcase);
      out.write("</td>\r\n    <td align=\"center\">&nbsp;");
      out.print(pub);
      out.write("</td>\r\n    <td width=\"11%\" align=\"center\">");
      out.print(author);
      out.write("</td>\r\n    <td width=\"8%\" align=\"center\">");
      out.print(price);
      out.write("</td>\r\n  </tr>\r\n\t");

	i++;
	}
}
      out.write("\r\n                </table>\r\n                  <table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n                    <tr>\r\n                      <td height=\"39\" align=\"right\"><a href=borrow.do?action=bookBorrowSort><img src=\"Images/more.GIF\" width=\"50\" height=\"20\" border=\"0\"></a></td>\r\n                    </tr>\r\n                  </table></td>\r\n                <td width=\"2%\">&nbsp;</td>\r\n              </tr>\r\n            </table></td>\r\n          </tr>\r\n          <tr>\r\n            <td height=\"19\" background=\"Images/main_booksort_2.gif\">&nbsp;</td>\r\n          </tr>\r\n        </table>\r\n          <table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n            <tr>\r\n              <td height=\"57\" background=\"Images/main_readersort_1.gif\">&nbsp;</td>\r\n            </tr>\r\n            <tr>\r\n              <td height=\"72\" valign=\"top\" background=\"Images/main_booksort_1.gif\">\r\n                <table width=\"100%\" height=\"63\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                  <tr>\r\n                    <td width=\"2%\">&nbsp;</td>\r\n");
      out.write("                    <td width=\"96%\" align=\"center\" valign=\"top\"><table width=\"100%\"  border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#FFFFFF\" bordercolordark=\"#eeeeee\" bordercolorlight=\"#FFFFFF\">\r\n                      <tr align=\"center\" bordercolordark=\"#D2E3E6\">\r\n                        <td width=\"6%\" height=\"25\" align=\"center\">排名</td>\r\n    <td width=\"11%\">读者条形码</td>\r\n    <td width=\"12%\">读者姓名</td>\r\n    <td width=\"13%\">读者类型</td>\r\n    <td width=\"23%\">证件类型</td>\r\n    <td width=\"14%\">证件号码</td>\r\n    <td width=\"12%\">电话</td>\r\n    <td colspan=\"2\">性别</td>\r\n                      </tr>\r\n\t\t\t\t  ");
if(coll_book!=null && !coll_book.isEmpty()){
	  Iterator it_reader=coll_reader.iterator();
	  int j=1;
	  String readername="";
	  String typename="";
	  String barcode_reader="";
	  String paperType="";
	  String paperNo="";
	  String tel="";
	  String sex="";
	  while(it_reader.hasNext()){
      BorrowForm borrowForm=(BorrowForm)it_reader.next();
	readername=chStr.toChinese(borrowForm.getReaderName());
        barcode_reader=borrowForm.getReaderBarcode();
        typename=chStr.toChinese(borrowForm.getReaderType());
        paperType=chStr.toChinese(borrowForm.getPaperType());
        paperNo=borrowForm.getPaperNo();
        tel=borrowForm.getTel();
        sex=chStr.toChinese(borrowForm.getSex());

	
      out.write(" \r\n                  <tr>\r\n                    <td height=\"25\" align=\"center\">");
      out.print(j);
      out.write("</td>\r\n    <td style=\"padding:5px;\">&nbsp;");
      out.print(barcode_reader);
      out.write("</td>\r\n    <td style=\"padding:5px;\">");
      out.print(readername);
      out.write("</td>\r\n    <td style=\"padding:5px;\">");
      out.print(typename);
      out.write("</td>\r\n    <td align=\"center\">&nbsp;");
      out.print(paperType);
      out.write("</td>\r\n    <td align=\"center\">&nbsp;");
      out.print(paperNo);
      out.write("</td>\r\n    <td width=\"12%\" align=\"center\">");
      out.print(tel);
      out.write("</td>\r\n    <td width=\"7%\" align=\"center\">");
      out.print(sex);
      out.write("</td>\r\n                  </tr>\r\n\t\t\t\t");

				j++;
				}
				}
      out.write("\r\n                    </table>\r\n                      <table width=\"100%\" height=\"42\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n                        <tr>\r\n                          <td height=\"35\" align=\"right\"><a href=borrow.do?action=readerBorrowSort><img src=\"Images/more.GIF\" width=\"50\" height=\"20\" border=\"0\"></a></td>\r\n                        </tr>\r\n                      </table></td>\r\n                    <td width=\"2%\">&nbsp;</td>\r\n                  </tr>\r\n                </table></td>\r\n            </tr>\r\n            <tr>\r\n              <td height=\"19\" background=\"Images/main_booksort_2.gif\">&nbsp;</td>\r\n            </tr>\r\n          </table></td>\r\n      </tr>\r\n    </table>\r\n      </td>\r\n  </tr>\r\n</table></td>\r\n  </tr>\r\n</table>\r\n");
      out.write("\r\n<table width=\"99%\" height=\"72\"  border=\"0\" align=\"center\" cellpadding=\"-2\" cellspacing=\"-2\">\r\n      <tr>\r\n        <td height=\"2\" colspan=\"4\"></td>\r\n        </tr>\r\n      <tr>\r\n        <td width=\"124\" height=\"23\">&nbsp;</td>\r\n        <td valign=\"bottom\" align=\"center\"> CopyRight &copy; 2006 www.mingrisoft.com 吉林省明日科技有限公司</td>\r\n        <td width=\"141\">&nbsp;</td>\r\n      </tr>\r\n      <tr>\r\n        <td height=\"28\">&nbsp;</td>\r\n        <td align=\"center\">本站请使用IE6.0或以上版本 1024*768为最佳显示效果</td>\r\n        <td>&nbsp;</td>\r\n      </tr>\r\n      <tr>\r\n        <td height=\"8\"></td>\r\n        <td height=\"8\"></td>\r\n        <td height=\"8\"></td>\r\n      </tr>\r\n    </table>\r\n");
      out.write("</td>\r\n  </tr>\r\n</table>\r\n</body>\r\n</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);
    }
  }
}