borrow_list.jsp

基于servlet的图书馆管理系统,学习参考

		"&queryOrderType=" +queryOrderType +"&borrowerID=" +borrowerID +"&searchOpt1=" +searchOpt1 +
		"&itemCallNumber=" +itemCallNumber;
%>
      <form name="form2" method="post" action="../admin/borrow_list.jsp?<%= queryParameter%>">
        <input type="submit" name="Show" value="Show">
          <input type="text" name="recDisplayNum" maxlength="2" size="4" value="<%= recDisplayNum %>">
          records per page 
        </form>
<%
	queryParameter="borrowStatus="+borrowStatus +"&borrowerID=" +borrowerID +
		"&searchOpt1=" +searchOpt1 +"&itemCallNumber=" +itemCallNumber +"&recDisplayNum=" +recDisplayNum;
%>
        <form name="form2" method="post" action="../admin/borrow_list.jsp">
        <i>* click on Borrower ID to sent email for notice</i><br>

          
        <table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
          <tr> 
            <th width="18%" bgcolor="#D3DCE3">Borrower ID<a href=../admin/borrow_list.jsp?&queryOrderField=borrowerID&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("borrowerID") && queryOrderType.equals("ASC")) 
					out.println("<img src='../images/common/icon_sort_up_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_up_off.gif' width='20' height='7' border='0'>");
				%>
              </a> <a href=../admin/borrow_list.jsp?&queryOrderField=borrowerID&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("borrowerID") && queryOrderType.equals("DESC")) 
					out.println("<img src='../images/common/icon_sort_down_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_down_off.gif' width='20' height='7' border='0'>");
				%>
              </a></th>
            <th width="20%" bgcolor="#D3DCE3">Item Call No<a href=../admin/borrow_list.jsp?&queryOrderField=itemCallNumber&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("itemCallNumber") && queryOrderType.equals("ASC")) 
					out.println("<img src='../images/common/icon_sort_up_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_up_off.gif' width='20' height='7' border='0'>");
				%>
              </a> <a href=../admin/borrow_list.jsp?&queryOrderField=itemCallNumber&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("itemCallNumber") && queryOrderType.equals("DESC")) 
					out.println("<img src='../images/common/icon_sort_down_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_down_off.gif' width='20' height='7' border='0'>");
				%>
              </a></th>
            <th width="18%" bgcolor="#D3DCE3">Borrow Date<a href=../admin/borrow_list.jsp?&queryOrderField=borrowDate&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("borrowDate") && queryOrderType.equals("ASC")) 
					out.println("<img src='../images/common/icon_sort_up_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_up_off.gif' width='20' height='7' border='0'>");
				%>
              </a> <a href=../admin/borrow_list.jsp?&queryOrderField=borrowDate&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("borrowDate") && queryOrderType.equals("DESC")) 
					out.println("<img src='../images/common/icon_sort_down_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_down_off.gif' width='20' height='7' border='0'>");
				%>
              </a></th>
            <th width="15%" bgcolor="#D3DCE3">Due Date<a href=../admin/borrow_list.jsp?&queryOrderField=dueDate&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("dueDate") && queryOrderType.equals("ASC")) 
					out.println("<img src='../images/common/icon_sort_up_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_up_off.gif' width='20' height='7' border='0'>");
				%>
              </a> <a href=../admin/borrow_list.jsp?&queryOrderField=dueDate&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("dueDate") && queryOrderType.equals("DESC")) 
					out.println("<img src='../images/common/icon_sort_down_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_down_off.gif' width='20' height='7' border='0'>");
				%>
              </a></th>
            <th width="17%" bgcolor="#D3DCE3">Return Date<a href=../admin/borrow_list.jsp?&queryOrderField=returnDate&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("returnDate") && queryOrderType.equals("ASC")) 
					out.println("<img src='../images/common/icon_sort_up_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_up_off.gif' width='20' height='7' border='0'>");
				%>
              </a> <a href=../admin/borrow_list.jsp?&queryOrderField=returnDate&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("returnDate") && queryOrderType.equals("DESC")) 
					out.println("<img src='../images/common/icon_sort_down_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_down_off.gif' width='20' height='7' border='0'>");
				%>
              </a></th>
            <th width="12%" bgcolor="#D3DCE3">Status<a href=../admin/borrow_list.jsp?&queryOrderField=borrowStatus&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("borrowStatus") && queryOrderType.equals("ASC")) 
					out.println("<img src='../images/common/icon_sort_up_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_up_off.gif' width='20' height='7' border='0'>");
				%>
              </a> <a href=../admin/borrow_list.jsp?&queryOrderField=borrowStatus&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("borrowStatus") && queryOrderType.equals("DESC")) 
					out.println("<img src='../images/common/icon_sort_down_on.gif' width='20' height='7' border='0'>");
					else
					out.println("<img src='../images/common/icon_sort_down_off.gif' width='20' height='7' border='0'>");
				%>
              </a></th>
          </tr>
<%
	queryParameter="borrowStatus="+borrowStatus +"&borrowerID=" +borrowerID + 
		"&searchOpt1=" +searchOpt1 +"&itemCallNumber=" +itemCallNumber +
		"&queryOrderField=" +queryOrderField +"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
	

	// Get the total record number to display for navigation
	String queryCount = "SELECT count(*) FROM borrowrec" + queryCondition;
   	try {  
      		Connection connection = connectionPool.getConnection();
			rsCount=DatabaseUtilities.getQueryResultSet(connection, queryCount, false);                                           
      		connectionPool.free(connection);
    	} catch(Exception e) {
      		errorMsg = "Error: " + e;    		
    	}  

		int recCount=0;  
		while (rsCount.next()){
			recCount=rsCount.getInt(1);
		}

		int pageCount = (recCount+recDisplayNum-1)/recDisplayNum;
		String strPage;
		strPage=request.getParameter("pageCurrent");
		if (strPage==null){
			pageCurrent = 1;
		} else{
			pageCurrent=Integer.parseInt(strPage);
		}
		if (pageCurrent<1) pageCurrent=1;
			pageOffSet=(pageCurrent-1)*recDisplayNum;
		
	// Get the request record result from search query
	query = "SELECT * FROM borrowrec" + queryCondition + queryOrder +" limit " +pageOffSet +"," +recDisplayNum;
  		try {  
      		Connection connection = connectionPool.getConnection();
			myResultSet = DatabaseUtilities.getQueryResultSet(connection, query, false);                                        
      		connectionPool.free(connection);
    	} catch(Exception e) {
      		errorMsg = "Error: " + e;    		
    	}            	
%>
          <%@ include file="/common/page_count.jsp" %>
          <%
		// Display the search result
    	if (myResultSet != null){
			int rowCount = 1 ; // set counter to separate even or odd
			try{
				while(myResultSet.next()) {
	    			if (rowCount % 2 == 0)
	       				out.println ("<tr bgcolor=#CCCCCC align=left>");
					else 
					out.println ("<tr bgcolor=#DDDDDD align=left>");
					out.println("<TD><a href='mailto:" +myResultSet.getString("borrowerEmail") +"'>" +myResultSet.getString("borrowerID") +"</a>");
					out.println("</TD><TD><a href='/JavaLibrary/libraryitem/libraryitem_view.jsp?itemCallNumber=" +myResultSet.getString("itemCallNumber") +"'>" +myResultSet.getString("itemCallNumber") +"</a>");
					out.println("</TD><TD>" +myResultSet.getString("borrowDate"));
					out.println("</TD><TD>" +myResultSet.getString("dueDate"));
					out.println("</TD><TD>" +myResultSet.getString("returnDate"));
					out.println("</TD><TD>" +myResultSet.getString("borrowStatus"));
					out.println("</TD></TR>");
					rowCount = rowCount+1;					
				}
			} catch(SQLException sqle) {
				System.err.println("Error connecting: " +sqle);		
			}
		} 
%>
        </table>
        </form> 
		<br>    
    </td>
  </tr>
</table>
<jsp:include page="../common/footer.jsp" flush="true" />
<% connectionPool.closeAllConnections(); %>
</body>
</html>