Java Source Code Warehouse :: Example :: my_reservation

What this is

This file is included in the DevDaily.com "Java Source Code Warehouse" project. The intent of this project is to help you "Learn Java by Example" ^TM.

The source code

<%@ include file="/common/common.jsp" %>
<%@ include file="../common/dbconnect.jsp" %>
<jsp:setProperty name="form" property="formName" value="reserve" />
<jsp:setProperty name="form" property="formType" value="delete" />
<jsp:setProperty name="form" property="formURL" value="/JavaLibrary/user/my_reservation_list.jsp" />
<%  response.setHeader("Cache-Control", "no-cache");
	response.setHeader("Pragma", "no-cahce");
// 	URLcurrent = "/JavaLibrary/user/my_reservation_list.jsp";
//	URLcurrent=response.encodeURL(URLcurrent);	
%>
<html>
<head>
<title>Library Management System
<META NAME="description" CONTENT="">
<META NAME="keywords" CONTENT="">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
   A:link                  { text-decoration:  none; font-weight: bold; color: #660033}
   A:active                { text-decoration:  none; font-weight: bold; color: #660033}
   A:visited               { text-decoration:  none; font-weight: bold; color: #336699}
   A:hover                 { text-decoration:  underline; font-weight: bold; color: #FF9999}
.footerLink {  font-family: Arial, Helvetica, sans-serif; font-size: 9pt; font-weight: bold; color: #000099}
-->
</style>
</head>

<body bgcolor="#0099ff" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0" onLoad="">
<%
	// Initialize the variables
	String queryOrderField= "";
	String queryOrderType= "";
	String queryParameter= "";

	String queryFilter= "";
	String querySearch= "";
	String queryCondition= "";
	String queryOrder= "";
	String query= "";

	String reserveStatus = "";

	int recDisplayNum= 0;
	String recDisplayNumStr= "";

	ResultSet myResultSet=null;
	ResultSet rsCount=null;

	int pageCurrent=0;
	int pageOffSet=0;
    String errorMsg= "";

	// Get the HTTP request parameter
	reserveStatus = request.getParameter("reserveStatus");
	recDisplayNumStr= request.getParameter("recDisplayNum");
	queryOrderField = request.getParameter("queryOrderField");
	queryOrderType = request.getParameter("queryOrderType");

	// Checking the HTTP request parameter
	if (recDisplayNumStr==null)
		recDisplayNum = 5;
	else
		recDisplayNum = Integer.parseInt(recDisplayNumStr);
	if (recDisplayNum <1) recDisplayNum = 1;

	if (reserveStatus == null)
		reserveStatus = "all";
	
	if (reserveStatus.equals("all")) {
		queryFilter = " WHERE reserverID ='" +login.getUserID() +"' ";
	} else {
		queryCondition = "";
		queryFilter = " WHERE reserverID='" +login.getUserID() +"'AND reserveStatus = '" +reserveStatus +"'";
	}

	if(queryOrderField ==null)
		queryOrderField ="";

	if (queryOrderType ==null)
		queryOrderType ="";

	// Generate the search query
	if((queryOrderField.equals("")) || (queryOrderType.equals("")))
		queryOrder = " ORDER BY itemCallNumber ASC ";
	else 
		queryOrder = " ORDER BY " +queryOrderField +" " +queryOrderType;

	if( queryFilter.equals("") ) {
		if(querySearch.equals(""))
			queryCondition = "";
		else			
			queryCondition = " where " +querySearch;
	} else {
		if (querySearch.equals(""))
			queryCondition = queryFilter;
		else
			queryCondition = queryFilter + " and " +querySearch;
	}
%>
<a name="top"> 
<%@ include file="../common/header_select.jsp" %>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
  <tr bgcolor="#f1f1f1"> 
    <td width="180" align="left" valign="top"> 
	  	  <%@ include file = "../common/navi.jsp" %>
    </td>
        <TD width=1 bgColor=#999999>
    <td valign="top" width="100%" bgcolor="#f1f1f1"> 
      <p align="center">My Reservation Record

        <br>
        <%@ include file="../common/printview.jsp" %>
      </p>
<%
	queryParameter="&queryOrderField=" +queryOrderField +
		"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
%>
      <form name="form1" action="my_borrow_list.jsp?<%= queryParameter%>" method="post">
        <center>
          Limiting options: 
          <select name=reserveStatus>
            <option value="all" selected>All reserve records
            <option value="over">Over reserve period
            <option value="available">Available
            <option value="queue">Queue
          </select>
          <input type="submit" name="Search" value="Go">
          <br>
        </center>
      </form>
<%		queryParameter="reserveStatus="+reserveStatus +"&queryOrderField=" +queryOrderField +
		"&queryOrderType=" +queryOrderType;
%>
      <form name="form2" method="post" action="my_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="reserveStatus="+reserveStatus +"&recDisplayNum=" +recDisplayNum;
%>
        
      <form name="form2" method="post" action="/JavaLibrary/servlet/sjservlets.FormProcess">
        <i>* click on User ID to view/edit the record


          <table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
          <tr> 
            <td width="3%">

" +myResultSet.getString("itemCallNumber") +""); out.println("</TD>

" +myResultSet.getString("reserveDate")); out.println("</TD>

" +myResultSet.getString("reserveCancelDate")); out.println("</TD>

" +myResultSet.getString("reserveInformDate")); out.println("</TD>

" +myResultSet.getString("reserveStatus")); out.println("</TD>

What this is

Other links

The source code