JSP购物网站连数据库问题 我弄了1天了 帮帮我 在线等！！！
下面第一串*号内的代码有问题 编译时提示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% "> </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% "> </td>
</tr>
<tr>
<td height= "24 " class= "td "> 密 码
<input name= "PWD " type= "password " class= "txt_grey " id= "PWD " size= "16 " onKeydown= "if(event.keyCode==13) form1.submit(); "> </td>
<td> </td>
</tr>
<tr>
<td height= "31 ">
<input name= "Button " type= "button " class= "btn_grey " value= "注册 " onClick= "window.location.href= 'register.jsp ' ">
<input name= "Submit2 " type= "button " class= "btn_grey " value= "登录 " onClick= "checkU(form1) "> <input name= "Submit3 " type= "reset " class= "btn_grey " value= "重置 "> </td>
<td> </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% "> </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> </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> </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 "> </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> </td>
</tr>
</table> </td>
</tr>
</table>
[解决办法]
先用工具整理一下代码，这样看的比较清晰一些
我的异常网推荐解决方案：An exception occurred processing JSP page,http://www.myexception.cn/j2se/33144.html
