Java Source Code Warehouse :: Example

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="borrow" />
<jsp:setProperty name="form" property="formType" value="list" />
<jsp:setProperty name="form" property="formURL" value="/JavaLibrary/admin/borrow_list.jsp" />
<%  response.setHeader("Cache-Control", "no-cache");
	response.setHeader("Pragma", "no-cahce");
// 	URLcurrent = "/JavaLibrary/admin/borrow_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 variable
	String queryOrderField= "";
	String queryOrderType= "";
	String queryParameter= "";

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

	String borrowStatus = "";
	String borrowerID = "";
	String searchOpt1= "";
	String itemCallNumber = "";

	int recDisplayNum= 0;
	String recDisplayNumStr= "";

	ResultSet myResultSet=null;
	ResultSet rsCount=null;

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

	// Get the HTTP request parameter
	borrowStatus = request.getParameter("borrowStatus");
	borrowerID = request.getParameter("borrowerID");
	itemCallNumber = request.getParameter("itemCallNumber");
	searchOpt1 = request.getParameter("searchOpt1");
	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 (borrowStatus == null)
		borrowStatus = "all";
	
	if (borrowStatus.equals("all")) {
		queryFilter = "";
	} else {
		queryCondition = "";
		queryFilter = " WHERE borrowStatus = '" +borrowStatus +"'";
	}

	if(borrowerID == null)
		borrowerID = "";

	if (!borrowerID.equals("")) 
		querySearch = " borrowerID like '%" + borrowerID +"%' ";

	if(itemCallNumber ==null)
		itemCallNumber = "";
	
	if(!itemCallNumber.equals("")){
		if(!querySearch.equals(""))
			querySearch = querySearch +" " +searchOpt1 +" itemCallNumber like '%" +itemCallNumber +"%' ";
		else
			querySearch = " itemCallNumber like '%" +itemCallNumber +"%' ";	
	}

	// Generate the search query
	if(queryOrderField ==null)
		queryOrderField ="";

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

	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">Borrow List 
<%
	queryParameter="&queryOrderField=" +queryOrderField +
		"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
%>
      <form name="form1" action="../admin/borrow_list.jsp?<%= queryParameter%>" method="post">
        <center>
          <p>Limiting options: 
            <select name=borrowStatus>
              <option value="all">All borrow records
              <option value="overdue">Over Due
              <option value="borrow">Borrow Out
              <option value="return">Had Return
            </select>
          </p>
          <table width="55%" border="0">
            <tr> 
              <td width="29%">Borrower ID

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

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

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

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

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

What this is

Other links

The source code