📄 first.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" %>
<%@ page import="java.sql.*,com.netshop.*" %>
<jsp:useBean scope="page" id="goods" class="com.netshop.goods" />
<jsp:useBean scope="page" id="user" class="com.netshop.user" />
<jsp:useBean scope="page" id="executeWay" class="com.netshop.executeWay" />
<html>
<head>
<title>网上商品交易平台</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body>
<table width="100%">
<tr>
<td width="50%" align="center" valign="top">
<p align="center"><font size="5">最新商品信息</font></p>
<table width="98%" 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>
</tr>
<%
ResultSet rs = goods.showGoods();
int i = 0;
while(rs.next() && i<10)
{
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>
</tr>
<%
i++;
}
if(i == 10)
{
%>
<tr>
<td colspan=3 align=right><a href=showGoods.jsp target=_self>更多</></td>
</tr>
<%}%>
</table>
</td>
<td width="50%" valign="top">
<p align="center"><font size="5">最新店铺信息</font></p>
<table width="98%">
<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>
</tr>
<%
rs = user.showAllMerchants("1");
i=0;
while(rs.next() && i<10)
{
String strSql1 = "select name from goodsField where ID = '"+rs.getLong("mainFields")+"'";
ResultSet rs1 = executeWay.exeSqlQuery(strSql1);
rs1.first();
%>
<tr>
<td> <a href=shopShow.jsp?ID=<%=rs.getLong("ID")%> target=_self><%=rs.getString("shopName")%></a></td>
<td> <%=rs.getString("shopper")%></td>
<td> <%=rs1.getString("name")%></td>
</tr>
<%
i++;
}
if(i==10)
{
%> <tr>
<td colspan=3 align=right>
<br>
<a href=showMerchant.jsp target=_self>更多</a>
</td>
</tr>
<%}%>
</table>
</td>
</td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -