散分了，向高手求助：关于javax.servlet.ServletException: 的问题！！

[石翮]

我写了一个页面核心部分是BEAN程序。该页面运行出现了错误，提示为：
javax.servlet.ServletException: mybbs.bbsboard.countSuperBoard()I
at org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:536)
at org.apache.jsp.boardmanager_jsp._jspService(boardmanager_jsp.java:150)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:137)
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
BEAN程序如下：
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
package bbs;
import mybbs.bbsadmin;
import mybbs.bbsboard;
import uuposystem.Text.ParamUtils;
import uuposystem.Text.DoText;
import uuposystem.Web.SessionCheck;
import uuposystem.Web.CopyRight;
import javax.servlet.*;
import javax.servlet.http.*;
import javax.servlet.jsp.*;
import java.sql.*;
public class boardmanager
{
private String B1 = null;
private String tempSTR;
private int tempInt=0;
private int tempInt2=0;
private int tempInt3=0;
private int method, boardid, boardhits, boardtopics, super_boardid;
ResultSet sqlRst; //子板块结果集
ResultSet strSQL; //父板块结果集
private String boardname, boardword,boardmaster, masterpwd, masteremail,board_name;
HttpServletRequest request;
HttpServletResponse response;
JspWriter out;
HttpSession session;
bbsboard bbs_board=new bbsboard();
public void boardmanager()
{

}
public void init(HttpServletRequest req,HttpServletResponse resp,JspWriter ou)
{
//初始化
request = req;
response = resp;
out =ou;
}

public void Load() throws Exception
{
//载入
SessionCheck.getSession(request);

if (!SessionCheck.isHaveSession()) {
out.println("<script>window.location='adminlog.jsp'</script>");
}
else {
String strUserName = SessionCheck.getUserName();
String strUserPassWD = SessionCheck.getUserPassWD();
tempInt=bbs_board.countSuperBoard();
tempInt2=bbs_board.countBoard();
tempSTR = null;
tempSTR = request.getParameter("method");
if (tempSTR == null) {
method = 0;
}
else {
method = ParamUtils.getInt(request,tempSTR,tempInt3);
}
//method=4 显示增加子版块表格
//method=5 显示修改删除论坛表格
//method=6 退出论坛管理
//method=1 增加论坛父版块
//method=2 修改论坛子版块
//method=3 删除论坛子版块
//method=7 增加论坛子版块
//method=8 显示增加父版块表格
//method=9 删除论坛父版块
/**
* 显示增加子版块表格
*/
if (method == 4) {
//显示增加子版块表格
out.println("<div style='width:250;height:235; position:absolute;left:600;top:55'>");
out.println("<table border='0' width='100%'>");
out.println("<tr>");
out.println("<td width='100%'>");
out.println("<td width='100%'>");
out.println("<p align='center' class='redBold'><b>子版面增加</b><p>");
out.println("</td></tr>");
out.println("<tr>");
out.println("<td width='100%'>");
out.println("<form method='post' action='boardmanager.jsp' onsubmit='return check_input(this)' name='frmAdd'>");
out.println("<p align='center' style='margin-top:0;margin-bottom:0' class='black'>版 名: <input type='text' class='textarea' name='boardname' size='20'></p>");
out.println("<p align='center' style='margin-top:0;margin-bottom:0' class='black'>版 主: <input type='text' class='textarea' name='boardmaster' size='20'></p>");
out.println("<p align='center' style='margin-top:0;margin-bottom:0' class='black'>密 码: <input type='text' class='textarea' name='masterpwd' size='20'></p>");
out.println("<p align='center' style='margin-top:0;margin-bottom:0' class='black'>邮 箱: <input type='text' class='textarea' name='masteremail' size='20'></p>");
out.println("<p align='left' style='margin-top:0;margin-bottom:0' class='black'>     版块说明:</p>");
out.println("<p align='center' style='margin-top:0;margin-bottom:0'>           <textarea rows='5' class='textarea' name='boardword' cols='19'></textarea></p><br>");
out.println("<p align='center' style='margin-top:0;margin-bottom:0'>            <input class='botton' type='submit' value='增加' name='B1'>   ");
out.println("<input class='botton' type='reset' value='重写' name='B2'>");
out.println(" <input type='hidden' name='method' value='7'>");
out.println(" </p></form></td></tr></table></div>");


} //end method=4显示增加子版块表格

/**
* 显示修改或删除子版块表格
*/
if (method == 5) {
//显示修改或删除子版块表格
tempSTR = request.getParameter("boardid");
boardid = ParamUtils.getInt(request,tempSTR,tempInt3);

boardname = "";
boardmaster = "";
masteremail = "";
masterpwd = "";
boardword = "";
if (bbs_board.getBoardInfo(boardid))
{
boardname = bbs_board.getBoardName();
boardmaster = bbs_board.getBoardMaster();
masteremail = bbs_board.getBoardMasteremail();
masterpwd = bbs_board.getBoardMasterpwd();
boardword = bbs_board.getBoardword();
} //end if(bbs_board.getBoardInfo(boardid))
out.println(
"<div style='width:300; heigth:242;position:absolute;left:600;top:55'>");
out.println(" <table border='0' width='89%'>");
out.println("<tr><td width='100%'>");
out.print("</td></tr></table></div>");


} //end if(method == 5)显示修改或删除子版块表格
out.println("<table border='1' width='100%' bordercolorlignt='#000000' bordercolordark='#ffffff' cellspacing='0' cellpadding='0'>");
strSQL = bbs_board.listSuperBoard();
strSQL.absolute(1);
int s=0;
while(!strSQL.isAfterLast()&&s<=tempInt);
{

board_name = strSQL.getString("board_name");
out.println("<tr>");
out.println(
"<td width='100%' height='25' align='center' bgcolor='#000080' class='bs'>");
out.println(board_name);
out.println("</td>");
out.println("</tr>");
sqlRst = bbs_board.listBoard(1, board_name);
sqlRst.absolute(1);
int i = 0;
while (!sqlRst.isAfterLast()&&i<=tempInt2) {

boardid = sqlRst.getInt("boardid");
boardname = sqlRst.getString("boardname");
boardword = sqlRst.getString("boardword");
boardmaster = sqlRst.getString("boardmaster");
masteremail = sqlRst.getString("masteremail");
out.println(" <tr>");
out.println("<td width='25%' align='center'>");
out.println(boardname);
out.println("</td>");
out.println("<td width='25%' align='center'>");
out.println(boardword);
out.println("</td>");
out.println("<td width='25%' align='center'>");
out.println(boardmaster);
out.println("</td>");
out.println("<td width='25%' align='center'>");
out.println(masteremail);
out.println("</td>");
out.println("</tr>");
sqlRst.next();
i++;

} //end while(sqlRst.next())
sqlRst.close();
strSQL.next();
s++;
} //end while(strSQL.next())

strSQL.close();


} //end else(!session_check.isHaveSession())

}//end Load()
}

请教一下高手该如何解决啊！！

[ainice]

这乱七八糟的什么东西啊
谁有那个工夫看啊
并且错误似乎在 mybbs.bbsboard.countSuperBoard()这个方法里
而不是这个类啊

[石翮]

怎么没有人理会我啊！！

[沙尘暴_0000]

rs = dbconn.executeQuery(m_DataParam,strSQL);
？？？

[石翮]

这是那个方法的的代码：

public int countSuperBoard()
{
//统计父版的数量
strSQL = "select count(*) as aa from super_board";
i = 0;
try
{
rs = dbconn.executeQuery(m_DataParam,strSQL);
if (rs.next())
i = rs.getInt("aa");
rs.close();
}
catch(SQLException SQLException)
{
System.err.println("aq.executeQuery:"+SQLException.getMessage());
System.err.println("countUser.STRSQL:"+strSQL);
}
return i;
}

[石翮]

怎么没有人理会我啊！！

[uupo]

while(!strSQL.isAfterLast()&&s<=tempInt);
后面怎么还带了个分号？去掉看看！！！！