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.
Other links
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/user/my_borrow_list.jsp" />
<% response.setHeader("Cache-Control", "no-cache");
response.setHeader("Pragma", "no-cahce");
// URLcurrent = "/JavaLibrary/user/my_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 variables
String queryOrderField= "";
String queryOrderType= "";
String queryParameter= "";
String queryFilter= "";
String querySearch= "";
String queryCondition= "";
String queryOrder= "";
String query= "";
String borrowStatus = "";
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");
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 = " WHERE borrowerID ='" +login.getUserID() +"' ";
} else {
queryCondition = "";
queryFilter = " WHERE borrowerID='" +login.getUserID() +"'AND borrowStatus = '" +borrowStatus +"'";
}
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 Borrower 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=borrowStatus>
<option value="all">All borrow records
<option value="overdue">Over Due
<option value="borrow">Currently On Hand
<option value="return">Had Return
</select>
<input type="submit" name="Search" value="Go">
<br>
</center>
</form>
<% queryParameter="borrowStatus="+borrowStatus +"&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="borrowStatus="+borrowStatus +"&recDisplayNum=" +recDisplayNum;
%>
<form name="form2" method="post" action="my_borrow_list.jsp">
<i>* click on User ID to view/edit the record
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr>
<th width="25%" bgcolor="#D3DCE3">Item Call No>
<% 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> >
<% 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 width="22%" bgcolor="#D3DCE3">Borrow Date>
<% 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> >
<% 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 width="21%" bgcolor="#D3DCE3">Due Date>
<% 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> >
<% 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 width="17%" bgcolor="#D3DCE3">Return Date>
<% 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> >
<% 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 width="15%" bgcolor="#D3DCE3">Status>
<% 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> >
<% 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>
</tr>
<%
queryParameter="borrowStatus="+borrowStatus +"&queryOrderField=" +queryOrderField +
"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
// calculate the total record that will 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>" +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> | | 
The search page
Other source code files at this package level
Click here to learn more about this project