booklist_jsp.java

Tomcat 是一个小型的轻量级应用服务器

										}
										
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t</SELECT>\r\n");
      out.write("\t\t\t\t\t\t\t  </td>\r\n");
      out.write("\t\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td height=\"35\" align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t<INPUT TYPE=\"submit\" name=\"submit\" value=\"查询\">\r\n");
      out.write("\t\t\t\t\t\t\t  </td>\r\n");
      out.write("\t\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t\t</table>\t\t\t\t\t\t\r\n");
      out.write("\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t<td align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t<p>\r\n");
      out.write("\t\t\t\t\t\t\t<br>\r\n");
      out.write("\t\t\t\t\t\t\t<b class=\"style16\"><font color=\"#0000FF\">图书");
      out.print(classname);
      out.write("列表</font> </b>\r\n");
      out.write("\t\t\t\t\t\t</p>\r\n");
      out.write("\t\t\t\t\t\t");

								if (!keyword.equals(""))
								out.println("<p ><font color=#ff0000>你要查找关于&nbsp;" + keyword
								+ "&nbsp;的图书如下</font></p>");
						
      out.write("\r\n");
      out.write("\t\t\t\t\t\t<table width=\"100%\" border=\"1\" cellspacing=\"0\" cellpadding=\"0\"\r\n");
      out.write("\t\t\t\t\t\t\tbordercolor=\"#00CCFe\">\r\n");
      out.write("\t\t\t\t\t\t\t<tr align=\"center\" class=\"style14\">\r\n");
      out.write("\t\t\t\t\t\t\t\t<td height=\"36\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t图书名称\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t\t作者\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t\t图书类别\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t\t出版社\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td>\r\n");
      out.write("\t\t\t\t\t\t\t\t\t单价\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td width=110>\r\n");
      out.write("\t\t\t\t\t\t\t\t\t选择\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t  </tr>\r\n");
      out.write("\t\t\t\t\t\t\t");

								if (book_list.execute(request))
								{
									if (book_list.getBooklist().size() > 0)
									{
										for (int i = 0; i < book_list.getBooklist().size(); i++)
										{
									Books bk = (Books) book_list.getBooklist().elementAt(i);
							
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td height=\"39\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");
      out.print(bk.getBookName());
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t  </td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");
      out.print(bk.getAuthor());
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");
      out.print(bk.getClassname());
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");
      out.print(bk.getPublish());
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");
      out.print(bk.getPrince());
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t元\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t<a href=\"#\" onclick=\"openScript('purchase.jsp?bookid=");
      out.print(bk.getId());
      out.write("','pur',300,250)\">购买</a>&nbsp;\r\n");
      out.write("\t\t\t\t\t\t\t\t\t<a href=\"#\" onclick=\"openScript('showbook.jsp?bookid=");
      out.print(bk.getId());
      out.write("','show',400,450)\">详细资料</a>\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t");

									}
									} else
									{
										if (keyword.equals(""))
										{
									out
											.println("<tr><td align='center' colspan=6>&nbsp;暂时没有此类图书资料</td></tr>");
										} else
										{
									out
											.println("<tr><td align='center' colspan=6>&nbsp;没有你要查找的&nbsp;"
											+ keyword + "&nbsp;相关图书</td></tr>");
										}
									}
								} else
								{
							
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td height=\"41\" colspan=6 align=\"center\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t&nbsp;数据库出错，请稍后\r\n");
      out.write("\t\t\t\t\t\t\t\t</td>\r\n");
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t\t\t");

							}
							
      out.write("\r\n");
      out.write("\r\n");
      out.write("\t\t\t\t\t  </table>\r\n");
      out.write("\t\t\t\t\t\t<table width=\"93%\" border=\"0\" cellspacing=\"1\" cellpadding=\"1\">\r\n");
      out.write("\t\t\t\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t\t\t\t<td height=\"34\" align=\"right\">\r\n");
      out.write("\t\t\t\t\t\t\t\t\t总计结果为\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");
      out.print(book_list.getRecordCount());
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t条，当前页第\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");
      out.print(book_list.getPage());
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t页\r\n");
      out.write("\t\t\t\t\t\t\t\t\t<a\r\n");
      out.write("\t\t\t\t\t\t\t\t\t\thref=\"booklist.jsp?classid=");
      out.print(classid);
      out.write("&keyword=");
      out.print(keyword);
      out.write("\">首页</a>&nbsp;\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");

										if (book_list.getPage() > 1)
										{
									
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t<a\r\n");
      out.write("\t\t\t\t\t\t\t\t\t\thref=\"booklist.jsp?page=");
      out.print(book_list.getPage() - 1);
      out.write("&classid=");
      out.print(classid);
      out.write("&keyword=");
      out.print(keyword);
      out.write("\">上一页</a>&nbsp;\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");

									}
									
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");

										if (book_list.getPage() < book_list.getPageCount() - 1)
										{
									
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t<a\r\n");
      out.write("\t\t\t\t\t\t\t\t\t\thref=\"booklist.jsp?page=");
      out.print(book_list.getPage() + 1);
      out.write("&classid=");
      out.print(classid);
      out.write("&keyword=");
      out.print(keyword);
      out.write("\">下一页</a>&nbsp;\r\n");
      out.write("\t\t\t\t\t\t\t\t\t");

									}
									
      out.write("\r\n");
      out.write("\t\t\t\t\t\t\t\t\t<a\r\n");
      out.write("\t\t\t\t\t\t\t\t\t\thref=\"booklist.jsp?page=");
      out.print(book_list.getPageCount());
      out.write("&classid=");
      out.print(classid);
      out.write("&keyword=");
      out.print(keyword);
      out.write("\">未页</a>&nbsp;\r\n");
      out.write("\t\t\t\t\t\t\t  </td>\r\n");
      out.write("\t\t\t\t\t\t\t</tr>\r\n");
      out.write("\t\t\t\t\t  </table>\r\n");
      out.write("\t\t\t\t\t</td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t</table>\r\n");
      out.write("\t\t\t\r\n");
      out.write("\t\t\t\r\n");
      out.write("\t\t\t<hr width=\"750\" color=\"#00CCFe\"/>\r\n");
      out.write("\t\t\t<table width=\"750\" border=\"0\"   cellspacing=\"0\" cellpadding=\"0\">\r\n");
      out.write("\t\t\t\t<tr>\r\n");
      out.write("\t\t\t\t\t<td align=\"center\" >\r\n");
      out.write("\t\t\t\t\t\t<div align=\"center\" class=\"style11\">06计算机科学与技术3班\r\n");
      out.write("\t\t\t\t\t\t  <br> \n");
      out.write("\t\t\t\t\t\tCopyRight@2009<br> \n");
      out.write("\t\t\t\t\t\tE-mail: [e-mail]<a href=\"mailto:[e-mail]\"></a>\r\n");
      out.write("\t\t\t\t\t    </div></td>\r\n");
      out.write("\t\t\t\t</tr>\r\n");
      out.write("\t\t\t</table>\r\n");
      out.write("\r\n");
      out.write("\t\t</div>\r\n");
      out.write("\t</body>\r\n");
      out.write("</html>\r\n");

book_list.close();

      out.write('\r');
      out.write('\n');
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          try { out.clearBuffer(); } catch (java.io.IOException e) {}
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}