booklist.jsp

来自「基于jsp的电子商务网站」· JSP 代码 · 共 310 行

JSP
310 行
字号 
<%@ page contentType="text/html; charset=gb2312" %>
<%@ page session="true" %>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="classlist" scope="page" class="leecong.javabean.BookClassList" />
<jsp:useBean id="booklist" scope="page" class="leecong.javabean.BookList"/>
<jsp:useBean id="togbk" scope="page" class="leecong.javabean.ToEncode"/>
<%!
String username="";
String truename="";
Enumeration listname=null;
Hashtable list=null;
int classid=0;
int dipage=0;
String pages=null;
int countRecord=0;//记录条数
int countPageRecord=0;//每页记录条数
int countPage=0;//总页数
ResultSet rs=null;
%>
<%
username=(String)session.getAttribute("username");
if (username!=null)
{
	session.setAttribute("username",username);
}
truename=togbk.ToGBK(request.getParameter("truename"));
if(truename==null)
{
	truename="";
}
%>
<%
if(!classlist.DBConn())
{
out.print("<script language='javascript'>alert('数据库连接错误!');</script>");
}
%>
<%
//当前页码数默认为1
pages=request.getParameter("dipage");
if(pages==null)
{
  pages="1";
}
try
{
  dipage=Integer.parseInt(pages);
}
catch(Exception e)
{
  dipage=1; 
}
%>
<%
if(!booklist.DBConn())
{
out.print("<script language='javascript'>alert('数据库连接错误!');</script>");
}
%>
<%
try{
if(request.getParameter("classid")!=null)
{
	classid=Integer.parseInt(request.getParameter("classid"));
	if(classid==0)
	{
		rs=booklist.getBookList();
	}
	else
	{
		rs=booklist.getBookList(classid);
	}
}
else
{
	rs=booklist.getBookList();
}
countPageRecord=8;//每页8条记录
//得到记录的条数

	rs.last();
	countRecord=rs.getRow();
	//得到总页数
	if(countRecord/countPageRecord==0){
		countPage=countRecord/countPageRecord;
	}
	else{
	    countPage=countRecord/countPageRecord+1;
	}
	//把记录指针移至当前页第一条记录之前
	if((dipage-1)*countPageRecord==0){
	    rs.beforeFirst();
	}
	else{
	    rs.absolute((dipage-1)*countPageRecord);
	}
}catch(Exception ex){System.out.println("error leecong");}
%>
<html>
<head>
<title>LEE电子商务　选购商品</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script language="javascript">
function checkform() {
	if (document.form1.keyword.value==""){
		alert("关键字不能为空！");
		form1.keyword.focus();
		return false;
	}
	return true;
  }
  
function openScript(url,name, width, height){
	window.open(url,name,'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}

var msg="    请使用IE5.5以上版本，800*600分辨率浏览 "; 
var seq = 0; 
function Scroll(){ 
 window.status = msg.substring(msg.length,seq); seq++; 
 if (seq >= msg.length )
 { seq = 0 };
 window.setTimeout("Scroll();", 300 );
}   
</script>
<link rel="stylesheet" href="books.css" type="text/css">
</head>

<body text="#000000" onLoad="Scroll();">
<div align="center">
  <table width="750" border="0" cellspacing="1" cellpadding="1">
    <tr> 
      <td width="120" align="center"><img src="images/Img20625.jpg" width="50" height="50"><br>
        <font color="#0066CC">LEE电子商务</font></td>
      <td align="center"><img src="images/baners2.gif" width="592" height="83"></td>
      <td align="center" width="80">
      </td>
    </tr>
  </table>

  <table width="750" border="0" cellspacing="1" cellpadding="1">
    <tr> 
      <td width="125" bgcolor="#99CCCC">
      <b>欢迎</b>：&nbsp;<font color="#990000"><%=truename%></font>&nbsp;<b>光临！</b>
      </td>
      <td width="100" bgcolor="#CCFFCC"><div align="center"><a href="index.jsp?truename=<%=truename%>">首页</a></div></td>
      <td width="100" bgcolor="#CCFFCC"><div align="center"><a href="booklist.jsp?truename=<%=truename%>&classid=0">在线购物</a></div></td>
      <td width="100" bgcolor="#CCFFCC"><div align="center"><a href="shoperlist.jsp?truename=<%=truename%>">我的购物车</a></div></td>
      <td width="100" bgcolor="#CCFFCC"><div align="center"><a href="userinfo.jsp">用户信息</a></div></td>
      <td width="100" bgcolor="#CCFFCC"><div align="center"><a href="login.jsp">退出登录</a></div></td>
	  <td width="125" bgcolor="#99CCCC">&nbsp;</td>
    </tr>
  </table>
  <table width="750" border="0" cellspacing="1" cellpadding="1">
    <tr valign="top"> 
      <td width="186"> 
        <table width="100%" border="0" cellspacing="1" cellpadding="1">
          <tr> 
            <td width="20">&nbsp;</td>
            <td>本店商品分类：</td>
          </tr>
          <% if(classlist.classList()){
          		list=classlist.getClassList();
				listname=list.keys();
				while(listname.hasMoreElements()){
					int ClassId=((Integer)listname.nextElement()).intValue(); 
					String ClassName=(String)(list.get(new Integer(ClassId)));
           %>
          <tr> 
            <td width="20">&nbsp;</td>
            <td><a href="booklist.jsp?classid=<%=ClassId%>&truename=<%=truename%>"><%=ClassName%></a></td>
          </tr>
          <%		
		  	}	
		  }
		   %>
          <tr> 
            <td width="20">&nbsp;</td>
            <td>&nbsp;</td>
          </tr>
        </table>
		<table width="100%" border="0" cellspacing="1" cellpadding="1">
  <form name="form1" method="post" action="selectbooks.jsp" onSubmit="return checkform();">
          <tr> 
            <td align=center><b>商品查询：</b></td>
          </tr>
		  <tr> 
            <td>
	关键字：<input type="text" name="keyword" size="12" maxlength="40">
	<input type="hidden" name="truename" value="<%=truename%>">	</td>
          </tr>
          <tr>
		  <td>类&nbsp;&nbsp;别：<select name="classid">
				<option value="0">所有类别</option>			
		  <%
			//if(classlist.classList()){
          		//list=classlist.getClassList();
				listname=list.keys();
				
				while(listname.hasMoreElements()){
					int ClassId=((Integer)listname.nextElement()).intValue(); 
					String ClassName=(String)(list.get(new Integer(ClassId)));
		  %>		    
            <option value="<%=ClassId%>"><%=ClassName%></option>
          <%}%></select>		    </td>
          </tr>
          <tr> 
            <td>&nbsp;&nbsp;<input type="reset" name="Reset1" value="重置">&nbsp;&nbsp;
            <input type="submit" name="submit1" value="查询" ></td>
          </tr>		  
		  </form>
        </table>
        <p><img src="images/01246.jpg" width="146" height="196"></p>
        </td>
      <td align="center"> 
        <p><br>
          <b><font color="#0000FF">电子商务商品
          <%
          if(request.getParameter("classid")!=null){
          	out.print((String)(list.get(new Integer(classid))));
          }%> 列表</font></b></p>
		
        <table width="100%" border="1" cellspacing="1" cellpadding="1" bordercolor="#CC9966">
          <tr align="center"> 
            <td>图书名称</td>
            <td>作者</td>
            <td>图书类别</td>
            <td>出版社</td>
            <td>单价</td>
            <td width=110>选择</td>
          </tr>
<% 
try{
int i=0;
while(rs.next())
{
%>
    <tr>
    <td><%=rs.getString(2)%></td>
    <td align="center"><%=rs.getString(4)%></td>
    <td align="center"><%=rs.getString(12)%></td>
    <td><%=rs.getString(5)%></td>
    <td align="center"><%=rs.getString(8)%>元</td>
    <td align="center">
    <a href="shoperlist.jsp?bookid=<%=rs.getString(1)%>&truename=<%=truename%>">购买</a>&nbsp;
	<a href="javascript:openScript('showbook.jsp?bookid=<%=rs.getString(1)%>','图书信息',550,550)" >详细资料</a>	</td>
    </tr>
<%
	i++;
	if(i>=countPageRecord){
		break; //当前页显示完，则退出循环
	}
}
}catch(Exception ex){ex.printStackTrace();}
%>
        </table>
   <table width="90%" border="0" cellspacing="1" cellpadding="1">
          <tr>
            <td align="right">
<%
try{
if(dipage==1)//当前是首页
	out.print("首页&nbsp;上一页&nbsp;&nbsp;");
else//当前不是首页
{
  out.print("<a href=booklist.jsp?dipage=1&truename="+truename+"&classid="+classid+">首页 </a>&nbsp; ");
  out.print("<a href=booklist.jsp?dipage="+(dipage-1)+"&truename="+truename+"&classid="+classid+">上一页</a>&nbsp;&nbsp;");
}
if(dipage==countPage || (dipage-1)==countPage)//当前是末页
  out.print("下一页&nbsp;末页&nbsp;&nbsp;");
else//当前不是末页
{
  out.print("<a href=booklist.jsp?dipage="+(dipage+1)+"&truename="+truename+"&classid="+classid+">下一页 </a>&nbsp;");
  out.print("<a href=booklist.jsp?dipage="+countPage+"&truename="+truename+"&classid="+classid+">末页 </a>&nbsp;");
}     
}catch(Exception e2){e2.printStackTrace();}
%>
<br>
<%
out.print("共"+countRecord+"条记录,共"+countPage+"页，当前第"+dipage+"页，每页"+countPageRecord+"条记录");
%>            </td>
          </tr>
        </table>
   <div align="left">
     <p>&nbsp;</p>
     <p><br>
       <br>
     </p>
     <p>&nbsp;</p>
     <p>&nbsp;</p>
     <table width="70%" border="0" cellspacing="2" cellpadding="2">
    <tr>
      <td align="center"><div align="center">开发:LeeCong<br>
        CopyRight@2006 <br>
        Email:<a href="mailto:leecong@eyou.com">leecong@eyou.com</a></div></td>
    </tr>
  </table>
     </div>      </td>
    </tr>
  </table>
  
</div>
<%
booklist.close();
classlist.close();
%>
</body>
</html>

booklist.jsp - 源码说明

本页面展示了「基于jsp的电子商务网站」中的 booklist.jsp 源码文件，采用 JSP 编程语言编写，共 310 行代码。您可以在线阅读完整代码内容，也可以返回资源详情页下载完整源码包进行本地学习和开发。

虫虫下载站收录了大量与jsp相关的技术资源，包括源代码、技术文档、电路图等，是电子工程师和嵌入式开发者的专业学习平台。

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?