bookslist.jsp

网上书店系统系统能实现用户的注册、登录功能；能够实现商品的查询

<script language="JavaScript" type="text/JavaScript">
<!--
function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<script>
  function openbag(id) { window.open("basket.jsp?id="+id,"","height=420,width=460,left=190,top=10,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no");} 
</script>
<table   border=0 align="center" cellpadding=0 cellspacing=1>
<tr bgcolor="#E6E6E6">
<th width="251">图书名称</th>
<th width="111">出版社</th>
<th width="112">定价</th>
<th colspan="2">日期</th>
</tr>
<%
//public bs=rs.getString("leiID");
  int intPageSize; //一页显示的记录数
  int intRowCount; //记录总数 
  int intPageCount; //总页数 
  int intPage; //待显示页码 
  String  strPage,lei; 
  int i; 
  //设置一页显示的记录数 
 intPageSize =15; 
//取得待显示页码 
strPage = request.getParameter("page"); 
lei = request.getParameter("lei"); //图书类别
if(lei==null){
lei="1";
}

if(strPage==null){//表明在QueryString中没有page这一个参数，此时显示第一页数据 
  intPage = 1; 
  } else{//将字符串转换成整型 
intPage = java.lang.Integer.parseInt(strPage); 
}

sql="select * from tushumingxi where lieID="+java.lang.Integer.parseInt(lei);
Statement selstmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=selstmt.executeQuery(sql);


if(intPage< 1){
intPage = 1; 
} 
//获取记录总数 
rs.last(); 
intRowCount = rs.getRow(); 
//记算总页数 
intPageCount = (intRowCount+intPageSize-1) / intPageSize; 
//调整待显示的页码 
if(intPage >intPageCount) intPage = intPageCount; 
if(intPageCount >0){ 
//将记录指针定位到待显示页的第一条记录上 
rs.absolute((intPage-1) * intPageSize+1); 
//显示数据 
}
i = 0; 
while(i< intPageSize && !rs.isAfterLast()){
int bkid=rs.getInt("shuID");
%>
        
        <tr valign="middle" bgcolor="#f8f8f8" height="25">
<td width="251" bgcolor="#f8f8f8" ><a href=# onClick="MM_openBrWindow('browbook.jsp?id=<%=bkid%>','','width=400,height=550')"><%=rs.getString("shu_name")%></a></td>
<td><%=rs.getString("banshe")%></td>
<td><div align="center">￥<%=rs.getString("dingjia")%>元</div></td>
<td width="114"><%=rs.getString("date")%></td>
<td width="34" align="center"><a href="javascript:MM_openBrWindow('basket.jsp?id=<%=bkid%>','','scrollbars=yes,width=480,height=350')"><img src="image/04dd_car.gif" width="19" height="16" border="0"></a></td>
  </tr>
        <tr>
          <td height=1 colspan="5" background="image/dian.gif"><img src="images/blank.gif" width=1 height=1></td>
        </tr>
         <%rs.next(); 
   i++; 
}			rs.close();
			selstmt.close();
			conn.close();%>	
</table>
<p align="center">
共<%=intRowCount%>个记录,分<%=intPageCount%>页显示,您所在本页是:第<%=intPageCount%>页
<%for(int j=1;j<=intPageCount;j++)
{out.print("&nbsp;&nbsp;<a href='language.jsp?lei="+lei+"&page="+j+"'>"+j+"</a>");
}%>