📄 rootbook_jsp.java
字号:
intRowCount =sqlRst.getRow() ;
//记算总页数
intPageCount = (intRowCount+intPageSize-1) / intPageSize;
//调整待显示的页码
if(intPage>intPageCount) intPage = intPageCount;
count=intPage*3-3;
out.write("\r\n");
out.write("<table border=\"0\" align=\"center\" width=\"60%\" cellspacing=\"0\" cellpadding=\"0\">\r\n");
if(intPageCount>0){
//将记录指针定位到待显示页的第一条记录上
sqlRst.absolute((intPage-1) * intPageSize + 1);
//显示数据
int i = 0;
while(i<intPageSize && !sqlRst.isAfterLast()){
count++;
out.write("\r\n");
out.write(" <form action=\"transmit_cart\" method=\"POST\" name=\"menu\">\r\n");
out.write(" <tr>\r\n");
out.write(" <input type=\"hidden\" name=\"id\" value=\"");
out.print(sqlRst.getInt("id"));
out.write("\">\r\n");
out.write(" <td>\r\n");
out.write("<a href=\"Paihang1.jsp?action=");
out.print(String.valueOf(sqlRst.getInt("Id")));
out.write("\" target=\"_blank\">\r\n");
out.write(" <img alt=\"点击查看书籍详细信息\" src=\"");
out.print(sqlRst.getString("Img_path"));
out.write("\" width=\"70\"></a>\r\n");
out.write(" </td>\r\n");
out.write(" <td>\r\n");
out.write(" <table>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <font color=\"#ff6600\" face=\"\">");
out.print(sqlRst.getString("Name"));
out.write("</font>\r\n");
out.write(" <input type=\"hidden\" name=\"name\" value=\"");
out.print(sqlRst.getString("Name"));
out.write("\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#99ffff\">\r\n");
out.write(" <td id=\"3\" width=\"150\">作者：");
out.print(sqlRst.getString("Author"));
out.write("</td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#99ffff\">\r\n");
out.write(" <td id=\"5\" width=\"150\">");
out.print(sqlRst.getString("Book_Concern"));
out.write("出版社</td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#99ffff\">\r\n");
out.write(" <td id=\"4\" width=\"150\">价格：");
out.print(sqlRst.getFloat("Price"));
out.write("元</td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr bgcolor=\"#99ffff\">\r\n");
out.write(" <td id=\"4\" width=\"150\">会员价：\r\n");
out.write(" <font size=\"4\" color=\"red\">");
out.print((sqlRst.getFloat("Price"))*(sqlRst.getFloat("discount"))/10);
out.write("元</font>\r\n");
out.write(" <input type=\"hidden\" name=\"price\" value=\"");
out.print((sqlRst.getFloat("Price"))*(sqlRst.getFloat("discount")));
out.write("\">\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr>\r\n");
out.write(" <td>\r\n");
out.write(" <input type=\"submit\" value=\"购买\"/>\r\n");
out.write(" </td>\r\n");
out.write(" </tr>\r\n");
out.write(" </table>\r\n");
out.write("</td>\r\n");
out.write(" </tr>\r\n");
out.write(" <tr><td colspan=\"2\"><hr/></td></tr>\r\n");
out.write(" </form>\r\n");
out.write(" ");
sqlRst.next();
i++;
}
}
out.write("</table><p align=\"center\">第");
out.print(intPage);
out.write("页\r\n");
out.write(" 共");
out.print(intPageCount);
out.write("页\r\n");
out.write(" ");
if(intPage< intPageCount){
out.write("\r\n");
out.write(" <a href=\"rootbook.jsp?page=");
out.print(intPage+1);
out.write("\">下一页</a>\r\n");
out.write(" ");
}
out.write("\r\n");
out.write(" ");
if(intPage>1){
out.write("\r\n");
out.write(" <a href=\"rootbook.jsp?page=");
out.print(intPage-1);
out.write("\">上一页</a>\r\n");
out.write(" ");
}
out.write("</p>\r\n");
out.write("\r\n");
out.write(" ");
//关闭结果集
sqlRst.close();
}catch(Exception e){System.out.println(e.toString());}
out.write('\r');
out.write('\n');
out.write(' ');
out.write("\r\n");
out.write("<html>\r\n");
out.write("<head>\r\n");
out.write("<meta http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\">\r\n");
out.write("<title>foot</title>\r\n");
out.write("<link href=\"index.images/style.css\" type=text/css rel=stylesheet>\r\n");
out.write("</head>\r\n");
out.write("\r\n");
out.write("<body>\r\n");
out.write("<DIV align=center>\r\n");
out.write("<TABLE cellSpacing=0 cellPadding=1 width=780 align=center bgColor=#000000\r\n");
out.write("border=0>\r\n");
out.write(" <TBODY>\r\n");
out.write(" <TR bgColor=#ffffff>\r\n");
out.write(" <TD align=center background=index.images/title_left.gif><FONT\r\n");
out.write(" color=#ff3000><B>..::友情站点::..</B></FONT> </TD></TR>\r\n");
out.write(" <TR bgColor=#ffffff>\r\n");
out.write(" <TD align=center> <A href=\"null.htm\" target=_blank><IMG\r\n");
out.write(" height=53\r\n");
out.write(" alt=\"名称：上海书城 地址：http://www.bookmall.com.cn/ 简介：购书中心\"\r\n");
out.write(" hspace=1 src=\"index.images/logogif.gif\" width=148 vspace=1\r\n");
out.write(" border=0></A> <A href=\"null.htm\" target=_blank><IMG height=53\r\n");
out.write(" alt=\"名称：雅虎 地址：http://cn.yahoo.com 简介：搜索引擎\" hspace=1\r\n");
out.write(" src=\"index.images/cn_sm4.gif\" width=144 vspace=1 border=0></A> <A\r\n");
out.write(" href=\"null.htm\" target=_blank><IMG height=53\r\n");
out.write(" alt=\"名称：丽水市新华书店 地址：http://www.lsxhsd.com 简介：网上书店\"\r\n");
out.write(" hspace=1 src=\"index.images/logo_ls.jpg\" width=164 vspace=1\r\n");
out.write(" border=0></A> <A href=\"null.htm\" target=_blank><IMG\r\n");
out.write(" height=53 alt=\"名称：博库书城 地址：http://www.bookuu.com 简介：网上书店\"\r\n");
out.write(" hspace=1 src=\"index.images/logo_002.gif\" width=162 vspace=1\r\n");
out.write(" border=0></A> </TD>\r\n");
out.write(" </TR>\r\n");
out.write(" <TR bgColor=#ffffff>\r\n");
out.write(" <TD align=center>| <A\r\n");
out.write(" title=\"名称：中国图书商报 地址：http://www.cbbr.com.cn/ 简介：全国性书业报刊\"\r\n");
out.write(" href=\"http://www.cbbr.com.cn/\" target=_blank>中国图书商报</A> | <A\r\n");
out.write(" title=\"名称：四川新华书店 地址：http://www.xinhuabookstore.com/ 简介：网上购书\"\r\n");
out.write(" href=\"http://www.xinhuabookstore.com/\" target=_blank>四川新华书店</A> | <A\r\n");
out.write(" title=\"名称：博览群书 地址：http://www.gmw.com.cn/gmw/blqs 简介：|文化思考 |学术之窗 |书与人 |新书点评 |读者茶座 \"\r\n");
out.write(" href=\"http://www.gmw.com.cn/gmw/blqs\" target=_blank>博览群书</A> | <A\r\n");
out.write(" title=\"名称：中华读书报 地址：http://www.gmdaily.com.cn/gmw/ds 简介：|家园 |要闻 |每周了望 |电脑书城 |国际文化 |电脑时代 |读者看法 |评论 |专版 |教育双周刊 |学术双周刊 \"\r\n");
out.write(" href=\"http://www.gmdaily.com.cn/gmw/ds\" target=_blank>中华读书报</A> | <A\r\n");
out.write(" title=\"名称：浙江图书馆 地址：http://www.zjlib.net.cn/default.asp 简介：付费网上阅读\"\r\n");
out.write(" href=\"http://www.zjlib.net.cn/default.asp\" target=_blank>浙江图书馆</A> | <A\r\n");
out.write(" title=\"名称：超星数字图书馆 地址：http://www.ssreader.com/ 简介：付费网上阅读\"\r\n");
out.write(" href=\"http://www.ssreader.com/\" target=_blank>超星数字图书馆</A> | <A\r\n");
out.write(" title=\"名称：郑州教育网 地址：http://www.zzedu.org 简介：介绍郑州教育信息\"\r\n");
out.write(" href=\"http://www.zjscedu.org/\" target=_blank>郑州教育网</A> | <A\r\n");
out.write(" title=\"名称：中国设计教学网 地址：http://www.5a609.com/ 简介：设计教学\"\r\n");
out.write(" href=\"http://www.5a609.com/\" target=_blank>中国设计教学网</A> | </TD>\r\n");
out.write(" </TR></TBODY></TABLE>\r\n");
out.write("<HR width=780 color=#077bbf SIZE=1>\r\n");
out.write("\r\n");
out.write("<TABLE cellSpacing=2 cellPadding=0 width=780 align=center border=0>\r\n");
out.write(" <TBODY>\r\n");
out.write(" <TR>\r\n");
out.write(" <TD\r\n");
out.write(" align=center>KSNB网上书店 0371-65015922 QQ:115465086<BR>\r\n");
out.write(" 技术支持QQ:35083766 电子信箱：<A href=\"mailto:txlng@163.com\"><FONT\r\n");
out.write(" face=\"Arial, Helvetica, sans-serif\"\r\n");
out.write(" color=#3333ff>txlng@163.com</FONT></A> <BR>\r\n");
out.write(" <a href=\"http://www.ksnb.com/\">KSNB网上书店</a> 版权所有©2005-2008<br>\r\n");
out.write(" <img alt=\"\" src=\"index.images/biaoshi.gif\" />\r\n");
out.write(" <SCRIPT language=JavaScript type=\"\">\r\n");
out.write("document.write(\"<a href='null.htm'>\");\r\n");
out.write("document.write(\"<img src='count/count.asp?Referer=www.scxhsd.net&Width=\"+escape(screen.width)+\"&Height=\"+escape(screen.height)+\"' border=0 width=0 height=0>\");\r\n");
out.write("document.write(\"</a>\");\r\n");
out.write("</SCRIPT>\r\n");
out.write("</TD></TR></TBODY></TABLE></DIV>\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
out.write("\r\n");
out.write("</center>\r\n");
out.write("</body>\r\n");
out.write("</html>\r\n");
} catch (Throwable t) {
if (!(t instanceof SkipPageException)){
out = _jspx_out;
if (out != null && out.getBufferSize() != 0)
out.clearBuffer();
if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
}
} finally {
if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -