booklist.jsp

来自「网上书店购物系统」· JSP 代码 · 共 188 行

<%@ page contentType="text/html; charset=GB2312" %>
<%@ page import="java.util.*,java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection("jdbc:odbc:bookshoplk","sa","");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null;
%>
<%
String s_admin=(String)session.getAttribute("admin");
if(s_admin==null){
response.sendRedirect("checklogin.jsp");
}
%>
<%
String s_where=(String)session.getAttribute("s_where");
if(s_where==null)
s_where="";
%>
<%
int i_totalnum=0;    //总记录数
int i_pagenum=10;    //一页显示的记录数码
int i_totalpage=0;   //总页数 
int i_currentpage=1; //当前页 
%>
<%
String op = request.getParameter("op");
if(op==null)
{
s_where="";
session.setAttribute("s_where",s_where);
}
%>
<%
rs=stmt.executeQuery("select count(*) from book where bookid is not null "+s_where);
rs.next();
i_totalnum=rs.getInt(1);

i_totalpage=i_totalnum/i_pagenum;
if(i_totalnum%i_pagenum!=0)
i_totalpage++;

%>

<%

if(op!=null&&op.equals("show"))
{
String s_currentpage = request.getParameter("currentpage");
i_currentpage=Integer.parseInt(s_currentpage);
}
if(op!=null&&op.equals("previous"))
{
String s_currentpage = request.getParameter("currentpage");
i_currentpage=Integer.parseInt(s_currentpage)-1;
}
if(op!=null&&op.equals("next"))
{
String s_currentpage = request.getParameter("currentpage");
i_currentpage=Integer.parseInt(s_currentpage)+1;
}
if(op!=null&&op.equals("firstpage"))
{
i_currentpage=1;
}
if(op!=null&&op.equals("lastpage"))
{
i_currentpage=i_totalpage;
}

%>
<link href="../maincss.css" rel="stylesheet" type="text/css">


<div align="center">
<table width="750" border="0" cellspacing="1" cellpadding="1">
  <tr> 
    <td ><div align="center"><%@include file="top.jsp" %></div></td>
  </tr>
  <tr> 
    <td ><div align="center">
   <table width="100%" border="0" cellpadding="1" cellspacing="1" class="td"> 
   <tr>
   <td colspan="9"><div align="right"><a href="bookadd.jsp">新建</a>&nbsp;&nbsp;&nbsp;&nbsp;<a href="booksearch.jsp">查询</a></div></td>
   </tr>
   <tr>
   <td colspan="9"><hr size="1" noshade width="100%"></td>
   </tr>  
 <%if(i_totalnum>0){%>   
  <tr>
    <td>书号</td>
    <td>书名</td>
    <td>作者</td>
    <td>出版社</td>	
    <td>价格</td>
              <td><div align="center">库存</div></td>
    <td>存储位置</td>
    <td>类别</td>
	<td>操作</td>
  </tr>
<%
rs=stmt.executeQuery("select * from book  left join publisher on book.publisherid=publisher.publisherid where bookid is not null "+s_where+" order by bookid ");
if(i_currentpage>i_totalpage)
i_currentpage=i_totalpage;

int i_position=(i_currentpage-1)*i_pagenum;
if(i_position==0)
rs.beforeFirst();
else
rs.absolute(i_position);

for(int i=0;i<i_pagenum;i++)
{

if(!rs.isLast()){
rs.next();
String s_bookid=(rs.getString("bookid")!=null?rs.getString("bookid"):"");
String s_bookname=(rs.getString("bookname")!=null?rs.getString("bookname"):"");
String s_author=(rs.getString("author")!=null?rs.getString("author"):"");
String s_price=(rs.getString("price")!=null?rs.getString("price"):"");
String s_type=(rs.getString("type")!=null?rs.getString("type"):"");
String s_quantity=(rs.getString("quantity")!=null?rs.getString("quantity"):"");
String s_place=(rs.getString("place")!=null?rs.getString("place"):"");
String s_publisherid=(rs.getString("name")!=null?rs.getString("name"):"");

if(s_type.equals("0"))
s_type="普通";
if(s_type.equals("1"))
s_type="新书";
if(s_type.equals("2"))
s_type="精品";

%>
  <tr>
              <td><a href="bookedit.jsp?op=show&bookid=<%=s_bookid%>"><%=s_bookid%></a></td>
              <td><%=s_bookname%></td>
              <td><%=s_author%></td>
              <td><%=s_publisherid%></td>
              <td>￥<%=s_price%></td>
              <td> <div align="center"><%=s_quantity%> </div></td>
              <td><%=s_place%></td>
              <td><%=s_type%></td>
			  <td><a href="bookdelete.jsp?op=delete&bookid=<%=s_bookid%>&currentpage=<%=i_currentpage%>">删除</a></td>

  </tr>
  <%
  }//if
  }//for%>
   <tr>
   <td colspan="9"><div align="center">
   共<%=i_totalpage%>页 第<%=i_currentpage%>页&nbsp;
<%if(i_currentpage>1){%>
   <a href="booklist.jsp?op=firstpage">首页</a>
<%}else{%>首页<%}%>     
   &nbsp;
<%if(i_currentpage>1){%>
   <a href="booklist.jsp?op=previous&currentpage=<%=i_currentpage%>">上一页</a>
<%}else{%>上一页<%}%>   
   &nbsp;
<%if(i_currentpage!=i_totalpage){%>
   <a href="booklist.jsp?op=next&currentpage=<%=i_currentpage%>">下一页</a>
<%}else{%>下一页<%}%>    
   
   &nbsp;
<%if(i_currentpage!=i_totalpage){%>
   <a href="booklist.jsp?op=lastpage">末页</a>
<%}else{%>末页<%}%>    

   </div></td>
   </tr>
<%}else{%>
   <tr>
   <td colspan="9">没有图书信息.</td>
   </tr>  
<%}%>
</table>
       

	
	</div></td>
  </tr>  
  <tr> 
    <td ><div align="center">
          <%@include file="../bottom.jsp" %>
        </div></td>
  </tr>
</table>
</div>