📄 libraryitem_list.jsp
字号:
<td width="45%">
<select name=itemMediaType>
<option value="all" selected>All Media Type</option>
<option value="Audio CD">Audio CD</option>
<option value="Audio Cassette">Audio Cassette</option>
<option value="Book">Book</option>
<option value="CD-ROM">CD-ROM</option>
<option value="Magazine">Magazine</option>
<option value="Map">Map</option>
<option value="Other">Other</option>
<option value="Video">Video</option>
</select>
</td>
<td width="31%">
<select name=filterOpt2>
<option value="and" selected>And</option>
<option value="or">Or</option>
</select>
</td>
</tr>
<tr>
<td width="24%">Language: </td>
<td width="45%">
<select name=itemLanguage>
<option value="all" selected>All Language</option>
<option value="English">English</option>
<option value="Chinese">Chinese</option>
<option value="Malay">Malay </option>
<option value="Tamil">Tamil</option>
</select>
</td>
<td width="31%"> </td>
</tr>
</table>
<br>
<table width="50%" border="0">
<tr>
<td width="21%">Title</td>
<td width="5%"> </td>
<td colspan="2">
<input type="text" name="itemTitle" size="54" maxlength="50">
</td>
</tr>
<tr>
<td width="21%">Call Number</td>
<td width="5%">
<select name="searchOpt1">
<option value="and" selected>And</option>
<option value="or">Or</option>
</select>
</td>
<td colspan="2">
<input type="text" name="itemCallNumber" size="54" maxlength="50">
</td>
</tr>
<tr>
<td width="21%">Keyword</td>
<td width="5%">
<select name="searchOpt2">
<option value="and" selected>And</option>
<option value="or">Or</option>
</select>
</td>
<td colspan="2">
<input type="text" name="itemKeyword" size="54" maxlength="50">
</td>
</tr>
<tr>
<td width="21%">ISBN</td>
<td width="5%">
<select name="searchOpt3">
<option value="and" selected>And</option>
<option value="or">Or</option>
</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="libraryitem_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="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'>
<i>* click on title to edit the record</i>
<table width="100%" border="0" cellspacing="1" cellpadding="1" align="center">
<tr valign="top">
<td width="5%"></td>
<th width="42%" bgcolor="#D3DCE3"><b>Title*</b><a href=libraryitem_list.jsp?&queryOrderField=itemTitle&queryOrderType=ASC&<%= queryParameter%>>
<br>
<% 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> <a href=libraryitem_list.jsp?&queryOrderField=itemTitle&queryOrderType=DESC&<%= queryParameter%>>
<% 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>
<th width="13%" bgcolor="#D3DCE3"><b>Subject</b><a href=libraryitem_list.jsp?&queryOrderField=itemSubject&queryOrderType=ASC&<%= queryParameter%>>
<br>
<% 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> <a href=libraryitem_list.jsp?&queryOrderField=itemSubject&queryOrderType=DESC&<%= queryParameter%>>
<% 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>
<th width="12%" bgcolor="#D3DCE3"><b>Media</b><a href=libraryitem_list.jsp?&queryOrderField=itemMediaType&queryOrderType=ASC&<%= queryParameter%>>
<br>
<% 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> <a href=libraryitem_list.jsp?&queryOrderField=itemMediaType&queryOrderType=DESC&<%= queryParameter%>>
<% 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>
<th width="13%" bgcolor="#D3DCE3"><b>Lang</b><a href=libraryitem_list.jsp?&queryOrderField=itemLanguage&queryOrderType=ASC&<%= queryParameter%>>
<br>
<% 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> <a href=libraryitem_list.jsp?&queryOrderField=itemLanguage&queryOrderType=DESC&<%= queryParameter%>>
<% 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>
<th width="4%" bgcolor="#D3DCE3">Qty<br>
</th>
<th width="3%" bgcolor="#D3DCE3"><b>Ava<br>
</b></th>
<th width="3%" bgcolor="#D3DCE3">Bor<br>
</th>
<th width="5%" bgcolor="#D3DCE3">Res<br>
</th>
</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;
// Search the database for request 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><td>");
else
out.println ("<tr bgcolor=#DDDDDD align=left><td>");
if((login.getUserType().equals("admin"))){
out.println("<input type=\"checkbox\" name=\"del_rec\" value=\"" +myResultSet.getString("itemRecNumber") +"\">");
}else{
//out.println("</TD> <TD>");
}
out.println("</TD><TD><a href='/JavaLibrary/libraryitem/libraryitem_edit.jsp?itemRecNumber=" +myResultSet.getString("itemRecNumber") +"'>" +myResultSet.getString("itemTitle") +"</a>");
out.println("</TD><TD>" +myResultSet.getString("itemSubject"));
out.println("</TD><TD>" +myResultSet.getString("itemMediaType"));
out.println("</TD><TD>" +myResultSet.getString("itemLanguage"));
out.println("</TD><TD>" +myResultSet.getString("itemTotQuantity"));
out.println("</TD><TD>" +myResultSet.getString("itemTotAvailable"));
out.println("</TD><TD>" +myResultSet.getString("itemTotBorrow"));
out.println("</TD><TD>" +myResultSet.getString("itemTotReserve"));
out.println("</TD></TR>");
rowCount = rowCount+1;
}
} catch(SQLException sqle) {
System.err.println("Error connecting: " +sqle);
}
}
%>
</table>
<% if((login.getUserType().equals("admin"))){
%>
<p> <img src="../images/common/arrow_ltr.gif" width="38" height="22">With
selected:
<input type='submit' name='Delete' value='Delete'>
Or
<input type='reset' name='Reset' value='Reset'>
</p>
<% } %>
</form>
<br>
</td>
</tr>
</table>
<jsp:include page="../common/footer.jsp" flush="true" />
<% connectionPool.closeAllConnections(); %>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -