⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 borrowquery_jsp.java

📁 一个使用J2EE的Java开发程序
💻 JAVA
字号:
🔍 
package org.apache.jsp;

import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
import com.dao.BorrowDAO;
import com.actionForm.BorrowForm;
import java.util.*;
import com.core.ChStr;
import com.dao.ManagerDAO;
import com.actionForm.ManagerForm;

public final class borrowQuery_jsp extends org.apache.jasper.runtime.HttpJspBase
    implements org.apache.jasper.runtime.JspSourceDependent {

  private static java.util.Vector _jspx_dependants;

  static {
    _jspx_dependants = new java.util.Vector(2);
    _jspx_dependants.add("/navigation.jsp");
    _jspx_dependants.add("/copyright.jsp");
  }

  public java.util.List getDependants() {
    return _jspx_dependants;
  }

  public void _jspService(HttpServletRequest request, HttpServletResponse response)
        throws java.io.IOException, ServletException {

    JspFactory _jspxFactory = null;
    PageContext pageContext = null;
    HttpSession session = null;
    ServletContext application = null;
    ServletConfig config = null;
    JspWriter out = null;
    Object page = this;
    JspWriter _jspx_out = null;
    PageContext _jspx_page_context = null;


    try {
      _jspxFactory = JspFactory.getDefaultFactory();
      response.setContentType("text/html; charset=gb2312");
      pageContext = _jspxFactory.getPageContext(this, request, response,
      			"", true, 8192, true);
      _jspx_page_context = pageContext;
      application = pageContext.getServletContext();
      config = pageContext.getServletConfig();
      session = pageContext.getSession();
      out = pageContext.getOut();
      _jspx_out = out;

      out.write("\r\n\r\n\r\n\r\n<html>\r\n");

Collection coll=(Collection)request.getAttribute("borrowQuery");

      out.write("\r\n<head>\r\n<title>图书馆管理系统</title>\r\n<link href=\"CSS/style.css\" rel=\"stylesheet\">\r\n<script src=\"JS/function.js\"></script>\r\n<script language=\"javascript\">\r\nfunction check(myform){\r\n\tif(myform.flag[0].checked==false && myform.flag[1].checked==false){\r\n\t\talert(\"请选择查询方式!\");return false;\r\n\t}\r\n\tif (myform.flag[1].checked){\r\n\t\tif(myform.sdate.value==\"\"){\r\n\t\t\talert(\"请输入开始日期\");myform.sdate.focus();return false;\r\n\t\t}\t\t\r\n\t\tif(CheckDate(myform.sdate.value)){\r\n\t\t\talert(\"您输入的开始日期不正确（如：2006-07-05）\\n 请注意闰年!\");myform.sDate.focus();return false;\r\n\t\t}\r\n\t\tif(myform.edate.value==\"\"){\r\n\t\t\talert(\"请输入结束日期\");myform.edate.focus();return false;\r\n\t\t}\t\t\r\n\t\tif(CheckDate(myform.edate.value)){\r\n\t\t\talert(\"您输入的结束日期不正确（如：2006-07-05）\\n 请注意闰年!\");myform.edate.focus();return false;\r\n\t\t}\r\n\t}\r\n}\r\n</script>\r\n</head>\r\n<body onLoad=\"clockon(bgclock)\">\r\n<table width=\"778\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" class=\"tableBorder\">\r\n  <tr>\r\n    <td height=\"183\">\r\n\t");
      out.write("\r\n\r\n\r\n\r\n");

//验证用户是否登录
String manager="";
manager=(String)session.getAttribute("manager");
if (manager==null || "".equals(manager)){
	response.sendRedirect("login.jsp");
}
ChStr chStr=new ChStr();
ManagerDAO managerDAO=new ManagerDAO();
ManagerForm form1=(ManagerForm)managerDAO.query_p(manager);
int sysset1=0;
int readerset1=0;
int bookset1=0;
int borrowback1=0;
int sysquery1=0;
if(form1!=null){
	sysset1=form1.getSysset();
	readerset1=form1.getReaderset();
	bookset1=form1.getBookset();
	borrowback1=form1.getBorrowback();
	sysquery1=form1.getSysquery();
}


      out.write("\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n<script src=\"JS/onclock.JS\"></script>\r\n<script src=\"JS/menu.JS\"></script>\r\n<div class=menuskin id=popmenu\r\n      onmouseover=\"clearhidemenu();highlightmenu(event,'on')\"\r\n      onmouseout=\"highlightmenu(event,'off');dynamichide(event)\" style=\"Z-index:100;position:absolute;\"></div>\r\n<table width=\"778\" border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\">\r\n  <tr>\r\n    <td height=\"150\" valign=\"top\" background=\"Images/top_bg.gif\" bgcolor=\"#EEEEEE\"><table width=\"100%\" height=\"53\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n      <tr>\r\n        <td width=\"77%\" height=\"18\">&nbsp;</td>\r\n        <td colspan=\"4\">&nbsp;</td>\r\n      </tr>\r\n      <tr>\r\n        <td>&nbsp;</td>\r\n        <td width=\"2%\"><img src=\"Images/Top_flag.gif\" width=\"3\" height=\"7\"></td>\r\n        <td width=\"8%\"><a href=\"#\" onClick=\"window.location.reload();\">刷新页面</a></td>\r\n        <td width=\"1%\"><img src=\"Images/Top_flag.gif\" width=\"3\" height=\"7\"></td>\r\n\t\t<script language=\"javascript\">\r\n");
      out.write("\t\t\tfunction myclose(){\r\n\t\t\t\tif(confirm(\"真的要关闭当前窗口吗?\")){\r\n\t\t\t\t\twindow.close();\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t</script>\r\n        <td width=\"12%\"><a href=\"#\" onClick=\"myclose()\" >关闭系统</a></td>\r\n      </tr>\r\n    </table>\r\n      <table width=\"98%\" height=\"93\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n        <tr>\r\n          <td align=\"right\" valign=\"bottom\" class=\"word_Green\">当前登录用户：");
      out.print(chStr.toChinese(manager));
      out.write("</td>\r\n        </tr>\r\n      </table></td>\r\n  </tr>\r\n  <tr>\r\n    <td height=\"33\" align=\"right\" background=\"Images/navigation_bg.gif\" bgcolor=\"#EEEEEE\"><table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n      <tr>\r\n        <td width=\"3%\">&nbsp;</td>\r\n        <td width=\"25%\"><div id=\"bgclock\" class=\"word_Green\"></div></td>\r\n\t\t<script language=\"javascript\">\r\n\t\t\tfunction quit(){\r\n\t\t\t\tif(confirm(\"真的要退出系统吗?\")){\r\n\t\t\t\t\twindow.location.href=\"logout.jsp\";\r\n\t\t\t\t}\r\n\t\t\t}\r\n\t\t</script>\r\n        <td width=\"70%\" align=\"right\"><a href=\"main.jsp\">首页</a>┊");
if(sysset1==1){
      out.write("<a  onmouseover=showmenu(event,sysmenu) onmouseout=delayhidemenu() class='navlink' style=\"CURSOR:hand\" >系统设置</a>┊");
}
if(readerset1==1){
      out.write("<a  onmouseover=showmenu(event,readermenu) onmouseout=delayhidemenu() class='navlink' style=\"CURSOR:hand\" >读者管理</a>┊");
}
if(bookset1==1){
      out.write("<a  onmouseover=showmenu(event,bookmenu) onmouseout=delayhidemenu() class='navlink' style=\"CURSOR:hand\" >图书管理</a>┊");
}
if(borrowback1==1){
      out.write("<a  onmouseover=showmenu(event,borrowmenu) onmouseout=delayhidemenu() class='navlink' style=\"CURSOR:hand\" >图书借还</a>┊");
}
if(sysquery1==1){
      out.write("<a  onmouseover=showmenu(event,querymenu) onmouseout=delayhidemenu() class='navlink' style=\"CURSOR:hand\" >系统查询</a>┊");
}
      out.write("<a  onmouseover=showmenu(event,sortmenu) onmouseout=delayhidemenu() class='navlink' style=\"CURSOR:hand\" >排行榜</a>┊<a  href=\"manager.do?action=querypwd\">更改口令</a>┊<a href=\"#\" onClick=\"quit()\">退出系统</a></td>\r\n        <td width=\"2%\">&nbsp;</td>\r\n      </tr>\r\n    </table></td>\r\n  </tr>\r\n</table>\r\n");
      out.write("\r\n\t</td>\r\n\t</tr>\r\n\t<td>\r\n\t<table width=\"100%\"  border=\"0\" cellspacing=\"0\" cellpadding=\"0\">\r\n  <tr>\r\n    <td valign=\"top\" bgcolor=\"#FFFFFF\"><table width=\"99%\" height=\"510\"  border=\"0\" align=\"center\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#FFFFFF\" class=\"tableBorder_gray\">\r\n  <tr>\r\n    <td height=\"510\" valign=\"top\" style=\"padding:5px;\"><table width=\"98%\" height=\"487\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n      <tr>\r\n        <td height=\"22\" valign=\"top\" class=\"word_orange\">当前位置：系统查询 &gt; 图书借阅查询 &gt;&gt;&gt;</td>\r\n      </tr>\r\n      <tr>\r\n        <td align=\"center\" valign=\"top\">\r\n\t\t<form name=\"myform\" method=\"post\" action=\"borrow.do?action=borrowQuery\">\r\n          <table width=\"98%\" height=\"67\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\" bgcolor=\"#E3F4F7\" class=\"tableBorder_gray\">\r\n            <tr>\r\n              <td rowspan=\"2\" align=\"center\">&nbsp;<img src=\"Images/search.gif\" width=\"45\" height=\"28\"></td>\r\n              <td height=\"29\"><input name=\"flag\" type=\"checkbox\" class=\"noborder\" value=\"a\" checked>\r\n");
      out.write("                请选择查询依据：\r\n                <select name=\"f\" class=\"wenbenkuang\" id=\"f\">\r\n                  <option value=\"barcode\">图书条形码</option>\r\n                  <option value=\"bookname\">图书名称</option>\r\n                  <option value=\"readerbarcode\">读者条形码</option>\r\n                  <option value=\"readername\">读者名称</option>\r\n                  </select>\r\n                  <input name=\"key\" type=\"text\" id=\"key\" size=\"50\">\r\n                  <input name=\"Submit\" type=\"submit\" class=\"btn_grey\" value=\"查询\" onClick=\"return check(myform)\"></td>\r\n            </tr>\r\n            <tr>\r\n              <td height=\"26\"><label>\r\n                <input name=\"flag\" type=\"checkbox\" class=\"noborder\" value=\"b\">\r\n              </label>\r\n                借阅时间：                从\r\n                <label>\r\n                <input name=\"sdate\" type=\"text\" id=\"sdate\">\r\n                </label> \r\n                到\r\n                <input name=\"edate\" type=\"text\" id=\"edate\">\r\n                (日期格式为：2006-07-05)</td>\r\n            </tr>\r\n          </table>\t\t\r\n");
      out.write("\t\t</form>\r\n\t\t");

if(coll==null || coll.isEmpty()){

      out.write("\r\n          <table width=\"100%\" height=\"30\"  border=\"0\" cellpadding=\"0\" cellspacing=\"0\">\r\n            <tr>\r\n              <td height=\"36\" align=\"center\">暂无图书借阅信息！</td>\r\n            </tr>\r\n          </table>\r\n          ");

}else{
  //通过迭代方式显示数据
  Iterator it=coll.iterator();
  String bookname="";
  String bookbarcode="";
  String readerbar="";
  String readername="";
  String borrowTime="";
  String backTime="";
  int ifback=0;
  String ifbackstr="";
  
      out.write("\r\n          <table width=\"98%\"  border=\"1\" cellpadding=\"0\" cellspacing=\"0\" bordercolor=\"#FFFFFF\" bordercolordark=\"#D2E3E6\" bordercolorlight=\"#FFFFFF\">\r\n  <tr align=\"center\" bgcolor=\"#e3F4F7\">\r\n    <td width=\"11%\">图书条形码</td>\r\n    <td width=\"29%\">图书名称</td>\r\n    <td width=\"15%\">读者条形码</td>\r\n    <td width=\"13%\">读者名称</td>\r\n    <td width=\"12%\">借阅时间</td>\r\n    <td width=\"12%\">应还时间</td>\r\n    <td width=\"8%\">是否归还</td>\r\n  </tr>\r\n");

  while(it.hasNext()){
    BorrowForm borrowForm=(BorrowForm)it.next();
	bookname=chStr.toChinese(borrowForm.getBookName());
	bookbarcode=borrowForm.getBookBarcode();
	readerbar=chStr.toChinese(borrowForm.getReaderBarcode());
	readername=chStr.toChinese(borrowForm.getReaderName());
	borrowTime=borrowForm.getBorrowTime();
	backTime=borrowForm.getBackTime();
	ifback=borrowForm.getIfBack();
	if(ifback==0){
		ifbackstr="未归还";
	}else{
		ifbackstr="已归还";
	}
	
      out.write("\r\n  <tr>\r\n    <td style=\"padding:5px;\">&nbsp;");
      out.print(bookbarcode);
      out.write("</td>\r\n    <td style=\"padding:5px;\">");
      out.print(bookname);
      out.write("</td>\r\n    <td style=\"padding:5px;\">&nbsp;");
      out.print(readerbar);
      out.write("</td>\r\n    <td style=\"padding:5px;\">&nbsp;");
      out.print(readername);
      out.write("</td>\r\n    <td style=\"padding:5px;\">&nbsp;");
      out.print(borrowTime);
      out.write("</td>\r\n    <td style=\"padding:5px;\">&nbsp;");
      out.print(backTime);
      out.write("</td>\r\n    <td align=\"center\" style=\"padding:5px;\">&nbsp;");
      out.print(ifbackstr);
      out.write("</td>\r\n  </tr>\r\n");

  }
}

      out.write("\r\n</table>\r\n          </td>\r\n      </tr>\r\n    </table>\r\n</td>\r\n  </tr>\r\n</table>");
      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</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);
    }
  }
}

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -