📄 loan.jsp
字号:
<%@ page contentType = "text/html; charset =GBK" %>
<%@ page language = "java" import = "java.sql.*,java.util.Calendar" %>
<%! int i=0;%>
<%
request.setCharacterEncoding("GBK");
response.setCharacterEncoding("GBK");
%>
<html>
<head>
<title>search result</title>
</head>
<body>
<table border="0" width="1035" id="table1" height="345">
<tr>
<td width="238" rowspan="2">
<img border="0" src="../images/Snap1.jpg" width="267" height="85"> </td>
<td width="652" height="59" colspan="5"></td>
<td width="130" height="59">
<TABLE cellSpacing=0 cellPadding=3 border=0 valign="top" id="table2" width="6">
<TBODY>
<TR>
<TD class=globalLinks vAlign=center noWrap align=right>
</TD></TR></TBODY></TABLE>
</td>
</tr>
<tr>
<td width="159" height="27"></td>
<td width="75" height="27" align="center" bgcolor="#008080"></td>
<td width="95" height="27" align="center" bgcolor="#C0C0C0"></td>
<td width="86" height="27" align="center" bgcolor="#C0C0C0"></td>
<td width="221" height="27"></td>
<td width="130" height="27"></td>
</tr>
<tr>
<td width="1025" colspan="7" height="32" align="center" bgcolor="#008080"></td>
</tr>
<tr>
<td width="1025" colspan="7" height="67"></td>
</tr>
<tr>
<td width="1025" colspan="7">
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0 id="table5">
<TBODY>
<TR height=30><TD bgColor=#eeeecc><font face="华文隶书" size="6"><b><A
class=boldBlackFont2>AMERCE</A> Result:</b></font></TD></TR></TBODY></TABLE></td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"><CENTER>
<%!
int computedate(String date1,String date2)
{
String a1 = date1.substring(0,date1.indexOf("-"));
int a1int = Integer.parseInt(a1);
String a2 = date1.substring(date1.indexOf("-")+1,date1.length());
int a2int = Integer.parseInt(a2);
String b1 = date2.substring(0,date1.indexOf("-"));
int b1int = Integer.parseInt(b1);
String b2 = date2.substring(date1.indexOf("-")+1,date1.length());
int b2int = Integer.parseInt(b2);
return b2int-a2int +(b1int-a1int)*30;
};
%>
<%
String bookid = request.getParameter("bookID");
Calendar cal = Calendar.getInstance();
String date = ""+cal.get(Calendar.MONTH)+"-"+cal.get(Calendar.DATE);
out.println("Book ID : "+bookid+"<BR>");
String mySqlDriver = "com.mysql.jdbc.Driver";
String url ="jdbc:mysql://localhost:3306/library?user=root&password=123456&useUnicode=true&characterEncoding=gbk";
Connection conn;
try{
Class.forName(mySqlDriver);
}
catch(Exception e){
out.println("Driver Error");
}
conn = DriverManager.getConnection(url);
if(conn==null){
out.println("get Conn erroe");
}
Statement stm = conn.createStatement();
ResultSet be = null;
be = stm.executeQuery("SELECT * FROM borrow WHERE bookID ='"+bookid+"'");
if(!be.next()) out.println("<tr vAlign=center align=middle bgcolor = #ffff00> <TD Align=center align=middle>No Such book be borrowed ERROR!</TD>");
else
{
String cardid = be.getString("cardID");
String boorowtime = be.getString("borrowtime"); //获得borrow信息
ResultSet re1 = null;
re1 = stm.executeQuery("SELECT * FROM accounts WHERE cardID ='"+cardid+"'");//获得帐号信息
if(!re1.next()||!re2.next()) out.println("<tr vAlign=center align=middle bgcolor = #ffff00> <TD Align=center align=middle>No Such cardID or the book not borrowed ERROR!</TD>");
else
{
String n3 = re1.getString("booknum");
String n4 = re1.getString("amerce");
String n5 = re1.getString("state");
String n6 = re1.getString("amerce_fun");
String n7 = re1.getString("book_max");
String n8 = re1.getString("amerce_total");
int bookNum = Integer.parseInt(n3);
int bookMax = Integer.parseInt(n7);
float amerce = Float.parseFloat(n4);
float amerce_total = Float.parseFloat(n8);
float amerce_fun ＝Float.parseFloat(n6);
//n5 = new String("T");
float currentAmerce = computedate(borrowtime,date)*amerce_fun;
//if(bookNum>= bookMax) n5 = new String("F");
//if(Float.parseFloat(n4)<0) n5 = new String("F");
String currentAmerceString = ""+currentAmerce;
if(currentAmerceString.length()>5)currentAmerceString = currentAmerceString.substring(0,5);
int re2 = 0;
int re3 = 0;
int re4 = 0;
int re5 = 0;
try{ //更新书的状态
re2 =stm.executeUpdate("UPDATE books SET bookstate = 'T' WHERE bookID = '"+bookid+"'");
out.println("<tr vAlign=center align=middle bgcolor = #00ff00> <TD Align=center align=middle>The successful line update books:"+re2+"</TD>");
}
catch(Exception e){
out.println("<tr vAlign=center align=middle bgcolor = #ffff00> <TD Align=center align=middle>No such books。</TD>");
}
if(re2!=0){
try{//删除borrow
re3 = stm.executeUpdate("DELETE FROM boorow WHERE bookID = '"+bookid+"'");//DATEcardID, amercetime, amerce
out.println("<tr vAlign=center align=middle bgcolor = #00ff00> <TD Align=center align=middle> The successful line insert borrow:"+re3+"</TD>");
}
catch(Exception e){
out.println("<tr vAlign=center align=middle bgcolor = #ffff00> <TD Align=center align=middle>The books is borrowed?</TD>");
}
if(re3!=0){
try{ //插入loan,还书时间和罚款
//罚款计算...
re4 = stm.executeUpdate("INSERT INTO loan SET bookID = '"+bookid+"',cardID ='"+cardid+"',borrowtime='"+boorrow+"',loantime = '"+date+"',amerce = '"+currentAmerceString+"'");//DATEcardID, amercetime, amerce
out.println("<tr vAlign=center align=middle bgcolor = #00ff00> <TD Align=center align=middle> The successful line insert borrow:"+re3+"</TD>");
}
catch(Exception e){
out.println("<tr vAlign=center align=middle bgcolor = #ffff00> <TD Align=center align=middle>The books is borrowed?</TD>");
}
bookNum --;
if(bookNum>= bookMax) n5 = new String("F");
n3=bookNum+"";
amerce -= currentAmerce;
if(amerce<0) n5 = new String("F");
n4 = ""+amerce;
if(n4.length()>5)n4 = n4.substring(0,5);
if(re4!=0)
{
//更新BOOKNUM和STATE和罚款。更新account
try{
int re4 = stm.executeUpdate("UPDATE accounts SET booknum = '"+n3+"',amerce = '"+n4+"',state = '"+n5+"' WHERE cardID = '"+n1+"'");
out.println("<tr vAlign=center align=middle bgcolor = #00ff00> <TD Align=center align=middle>The successful line update accounts:"+re4+"</TD>");
}
catch(Exception e){
out.println("<tr vAlign=center align=middle bgcolor = #ffff00> <TD Align=center align=middle>ERROR re4</TD>");
}
}
}
else out.println("<tr vAlign=center align=middle bgcolor = #ffff00> <TD Align=center align=middle>No such books。</TD>");
}
}
}
%>
</TR>
<%
stm.close();
conn.close();
%>
</TABLE></CENTER>
<p align="center"></td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"> <font face="Courier New">
<a href="index.htm">GO BACK SEARCH AGAIN</a></font><p>Library</td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"></td>
</tr>
<tr>
<td width="1025" colspan="7" align="center"><FONT size=1>© 2007.5-2007.6 142042 All rights
reserved.</FONT></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -