请教各位前辈，这段代码该怎么改
<%@ page contentType="text/html;charset=gb2312"%>
<%@include file="../../pub/userSession.jsp"%>
<SCRIPT src="file:///D|/Documents and Settings/Administrator/pur_plan/jQuery Autocomplete.files/jquery-1[1].2.1.pack.js" type=text/javascript></SCRIPT>
<LINK media=screen href="file:///D|/Documents and Settings/Administrator/pur_plan/jQuery Autocomplete.files/jquery.autocomplete.css" type=text/css rel=stylesheet>
<SCRIPT src="file:///D|/Documents and Settings/Administrator/pur_plan/jQuery Autocomplete.files/jquery.autocomplete.js" type=text/javascript></SCRIPT>
<jsp:useBean id="Page" class="front.chatroom.boboPage" scope="page"/>
<%
String strCurPage=request.getParameter("page");
if(strCurPage==null)strCurPage="1";
String query_vendor="",syear="",smonth="",stime="";
String draw_no="",pro_name="",use_dept="",start_date="",vendor="",require_date="",fact_date="",check_flag="";
String vendor="",vendor_name="";
String yhb_zh=UserSession.user_zh;
String strWhere="ppap";
draw_no = request.getParameter("draw_no");
pro_name = request.getParameter("pro_name");
use_dept = request.getParameter("use_dept");
start_date = request.getParameter("start_date");
vendor = request.getParameter("vendor");
require_date = request.getParameter("require_date");
fact_date = request.getParameter("fact_date");
check_flag = request.getParameter("flag");
syear = request.getParameter("syear");
smonth = request.getParameter("smonth");
int year=2006,month=1;
int yhb_zh_type=UserSession.user_zh_type;
Page.setOut(out);
Page.initialize(Integer.parseInt(strCurPage), 15,strWhere,request.getParameter("strThisPage"),10);
Page.setStrClass("black");
Page.setStrImg("../image/left_arrow.gif","../image/right_arrow.gif");
String sql_query="select * from "+strWhere+" ";
rs=dbquery.executeQuery (sql_query);
int i=0;
for(;i < Page.getFirstRec();i ++) rs.next();
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%@include file="../../pub/css.jsp"%>
<style type="text/css">
<!--
.style1 {
color: #FFFFFF;
font-weight: bold;
}
-->
</style>
</head>
<body leftmargin="0" topmargin="0">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="center">
<table width="99%" border="0" cellpadding="0" cellspacing="0" background="images/pointline.gif">
<tr>
<td height="1"></td>
</tr>
</table>
</td>
</tr>
<tr>
<td>
<table width="99%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#C1C7D7">
<tr bgcolor="#F7FAFD">
<td>
<table width="100%" border="0" align="center" >
<tr>
<%if(yhb_zh_type==1) {%>
<td width="60" height="100%" align="right">供应商：</td>
<td width="205" align="left" >
<div style="position:relative;">
<span style="margin-left:200px;width:18px;overflow:hidden;">
<SELECT style="width:218px;margin-left:-200px" onChange="this.parentNode.nextSibling.value=this.value">
<%
ResultSet rsbm1=dbquery.executeQuery("select user_zh,user_name from zd_user where user_zh_type='3'");
%>
<option selected value="" > 供应商选择 </option>
<%
while (rsbm1.next())
{%>
<option value="<%=rsbm1.getString("user_zh")%>"><%=rsbm1.getString("user_name")%> </option>
<%
}
rsbm1.close();
%>
</SELECT>
</span><input name="query_vendor" style="width:200px;position:absolute;left:0px;">
</div> </td>
<%}%>
<td width="47" height="100%" align="right">月份：</td>
<td width="142" align="left" >
<select name="syear">
<%
year=2006;
while(year<=2015)
{
%>
<option value="<%=year%>"><%=year%></option>
<%
year++;
}%>
</select>年
<select name="smonth">
<%
month=1;
while(month<=12)
{
%>
<option value="<%=month%>"><%=month%></option>
<%
month++;
}%>
</select>月
</td>
<td width="714" colspan="2" align="left"><input type="submit" name="Submit" value="查询"></td>
</tr>
</table>
</td>
</tr>
</table>
</form>
<form name="frm1">
<table width="1239" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#C1C7D7">
<tr bgcolor="#FF9900" height="20">
<td width="104" class="style1"><span class="STYLE6">序号</span></td>
<td width="124" class="style1"><span class="STYLE6">产品图号</span></td>
<td width="119" class="style1"><span class="STYLE6">产品名称</span></td>
<td width="117" class="style1"><span class="STYLE6">使用部门</span></td>
<td width="112" class="style1"><span class="STYLE6">供应商代码</span></td>
<td width="106" class="style1"><span class="STYLE6">要求提交时间</span></td>
<td width="105" class="style1"><span class="STYLE6">实际提交时间</span></td>
<td width="101" class="style1"><span class="STYLE6">验证状态</span></td>
<td width="197" class="style1"><span class="STYLE6">备注</span></td>
<td width="83" class="style1">操作</td>
</tr>
<%
i=0;
while (rs.next() && i < Page.getPageSize())
{ i++;
ResultSet rs_zh=dbquery.executeQuery("select * from zd_user where user_zh='"+vendor+"'");
draw_no=rs.getString("draw_no");
pro_name=rs.getString("pro_name");
use_dept=rs.getString("use_dept");
start_date=rs.getString("start_date");
vendor=rs.getString("vendor");
require_date=rs.getString("require_date");
fact_date=rs.getString("fact_date");
check_flag=rs.getString("check_flag");
%>
<tr>
<td><%=i%></td>
<td><%=rs.getString("draw_no")%></td>
<td><%=rs.getString("pro_name")%></td>
<td><%=rs.getString("use_dept")%></td>
<td><%=rs.getString("vendor")%></td>
<td><%=rs.getString("require_date")%></td>
<td><%=rs.getString("fact_date")%></td>
<td><%if(check_flag.equals("1")) out.print("已确认"); else out.print("未确认");%></td>
<td></td>
<td></td>
<%}%>
</tr>
<%}
rs.close();
dbquery.stmtcls();
%>
</table>
</form>
</td>
</tr>
</table>
</body>
</html>
<%dbquery.cls();%>
[解决办法]
不是说了An error occurred at line: 167 in the jsp file: /body/feedback/ppap.jsp吗
[解决办法]
要看错误怎么报的，报的你这个页面167行有问题，这是硬错误，赤裸裸的错，看都不看这么段大码就贴上来了！
[解决办法]
没有try-catch-finally
