📄 borrow_list.jsp
字号:
<%@ 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/admin/borrow_list.jsp" />
<% response.setHeader("Cache-Control", "no-cache");
response.setHeader("Pragma", "no-cahce");
// URLcurrent = "/JavaLibrary/admin/borrow_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 variable
String queryOrderField= "";
String queryOrderType= "";
String queryParameter= "";
String queryFilter= "";
String querySearch= "";
String queryCondition= "";
String queryOrder= "";
String query= "";
String borrowStatus = "";
String borrowerID = "";
String searchOpt1= "";
String itemCallNumber = "";
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");
borrowerID = request.getParameter("borrowerID");
itemCallNumber = request.getParameter("itemCallNumber");
searchOpt1 = request.getParameter("searchOpt1");
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 = "";
} else {
queryCondition = "";
queryFilter = " WHERE borrowStatus = '" +borrowStatus +"'";
}
if(borrowerID == null)
borrowerID = "";
if (!borrowerID.equals(""))
querySearch = " borrowerID like '%" + borrowerID +"%' ";
if(itemCallNumber ==null)
itemCallNumber = "";
if(!itemCallNumber.equals("")){
if(!querySearch.equals(""))
querySearch = querySearch +" " +searchOpt1 +" itemCallNumber like '%" +itemCallNumber +"%' ";
else
querySearch = " itemCallNumber like '%" +itemCallNumber +"%' ";
}
// Generate the search query
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"></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">
<p align="center"><b>Borrow List</b> </p>
<%
queryParameter="&queryOrderField=" +queryOrderField +
"&queryOrderType=" +queryOrderType +"&recDisplayNum=" +recDisplayNum;
%>
<form name="form1" action="../admin/borrow_list.jsp?<%= queryParameter%>" method="post">
<center>
<p>Limiting options:
<select name=borrowStatus>
<option value="all">All borrow records</option>
<option value="overdue">Over Due</option>
<option value="borrow">Borrow Out</option>
<option value="return">Had Return</option>
</select>
</p>
<table width="55%" border="0">
<tr>
<td width="29%">Borrower ID</td>
<td width="17%"> </td>
<td width="35%">
<input type="text" name="borrowerID" size="30">
</td>
<td width="19%"> </td>
</tr>
<tr>
<td width="29%">Item Call Number</td>
<td width="17%">
<select name="searchOpt1">
<option value="and" selected>And</option>
<option value="or">Or</option>
</select>
</td>
<td width="35%">
<input type="text" name="itemCallNumber" size="30">
</td>
<td width="19%">
<input type="submit" name="Search" value="Search">
</td>
</tr>
</table>
</center>
</form>
<% queryParameter="borrowStatus="+borrowStatus +"&queryOrderField=" +queryOrderField +
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -