【JSP开源代码栏目提醒】:网学会员为广大网友收集整理了,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(" <a href='language.jsp?lei="+lei+"&page="+j+"'>"+j+"</a>");
}%>