?? userlogin.jsp~111~
字號(hào):
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>用戶登陸界面</title>
<style type="text/css">
<!--
.style1 { font-family: "黑體";
font-size: 2;
color: #FFFFFF;
}
-->
</style>
</head>
<body>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#dbdcdc" id="table1">
<caption>
</caption>
<tr>
<td bgcolor="#dbdcdc"><div align="center">
<table width="659" border="0" align="center" cellpadding="0" cellspacing="0" id="table2">
<caption>
</caption>
<tr>
<td width="1" bgcolor="#000000"> </td>
<td valign="top" bgcolor="#dad5d5"><table width="91%" border="0" align="center" cellpadding="0" cellspacing="0" id="table3">
<caption>
</caption>
<tr>
<td valign="top"><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#808877" id="table4">
<caption>
</caption>
<tr>
<td align="center"><span class="style1">用戶登陸界面</span></td>
</tr>
</table>
<br>
<table width="73%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#808877" id="table5">
<caption>
</caption>
<tr>
<td><table width="100%" border="0" cellpadding="2" cellspacing="1" bgcolor="#808877" id="table6">
<caption>
</caption>
<tr>
<td width="33%" align="center" valign="middle" bgcolor="#fef8ef"><form name="form1" method="post" action="">
<img src="F:\example\圖書(shū)館\login/479226731.jpg" width="128" height="128" alt=""> </form></td>
<td align="center" bgcolor="#fef8ef"><form name="form3" method="post" action="">
<input name="userrights" type="submit" id="userrights" value="userrights">
</form></td>
</tr>
<tr>
<td align="center" valign="middle" bgcolor="#fef8ef"><img src="F:\example\圖書(shū)館\login/479227809.jpg" width="128" height="128" alt=""></td>
<td align="center" bgcolor="#fef8ef"><form name="form5" method="post" action="">
<input name="booksearch" type="submit" id="booksearch" value="booksearch">
</form></td>
</tr>
<tr>
<td align="center" valign="middle" bgcolor="#fef8ef"><img src="F:\example\圖書(shū)館\login/479226731.jpg" width="128" height="128" alt=""></td>
<td align="center" bgcolor="#fef8ef"><form name="form6" method="post" action="">
<input name="pay" type="submit" id="pay" value="pay">
</form></td>
</tr>
<tr>
<td width="33%" align="center" valign="middle" bgcolor="#fef8ef"><form name="form2" method="post" action="">
</form>
<img src="F:\example\圖書(shū)館\login/479227809.jpg" width="128" height="128" alt=""></td>
<td align="center" bgcolor="#fef8ef"><form name="form4" method="post" action="">
<input name="modifymessage" type="submit" id="modifymessage" value="modifymessage">
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="1" bgcolor="#000000"> </td>
</tr>
</table>
</div></td>
</tr>
</table>
<jsp:useBean id="Library" scope="session" class="login.Library">
</jsp:useBean>
<center>
<%
//java.util.Locale locale = request.getLocale();
//java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.LONG,locale);
String id = Library.getid();
out.println("<p>"+id+"</p>");
int shouldreturndata=0;
String title="",strsrd="",returnmoney="yes",returnmoney1="yes";//returndata1="",title1="";
try{
Connection conn=Library.getConn();
Statement stmt,stmt1;
stmt = conn.createStatement();
//PreparedStatement pstmt1 = conn.prepareStatement();
// PreparedStatement pstmt3 = conn.prepareStatement("select * from borrowbook where id ='" + id + "'");
ResultSet rs1 = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");//在用戶登陸時(shí)，判斷用戶是不是有超出借期的書(shū)沒(méi)還，把相應(yīng)紀(jì)錄的overdata,fee,returnmoney改變，即在每次用戶登陸時(shí)判斷是否要罰款
// out.println("<p>"+rs1.getString("studnetnumber")+"</p>");
stmt1=conn.createStatement();//Resultset is closed，是指在一個(gè)rs正在循環(huán)時(shí)，使用這個(gè)rs所對(duì)應(yīng)的stmt等，進(jìn)行操作，產(chǎn)生的rs關(guān)閉，一個(gè)rs在沒(méi)有結(jié)束時(shí)，他的stmt不能被再次使用
while(rs1.next()){//無(wú)效游標(biāo)有時(shí)指缺少rs1.next()
int returndata=Integer.parseInt(rs1.getString("returndata"));//因?yàn)槿绻鹯eturndata為String型，無(wú)法判斷null,所以用int,可判斷0
//out.println("<p>'"+returndata+"'</p>");
strsrd=rs1.getString("shouldreturndata");
//title=rs1.getString("title");
shouldreturndata=Integer.parseInt(strsrd);
// out.println("<p>"+shouldreturndata+"</p>");
int trailnumber =Integer.parseInt(rs1.getString("trailnumber"));//用rs1.getInt()無(wú)法識(shí)別，盡管數(shù)據(jù)表數(shù)據(jù)是int型
//out.println("<p>"+(new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay())+"</p>");
if(returndata==0 && (new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay())>shouldreturndata)//new java.util.Date()獲得系統(tǒng)當(dāng)前時(shí)間，因?yàn)槿掌诘南鄿p比較工作很復(fù)雜，所以把日期型變量用get函數(shù)轉(zhuǎn)化為相應(yīng)的int型，在乘以權(quán)數(shù)，進(jìn)行比較
{
int overdata = (new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay()) - shouldreturndata;
//out.println("<p>"+overdata+"</p>");
double feeperday = 0.01;
double fee = feeperday*overdata;
// Statement stmt=conn.createStatement();
stmt1.execute("update borrowbook set overdata = '" + overdata + "' where trailnumber ='" + trailnumber + "'");
stmt1.execute("update borrowbook set fee = '" + fee + "' where trailnumber ='" + trailnumber + "'");
stmt1.execute("update borrowbook set returnmoney = 'no' where trailnumber ='" + trailnumber + "'");
}
//if(!rs1.next()){break;}
/* returndata=rs1.getString("returndata");
strsrd=rs1.getString("shouldreturndata");
title=rs1.getString("title");
shouldreturndata=Integer.parseInt(strsrd);
if( (new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay())>shouldreturndata){
int overdata = (new java.util.Date().getYear()*365 + new java.util.Date().getMonth()*31 + new java.util.Date().getDay()) - shouldreturndata;
double feeperday = 0.01;
double fee = feeperday*overdata;
// Statement stmt=conn.createStatement();
stmt.execute("update borrowbook set overdata = '" + overdata + "' where title ='" + title + "' and id ='" + id + "'");
stmt.execute("update borrowbook set fee = '" + fee + "' where title ='" + title + "' and id ='" + id + "'");
stmt.execute("update borrowbook set returnmoney = 'no' where title ='" + title + "' and id ='" + id + "'");} *///break;}
}
if(request.getParameter("userrights")!=null){
ResultSet rs = stmt.executeQuery("select * from user where id ='" + id + "'");
if(rs.next()){
out.println("<p>You can borrow" + rs.getString("maxbook") +"in total. </p>");}
ResultSet rs3 = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");
while(rs3.next()){
returnmoney=rs3.getString("returnmoney");
if(returnmoney.equals("no")){
out.println("<p>But you can't borrow now,because you haven't pay the fee.The message is below. </p>" );
out.println("<p>serialnumber =" + rs3.getString("serialnumber") + " </p>");
out.println("<p>sortnumber =" + rs3.getString("sortnumber") + " </p>");
out.println("<p>title =" + rs3.getString("title") + " </p>");
out.println("<p>borrowdata =" + rs3.getString("borrowdata") + " </p>");
out.println("<p>shouldreturndata =" + rs3.getString("shouldreturndata") + " </p>");
out.println("<p>returndata =" + rs3.getString("returndata") + " </p>");
out.println("<p>overdata =" + rs3.getString("overdata") + " </p>");
out.println("<p>fee =" + rs3.getString("fee") + " </p>");
out.println("<p>returnmoney =" + returnmoney + " </p>");
}
}
}
else if(request.getParameter("booksearch")!=null){
response.sendRedirect("booksearch.jsp");}
else if(request.getParameter("pay")!=null){
// PreparedStatement pstmt2 = conn.prepareStatement();
// Statement stmt1=conn.createStatement();
ResultSet rs2 = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");
while(rs2.next()){
returnmoney1=rs2.getString("returnmoney");
int returndata=Integer.parseInt(rs2.getString("returndata"));
// returndata=rs2.getString("returndata");
if(returndata!=0 && returnmoney1.equals("no")){//當(dāng)returndata!=0，即書(shū)已還，而returnmoney=no，即欠款還沒(méi)還的情況下，找出相對(duì)應(yīng)的借書(shū)記錄，將欠款還了，即置相應(yīng)紀(jì)錄的returnmoney=yes
// title1 = rs2.getString("title");
// Statement stmt=conn.createStatement();
stmt1.execute("update borrowbook set returnmoney = 'yes' where id ='" + id + "' and title ='"+rs2.getString("title")+"'");
}
// if(!rs2.next()){break;}
}
}
else if(request.getParameter("modifymessage")!=null){
response.sendRedirect("modifyuser.jsp");}
}catch (Exception ex){
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</body>
</html>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -