reserve_list.jsp

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

%>
      <form name="form2" method="post" action="../admin/reserve_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="reserveStatus="+reserveStatus +"&reserverID=" +reserverID +
		"&searchOpt1=" +searchOpt1 +"&itemCallNumber=" +itemCallNumber +"&recDisplayNum=" +recDisplayNum;
%>
        
      <form name="form2" method="post" action="/JavaLibrary/servlet/sjservlets.FormProcess">
        <i>* click on Reserver ID to sent email for notice</i><br>

          
        <table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
          <tr>             
            <td width="4%"></td>
            <th width="18%" bgcolor="#D3DCE3">Reserver ID<a href=../admin/reserve_list.jsp?&queryOrderField=reserverID&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("reserverID") && 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/reserve_list.jsp?&queryOrderField=reserverID&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("reserverID") && 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="14%" bgcolor="#D3DCE3">Item Call No<a href=../admin/reserve_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/reserve_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">Reserve Date<a href=../admin/reserve_list.jsp?&queryOrderField=reserveDate&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("reserveDate") && 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/reserve_list.jsp?&queryOrderField=reserveDate&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("reserveDate") && 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">Cancel Date<a href=../admin/reserve_list.jsp?&queryOrderField=reserveCancelDate&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("reserveCancelDate") && 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/reserve_list.jsp?&queryOrderField=reserveCancelDate&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("reserveCancelDate") && 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="19%" bgcolor="#D3DCE3">Inform Date<a href=../admin/reserve_list.jsp?&queryOrderField=reserveInformDate&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("reserveInformDate") && 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/reserve_list.jsp?&queryOrderField=reserveInformDate&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("reserveInformDate") && 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="13%" bgcolor="#D3DCE3">Status<a href=../admin/reserve_list.jsp?&queryOrderField=reserveStatus&queryOrderType=ASC&<%= queryParameter%>><br>
              <% if(queryOrderField.equals("reserveStatus") && 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/reserve_list.jsp?&queryOrderField=reserveStatus&queryOrderType=DESC&<%= queryParameter%>> 
              <% if(queryOrderField.equals("reserveStatus") && 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="reserveStatus="+reserveStatus +"&reserverID=" +reserverID + 
		"&searchOpt1=" +searchOpt1 +"&itemCallNumber=" +itemCallNumber +
		"&queryOrderField=" +queryOrderField +"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
	
	// calculate the total record that will display for navigation
	String queryCount = "SELECT count(*) FROM reserverec" + 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 reserverec" + 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><input type=\"checkbox\" name=\"reserveRecNumber\" value=\"" +myResultSet.getString("reserveRecNumber") +"\">");
					out.println("</TD><TD><a href='mailto:" +myResultSet.getString("reserverEmail") +"'>" +myResultSet.getString("reserverID") +"</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("reserveDate"));
					out.println("</TD><TD>" +myResultSet.getString("reserveCancelDate"));
					out.println("</TD><TD>" +myResultSet.getString("reserveInformDate"));
					out.println("</TD><TD>" +myResultSet.getString("reserveStatus"));
					out.println("</TD></TR>");
					rowCount = rowCount+1;					
				}
			} catch(SQLException sqle) {
				System.err.println("Error connecting: " +sqle);		
			}
		} 
%>
        </table>
<br>
        <img src="../images/common/arrow_ltr.gif" width="38" height="22">With 
        selected: 
        <input type='submit' name='Delete' value='Cancel Reservation'>
        Or 
        <input type='reset' name='Reset' value='Reset'>
      </form> 
    
    </td>
  </tr>
</table>
<jsp:include page="../common/footer.jsp" flush="true" />
<% connectionPool.closeAllConnections(); %>
</body>
</html>