出错文件原代码
<%@ 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>
<%@ 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>
{
String userName="root";
String userPassword="root";
private String driverName = "com.mysql.jdbc.Driver";
private String url = "jdbc:mysql://localhost/netshop?useUnicode=true&characterEncoding=gb2312"; Connection dbConn;
public OpenDB()
{ }
public Connection getConnection()
{
try
{
Class.forName(driverName);
dbConn=DriverManager.getConnection(url,userName,userPassword);
}
catch(Exception ex)
{
System.out.println(ex.toString());
dbConn = null;
}
return dbConn;
}}