📄 update.jsp~2~
字号:
<%@ 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>Update</title>
<style type="text/css">
<!--
.style3 {font-size: 24px}
.style4 {font-size: 18px}
-->
</style></head>
<body>
<form name="form1" method="post" action="">
<table border="0" cellpadding="0" cellspacing="0">
<tr align="left" valign="top" bgcolor="#000000">
<td height="100" colspan="2"><table width="100%" border="0" align="left" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr>
<td bgcolor="#FFFFFF"><img src="F:\example\图书馆\login\library1.gif" width="699" height="100" alt=""></td>
</tr>
</table></td>
</tr>
<tr>
<td height="449" align="left" valign="top" bgcolor="#000000"><table width="99%" border="0" align="left" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td valign="top" bgcolor="#CCCCCC"><table width="70%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"> </td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"> <a href="adduser.jsp">Adduser</a> </td>
</tr>
<tr>
<td width="20" height="5" align="right"> </td>
<td width="130" height="5" align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="modifyuser.jsp">Modifyuser</a></td>
</tr>
<tr>
<td width="20" height="5" align="right"> </td>
<td width="130" height="5" align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="deleteuser.jsp">Deletuser</a></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="searchuser.jsp">Searchuser</a></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td width="130" align="center"><a href="addbook.jsp">Addbook</a></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="deletebook.jsp">Deletebook</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\图书馆\loginlibrary4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="borrowsearch.jsp">Borrowsearch</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="search.jsp">Search</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="userpay.jsp">Userpay</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td align="right"><img src="F:\example\图书馆\login/library3.png" width="10" height="10" alt=""></td>
<td align="center"><a href="update.jsp">Update</a></td>
</tr>
<tr>
<td align="right"> </td>
<td align="center"><img src="F:\example\图书馆\login/library4.png" width="102" height="5" alt=""></td>
</tr>
<tr>
<td width="20" align="right"> </td>
<td width="130" align="center"> </td>
</tr>
</table></td>
</tr>
<tr>
<td height="230" valign="top" bgcolor="#CCCCCC"> </td>
</tr>
</table></td>
<td height="449" align="center" valign="middle"><p class="style5">You have succeeded in updating</p>
<p class="style5">Administrator!</p></td>
</tr>
<tr>
<td bgcolor="#666666"> </td>
<td><img src="F:\example\图书馆\login/library2.png" width="573" height="40" alt=""></td>
</tr>
</table>
</form>
<jsp:useBean id="Library" scope="session" class="login.Library">
</jsp:useBean>
<center>
<%
String id = Library.getid();
int shouldreturndata=0,number=1;
String title="",strsrd="",returnmoney="yes",returnmoney1="yes";//returndata1="",title1="";
try{
Connection conn=Library.getConn();
Statement stmt,stmt1;
stmt = conn.createStatement();
ResultSet rs1 = stmt.executeQuery("select * from borrowbook");
while(rs1.next()){++number;}
for(int i=1;i<=number;i++){
ResultSet rs2 = stmt.executeQuery("select * from borrowbook where trailnumber ='" + i + "'");
//int trailnumber =Integer.parseInt(rs1.getString("trailnumber"));//用rs1.getInt()无法识别，尽管数据表数据是int型
//PreparedStatement pstmt1 = conn.prepareStatement();
// PreparedStatement pstmt3 = conn.prepareStatement("select * from borrowbook where id ='" + id + "'");
// ResultSet rs1 = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");//在用户登陆时，判断用户是不是有超出借期的书没还，把相应纪录的overdata,fee,returnmoney改变，即在每次用户登陆时判断是否要罚款
// out.println("<p>"+rs1.getString("studnetnumber")+"</p>");
stmt1=conn.createStatement();//Resultset is closed，是指在一个rs正在循环时，使用这个rs所对应的stmt等，进行操作，产生的rs关闭，一个rs在没有结束时，他的stmt不能被再次使用
while(rs2.next()){//无效游标有时指缺少rs1.next()
int returndata=Integer.parseInt(rs2.getString("returndata"));//因为如果returndata为String型，无法判断null,所以用int,可判断0
//out.println("<p>'"+returndata+"'</p>");
strsrd=rs2.getString("shouldreturndata");
//title=rs1.getString("title");
shouldreturndata=Integer.parseInt(strsrd);
// out.println("<p>"+shouldreturndata+"</p>");
//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()获得系统当前时间，因为日期的相减比较工作很复杂，所以把日期型变量用get函数转化为相应的int型，在乘以权数，进行比较
{
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 ='" + i + "'");
stmt1.execute("update borrowbook set fee = '" + fee + "' where trailnumber ='" + i + "'");
stmt1.execute("update borrowbook set returnmoney = 'no' where trailnumber ='" + i + "'");
}
}
}
}catch (Exception ex){
response.sendRedirect("fail.jsp");
ex.printStackTrace();}
%>
</center>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -