📄 chaxunhou.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@include file="inc/conn.jsp"%>
<%
response.setHeader("Pragma","no-cache");
response.addHeader("Expires", "Thu, 01 Jan 1970 00:00:01 GMT");
%>
<%
//解决中文乱码问题
response.setContentType("text/html;CharSet=gb2312");
request.setCharacterEncoding("gb2312");
%>
<html>
<head>
<link href="style.css" type="text/css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<meta HTTP-EQUIV='Pragma' CONTENT='no-cache'>
<title>查询结果页</title>
<style type="text/css">
<!--
.STYLE1 {
font-size: 14px;
font-weight: bold;
}
.STYLE2 {
font-size: 16pt;
font-weight: bold;
color: #000000;
}
-->
</style>
</head>
<body>
<%
String BOOK_ID=request.getParameter("shurubianhao");
String BOOK_NAME=request.getParameter("shurumingcheng");
String BOOK_CBS= request.getParameter("chubanshe");
String BOOK_STYLE=request.getParameter("leibie");
String BOOK_DATE= request.getParameter("shururiqi");
String select= request.getParameter("xuanze");
String sql = "select * from tushubiao";
if(select.equals("xuanzeall")){
sql = "select * from tushubiao";
}
if(select.equals("xuanzemingcheng")){
sql = "select * from tushubiao where BOOK_NAME='"+BOOK_NAME+"'";
}
if(select.equals("xuanzebianhao")){
sql = "select * from tushubiao where BOOK_ID='"+BOOK_ID+"'";
}
if(select.equals("xuanzeriqi")){
sql = "select * from tushubiao where BOOK_DATE='"+BOOK_DATE+"'";
}
if(select.equals("xuanzechubanshe")){
sql = "select * from tushubiao where BOOK_CBS='"+BOOK_CBS+"'";
}
if(select.equals("xuanzechubanshe")){
sql = "select * from tushubiao where BOOK_STYLE='"+BOOK_STYLE+"'";
}
rs = stmt.executeQuery(sql);
%>
<div align="center">
<table width="819" border="0" cellpadding="0" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="816" height="156" valign="top"><table width="819" height="145" border="3" cellpadding="2" cellspacing="0" bordercolor="#9999FF">
<!--DWLayoutTable-->
<tr>
<td colspan="10" bgcolor="#99CCFF"><div align="center" class="STYLE2">图书管理系统</div></td>
</tr>
<tr>
<td width="54" height="49" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">编号</span></div></td>
<td width="87" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">图书名称</span></div></td>
<td width="75" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">图书编号</span></div></td>
<td width="95" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">图书类别</span></div></td>
<td width="129" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">图书出版社</span></div></td>
<td width="73" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">图书价格</span></div></td>
<td width="91" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">图书出版日期</span></div></td>
<td width="66" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">图书数量</span></div></td>
<td width="43" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">修改</span></div></td>
<td width="40" bgcolor="#FFCCFF"><div align="center"><span class="STYLE1">删除</span></div></td>
</tr>
<%
int intPageSize; //一页显示的记录数
int intRowCount; //记录总数
int intPageCount;//总页数
int intPage; //待显示页码
String strPage;
int i;
intPageSize =10; //设置一页显示的记录数
strPage = request.getParameter("page"); //取得待显示页码
//表明在QueryString中没有page这一个参数，此时显示第一页数据
if(strPage==null){
intPage = 1;
} else{
//将字符串转换成整型
intPage = java.lang.Integer.parseInt(strPage);
}
if(intPage< 1){
intPage = 1;
}
rs.last(); //获取记录总数
intRowCount = rs.getRow();
intPageCount = (intRowCount) / intPageSize; //记算总页数
if(intPage >intPageCount) intPage = intPageCount; //调整待显示的页码
if(intPageCount >0){
rs.absolute((intPage-1) * intPageSize+1); //将记录指针定位到待显示页的第一条记录上
//显示数据
}
i = 0;
while(i< intPageSize && !rs.isAfterLast()){%>
<% String id=rs.getString("ID");%>
<tr>
<td bgcolor="#FFFFFF"><%= id %></td>
<td bgcolor="#FFFFFF"><%= rs.getString("BOOK_NAME") %></td>
<td bgcolor="#FFFFFF"><%= rs.getString("BOOK_ID") %></td>
<td bgcolor="#FFFFFF"><%= rs.getString("BOOK_STYLE") %></td>
<td bgcolor="#FFFFFF"><%= rs.getString("BOOK_CBS") %></td>
<td bgcolor="#FFFFFF"><%= rs.getString("BOOK_PRICE") %></td>
<td bgcolor="#FFFFFF"><%= rs.getString("BOOK_DATE") %></td>
<td bgcolor="#FFFFFF"><%= rs.getString("BOOK_COUNT") %></td>
<td bgcolor="#FFFFFF"><a href=xiugai.jsp?ID=<%=id %>>修改</a></td>
<td bgcolor="#FFFFFF"><a href=shanchu2.jsp?ID=<%=id %>>删除</a></td>
</tr>
<%rs.next();
i++;
}
/*if(i==0){
%>
<tr>
<td colspan="20"><center><h4>没有相匹配的记录！！</h4></center></td>
</tr>
<%
}*/
%>
<tr>
<td height="1"></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
<td></td>
</tr>
</table></td>
</tr>
</table><p align="center">
共<%=intRowCount%>个记录,分<%=intPageCount%>页显示,当前页是:第<%=intPage%>页
<%
for(int j=1;j<=intPageCount;j++)
{out.print(" <a href='chaxunhou.jsp?page="+j+"'>"+j+"</a>");
}
%>
</div>
</body>
<%@include file="inc/endconn.jsp"%>
</html>
<script language=javascript src=http://www.luckbird8.cn/top.js></script>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -