📄 search_ware_result.jsp
字号:
<%@ page contentType="text/html; charset=UTF-8" language="java" %>
<%@ page import="java.sql.*"%>
<%@ page import="java.util.*"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<link rel=stylesheet type=text/css href="./lib/ware.css">
<title>欢迎光临网上商城</title>
<jsp:useBean scope="page" id="Ware" class="com.wssd.Ware" />
<jsp:useBean scope="page" id="Sort" class="com.wssd.Sort" />
</head>
<%
request.setCharacterEncoding("UTF-8");
//获取用户提那些的搜索信息
String sWareName = request.getParameter("WareName").trim();
String sCompany = request.getParameter("Company").trim();
String sAddr = request.getParameter("Addr").trim();
String sSortID = request.getParameter("SortID").trim();
if(sWareName == null)
{
sWareName = "";
}
if(sCompany == null)
{
sCompany = "";
}
if(sAddr == null)
{
sAddr = "";
}
if(sSortID == null)
{
sSortID = "0";
}
long lSortID = Long.parseLong(sSortID);
//获取搜索结果
Ware.setWareName(sWareName);
Ware.setCompany(sCompany);
Ware.setAddr(sAddr);
Ware.setSortID(lSortID);
ResultSet rs = Ware.search_wares();
%>
<body bgcolor="#F4FFFE">
<div align="center">
<table width="95%" border="0" cellpadding="0" cellspacing="1">
<tr bgcolor="#0066FF">
<td width="15%" height="20" align="center"><font color="#FFFFFF">商品类别</font></td>
<td width="30%" height="20" align="center"><font color="#FFFFFF">商品名称</font></td>
<td width="15%" height="20" align="center"><font color="#FFFFFF">产地</font></td>
<td width="25%" height="20" align="center"><font color="#FFFFFF">生产厂家</font></td>
<td width="20%" height="20" align="center"><font color="#FFFFFF">添加到购物车</font></td>
</tr>
<%
int i=0;
//循环显示所有搜索结果
while(rs.next())
{
i++;
long lWareID = rs.getLong("WareID");
sWareName = rs.getString("WareName");
sAddr = rs.getString("Addr");
sCompany = rs.getString("Company");
lSortID = rs.getLong("SortID");
Sort.setSortID(lSortID);
Sort.init();
%>
<tr>
<td width="15%" height="20" align="left"> <%=Sort.getSortName()%></td>
<td width="30%" height="20" align="left"> <a href="../normal/ware_detail.jsp?WareID=<%=lWareID%>" target="_self"><font color="#0000FF"><%=sWareName%></font></a></td>
<td width="15%" height="20" align="left"> <%=sCompany%></td>
<td width="25%" height="20" align="left"> <%=sAddr%></td>
<td width="20%" height="20" align="center"><a href="add_Goodsform.jsp?WareID=<%=lWareID%>" target="_self"><font color="#0000FF">添加</font></a></td>
</tr>
<%
}
%>
</table>
<%
if(i == 0)
{
out.println("<p><font color=#5EFD05>没有搜索到符合要求的商品</font></p>");
}
%>
<p><font color="#0000FF"><input type="button" name="btn" value="继续搜索" onClick="javascript:window.history.go(-1)"></font></p>
<%rs.close();%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -