📄 b06e1734c9ab001d1412e7a87039532d
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%@ taglib uri="http://struts.apache.org/tags-bean" prefix="bean"%>
<%@ taglib uri="http://struts.apache.org/tags-html" prefix="html"%>
<jsp:useBean id="data" class="com.hua.book.struts.datebase.Database" scope="session"/>
<body>
<table width="580" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><img src="images/2284008.gif" width="760" height="90"></td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><%@ include file="top.jsp"%></td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><%@ include file="serach.jsp"%></td>
</tr>
<tr>
<td width="200" align="left" valign="top" bgcolor="#FFFFFF">
<%@ include file="left.jsp"%>
</td>
<td width="580" align="left" valign="top" bgcolor="#FFFFFF">
<%
if(session.getAttribute("username")!=null)
{
%>
<table width="580" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td align="center" bgcolor="#FFFFFF" colspan="6">还书</td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">借书者</td>
<td align="center" bgcolor="#FFFFFF">书籍编号</td>
<td align="center" bgcolor="#FFFFFF">书籍名称</td>
<td align="center" bgcolor="#FFFFFF">出租价格</td>
<td align="center" bgcolor="#FFFFFF">借书时间</td>
<td align="center" bgcolor="#FFFFFF">相关操作</td>
</tr>
<%
String username=(String)session.getAttribute("username");
ResultSet m=(ResultSet)data.getRs_leihailong("select * from carduserborrow where cardusername='"+username+"'");
while(m.next())
{
%>
<tr>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("cardusername")%></td>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("bookid")%></td>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("bookname")%></td>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("bookborrowprice")%></td>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("booktime")%></td>
<td align="center" bgcolor="#FFFFFF"><a href="backbook.jsp?id=<%=m.getString(1)%>">还书</a></td>
</tr>
<%
}
ResultSet k=(ResultSet)data.sum(username);
String jk;
while(k.next())
{
%>
<tr>
<td colspan="6" align="center" valign="top" bgcolor="#FFFFFF">
<a href="page.jsp">返回</a>
</td>
</tr>
<%
}
%>
</table>
<%
}
else
{
%>
<form action="userback.jsp">
<table width="580" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td align="center" bgcolor="#FFFFFF">请输入身份证：</td>
<td align="center" bgcolor="#FFFFFF"><input type="text" name="number" /></td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><label>
<input type="submit" name="Submit" value="提交">
</label></td>
</tr>
</table>
</form>
<%
}
%>
</td>
</tr>
<tr>
<td colspan="2" align="center" bgcolor="#FFFFFF"><%@ include file="last.jsp"%></td>
</tr>
</table>
</body>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -