?? first.jsp
字號(hào):
<%@ 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>網(wǎng)上商品交易平臺(tái)</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">價(jià)格</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">經(jīng)營(yíng)項(xiàng)目</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>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -