【JSP开源代码栏目提醒】:以下是网学会员为您推荐的JSP开源代码-bookQuery.jsp,希望本篇文章对您学习有所帮助。
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.dao.BookDAO" %>
<%@ page import="com.actionForm.BookForm" %>
<%@ page import="java.util.*"%>
<html>
<%
Collection coll=(Collection)request.getAttribute("ifbook");
%>
<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="510" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" class="tableBorder_gray">
<tr>
<td height="510" 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">
<form action="" method="post" name="form1">
<table width="98%" height="38" border="0" cellpadding="0" cellspacing="0" bgcolor="#E3F4F7" class="tableBorder_gray">
<tr>
<td align="center">
<img src="Images/search.gif" width="45" height="28"></td>
<td>请选择查询依据:
<select name="f" class="wenbenkuang" id="f">
<option value="barcode">条形码</option>
<option value="typename">类别</option>
<option value="bookname" selected>书名</option>
<option value="author">作者</option>
<option value="publishing">出版社</option>
<option value="bookcasename">书架</option>
</select>
<input name="key" type="text" id="key" size="50">
<input name="Submit" type="submit" class="btn_grey" value="查询"></td>
</tr>
</table>
<%
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 ID=0;
String bookname="";
String barcode="";
String typename="";
String publishing="";
String bookcase="";
int storage=0;
%>
<table width="98%" border="1" cellpadding="0" cellspacing="0" bordercolor="#FFFFFF" bordercolordark="#D2E3E6" bordercolorlight="#FFFFFF">
<tr align="center" bgcolor="#e3F4F7">
<td width="13%">条形码</td>
<td width="26%">图书名称</td>
<td width="15%">图书类型</td>
<td width="14%">出版社</td>
<td width="12%">书架</td>
<td width="9%">库存总数</td>
</tr>
<%
while(it.hasNext()){
BookForm bookForm=(BookForm)it.next();
ID=bookForm.getId().intValue();
bookname=chStr.toChinese(bookForm.getBookName());
barcode=bookForm.getBarcode();
if(barcode==null) barcode="";
typename=chStr.toChinese(bookForm.getTypeName());
publishing=chStr.toChinese(bookForm.getPublishing());
bookcase=chStr.toChinese(bookForm.getBookcaseName());
storage=bookForm.getStorage();
%>
<tr>
<td style="padding:5px;"> <%=barcode%></td>
<td style="padding:5px;"><a href="book.do?action=bookDetail&ID=<%=ID%>"><%=bookname%></a></td>
<td style="padding:5px;"> <%=typename%></td>
<td style="padding:5px;"> <%=publishing%></td>
<td style="padding:5px;"> <%=bookcase%></td>
<td style="padding:5px;"> <%=storage%>(本)</td>
</tr>
<%
}
}
%>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table><%@ include file="copyright.jsp"%></td>
</tr>
</table>
</td>
</tr>
</table>
</body>
</html>
上一篇:
bookmsg.jsp
下一篇:
成本管理详细介绍