📄 system_info.jsp

📁 一个用java开发的具有搜索功能的图书管理系统
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" errorPage="error.jsp" %><%@ include file="initialization.jsp" %><%String unit=xml.getValue("/System/PenltyPerDay/@unit");String database=xml.getName("/System/Database/*");int sortSum=xml.getElementsValues("/System/BookSort").length;String penlty=xml.getValue("/System/PenltyPerDay");String borrowSum=xml.getValue("/System/BorrowSum");String borrowTerm=xml.getValue("/System/BorrowTerm");String borrowTermUnit=xml.getValue("/System/BorrowTerm/@unit");ResultSet rs=mysql.getResultSet("select count(*) bulletinCount from bulletin;");String recordSum=(rs.next()==true)?rs.getString("bulletinCount"):"0";rs=mysql.getResultSet("select bulletinID,title from bulletin where bulletinID=(select max(bulletinID) from bulletin);");String bulletinTitle=(rs.next()==true)?rs.getString("title"):"0";String bulletinID=(rs.next()==true)?rs.getString("bulletinID"):"0";rs=mysql.getResultSet("select count(*) promulgatorSum from bulletin group by promulgator;");String promulgatorSum=(rs.next()==true)?rs.getString("promulgatorSum"):"0";rs=mysql.getResultSet("select count(*) bookSortSum from book;");String bookSortSum=(rs.next()==true)?rs.getString("bookSortSum"):"0";rs=mysql.getResultSet("select sum(totality) bookSum from book;");String bookSum=(rs.next()==true)?rs.getString("bookSum"):"0";rs=mysql.getResultSet("select sum(stocks) bookStocks from book;");String bookStocks=(rs.next()==true)?rs.getString("bookStocks"):"0";rs=mysql.getResultSet("select sum(price) bookPriceSum from book;");String bookPriceSum=(rs.next()==true)?rs.getString("bookPriceSum"):"0";rs=mysql.getResultSet("select count(*) studentSum from student;");String studentSum=(rs.next()==true)?rs.getString("studentSum"):"0";rs=mysql.getResultSet("select count(*) borrowStudentSum from student where borrowNum>0;");String borrowStudentSum=(rs.next()==true)?rs.getString("borrowStudentSum"):"0";rs=mysql.getResultSet("select count(*) needReturnedSum from record where isReturned='no';");String needReturnedSum=(rs.next()==true)?rs.getString("needReturnedSum"):"0";int type=0;if(borrowTermUnit.equals("月")){	type=dateTime.MONTH;}else{	if(borrowTermUnit.equals("周"))	{		type=dateTime.WEEK;	}	else	{		type=dateTime.DAY;	}}rs=mysql.getResultSet("select count(*) overdueSum from record where borrowDate<"+						dateTime.addDate(dateTime.getDate(),0-Integer.parseInt(borrowTerm),dateTime.MONTH)+";");String overdueSum=(rs.next()==true)?rs.getString("overdueSum"):"0";//out.println(requestPage);//out.println(thisPage); %><html xmlns="http://www.w3.org/1999/xhtml"><head><meta http-equiv="Content-Type" content="text/html; charset=gb2312" /><title>无标题文档</title></head><body><table width="550" height="455" border="0" cellspacing="0" cellpadding="0" style="font-size:13px;">  <tr>    <td height="455">	<table width="540" cellpadding="0" cellspacing="0" border="0" >      <tr>        <td colspan="4" align="center" height="80">		<table width="500" height="70"border="1" cellspacing="0" cellpadding="0" bordercolor="#C2D1E9" style=" border-bottom-color:#3399CC; border-left-color:#3399CC; border-right-color:#3399CC; border-top-color:#3399CC;font-size:13px;">		    <tr>		      <td colspan="3" align="center" bgcolor="#6699CC">数据库 </td>		      </tr>		    <tr>		      <td align="center">名称</td>              <td align="center">管理员</td>              <td align="center">密码</td>              </tr>		    <tr>		      <td align="center"><%= database %></td>              <td align="center"><%= mysqlAdmin %></td>              <td align="center"><%= mysqlPassword %></td>              </tr>	        </table>		<br>		</td>        </tr>            <tr>        <td colspan="4" align="center" height="80">		<table width="500" height="70"border="1" cellspacing="0" cellpadding="0" bordercolor="#C2D1E9"  style=" border-bottom-color:#3399CC; border-left-color:#3399CC; border-right-color:#3399CC; border-top-color:#3399CC;font-size:13px;">            <tr>              <td colspan="3" align="center" bgcolor="#6699CC">公告表</td>            </tr>            <tr>              <td align="center">记录数</td>              <td align="center">最近发布记录</td>              <td align="center">发布者个数</td>              </tr>            <tr>              <td align="center"><%= recordSum %></td>              <td align="center"><%= bulletinTitle %></td>              <td align="center"><%= promulgatorSum %></td>              </tr>          </table>		<br></td>        </tr>            <tr>        <td colspan="4" align="center" height="80">		<table width="500" height="70"border="1" cellspacing="0" cellpadding="0" bordercolor="#C2D1E9"  style=" border-bottom-color:#3399CC; border-left-color:#3399CC; border-right-color:#3399CC; border-top-color:#3399CC;font-size:13px;">            <tr>              <td colspan="5" align="center" bgcolor="#6699CC">书籍表</td>            </tr>            <tr>              <td align="center">书目总数</td>              <td align="center">分类类</td>              <td align="center">书本总数</td>              <td align="center">库存总数</td>              <td align="center">总价</td>              </tr>            <tr>              <td align="center"><%= bookSortSum %></td>              <td align="center"><%= sortSum %></td>              <td align="center"><%= bookSum %></td>              <td align="center"><%= bookStocks %></td>              <td align="center"><%= bookPriceSum %></td>              </tr>          </table>		<br></td>        </tr>            <tr>        <td colspan="4" align="center" height="80">		<table width="500" height="70"border="1" cellspacing="0" cellpadding="0" bordercolor="#C2D1E9"  style=" border-bottom-color:#3399CC; border-left-color:#3399CC; border-right-color:#3399CC; border-top-color:#3399CC;font-size:13px;">            <tr>              <td colspan="2" align="center" bgcolor="#6699CC">用户表 </td>            </tr>            <tr>              <td align="center">用户总数</td>              <td align="center">借书用户数</td>              </tr>            <tr>              <td align="center"><%= studentSum %></td>              <td align="center"><%= borrowStudentSum %></td>              </tr>          </table>		<br></td>        </tr>            <tr>        <td colspan="4" align="center" height="80">		<table width="500" height="70"border="1" cellspacing="0" cellpadding="0" bordercolor="#C2D1E9"  style=" border-bottom-color:#3399CC; border-left-color:#3399CC; border-right-color:#3399CC; border-top-color:#3399CC;font-size:13px;">            <tr>              <td colspan="5" align="center" bgcolor="#6699CC">借阅表</td>            </tr>            <tr>              <td align="center">最多可借数</td>              <td align="center">借阅期(<%= borrowTermUnit %>)</td>			  <td align="center">逾期罚价（<%=unit%>/日）</td>              <td align="center">未还数</td>              <td align="center">逾期数</td>                         </tr>            <tr>              <td align="center"><%= borrowSum %></td>              <td align="center"><%= borrowTerm %></td>              <td align="center"><%= penlty %></td>              <td align="center"><%= needReturnedSum %></td>              <td align="center"><%= overdueSum %></td>            </tr>          </table>		<br></td>        </tr>    </table>	</td>  </tr></table></body></html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -