📄 search.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import ="java.sql.*" %>
<%@ page import ="Beans.*" %>
<html>
<head>
<title>信息浏览页面</title>
<LINK REL=STYLESHEET HREF="../CSS/style.css" TYPE="TEXT/CSS">
</head>
<br><img src="../imgs/disc2.jpg">
<body onload="document.form1.inp.focus()" bgcolor="#EFFBFE" leftmargin="0" topmargin="0" link="#666666" vlink="#336699" alink="#666666">
<a href=index.html>主页>> </a><a href=management.jsp>管理>></a>
<form name=form1 action="search.jsp" onsubmit="return check()" method=get>
<table><tr><td>
<font color="blue" >选择查询方式：</font>
<select name="SearchBy" size=1 onchange="check2()"><option value="name" checked>按照书名字</option><option value="no">按照书标号</option></select>
</td></tr><tr><td>
<font color="blue" >输入关键字：</font>
<input type="text" name="inp" value="" maxlength=20>
<input type="submit" name="submit" color="blue" >
</td></tr></table>
</form>
<hr>
<ul><li><b><font color=blue>以下是所搜索信息:<b></font></li></ul><br>
<center>
<%
String radioValue=null;
String inputStr =null;
%>
<%
radioValue=PubStatic.toGBK(request.getParameter("SearchBy"));
inputStr=PubStatic.toGBK(request.getParameter("inp"));
GetRS grs=new GetRS();
ResultSet rs=null;
int pageSize=6;
int pageOf=1;
int totalPage=1;
int totalRecord=0;
%>
<%
try{
if(radioValue.equals("name")) //按名搜索
{
grs.setQueryStr("select count(*) from book_info where book_name like '%"+inputStr+"%'");
rs=grs.getRs();
if(rs.next()) totalRecord=rs.getInt(1);
grs.setQueryStr("select * from book_info where book_name like '%"+inputStr+"%'");
rs=grs.getRs();
}
else //按照书标号
{
grs.setQueryStr("select count(*) from book_info where book_no like '%"+inputStr+"%'");
rs=grs.getRs();
if(rs.next()) totalRecord=rs.getInt(1);
grs.setQueryStr("select * from book_info where book_no like '%"+inputStr+"%'");
rs=grs.getRs();
}
%>
<%
if(totalRecord%pageSize==0)
totalPage=totalRecord/pageSize;
else
{
totalPage=totalRecord/pageSize+1;
}
if(totalPage==0) totalPage=1;
//确定pageOf的值：当前页号
if(request.getParameter("page")==null || request.getParameter("page").equals(""))
pageOf=1;
else
{
try {
pageOf=Integer.parseInt(request.getParameter("page"));
}catch(NumberFormatException e2)
{
pageOf=1;
}
}
if(pageOf<1) pageOf=1;
if(pageOf>totalPage) pageOf=totalPage;
//定位到某一行
rs.absolute((pageOf-1)*pageSize+1);
%>
<center>
<table border=0 width=50% name=mytb bgcolor=#e1e1e1 border=1 bordercolordark=#ffffff bordercolorlight=#999999 cellpadding=1 cellspacing=5>
<tr bgcolor=009999 align=center><td colspan=4 ><font color=white size=-1>共<%=totalRecord%>条记录</font><td>
<tr bgcolor=FFCC00 align=middle>
<td width=37%><font color=blue> 编号</font></td>
<td><font color=blue> 名称</font></td>
<td><font color=blue> 状态</font></td>
<td><font color=blue> 价格</font></td>
</tr>
<%
for(int iPage=1;iPage<=pageSize;iPage++)
{
out.print("<tr bgcolor=009999 align=middle><td>"+rs.getString(1)+
"</td><td>"+rs.getString(2)+
"</td><td>"+rs.getString(3)+"</td>"+
"<td>"+rs.getInt(4)+"</td></tr>");
if(!rs.next()) break;
}
rs.close();
grs.close();//关闭STMT和CONN连接
}catch(Exception eee){}
%>
</table></center><br>
<form method="get">
<center>
<%
if(pageOf!=1)
{
out.print("<a href=search.jsp?page=1>第一页</a> ");
out.print("<a href=search.jsp?page="+(pageOf-1)+">上一页</a> ");
}
if(pageOf!=totalPage)
{
out.print("<a href=search.jsp?page="+(pageOf+1)+">下一页</a> ");
out.print("<a href=search.jsp?page="+totalPage+">最后一页</a>");
}
%>
</center>
</form>
<%/**************************************************/%>
<Script LANGUAGE="JavaScript">
function check()
{
if(document.form1.inp.value==null || document.form1.inp.value=="")
{
alert("查询条件不为空！");
return false;
}
}
</Script>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -