📄 showbooklist.jsp.bak
字号:
<HTML>
<%@page contentType="text/html;charset=GB2312"%>
<%@page import="java.sql.*" %>
<%@page import="java.io.*" %>
<%@page import="Login" %>
<%@page import="PageNumber" %>
<jsp:useBean id="login" class="Login" scope="session">
</jsp:useBean>
<jsp:useBean id="handlePage" class="PageNumber" scope="session">
</jsp:useBean>
<% if(session.isNew())
response.sendRidirect("userLogin.jsp");
String success=login.getSuccess();
if(success==null)success="";
if(!(success.equals("ok")))
response.sendRidirect("userLogin.jsp");
%>
<BODY bgcolor=white><Font size=3>
<%@include file="head.txt"%>
<P>图书书目：
<%!
Connection con;
public void showList(ResultSet rs,javax.servlet.jsp.JspWriter out,int n,String buybook)
{
try
{ out.print("<Table Border>");
out.print("<TR>");
out.print("<TH width=50>"+"<Font size=3>"+"id"+"</Font>");
out.print("<TH width=50>"+"<Font size=3>"+"订购号"+"</Font>");
out.print("<TH width=70>"+"<Font size=3>"+"书名"+"</Font>");
out.print("<TH width=60>"+"<Font size=3>"+"作者"+"</Font>");
out.print("<TH width=60>"+"<Font size=3>"+"出版社"+"</Font>");
out.print("<TH width=50>"+"<Font size=3>"+"出版时间"+"</Font>");
out.print("<TH width=20>"+"<Font size=3>"+"价钱"+"</Font>");
out.print("<TH width=50>"+"<Font size=3>"+"分类"+"</Font>");
out.print("<TH width=50>"+"<Font size=3>"+"添加到订单"+"</Font>");
out.print("</TR>");
for(int i=1;i<=n;i++)
{
String id=rs.getString(1);
out.print("<TR>");
out.print("<TD>"+id+"</TD>");
out.print("<TD>"+rs.getString(2)+"</TD>");
out.print("<TD>"+rs.getString(3)+"</TD>");
out.print("<TD>"+rs.getString(4)+"</TD>");
out.print("<TD>"+rs.getString(5)+"</TD>");
out.print("<TD>"+rs.getString(6)+"</TD>");
out.print("<TD>"+rs.getString(7)+"</TD>");
out.print("<TD>"+rs.getString(8)+"</TD>");
String s1="<Form action="+buybook+" method=get>";
String s2="<input type=hidden name=id value="+id+">";
String s3="<input type=submit value=订购></Form>";
String s=s1+s2+s3;
out.print("<TD>"+s+"</TD>");
out.print("</TR>");
rs.next();
}
out.print("</Table>");
}catch(Exception e){}
}
%>
<%
Statement sql=null;
ResultSet rs=null;
int rowCount=0;
if(con==null)
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){out.print(e);}
try
{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM book");
rs.last();
int number=rs.getRow();
rowCount=number;
handlePage.setPageSize(3);
handlePage.setPageCount(rowCount,handlePage.getPageSize());
out.print("共有"+handlePage.getPageCount()+"页,");
out.print("每页显示"+handlePage.getPageSize()+"条记录");
} catch(SQLException e){ out.print(e);}
}
else
{
synchronized(con)
{
try
{
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("SELECT * FROM book");
rs.last();
int number=rs.getRow();
rowCount=number;
handlePage.setPageSize(3);
handlePage.setPageCount(rowCount,handlePage.getPageSize());
out.print("共有"+handlePage.getPageCount()+"页,");
out.print("每页显示"+handlePage.getPageSize()+"条记录");
} catch(SQLException e){ out.print(e);}
}
}
%>
<% String str=response.encodeRedirectURL("showBookList.jsp");
String buybook= response.encodeRedirectURL("buybook1.jsp");
%>
<FORM action="<%=str%>" method=post>
显示下一页：<INPUT type="hidden" name="a" value="next">
<INPUT type="submit" value="next" >
</FORM>
<FORM action="<%=str%>" method=post>
显示上一页：<INPUT type="hidden" name="a" value="previous">
<INPUT type="submit" value="previous" >
</FORM>
<FORM action="<%=str%>" method=post>
输入欲要显示的页：<INPUT type="text" name="a" value="1">
<INPUT type="submit" value="submit" >
</FORM>
<% String s=request.getParameter("a");
if(s==null)s="1";
if(s.equals("next"))
{
int n=handlePage.getShowPage();
n=n+1;
if(n> handlePage.getPageCount())n=1;
handlePage.setShowPage(n);
out.print("目前显示第"+handlePage.getShowPage()+"页");
rs.absolute((n-1)*handlePage.getPageSize()+1);
showList(rs,out,handlePage.getPageSize(),buybook);
}
else if(s.equals("previous"))
{
int n=handlePage.getShowPage();
n=n-1;
if(n<=0)n=handlePage.getPageCount();
handlePage.setShowPage(n);
out.print("目前显示第"+handlePage.getShowPage()+"页");
rs.absolute((n-1)*handlePage.getPageSize()+1);
showList(rs,out,handlePage.getPageSize(),buybook);
}
else
{
int m=Integer.parseInt(s);
handlePage.setShowPage(m);
out.print("目前显示第"+handlePage.getShowPage()+"页");
int n= handlePage.getShowPage();
rs.absolute((n-1)*handlePage.getPageSize()+1);
showList(rs,out,handlePage.getPageSize(),buybook);
}
%>
</FONT>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -