请问怎样输出总和？

Question

呵呵！没有写结果集哈ResultSet rs = sqlbean.executeQuery(sql);rs.next();
int s = rs.getInt(1);
...

Answer 1

<%String date1=sqlbean.toByteString(request.getParameter("date1"));
int totalRecord=0;
sqlbean.executeQuery("SELECT SUM(TransferIQuantity) AS cnt FROM TransferIMaster");
while(sqlbean.next())
{
totalRecord = sqlbean.getInt("cnt");
}
%>
看我这样写对么？为什么老出错呢
java.lang.NullPointerException
net.fineso.sqlcon.next(sqlcon.java:336)
org.apache.jsp.weishan.baobiao.zhuba1_jsp._jspService(zhuba1_jsp.java:178)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:324)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:292)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:236)

Answer 2

sqlbean是什么呢
ResultSet rs = executeQuery("SELECT SUM(TransferIQuantity) AS cnt FROM TransferIMaster");while(rs.next())
{
totalRecord = rs.getInt("cnt");
}