- <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
- <%@ page import="com.dao.BorrowDAO" %>
- <%@ page import="com.actionForm.BorrowForm" %>
- <%@ page import="java.util.*"%>
- <html>
- <%
- Collection coll=(Collection)request.getAttribute("readerBorrowSort");
- %>
- <head>
- <title>图书馆管理系统</title>
- <link href="CSS/style.css" rel="stylesheet">
- </head>
- <body onLoad="clockon(bgclock)">
- <table width="778" border="0" align="center" cellpadding="0" cellspacing="0" class="tableBorder">
- <tr>
- <td height="183">
- <%@include file="navigation.jsp"%>
- </td>
- </tr>
- <td>
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td valign="top" bgcolor="#FFFFFF"><table width="99%" height="966" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="tableBorder_gray">
- <tr>
- <td height="966" valign="top" style="padding:5px;"><table width="98%" height="487" border="0" cellpadding="0" cellspacing="0">
- <tr>
- <td height="22" valign="top" class="word_orange">当前位置:排行榜 > 读者借阅排行榜 >>></td>
- </tr>
- <tr>
- <td align="center" valign="top"><%
- if(coll==null || coll.isEmpty()){
- %>
- <table width="100%" height="30" border="0" cellpadding="0" cellspacing="0">
- <tr>
- <td height="36" align="center">暂无读者借阅信息!</td>
- </tr>
- </table>
- <%
- }else{
- //通过迭代方式显示数据
- Iterator it=coll.iterator();
- int degree=0;
- String readername="";
- String typename="";
- String barcode_reader="";
- String paperType="";
- String paperNo="";
- String tel="";
- String sex="";
- %>
- <table width="98%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#D2E3E6" bordercolorlight="#FFFFFF">
- <tr align="center" bgcolor="#e3F4F7">
- <td width="8%">借阅次数</td>
- <td width="11%">读者条形码</td>
- <td width="12%">读者姓名</td>
- <td width="13%">读者类型</td>
- <td width="23%">证件类型</td>
- <td width="14%">证件号码</td>
- <td width="12%">电话</td>
- <td colspan="2">性别</td>
- </tr>
- <%
- while(it.hasNext()){
- BorrowForm borrowForm=(BorrowForm)it.next();
- bookname=chStr.toChinese(borrowForm.getReaderName());
- barcode_book=borrowForm.getBookBarcode();
- typename=chStr.toChinese(borrowForm.getBookType());
- degree=borrowForm.getDegree();
- bookcase=chStr.toChinese(borrowForm.getBookcaseName());
- pub=chStr.toChinese(borrowForm.getPubName());
- author=chStr.toChinese(borrowForm.getAuthor());
- price=borrowForm.getPrice();
- %>
- <tr>
- <td align="center"> <%=degree%></td>
- <td style="padding:5px;"> <%=barcode_book%></td>
- <td style="padding:5px;"><%=bookname%></td>
- <td style="padding:5px;"><%=typename%></td>
- <td align="center"> <%=bookcase%></td>
- <td align="center"> <%=pub%></td>
- <td width="12%" align="center"><%=author%></td>
- <td width="7%" align="center"><%=price%></td>
- </tr>
- <%
- }
- }
- %>
- </table></td>
- </tr>
- </table>
- </td>
- </tr>
- </table></td>
- </tr>
- </table>
- </td>
- </tr>
- </table>
- </body>
- </html>