日期:2014-05-18  浏览次数:20787 次

mysql中Select中SUM用法的问题,请赐教!
gzrzDhSl字段为int型;
sql   =   "select   sum(gzrzDhSl)   as   t1   from   gzrz   where   bmId   =   "+bmId+ "   ";
rs   =   stmt.executeQuery(sql);
if(rs.next())
{
      out.println(rs.getString(t1));
}
出现下列错误:
java.lang.NullPointerException
at   com.mysql.jdbc.Statement.executeQuery(Unknown   Source)
at   com.mysql.jdbc.jdbc2.Statement.executeQuery(Unknown   Source)
at   com.base.db.DBConn.execSQL(DBConn.java:118)
at   _yggl._mainlist__jsp._jspService(/yggl/mainlist.jsp:43)
at   com.caucho.jsp.JavaPage.service(JavaPage.java:75)
at   com.caucho.jsp.Page.subservice(Page.java:485)
at   com.caucho.server.http.FilterChainPage.doFilter(FilterChainPage.java:182)
at   com.caucho.server.http.Invocation.service(Invocation.java:312)
at   com.caucho.server.http.CacheInvocation.service(CacheInvocation.java:135)
at   com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:221)
at   com.caucho.server.http.HttpRequest.handleConnection(HttpRequest.java:163)
at   com.caucho.server.TcpConnection.run(TcpConnection.java:137)
at   java.lang.Thread.run(Thread.java:534)



------解决方案--------------------
和版本没得关系的
你的错误是java.lang.NullPointerException,空指针,你访问了一个空的变量.
out.println(rs.getInt(1));看看
------解决方案--------------------
确认bmId是有值吗