|
|
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="libraryitem" />
<jsp:setProperty name="form" property="formType" value="delete" />
<jsp:setProperty name="form" property="formURL" value="/JavaLibrary/search/search_libraryitem.jsp" />
<% response.setHeader("Cache-Control", "no-cache");
response.setHeader("Pragma", "no-cahce");
// URLcurrent = "/JavaLibrary/search/search_libraryitem.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 itemSubject = "";
String filterOpt1 = "";
String itemMediaType = "";
String filterOpt2 = "";
String itemLanguage = "";
String itemTitle = "";
String searchOpt1 = "";
String itemCallNumber = "";
String searchOpt2 = "";
String itemKeyword = "";
String searchOpt3 = "";
String itemISBN = "";
int recDisplayNum= 0;
String recDisplayNumStr= "";
ResultSet myResultSet=null;
ResultSet rsCount=null;
int pageCurrent=0;
int pageOffSet=0;
String errorMsg= "";
// Get the HTTP request parameter
itemSubject = request.getParameter("itemSubject");
filterOpt1 = request.getParameter("filterOpt1");
itemMediaType = request.getParameter("itemMediaType");
filterOpt2 = request.getParameter("filterOpt2");
itemLanguage = request.getParameter("itemLanguage");
itemTitle = request.getParameter("itemTitle");
searchOpt1 = request.getParameter("searchOpt1");
itemCallNumber = request.getParameter("itemCallNumber");
searchOpt2 = request.getParameter("searchOpt2");
itemKeyword = request.getParameter("itemKeyword");
searchOpt3 = request.getParameter("searchOpt3");
itemISBN = request.getParameter("itemISBN");
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 (itemSubject == null)
itemSubject = "all";
if (!(itemSubject.equals("all"))) {
if ((itemSubject.equals("Arts")) || (itemSubject.equals("Business"))
|| (itemSubject.equals("Computing")) || (itemSubject.equals("Commerce"))
|| (itemSubject.equals("Education")) || (itemSubject.equals("Engineering and Surveying"))
|| (itemSubject.equals("Science and Technology"))) {
queryFilter = " WHERE itemCategory = '" +itemSubject +"' ";
} else {
queryFilter = " WHERE itemSubject = '" +itemSubject +"' ";
}
}
if(itemMediaType == null)
itemMediaType = "all";
if(!(itemMediaType.equals("all"))) {
if(queryFilter.equals("")) {
queryFilter = " WHERE itemMediaType = '" +itemMediaType +"' ";
} else {
queryFilter = queryFilter +filterOpt1 +" itemMediaType = '" +itemMediaType +"' ";
}
}
if(itemLanguage == null)
itemLanguage = "all";
if(!(itemLanguage.equals("all"))) {
if(queryFilter.equals("")) {
queryFilter = " WHERE itemLanguage = '" +itemLanguage +"' ";
}else {
queryFilter = queryFilter +filterOpt2 +" itemLanguage = '" +itemLanguage +"' ";
}
}
if(itemTitle == null)
itemTitle = "";
if (!itemTitle.equals(""))
querySearch = " itemTitle like '%" + itemTitle +"%' ";
if(itemCallNumber ==null)
itemCallNumber = "";
if(!itemCallNumber.equals("")){
if(!querySearch.equals(""))
querySearch = querySearch +" " +searchOpt1 +" itemCallNumber like '%" +itemCallNumber +"%' ";
else
querySearch = " itemCallNumber like '%" +itemCallNumber +"%' ";
}
if(itemKeyword ==null)
itemKeyword = "";
if(!itemKeyword.equals("")){
if(!querySearch.equals(""))
querySearch = querySearch +" " +searchOpt2 +" itemKeyword like '%" +itemKeyword +"%' ";
else
querySearch = " itemKeyword like '%" +itemKeyword +"%' ";
}
if(itemISBN ==null)
itemISBN = "";
if(!itemISBN.equals("")){
if(!querySearch.equals(""))
querySearch = querySearch +" " +searchOpt3 +" itemISBN like '%" +itemISBN +"%' ";
else
querySearch = " itemISBN like '%" +itemISBN +"%' ";
}
// Generate the search query
if(queryOrderField ==null)
queryOrderField ="";
if (queryOrderType ==null)
queryOrderType ="";
if((queryOrderField.equals("")) || (queryOrderType.equals("")))
queryOrder = " ORDER BY itemTitle 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">
<center>
<b>Search Items
</b>
</center>
<center>
<%@ include file="../common/printview.jsp" %>
<%
queryParameter="&queryOrderField=" +queryOrderField +
"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
%>
<form name="form1" method="post" action="../search/search_libraryitem.jsp?<%= queryParameter%>">
<p>Limiting options:
</p>
<table width="60%" border="0">
<tr>
<td width="24%">Subject: |
<td width="45%">
<select name="itemSubject">
<option value="all" selected>All Subject
<option value="Arts">Arts
<option value="Anthropology">....Anthropology
<option value="Journalism">....Journalism
<option value="English Literature">....English Literature
<option value="Media">....Media
<option value="Music">....Music
<option value="Theatre">....Theatre
<option value="Visual Arts">....Visual Arts
<option value="Business">Business
<option value="CRM">....CRM
<option value="Economics">....Economics
<option value="Employment">....Employment
<option value="HRM">....HRM
<option value="Marketing">....Marketing
<option value="Information Systems">....Information Systems
<option value="Resource Management">....Resource Management
<option value="Commerce">Commerce
<option value="Accounting">....Accounting
<option value="Banking">....Banking
<option value="Finance">....Finance
<option value="Law">....Law
<option value="Computing">Computing
<option value="Application">....Application
<option value="Certify Exam">....Certify Exam
<option value="Computer Graphics">....Computer Graphics
<option value="Database">....Database
<option value="Networking">....Networking
<option value="Operating System">....Operating System
<option value="Programming">....Programming
<option value="Telecommunication">....Telecommunicaiton
<option value="Web Development">....Web Development
<option value="Education">Education
<option value="Early Childhood">....Early Childhood
<option value="Further Edu and Training">....Further Edu and Training
<option value="Engineering and Surveying">Engineering and Surveying
<option value="Agricultural">....Agricultural
<option value="Civil">....Civil
<option value="Electrical">....Electrical
<option value="Mechanical">....Mechanical
<option value="Science and Technology">Science and Technology
<option value="Biology">....Biology
<option value="Chemistry">....Chemistry
<option value="Maths">....Maths
<option value="Nursing">....Nursing
<option value="Physics">....Physics
<option value="Psychology">....Psychology
</select>
</td>
<td width="31%">
<select name=filterOpt1>
<option value="and" selected>And
<option value="or">Or
</select>
</td>
</tr>
<tr>
<td width="24%">Media Type:
<td width="45%">
<select name=itemMediaType>
<option value="all" selected>All Media Type
<option value="Audio CD">Audio CD
<option value="Audio Cassette">Audio Cassette
<option value="Book">Book
<option value="CD-ROM">CD-ROM
<option value="Magazine">Magazine
<option value="Map">Map
<option value="Other">Other
<option value="Video">Video
</select>
</td>
<td width="31%">
<select name=filterOpt2>
<option value="and" selected>And
<option value="or">Or
</select>
</td>
</tr>
<tr>
<td width="24%">Language:
<td width="45%">
<select name=itemLanguage>
<option value="all" selected>All Language
<option value="English">English
<option value="Chinese">Chinese
<option value="Malay">Malay
<option value="Tamil">Tamil
</select>
</td>
<td width="31%">
</tr>
</table>
<br>
<table width="50%" border="0">
<tr>
<td width="21%">Title
<td width="5%">
<td colspan="2">
<input type="text" name="itemTitle" size="54" maxlength="50">
</td>
</tr>
<tr>
<td width="21%">Call Number
<td width="5%">
<select name="searchOpt1">
<option value="and" selected>And
<option value="or">Or
</select>
</td>
<td colspan="2">
<input type="text" name="itemCallNumber" size="54" maxlength="50">
</td>
</tr>
<tr>
<td width="21%">Keyword
<td width="5%">
<select name="searchOpt2">
<option value="and" selected>And
<option value="or">Or
</select>
</td>
<td colspan="2">
<input type="text" name="itemKeyword" size="54" maxlength="50">
</td>
</tr>
<tr>
<td width="21%">ISBN
<td width="5%">
<select name="searchOpt3">
<option value="and" selected>And
<option value="or">Or
</select>
</td>
<td width="30%">
<input type="text" name="itemISBN" size="12" maxlength="10">
</td>
<td width="44%">
<div align="center">
<input type="submit" name="Search" value="Search">
</div>
</td>
</tr>
</table>
</form>
</center>
<% queryParameter="itemSubject=" +itemSubject +"&filterOpt1=" +filterOpt1 +
"&itemMediaType=" +itemMediaType + "&filterOpt2=" +filterOpt2 +
"&itemLanguage=" +itemLanguage +"&itemTitle=" +itemTitle +"&searchOpt1=" +searchOpt1 +
"&itemCallNumber=" +itemCallNumber +"searchOpt2=" +searchOpt2 +
"&itemKeyword=" +itemKeyword +"searchOpt3=" +searchOpt3 +"&itemISBN=" +itemISBN +
"&queryOrderField=" +queryOrderField +"&queryOrderType=" +queryOrderType;
%>
<form name="form2" method="post" action="../search/search_libraryitem.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="itemSubject=" +itemSubject +"&filterOpt1=" +filterOpt1 +
"&itemMediaType=" +itemMediaType + "&filterOpt2=" +filterOpt2 +
"&itemLanguage=" +itemLanguage +"&itemTitle=" +itemTitle +"&searchOpt1=" +searchOpt1 +
"&itemCallNumber=" +itemCallNumber +"searchOpt2=" +searchOpt2 +
"&itemKeyword=" +itemKeyword +"searchOpt3=" +searchOpt3 +"&itemISBN=" +itemISBN +
"&recDisplayNum=" +recDisplayNum;
%>
<form name='userList' action='/JavaLibrary/servlet/sjservlets.FormProcess'>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr>
<td width="2%">
<th width="36%" bgcolor="#D3DCE3">Title* >
<% if(queryOrderField.equals("itemTitle") && 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("itemTitle") && 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">Subject >
<% if(queryOrderField.equals("itemSubject") && 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("itemSubject") && 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">Media >
<% if(queryOrderField.equals("itemMediaType") && 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("itemMediaType") && 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">Lang >
<% if(queryOrderField.equals("itemLanguage") && 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("itemLanguage") && 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="3%" bgcolor="#D3DCE3">Qty
<th width="3%" bgcolor="#D3DCE3">Ava
<th width="3%" bgcolor="#D3DCE3">Bor
<th width="4%" bgcolor="#D3DCE3">Res
</tr>
<% queryParameter="itemSubject=" +itemSubject +"&filterOpt1=" +filterOpt1 +
"&itemMediaType=" +itemMediaType + "&filterOpt2=" +filterOpt2 +
"&itemLanguage=" +itemLanguage +"&itemTitle=" +itemTitle +"&searchOpt1=" +searchOpt1 +
"&itemCallNumber=" +itemCallNumber +"searchOpt2=" +searchOpt2 +
"&itemKeyword=" +itemKeyword +"searchOpt3=" +searchOpt3 +"&itemISBN=" +itemISBN +
"&queryOrderField=" +queryOrderField +"&queryOrderType=" +queryOrderType +
"&recDisplayNum=" +recDisplayNum;
// calculate the total record that will display for navigation
String queryCount = "SELECT count(*) FROM libraryitem" + 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 libraryitem" + 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("itemTitle") +"");
out.println("</TD> | " +myResultSet.getString("itemSubject"));
out.println("</TD> | " +myResultSet.getString("itemMediaType"));
out.println("</TD> | " +myResultSet.getString("itemLanguage"));
out.println("</TD> | " +myResultSet.getString("itemTotQuantity"));
out.println("</TD> | " +myResultSet.getString("itemTotAvailable"));
out.println("</TD> | " +myResultSet.getString("itemTotBorrow"));
out.println("</TD> | " +myResultSet.getString("itemTotReserve"));
out.println("</TD> |
");
rowCount = rowCount+1;
}
} catch(SQLException sqle) {
System.err.println("Error connecting: " +sqle);
}
}
%>
</table>
</form>
<br>
</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