right2.jsp
上传用户:helenhuo66
上传日期:2007-06-01
资源大小:865k
文件大小:7k
- <!-------------------------right begin------------------------------------->
- <table width="560" border="0" align="center" cellpadding="0" cellspacing="0" style="margin-bottom: 6">
- <!--DWLayoutTable-->
- <tr>
- <td width="560" height="328" valign="top" bgcolor="#FFFFFF">
- <table width="560" height="5" border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
- <!--DWLayoutTable-->
- <tr>
- <td> <p align="center">
- <a target="_blank" href="http://www.jspshop.cn/">
- <img src="img/banner.gif" width="575" height="118" border="0"></a></td>
- <td width="1"></td>
- </tr>
- <tr>
- <td width=478 height="2" style="border-bottom:#cccccc 1px solid" bgcolor="f7f7f7">
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td width="8%"> </td>
- <td height="25" valign="middle"> <b><%=Nsort_name%></b>型号列表 |
- <%
- sql="select * from Nsort where sort_id="+sort_id+" and Nsort_id<>"+nsort_id;
- rs=mdb.executeQuery(sql);
- if(rs.next())
- {
- %>
- <font color="#0000FF">相关小类</font>|--
- <%
- rs.previous();
- while(rs.next())
- {
- %>
- |<a href="nsort.jsp?sort_id=<%=sort_id%>&nsort_id=<%=rs.getInt("Nsort_id")%>"><%=rs.getString("Nsort_name")%></a>
- <%
- }
- }
- rs.close();
- %>
- </td>
- </tr>
- </table></td>
- <td></td>
- </tr>
- <tr>
- <td width="100%"> <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td valign="top"> <div align="center"> </div>
- <table width="99%" border="0"cellspacing="0" cellpadding="0" align="center">
- <tr>
- <td valign="top"> <table width="100%" border="0" cellspacing="0" cellpadding="0" >
- <%
- int PageSize =10; //设置每张网页显示两条记录
- int ShowPage = 1; //设置欲显示的页数
- int RowCount = 0; //ResultSet的记录数目
- int PageCount = 0; //ResultSet分页后的总页数
- int duoyu=0;
- sql="select * from hw where sort_id="+sort_id+" and Nsort_id="+nsort_id;
- rs=mdb.executeQuery(sql);
- if(rs.next())
- {
- //建立ResultSet(结果集)对象,并执行SQL语句
- rs.last(); //将指标移至最后一笔记录
- RowCount=rs.getRow();
- duoyu=RowCount % PageSize;
- if(duoyu==0)
- {
- PageCount=RowCount/PageSize;
- }
- else{
- PageCount=(RowCount-duoyu)/PageSize;
- PageCount++;
- }
- // PageCount=((RowCount % PageSize) == 0?(RowCount/PageSize) : (RowCount/PageSize)+1);
- //计算显示的页数
- String ToPage = request.getParameter("ToPage");
- if(ToPage==""){ToPage="1";}
- //判断是否可正确取得ToPage参数,
- //可取得则表示JSP网页应显示特定分页记录的语句
- if(ToPage!=""){
- ShowPage =Cint(ToPage); //取得指定显示的分页页数
- //下面的if语句将判断用户输入的页数是否正确
- if(ShowPage > PageCount)
- { //判断指定页数是否大于总页数, 是则设置显示最后一页
- ShowPage = PageCount;
- }
- else if(ShowPage <= 0)
- { //若指定页数小于0, 则设置显示第一页的记录
- ShowPage = 1;
- }
- }
- rs.absolute((ShowPage - 1) * PageSize + 1);
- //计算欲显示页的第一笔记录位置
- %>
- <!----------------------one showing unit------------------------------->
- <%
- //利用For循环配合PageSize属性输出一页中的记录
- int i=1,hw_id,daili,pifa,hw_cash,linshi;
- String hw_pic,hw_name,hw_content;
- rs.previous();
- while(rs.next()&i<= PageSize)
- {
- i++;
- hw_id=rs.getInt("hw_id");
- hw_pic=rs.getString("hw_pic");
- hw_name=rs.getString("hw_name");
- hw_content=rs.getString("hw_content");
- hw_cash=rs.getInt("hw_cash");
- daili=rs.getInt("daili");
- pifa=rs.getInt("pifa");
- %>
- <tr>
- <td valign="top"> <table width="100%" border="0" align="center"cellspacing="0">
- <tr>
- <td width="25%" rowspan="5" bgcolor="#FFFFFF" align="left"><a href="views.jsp?hw_id=<%=hw_id%>"><img border="0" src="<%=hw_pic%>" width="120" height="85"></a>
- <div align="right"></div>
- <div align="right"></div>
- <div align="right"></div></td>
- <td height="25" bgcolor="#FFFFFF" width="75%"> </td>
- </tr>
- <tr>
- <td height="28" bgcolor="#FFFFFF" width="75%">
- <a href="views.jsp?hw_id=<%=hw_id%>"><font color="#006699"><u><%=hw_name%></u></font></a></td>
- </tr>
- <tr>
- <td height="28" style="line-height:20px" bgcolor="#FFFFFF" width="75%"><%=hw_content%></td>
- </tr>
- <tr>
- <td height="28" bgcolor="#FFFFFF" width="75%">市场价格:<s><%=pifa%></s>元 本站会员价:<%=hw_cash%>元 VIP价:¥<%=daili%>元<br>
- <a href='javascript:openbag(<%=hw_id%>)'>定购<img src="img/order.gif" width="21" height="15" border="0" align="middle"></a></td>
- </tr>
- <tr>
- <td height="25" bgcolor="#FFFFFF" width="75%"> </td>
- </tr>
- </table>
- <table width="100%" border="0" cellspacing="0" cellpadding="0">
- <tr>
- <td height="1"></td>
- </tr>
- </table></td>
- </tr>
- <%
- //下面的if判断语句用于防止输出最后一页记录时,
- //将记录指标移至最后一笔记录之后
- //跳出for循环
- }
- %>
- <!-----------------------shonwing unit end----------------------------------------------->
- </table></td>
- </tr>
- </table></td>
- </tr>
- </table></td>
- <td></td>
- </tr>
- <tr>
- <td width="100%" height="20"> <div align="center"></div></td>
- <td></td>
- </tr>
- <tr>
- <td width=478 height="23"> <p align="right">第<%=ShowPage%>页/共<%=PageCount%>页
- <%linshi=ShowPage-1;if(linshi>0){%>
- <a href="nsort.jsp?sort_id=<%=sort_id%>&ToPage=<%=linshi%>&nsort_id=<%=nsort_id%>">上一页</a>
- <%
- }else
- {%>
- 上一页
- <%}%>
-
- <%
- linshi=ShowPage+1;
- if(linshi<=PageCount){%>
- <a href="nsort.jsp?sort_id=<%=sort_id%>&ToPage=<%=linshi%>&nsort_id=<%=nsort_id%>">下一页</a>
- <%
- }else
- {%>
- 下一页
- <%}%></font>
- </p></td>
- <td></td>
- </tr>
- </table></td>
- </tr>
- </table>
- <!-------------------------right end------------------------------------->
- <%
- }//找到相应的小类的产品
-
- %>