📄 libraryitem_list.jsp
字号:
<%@ 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/admin/libraryitem_list.jsp" />
<% response.setHeader("Cache-Control", "no-cache");
response.setHeader("Pragma", "no-cahce");
// URLcurrent = "/JavaLibrary/admin/libraryitem_list.jsp";
// URLcurrent=response.encodeURL(URLcurrent);
%>
<html>
<head>
<title>Library Management System</title>
<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"></a>
<%@ 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><IMG height=1 alt=""
src="../images/common/1ptrans.gif"
width=1 border=0></TD>
<td valign="top" width="100%" bgcolor="#f1f1f1">
<center>
<b>Items List<br>
</b>
</center>
<center>
[<a href="../libraryitem/libraryitem_add.jsp">Add new item recod</a>]
<%@ include file="../common/printview.jsp" %>
<%
queryParameter="&queryOrderField=" +queryOrderField +
"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
%>
<form name="form1" method="post" action="libraryitem_list.jsp?<%= queryParameter%>">
<p>Limiting options:<br>
</p>
<table width="60%" border="0">
<tr>
<td width="24%">Subject:</td>
<td width="45%">
<select name="itemSubject">
<option value="all" selected>All Subject</option>
<option value="Arts">Arts</option>
<option value="Anthropology">....Anthropology</option>
<option value="Journalism">....Journalism</option>
<option value="English Literature">....English Literature</option>
<option value="Media">....Media</option>
<option value="Music">....Music</option>
<option value="Theatre">....Theatre</option>
<option value="Visual Arts">....Visual Arts</option>
<option value="Business">Business</option>
<option value="CRM">....CRM</option>
<option value="Economics">....Economics</option>
<option value="Employment">....Employment</option>
<option value="HRM">....HRM</option>
<option value="Marketing">....Marketing</option>
<option value="Information Systems">....Information Systems</option>
<option value="Resource Management">....Resource Management</option>
<option value="Commerce">Commerce</option>
<option value="Accounting">....Accounting</option>
<option value="Banking">....Banking</option>
<option value="Finance">....Finance</option>
<option value="Law">....Law</option>
<option value="Computing">Computing</option>
<option value="Application">....Application</option>
<option value="Certify Exam">....Certify Exam</option>
<option value="Computer Graphics">....Computer Graphics</option>
<option value="Database">....Database</option>
<option value="Networking">....Networking</option>
<option value="Operating System">....Operating System</option>
<option value="Programming">....Programming</option>
<option value="Telecommunication">....Telecommunicaiton</option>
<option value="Web Development">....Web Development</option>
<option value="Education">Education</option>
<option value="Early Childhood">....Early Childhood</option>
<option value="Further Edu and Training">....Further Edu and Training</option>
<option value="Engineering and Surveying">Engineering and Surveying</option>
<option value="Agricultural">....Agricultural</option>
<option value="Civil">....Civil</option>
<option value="Electrical">....Electrical</option>
<option value="Mechanical">....Mechanical</option>
<option value="Science and Technology">Science and Technology</option>
<option value="Biology">....Biology</option>
<option value="Chemistry">....Chemistry</option>
<option value="Maths">....Maths</option>
<option value="Nursing">....Nursing</option>
<option value="Physics">....Physics</option>
<option value="Psychology">....Psychology</option>
</select>
</td>
<td width="31%">
<select name=filterOpt1>
<option value="and" selected>And</option>
<option value="or">Or</option>
</select>
</td>
</tr>
<tr>
<td width="24%">Media Type:</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -