📄 f059fbbecaab001d1412e7a87039532d
字号:
<%@ 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+"/";
%>
<%
request.setCharacterEncoding("gbk");
response.setCharacterEncoding("gbk");
%>
<!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">
<table width="580" border="0" align="left" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC">
<tr>
<td align="center" bgcolor="#FFFFFF" colspan="8">借书账单</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>
<td align="center" bgcolor="#FFFFFF">借书时间</td>
<td align="center" bgcolor="#FFFFFF">相关操作</td>
</tr>
<%
String userid=(String)session.getAttribute("userid");
ResultSet m=(ResultSet)data.getRs_leihailong("select * from userborrow where userid='"+userid+"'");
while(m.next())
{
%>
<tr>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("usertruename")%></td>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("userid")%></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("bookprice")%></td>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("borrowprice")%></td>
<td align="center" bgcolor="#FFFFFF"><%=m.getString("booktime")%></td>
<td align="center" bgcolor="#FFFFFF"><a href="userborrowdelete.jsp?id=<%=m.getString(1)%>">移除</a></td>
</tr>
<%
}
%>
<tr>
<td colspan="8" align="center" valign="top" bgcolor="#FFFFFF"><a href="page.jsp">结账</a> <a href="page.jsp">继续借书</a></td>
</tr>
</table>
</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 + -