|
|
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
<% response.setHeader("Cache-Control", "no-cache");
response.setHeader("Pragma", "no-cahce");
// URLcurrent = "/JavaLibrary/operation/return.jsp";
// URLcurrent=response.encodeURL(URLcurrent);
%>
<%@ page import="java.util.Date, java.text.DateFormat, java.util.*" %>
<%@ include file="/common/common.jsp" %>
<%@ include file="../common/dbconnect.jsp" %>
<jsp:setProperty name="form" property="formName" value="borrowrec" />
<jsp:setProperty name="form" property="formType" value="return" />
<jsp:setProperty name="form" property="formURL" value="/JavaLibrary/operation/return.jsp" />
<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
Date returnDate = new Date();
String returnDateStr = DateFormat.getDateInstance(DateFormat.MEDIUM).format(returnDate);
String queryOrderField= "";
String queryOrderType= "";
String queryParameter= "";
String queryFilter= "";
String querySearch= "";
String queryCondition= "";
String queryOrder= "";
String query= "";
String borrowerID = "";
boolean skipSearch = false;
int recDisplayNum= 0;
String recDisplayNumStr= "";
ResultSet myResultSet=null;
ResultSet rsCount=null;
int pageCurrent=0;
int pageOffSet=0;
String errorMsg= "";
// Get the HTTP request parameter
borrowerID = request.getParameter("borrowerID");
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(borrowerID == null)
borrowerID = "";
if (!borrowerID.equals("")) {
if (borrowerID.equals(staff.getUserID())) {
errorMsg = "Error: borrower ID " + borrowerID +" cannot be same as staff in charge";
skipSearch = true;
} else {
querySearch = " borrowerID = '" + borrowerID +"' ";
}
} else {
skipSearch = true;
}
// Generate the search query
queryFilter = " WHERE borrowStatus != 'return' ";
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">Return
<center>
<table width="75%" border="0">
<tr>
<td width="25%">Staff ID: <%= staff.getUserID() %> |
<td width="25%">
<td width="25%">Today:
<% out.println(returnDateStr); %>
</td>
<td width="25%">
</tr>
</table>
<font color=RED>
<% out.println("" +errorMsg +""); %>
</font>
</center>
<center>
<font color=RED>
</center>
<hr>
<table width="100%" border="0" bgcolor="#66FFCC">
<tr>
<td>
<%
queryParameter="&queryOrderField=" +queryOrderField +
"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
%>
<form name="form1" method="post" action="../operation/return.jsp?<%= queryParameter%>">
<p>Borrower ID
<input type="text" name="borrowerID" size="30">
<input type="submit" name="Submit" value="Submit">
</p>
</form>
</td>
</tr>
</table>
<hr>
<table width="100%" border="0" bgcolor="#66FFCC">
<tr>
<td>
<% queryParameter="&queryOrderField=" +queryOrderField +
"&queryOrderType=" +queryOrderType +"&borrowerID=" +borrowerID;
%>
<form action="../operation/return.jsp?<%= queryParameter%>" name="form2" method="post">
<p>
<input type="submit" name="Show" value="Show">
<input type="text" name="recDisplayNum" maxlength="2" size="4" value="<%= recDisplayNum %>">
records per page </p>
</form>
<center>
<b>
</b>
</center>
<%
queryParameter="&borrowerID=" +borrowerID +"&recDisplayNum=" +recDisplayNum;
%>
<i> Borrower ID: <%= borrowerID %>
<form name="form3" method="post" action="/JavaLibrary/servlet/sjservlets.FormProcess">
* Penalty = Total over due day * 1.50<br>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr valign="top">
<td width="4%">
<th width="14%" bgcolor="#D3DCE3">Item Call No
<a href=../operation/return.jsp?&queryOrderField=itemCallNumber&queryOrderType=ASC&<%= queryParameter%>>
<% 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="18%" bgcolor="#D3DCE3">Borrow Date
<a href=../operation/return.jsp?&queryOrderField=borrowDate&queryOrderType=ASC&<%= queryParameter%>>
<% 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="18%" bgcolor="#D3DCE3">Due Date
<a href=../operation/return.jsp?&queryOrderField=dueDate&queryOrderType=ASC&<%= queryParameter%>>
<% 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="13%" bgcolor="#D3DCE3">Status
<a href=../operation/return.jsp?&queryOrderField=borrowStatus&queryOrderType=ASC&<%= queryParameter%>>
<% 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>
<th width="13%" bgcolor="#D3DCE3">Overdue Day
<th width="13%" bgcolor="#D3DCE3">Penalty
</tr>
<%
if(!skipSearch) {
queryParameter="&borrowerID=" +borrowerID +"&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 *, (TO_DAYS(NOW())-TO_DAYS(dueDate)) as overdueDay 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>");
out.println("</TD>" +myResultSet.getString("itemCallNumber") +"");
out.println("</TD> | " +myResultSet.getString("borrowDate"));
out.println("</TD> | " +myResultSet.getString("dueDate"));
out.println("</TD> | " +myResultSet.getString("borrowStatus"));
if(Integer.parseInt(myResultSet.getString("overdueDay")) > 0) {
out.println("</TD> | " +myResultSet.getString("overdueDay"));
out.println("</TD> | $" +Integer.parseInt(myResultSet.getString("overdueDay"))*1.50);
} else {
out.println("</TD> | -");
out.println("</TD> | -");
}
out.println("</TD> |
");
rowCount = rowCount+1;
}
} catch(SQLException sqle) {
System.err.println("Error connecting: " +sqle);
}
}
}
%>
</table>
<input type="hidden" name="borrowerID" value="<%= borrowerID %>">
<input type="hidden" name="returnDate" value="<%= ServletUtilities.dateToString(returnDate) %>">
<br>
<% if(!skipSearch) { %>
<img src="../images/common/arrow_ltr.gif" width="38" height="22">With
selected:
<input type='submit' name='Delete' value='Process item return'>
Or
<input type='reset' name='Reset' value='Reset'>
<% } %>
</form>
<p>
</td>
</tr>
</table>
</td>
</tr>
</table>
<jsp:include page="../common/footer.jsp" flush="true" />
<% connectionPool.closeAllConnections(); %>
</body>
</html>
The search page
Other source code files at this package level
Click here to learn more about this project