📄 book.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<%@ page import="j0202_05_login.*" %>
<%@ page import="j0202_05_book.*" %>
<%@ page import="java.io.*" %>
<%!
public String codeString(String s)
{String str=s;
try{byte b[]=str.getBytes("ISO-8859-1");
str=new String (b);
return str;
}
catch(Exception e)
{return str;
}
}
%>
<HTML>
<BODY bgcolor="#DEEFEF"><Font size=4>
<jsp:useBean id="handlePage" class="j0202_05_book.PageNumber" scope="session" >
</jsp:useBean>
<jsp:useBean id="login" class="j0202_05_login.Login" scope="session" >
</jsp:useBean>
<a href="<%=response.encodeURL("main.jsp") %>">首页(main)</a>
<a href="<%=response.encodeURL("registertj.jsp") %>">用户注册(register)</a>
<a href="<%=response.encodeURL("bookinftj.jsp") %>">录入图书(bookinf)</a>
<a href="<%=response.encodeURL("buybook.jsp") %>">查看订单(bookinf)</a>
<br>
<% String cxsp=request.getParameter("cxsp");
if(cxsp==null)
{cxsp="";
}
cxsp=codeString(cxsp);
String cxtype=request.getParameter("cxtype");
if(cxtype==null)
{cxtype="";
}
cxtype=codeString(cxtype);
%>
<P>图书目录:
<%! Connection con=null;
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=70>"+"<Font size=2>"+"商品编号"+"</Font>");
out.print("<TH width=70>"+"<Font size=2>"+"商品名称"+"</Font>");
out.print("<TH width=40>"+"<Font size=2>"+"价格"+"</Font>");
out.print("<TH width=70>"+"<Font size=2>"+"总页数"+"</Font>");
out.print("<TH width=70>"+"<Font size=2>"+"软件大小"+"</Font>");
out.print("<TH width=90>"+"<Font size=2>"+"作者"+"</Font>");
out.print("<TH width=90>"+"<Font size=2>"+"出版社"+"</Font>");
out.print("<TH width=90>"+"<Font size=2>"+"出版时间"+"</Font>");
out.print("<TH width=90>"+"<Font size=2>"+"版次"+"</Font>");
out.print("<TH width=100>"+"<Font size=2>"+"商品简介"+"</Font>");
out.print("<TH width=70>"+"<Font size=2>"+"添加到订单"+"</Font>");
out.print("</TR>");
for(int i=1;i<=n;i++)
{out.print("<TR>");
String id=rs.getString(1),
id2=rs.getString(2),
id3=rs.getString(3),
id6=rs.getString(6);
out.print("<TD >"+rs.getString(1)+"</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>");
out.print("<TD >"+rs.getString(9)+"</TD>");
out.print("<TD >"+rs.getString(10)+"</TD>");
String s1="<FORM action="+buybook+" method=post>";
String s2="<input type=hidden name=id value="+id+">";
String s3="<input type=hidden name=sp_name value="+id2+">";
String s4="<input type=hidden name=sp_price value="+id3+">";
String s5="<input type=hidden name=sp_writer value="+id6+">";
String s6="<input type=submit value=订购></FORM> ";
String s=s1+s2+s3+s4+s5+s6;
out.print("<TD >"+s+"</TD>");
out.print("</TR>");
rs.next();
}
out.print("</Table>");
}
catch(Exception e1){}
}
%>
<% Statement sql=null;
ResultSet rs=null;
int rowCount=0;
if(con==null)
{ try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){}
try{
con=DriverManager.getConnection("jdbc:odbc:LocalServer","sa","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
if(cxsp.equals("allbook"))
{
rs=sql.executeQuery("SELECT * FROM spinf");
}
else
{ rs=sql.executeQuery("SELECT * FROM spinf where"+cxtype+"="+cxsp);}
rs.last();
int number=rs.getRow();
rowCount=number;
handlePage.setPageSize(10);
handlePage.setPageCount(rowCount,handlePage.getPageSize());
out.print("共有"+handlePage.getPageCount()+"页,");
out.print("每页显示"+handlePage.getPageSize()+"条记录");
}
catch(SQLException e)
{
}
}
else
{synchronized(con)
{ try{sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
if(cxsp.equals("allbook"))
{
rs=sql.executeQuery("SELECT * FROM spinf");
}
else
{ rs=sql.executeQuery("SELECT * FROM spinf where"+cxtype+"="+cxsp);}
rs.last();
int number=rs.getRow();
rowCount=number;
handlePage.setPageSize(10);
handlePage.setPageCount(rowCount,handlePage.getPageSize());
out.print("共有"+handlePage.getPageCount()+"页,");
out.print("每页显示"+handlePage.getPageSize()+"条记录");
}
catch(SQLException e)
{
}
}
}
%>
<% String str=response.encodeURL("book.jsp");
String buybook=response.encodeURL("buybook.jsp");
%>
<% String pagex=request.getParameter("page");
if(pagex==null)
{pagex="1";
}
if(pagex.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(pagex.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(pagex);
handlePage.setShowPage(m);
out.print("目前显示第"+handlePage.getShowPage()+"页");
int n=handlePage.getShowPage();
showList(rs,out,handlePage.getPageSize(),buybook);
}
%>
<FORM action="<%=str%>" method="post" >
<input type="hidden" name="page" value="previous">
<input type=submit value="上一页">
</FORM>
<FORM action="<%=str%>" method="post" >
<input type="hidden" name="page" value="next">
<input type=submit value="下一页">
</FORM>
<FORM action="<%=str%>" method="post" >
输入要显示的页<input type="text" name="page" value="1">
<input type=submit value="显示">
</FORM>
</Font>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -