?? borrow.jsp
字號:
<% response.setHeader("Cache-Control", "no-cache");
response.setHeader("Pragma", "no-cahce");
// URLcurrent = "/JavaLibrary/operation/borrow.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="borrow" />
<jsp:setProperty name="form" property="formURL" value="/JavaLibrary/operation/borrow.jsp" />
<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="">
<%!
// decare the class level variable so if reenter the same form
// from will get back the same value
String borrowerID="";
String userFirstName = "";
String userEmail = "";
int userTotQuota = 0;
int userQuotaAvailable = 0;
String itemCallNumber = "";
String itemTitle = "";
int itemTotAvailable = 0;
int itemTotQuantity = 0;
int itemTotReserve = 0;
int itemTotBorrow = 0;
Vector itemsBorrowed = new Vector();
%>
<%
String refURL = "";
refURL = request.getHeader("Referer");
// if not from current URL
if (refURL!=null){
if((refURL.indexOf("/operation/borrow.jsp") < 0) || (dbprocess.isProcessComplete())) {
//reset all the class variable if not reenter the form from same URL
borrowerID="";
userFirstName = "";
userEmail = "";
userTotQuota = 0;
userQuotaAvailable = 0;
itemCallNumber = "";
itemTitle = "";
itemTotAvailable = 0;
itemTotQuantity = 0;
itemTotReserve = 0;
itemTotBorrow = 0;
itemsBorrowed = new Vector();
dbprocess.setProcessComplete(false);
}
}
String query="";
ResultSet myResultSet=null;
String errorMsg= "";
Date borrowDate = new Date();
Date dueDate = ServletUtilities.diffrenceDay(borrowDate, 7);
String borrowDateStr = DateFormat.getDateInstance(DateFormat.MEDIUM).format(borrowDate);
String dueDateStr = DateFormat.getDateInstance(DateFormat.MEDIUM).format(dueDate);
String formName="";
String itemBorrow[];
String[] itemCallNumberInList;
String borrowStatus = "borrow";
String[] removeItem;
String itemCallNumberToRemove = "";
Vector itemBorrowCallNumber = new Vector();
if(request.getParameter("formName") != null) {
formName=request.getParameter("formName");
if (formName.equals("resetForm")) {
// Reset the form
borrowerID="";
userFirstName = "";
userEmail = "";
userTotQuota = 0;
userQuotaAvailable = 0;
itemCallNumber = "";
itemTitle = "";
itemTotAvailable = 0;
itemTotQuantity = 0;
itemTotReserve = 0;
itemTotBorrow = 0;
itemsBorrowed = new Vector();
dbprocess.setProcessComplete(false);
}else if (formName.equals("borrowerID")) {
borrowerID = request.getParameter("borrowerID");
if (borrowerID == null)
borrowerID = "";
if( !(borrowerID.equals("")) ) {
// Reset all the value
if(borrowerID.equals(staff.getUserID())) {
errorMsg = "Error: borrower ID " + borrowerID +" cannot be same as staff in charge";
borrowerID=""; userFirstName=""; userEmail=""; userTotQuota=0; userQuotaAvailable=0;
}else {
query = "SELECT * FROM user WHERE UserID ='" +borrowerID +"'";
try {
Connection connection = connectionPool.getConnection();
myResultSet = DatabaseUtilities.getQueryResultSet(connection, query, false);
connectionPool.free(connection);
} catch(Exception e) {
errorMsg = "Error: " + e;
}
borrowerID=""; userFirstName=""; userEmail=""; userTotQuota=0; userQuotaAvailable=0;
if (myResultSet != null){
try{
while(myResultSet.next()) {
borrowerID = myResultSet.getString("userID");
userFirstName = myResultSet.getString("userFirstName");
userEmail = myResultSet.getString("userEmail");
userTotQuota = Integer.parseInt(myResultSet.getString("userTotQuota"));
userQuotaAvailable = Integer.parseInt(myResultSet.getString("userQuotaAvailable"));
}
} catch(SQLException sqle) {
System.err.println("Error connecting: " +sqle);
}
}
if(borrowerID.equals("")) {
errorMsg ="Error: borrower ID not found";
} else {
if(userQuotaAvailable <=0) {
errorMsg = "Error: borrower ID " +borrowerID +" do not have quoat available!";
borrowerID = ""; userFirstName=""; userEmail=""; userTotQuota=0; userQuotaAvailable=0;
}
}
}
}
} else if (formName.equals("itemCallNumber")) {
itemCallNumber = request.getParameter("itemCallNumber");
if (itemCallNumber == null)
itemCallNumber = "";
if( !(itemCallNumber.equals("")) ) {
// Reset all the value
itemTitle = ""; itemTotAvailable = 0; itemTotQuantity = 0; itemTotReserve =0; itemTotBorrow=0;
query = "SELECT * FROM libraryitem WHERE itemCallNumber ='" +itemCallNumber +"'";
try {
Connection connection = connectionPool.getConnection();
myResultSet = DatabaseUtilities.getQueryResultSet(connection, query, false);
connectionPool.free(connection);
} catch(Exception e) {
errorMsg = "Error: " + e;
}
itemCallNumber="";
if (myResultSet != null){
try{
while(myResultSet.next()) {
itemCallNumber = myResultSet.getString("itemCallNumber");
itemTitle = myResultSet.getString("itemTitle");
itemTotAvailable = Integer.parseInt(myResultSet.getString("itemTotAvailable"));
itemTotQuantity = Integer.parseInt(myResultSet.getString("itemTotQuantity"));
itemTotReserve = Integer.parseInt(myResultSet.getString("itemTotReserve"));
itemTotBorrow = Integer.parseInt(myResultSet.getString("itemTotBorrow"));
}
} catch(SQLException sqle) {
System.err.println("Error connecting: " +sqle);
}
}
if(itemCallNumber.equals(""))
errorMsg = "Error: item call number not found!";
if(itemTotAvailable <=0) {
errorMsg = "Error: item call number " +itemCallNumber +" currently not available in quantity";
itemCallNumber=""; itemTitle=""; itemTotAvailable=0;
itemTotQuantity=0; itemTotReserve=0; itemTotBorrow=0;
}else{
if(itemTotReserve >= itemTotAvailable) {
errorMsg = "Error: All available item call number " +itemCallNumber +" currently under reservation";
itemCallNumber=""; itemTitle=""; itemTotAvailable=0;
itemTotQuantity=0; itemTotReserve=0; itemTotBorrow=0;
}
}
}
} else if (formName.equals("addToList")) {
itemCallNumber = request.getParameter("itemCallNumber");
itemTitle = request.getParameter("itemTitle");
boolean itemInList = false;
itemBorrow = new String[2];
itemBorrow[0] = itemCallNumber;
itemBorrow[1] = itemTitle;
if (itemsBorrowed.size()==0) {
itemsBorrowed.addElement(itemBorrow);
} else{
for(int i=0; i<itemsBorrowed.size(); i++){
itemCallNumberInList = (String[])itemsBorrowed.elementAt(i);
if(itemCallNumber.equals(itemCallNumberInList[0])) {
itemInList = true;
}
}
if(!itemInList)
itemsBorrowed.addElement(itemBorrow);
}
} else if(formName.equals("removeFromList")) {
if(request.getParameter("removeItem") != null) {
String[] paramValues = request.getParameterValues("removeItem");
for(int x = 0; x<paramValues.length; x++) {
itemCallNumberToRemove = paramValues[x];
for(int y=0; y<itemsBorrowed.size(); y++){
itemCallNumberInList = (String[])itemsBorrowed.elementAt(y);
if(itemCallNumberToRemove.equals(itemCallNumberInList[0])) {
itemsBorrowed.removeElementAt(y);
}
}
}
}
} else {
if (borrowerID.equals("")) {
errorMsg="Error: Borrower ID Not Yet Keyin";
} else if(userQuotaAvailable < itemsBorrowed.size()) {
errorMsg="Error: User cannot borrow more then quota available";
} else if(itemsBorrowed.size()<=0) {
errorMsg="Error: That is nothing in the borrow list";
} else {
%>
<jsp:forward page="/servlet/sjservlets.FormProcess">
</jsp:forward>
<% }
}
}
%>
<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>Add Borrow Record</b></p>
<center>
<table width="75%" border="0">
<tr>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -