JSP购物网站连数据库问题 我弄了1天了 帮帮我 在线等！！！

Question

下面第一串*号内的代码有问题 编译时提示org.apache.jasper.JasperException: An exception occurred processing JSP page /left.jsp at line 80
但是第二串*号内的代码格式跟第一个是一样的 为什么没事啊 帮帮我啊 <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" %>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:db_shop";
String user="sa";
String password="123456";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs_bbs=stmt.executeQuery("select top 5 * from tb_bbs order by INTime desc");ResultSet rs_sort=stmt.executeQuery("select GoodsID,GoodsName, sum(number) as sumNum from V_order_detail group by GoodsName,GoodsID order by sumNum desc");
%>
<script src="JS/check.jsp"></script>
<link href="CSS/style.css" rel="stylesheet" type="text/css"><table width="100%"  border="0" cellpadding="0" cellspacing="0">
      <tr>
        <td height="83" align="center"><img src="images/shop_11.gif" width="182" height="83"></td>
      </tr>
      <tr>
        <td height="98" align="center" background="images/shop_17.gif">   <form name="form1" method="post" action="Login_U.jsp">
  <table width="100%"  border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td width="10%">&nbsp;</td>
              <td width="90%" valign="top" background="Images/index_09.gif">
  <%String username=(String)session.getAttribute("username");
  if (username==null || username==""){%>
  <table width="100%"  border="0" cellpadding="0" cellspacing="0">
                <tr>
                  <td width="94%" height="24" class="td">会员名
                    <input name="username" type="text" class="txt_grey" id="username" size="16"></td>
                  <td width="6%">&nbsp;</td>
                </tr>
                <tr>
                  <td height="24" class="td">密&nbsp;&nbsp;码
                    <input name="PWD" type="password" class="txt_grey" id="PWD" size="16" onKeydown="if(event.keyCode==13) form1.submit();"></td>
                  <td>&nbsp;</td>
                </tr>
                <tr>
                  <td height="31">
                    <input name="Button" type="button" class="btn_grey" value="注册" onClick="window.location.href='register.jsp'">
                    &nbsp;
                    <input name="Submit2" type="button" class="btn_grey" value="登录" onClick="checkU(form1)">                    <input name="Submit3" type="reset" class="btn_grey" value="重置"></td>
                  <td>&nbsp;</td>
                </tr>
              </table>
  <%}else{%>
                <table width="100%"  border="0" cellpadding="0" cellspacing="0">
                  <tr>
                    <td width="94%" height="31" align="center" class="word_white">[<%=username%>]您好!<br>您现在可以购物了!</td>
                    <td width="6%">&nbsp;</td>
                  </tr>
                  <tr>
                    <td height="24" align="center"><input name="Submit22" type="button" class="btn_grey" value="修改资料" onClick="window.location.href='modifyMember.jsp';"></td>
                    <td>&nbsp;</td>
                  </tr>
                  <tr>
                    <td height="24" align="center">
      <input name="Submit32" type="button" class="btn_grey" value="退出登录" onClick="window.location.href='logout.jsp';"></td>
                    <td>&nbsp;</td>
                  </tr>
                </table>
<%}%>
</td>
            </tr>
          </table>
  </form></td>
      </tr>
    </table>
      <table width="100%" height="155"  border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td><img src="images/shop_22.gif" width="182" height="58"></td>
        </tr>
        <tr>
          <td height="97" align="center" valign="top" class="tableBorder_l"><table width="88%"  border="0" cellspacing="0" cellpadding="0">
/************************************************/          
 <%
int ID_bbs=0;
String title="";
while(rs_bbs.next()){
  ID_bbs=rs_bbs.getInt(1);
  title=rs_bbs.getString(2);
%>
/**************************************************/
<tr>
              <td height="24" class="tableBorder_T_dashed"><a href="bbs_detail.jsp?ID=<%=ID_bbs%>"><%=title%></a></td>
            </tr>
<% }%>
          </table></td>
        </tr>
      </table>
      <table width="100%" height="151"  border="0" cellpadding="0" cellspacing="0">
        <tr>
          <td height="40" background="images/shop_33.gif">&nbsp;</td>
        </tr>
        <tr>
          <td align="center" valign="top" class="tableBorder_lb"><table width="88%"  border="0" cellspacing="0" cellpadding="0">
/**************************************************/            
<%
int ID_sort=0;
String goodsname="";
while(rs_sort.next()){
  ID_sort=rs_sort.getInt(1);
  goodsname=rs_sort.getString(2);
%>
/*************************************************/
<tr>
              <td height="20" class="tableBorder_B_dashed"><font size="2"><a href="goods_detail.jsp?ID=<%=ID_sort%>"><%=goodsname%></a></font></td>
            </tr>
<%}%>
          </table>
            <table width="100%"  border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td>&nbsp;</td>
              </tr>
            </table></td>
        </tr>
      </table>

Answer 1

呵呵 终于搞定了 把它们分开了 用jsp:include再整合到一起 是不是stmt语句在每个页面都只能有1个啊

Answer 2

应该说每个java文件里只能有一个,不然就重定义了

Answer 3

left.jsp的页面 <%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:db_shop";
String user="sa";
String password="123456";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs_bbs=stmt.executeQuery("select top 5 * from tb_bbs order by INTime desc");
%>
<script src="JS/check.jsp"></script>
<link href="CSS/style.css" rel="stylesheet" type="text/css">
<table width="100%"  border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="83" align="center"><img src="images/shop_11.gif" width="182" height="83"></td>
</tr>
<tr>
<td height="98" align="center" background="images/shop_17.gif">
<form name="form1" method="post" action="Login_U.jsp">
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="10%">&nbsp;</td>
<td width="90%" valign="top" background="images/index_09.gif">
<%
String username=(String)session.getAttribute("username");
if (username==null || username=="")
{%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="94%" height="24" class="td">会员名:
<input name="username" type="text" class="txt_grey" id="username" size="16">
</td>
<td width="6%">&nbsp;</td>
</tr>
<tr>
<td height="24" class="td">密&nbsp;&nbsp;码:
<input name="PWD" type="password" class="txt_grey" id="PWD" size="16" onKeyDown="if(event.keycode==13)form1.submit();">
</td>
<td width="6%">&nbsp;</td>
</tr>
<td height="30">
<input name="Button" type="button" class="btn_grey" value="注册" onClick="window.location.href='register.jsp'">&nbsp;
<input name="Submit2" type="button" class="btn_grey" value="登录" onClick="checkU(form1)">&nbsp;
<input name="Submit3" type="reset" class="btn_grey" value="重置">
</td>
</table>
<%}
else{%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="94%" height="30" align="center" class="word_white">[<%=username%>您好!<br>您现在可以购物了!</td>
<td width="6%">&nbsp;</td>
</tr>
<tr>
<td height="24" align="center">
<input name="Submit22" type="button" class="btn_grey" value="修改资料" onClick="window.location.href='modifyMember.jsp';">
</td>
<td>&nbsp;</td>
</tr>
<tr>
<td height="24" align="center">
<input name="Submit32" type="button" class="btn_grey" value="退出登录" onClick="window.location.href='logout.jsp';">
</td>
<td>&nbsp;</td>
</tr>
</table>
<%}%>
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<table width="100%" height="155" border="0" cellpadding="0" cellspacing="0">
<tr>
<td><img src="images/shop_22.gif" width="182" height="58"></td>
</tr>
<tr>
<td height="95" align="center" valign="top" class="tableBorder_l">
<table width="88%" border="0" cellpadding="0" cellspacing="0">
<%
int ID_bbs=0;
String title="";
while(rs_bbs.next())
{
ID_bbs=rs_bbs.getInt(1);
title=rs_bbs.getString(2);
%>
<tr>
<td height="24" class="tableBorder_T_dashed"><a href="bbs_detail.jsp?ID=<%=ID_bbs%>"><%=title%></a></td>
</tr>
<%}%>
</table>
</td>
</tr>
</table>
<table>
<jsp:include page="left1.jsp"></jsp:include>
</table>
left1.jsp的页面
<%@ page contentType="text/html;charset=gb2312" import="java.sql.*"%>
<%
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:db_shop";
String user="sa";
String password="123456";
Connection conn=DriverManager.getConnection(url,user,password);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs_sort=stmt.executeQuery("select GoodsID,GoodsName, sum(number) as sumNum from V_order_detail group by        GoodsName,GoodsID order by sumNum desc");
%>
<table width="100%" height="151"  border="0" cellpadding="0" cellspacing="0">
<tr>
<td height="40" background="images/shop_33.gif"></td>
</tr>
<tr>
<td align="center" valign="top" class="tableBorder_lb">
<table width="88%" border="0" cellpadding="0" cellspacing="0">
<%
int ID_sort=0;
String goodsname="";
while(rs_sort.next())
{
ID_sort=rs_sort.getInt(1);
goodsname=rs_sort.getString(2);
%>
<tr>
<td height="20" class="tableBorder_B_dashed"><a href="goods_detail.jsp?ID=<%=ID_sort%>"><%=goodsname%></td>
</tr>
<%}%>
</table>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td>&nbsp;</td>
</tr>
</table>
</td>
</tr>
</table>不这样弄又该怎么在一个页面里多次查询