📄 bookinfo.jsp
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBbookinfo" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<head>
<script language=javascript src="../function/admin.js"></script>
<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<%
int PageSize=10;
int CurPage=1;
int TotalPage=0;
int RecCount=0;
if(request.getParameter("page")!=null){
CurPage=Integer.parseInt(request.getParameter("page"));}
ResultSet rs=null;
try{
String strSQL="select count(*) as RecCount from bookinfo";
rs=DBbookinfo.executeQuery(strSQL);
if(rs.next()){
RecCount=rs.getInt("RecCount");
}
rs=null;
TotalPage=RecCount/PageSize+(RecCount%PageSize==0?0:1);
strSQL="select top "+PageSize+" * from bookinfo where BookNo not in " +
"(select top "+(CurPage-1)*PageSize+" BookNo from bookinfo)";
rs=DBbookinfo.executeQuery(strSQL);
//rs.next();
//out.print(rs.getString("ID"));
}
catch(Exception e){
out.println(e.toString());
}
%>
<BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
<br>
<form name=sobook action=book_so.jsp method=post>
<TABLE class=navi cellSpacing=1 align=center border=0>
<TBODY>
<TR>
<TH colSpan=2>当前位置:系统管理>>图书信息管理>>所有图书</TH></TR>
<TR>
<td>图书搜索：输入书名：
<input type=text name=book size=20 onfocus=this.value='' value=请输入关键字>
<SELECT size=1 name=soulei>
<OPTION value="" selected>请选择分类</OPTION>
<OPTION value=法律类 >法律类</OPTION><OPTION value=经济管理类 >经济管理类</OPTION>
<OPTION value=计算机类 >计算机类</OPTION><OPTION value=建筑类 >建筑类</OPTION>
<OPTION value=生活类 >生活类</OPTION><OPTION value=社科类 >社科类</OPTION>
<OPTION value=文学类 >文学类</OPTION><OPTION value=外语类 >外语类</OPTION>
<OPTION value=艺术类 >艺术类</OPTION>
</SELECT> <input type=submit name=submit value=半岛搜索 onclick="return sous();"></td>
<TD align=right>[所有图书] [<A href="addbook.jsp">新增图书</A>] [<A href="index.jsp">回首页</A>]</TD>
</TR>
</TBODY>
</TABLE></form>
<FORM name=checkform method=post>
<TABLE class=list cellSpacing=1 align=center border=0 width=760px;>
<TBODY>
<TR>
<TH >书编号</TH>
<TH >类ID</TH>
<TH >书名</TH>
<TH >作者</TH>
<TH >类名</TH>
<TH >出版社</TH>
<TH >封面图</TH>
<TH >内容简介</TH>
<TH >书价</TH>
<TH >总数</TH>
<TH >余数</TH>
<TH >登记时间</TH>
<TH >销售价</TH>
<th >操作</th>
<th >预览</th>
</TR>
<%
while(rs.next()){
String bookno=rs.getString("BookNo");
String idname=rs.getString("ID");
//out.println(idname);
%>
<TR align=center>
<TD><input type=text class=text1 name=bn size=4 readonly=true value=<%=bookno%>></TD>
<td><input type=text class=text1 name=idna size=4 readonly=true value=<%=idname%>></td>
<TD><input type=text class=text1 name=bn size=5 readonly=true value=<%=rs.getString("BookName")%>></TD>
<TD><input type=text class=text1 name=aut size=3 readonly=true value=<%=rs.getString("Author")%>></TD>
<TD><input type=text class=text1 name=bc size=4 readonly=true value=<%=rs.getString("BookClass")%>></TD>
<TD><input type=text class=text1 name=pub size=5 readonly=true value=<%=rs.getString("Publish")%>></TD>
<TD><input type=text class=text1 name=pic size=5 readonly=true value=<%=rs.getString("Pictrue")%>></TD>
<TD><TEXTAREA name=bookcon readonly=true cols=12><%=rs.getString("Content")%></TEXTAREA></TD>
<TD><input type=text class=text1 name=pri size=3 readonly=true value=<%=rs.getString("Price")%>></TD>
<TD><input type=text class=text1 name=amo size=3 readonly=true value=<%=rs.getString("Amount")%>></TD>
<TD><input type=text class=text1 name=lno size=3 readonly=true value=<%=rs.getString("Leav_number")%>></TD>
<TD><input type=text class=text1 name=reg size=7 readonly=true value=<%=rs.getString("RegTime")%>></TD>
<TD><input type=text class=text1 name=sal size=5 readonly=true value=<%=rs.getString("SalePrice")%>></TD>
<td><input type=checkbox name="check<%=bookno%>" value=<%=bookno%>></td>
<td><a href="scanbook.jsp?ID=<%=bookno %>">预览</a></td>
</TR>
<% } %>
</TBODY>
</TABLE>
<TABLE align=center style="width:700px;">
<tr><td> </td></tr>
<TR>
<TD style="margin-top:30px; text-align:center; font-size:14px; ">
<%
if(CurPage==1){
if(CurPage==TotalPage){
out.println("首页 上一页 下一页 尾页");
}else{
out.println("首页 上一页 <a href='#' onclick='javascript:gotoPagebook("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagebook("+TotalPage+")'>尾页</a>");
}
}else{
if(CurPage==TotalPage){
out.println("<a href='#' onclick='javascript:gotoPagebook(1)'>首页</a> <a href='#' onclick='javascript:gotoPagebook("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
}else{
out.println("<a href='#' onclick='javascript:gotoPagebook(1)'>首页</a> <a href='#' onclick='javascript:gotoPagebook("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPagebook("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagebook("+TotalPage+")'>尾页</a>");
}
}
%></TD>
<td style="margin-top:10px; text-align:center; font-size=14px">
<%
out.print("跳转到第");
out.println("<select size=1 name=\"page\" onChange=\"gotoPagebook(this.value)\">");
for(int i=1;i<=TotalPage;i++)
{
String selectAdd=(i==CurPage)?" selected":"";
out.println("<option value='"+i+"' "+selectAdd+"> "+i+" </option>");
}
out.println("</select>");
out.print("页");
%></td>
<td> </td>
<td style="margin-top:10px text-align:center "> <input type="button" name="Submit" value="全选" onclick="check()" /> <input type="button" name="Submit" value="反选" onclick="check2()" /> </td>
<td >
<input type="button" name="delete" value="删除选中项" style="margin-top:0px" onClick="return bookdele();">
<input type="button" name="up" value="修改选中项" style="margin-top:0px" onClick="return bookupp();">
</td>
</TR>
</TABLE>
</FORM>
<%
rs.close();
DBbookinfo.close();
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -