📄 403cf691caab001d1412e7a87039532d
字号:
<%@ page language="java" import="java.util.*" contentType="text/html;charset=gb2312" 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"/>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>海龙图书</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/css" href="styles.css">
-->
</head>
<body>
<table width="780" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td colspan="3" align="center" bgcolor="#FFFFFF"><img src="images/2284008.gif" width="760" height="90"></td>
</tr>
<tr>
<td colspan="2" background="images/titlemu_2.gif" bgcolor="#FFFFFF"><div align="center">
<%@ include file="top.jsp"%>
</div></td>
</tr>
<tr>
<td colspan="2" background="images/titlemu_2.gif" bgcolor="#FFFFFF"><div align="center">
<%@ include file="serach.jsp"%>
</div></td>
</tr>
<tr>
<td width="200" align="center" 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="orderdelete.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="usermoneykouchu.jsp?jk=<%=k.getString(1)%>&name=<%=username%>">结帐</a>
</td>
</tr>
<%
}
%>
</table>
<%
}
else
{
%>
<script language="javascript">
alert('你还没有登录！请登录借书卡！');
window.location="page.jsp";
</script>
<%
}
%>
</td>
</tr>
<tr>
<td colspan="2" bgcolor="#FFFFFF"> <div align="center">
<%@ include file="last.jsp"%>
</div></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -