📄 showgoods.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*,com.netshop.*" %>
<jsp:useBean scope="page" id="executeWay" class="com.netshop.executeWay" />
<%
request.setCharacterEncoding("gb2312");
int count=0;
int totalPageCount=0;
int perPageCount=5;
int currentPage=1;
String pageId = request.getParameter("page");
if(pageId!=null)
{
currentPage=Integer.parseInt(pageId);
}
String title = request.getParameter("title");
String price = request.getParameter("price");
String strGoodsField = request.getParameter("goodsField");
long goodsField = 0;
String strField = "";
if(strGoodsField != null && strGoodsField != "")
{
goodsField = Long.parseLong(strGoodsField);
}
else
{
strGoodsField="0";
}
if(goodsField > 0)
{
strField = " and goodsField ="+goodsField;
}
String strPrice = "";
int intPrice = 0;
if(price != null)
{
intPrice = Integer.parseInt(price);
}
switch(intPrice)
{
case 1: strPrice = " and price <100 ";
break;
case 2: strPrice = " and price <=500 and price > 100 ";
break;
case 3: strPrice = " and price <=2000 and price > 500 ";
break;
case 4: strPrice = " and price <=5000 and price > 2000 ";
break;
case 5: strPrice = " and price <=10000 and price > 5000 ";
break;
case 6: strPrice = " and price > 10000 ";
break;
}
if(title == null)
{
title = "";
}
title = title.trim();
String strSql = "select * from goods where title like '%"+title+"%'"+strPrice+" "+strField;
%>
<html>
<head>
<title>网上商品交易平台</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<div align=center>
<p align="center"><font size="5">最新商品信息</font></p>
<table width="90%" border=0>
<tr bgcolor="#F0F0F0">
<td align="center"><font size="4">类别</font></td>
<td align="center"><font size="4">商品名</font></td>
<td align="center"><font size="4">价格</font></td>
<td align="center"><font size="4">所属店铺</font></td>
<td align="center"><font size="4">发布时间</font></td>
</tr>
<%
ResultSet rs = executeWay.exeSqlQuery(strSql);
rs.last();//移到末尾
count = rs.getRow();//取得总查询数
totalPageCount = (count + perPageCount -1)/perPageCount;
if(currentPage > totalPageCount || currentPage<=0)
{
currentPage=1;
}
int currentIndex = (currentPage - 1) * perPageCount +1;
if(count>0)
{
rs.absolute(currentIndex);
String strSql1 = "select name from goodsField where ID ='"+rs.getLong("goodsField")+"'";
String strSql2 = "select * from users where ID ='"+rs.getLong("issuer")+"'";
ResultSet rs1 = executeWay.exeSqlQuery(strSql1);
ResultSet rs2 = executeWay.exeSqlQuery(strSql2);
rs1.first();
rs2.first();
%>
<tr>
<td> <%=rs1.getString("name")%></td>
<td> <a href=goodsShow.jsp?ID=<%=rs.getLong("ID")%> target=_blank ><%=rs.getString("title")%></a></td>
<td> <%=rs.getLong("price")%></td>
<td> <%=rs2.getString("shopName")%></td>
<td> <%=rs.getString("createDate")%></td></td>
</tr>
<%
int i=1;
while(rs.next())
{
strSql1 = "select name from goodsField where ID ='"+rs.getLong("goodsField")+"'";
strSql2 = "select * from users where ID ='"+rs.getLong("issuer")+"'";
rs1 = executeWay.exeSqlQuery(strSql1);
rs2 = executeWay.exeSqlQuery(strSql2);
rs1.first();
rs2.first();
%>
<tr>
<td> <%=rs1.getString("name")%></td>
<td> <a href=goodsShow.jsp?ID=<%=rs.getLong("ID")%> target=_blank ><%=rs.getString("title")%></a></td>
<td> <%=rs.getLong("price")%></td>
<td> <%=rs2.getString("shopName")%></td>
<td> <%=rs.getString("createDate")%></td></td>
</tr>
<%
i++;
if(i > perPageCount-1) break;
}
}
%>
</td>
</tr>
</table>
<br>
<table width="90%" border=0>
<TR height="20">
<TD width="25%" height="20" align="center" valign="top">
共<font color="#0000FF"><%= count %></font>条
第<font color="#0000FF"><%= currentPage %></font>页/共
<font color="#0000FF"><%= totalPageCount %></font>页
</TD>
<TD width="10%" height="20" align="center" valign="top">
<form name="form1" action="showGoods.jsp" method="post">
<input type="hidden" name="title" value="<%=title%>">
<input type="hidden" name="price" value="<%=intPrice%>">
<input type="hidden" name="goodsField" value="<%=strGoodsField%>">
<input type="hidden" name="page" value="1">
<input type="submit" name="sub1" value="首页">
</form>
</TD>
<TD width="10%" height="20" align="center" valign="top">
<form name="form2" action="showGoods.jsp" method="post">
<input type="hidden" name="title" value="<%=title%>">
<input type="hidden" name="price" value="<%=intPrice%>">
<input type="hidden" name="goodsField" value="<%=strGoodsField%>">
<input type="hidden" name="page" value="<%=currentPage-1%>">
<input type="submit" name="sub2" value="上一页">
</form>
</TD>
<TD width="10%" height="20" align="center" valign="top">
<form name="form3" action="showGoods.jsp" method="post">
<input type="hidden" name="title" value="<%=title%>">
<input type="hidden" name="price" value="<%=intPrice%>">
<input type="hidden" name="goodsField" value="<%=strGoodsField%>">
<input type="hidden" name="page" value="<%=currentPage+1%>">
<input type="submit" name="sub3" value="下一页" >
</form>
</TD >
<TD width="10%" height="20" align="center" valign="top">
<form name="form4" action="showGoods.jsp" method="post">
<input type="hidden" name="title" value="<%=title%>">
<input type="hidden" name="price" value="<%=intPrice%>">
<input type="hidden" name="goodsField" value="<%=strGoodsField%>">
<input type="hidden" name="page" value="<%=totalPageCount%>">
<input type="submit" name="sub4" value="尾页" >
</form>
</TD>
<TD width="20%" height="20" valign="top" align="center">
<form name="form5" action="showGoods.jsp" method="post">
<input type="hidden" name="title" value="<%=title%>">
<input type="hidden" name="price" value="<%=intPrice%>">
<input type="hidden" name="goodsField" value="<%=strGoodsField%>">
到第<input type="text" name="page" size="3">页
<input type="submit" name="sub5" value="GO">
</form>
</TD>
</TR>
</form>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -