📄 showbooklist.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%><%@ page import="java.sql.*"%><%@ page import="aa.Login"%><%@ page import="aa.PageNumber"%><jsp:useBean id="handlePage" class="PageNumber" scope="session"></jsp:useBean><jsp:useBean id="login" class="Login" scope="session"></jsp:useBean><%if(session.isNew()){response.sendRedirect("useLogin.jsp");}String success=login.getSuccess();if(success==null){success="";}if(!(success.equals("ok"))){response.sendRedirect("userLogin.jsp");}%><html><body font size=3 bgcolor="#FFFFFF"><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=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++) { out.print("</tr>"); String id=rs.getString(1); 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.getDate(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","sa",""); 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.encodeURL("showBookList.jsp");String buybook=response.encodeURL("buybook.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 + -