?? userrights.jsp~5~
字號(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>User Rights</title>
<style type="text/css">
<!--
.style5 {font-size: 36px}
-->
</style></head>
<body>
<jsp:useBean id="Library" scope="session" class="login.Library">
</jsp:useBean>
<%
try{
String returnmoney="yes";
String id=Library.getid();
Connection conn=Library.getConn();
Statement stmt;
stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from user where id ='" + id + "'");
while(rs.next()){
Library.setuserrights1("You can borrow " + rs.getString("maxbook") +" in total. ");}
ResultSet rs3 = stmt.executeQuery("select * from borrowbook where id ='" + id + "'");
while(rs3.next()){
returnmoney=rs3.getString("returnmoney");
if(returnmoney.equals("no")){
Library.setuserrights2("But you can't borrow now,because you haven't pay the fee." );
}
}
}catch (Exception ex) {
response.sendRedirect("fail.jsp");
ex.printStackTrace();}%>
<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="userrights.jsp">UserRights</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">ModifyMessage</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="booksearch.jsp">BookSearch</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="bookreturn.jsp">BookReturn</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="haveborrowtemp.jsp">HaveBorrow</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>
</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"><%=Library.getuserrights1() %></p>
<p class="style5"><%=Library.getuserrights2() %></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>
</body>
</html>
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -