<%@ page contentType="text/html; charset=GBK" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="java.util.*" %>
<%@ page import="oracle.jdbc.*" %>
<%@ page import="oracle.jdbc.driver.*" %>
<html>
<head>
<title>total</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head><%
Connection conn=null;


Statement stmt=null;
ResultSet rs=null;

Statement stmt1=null;
ResultSet rs1=null;
String strSQL=null;

Statement stmt2=null;
ResultSet rsdate=null;
        String sDBDriver = "oracle.jdbc.driver.OracleDriver";
        Class.forName(sDBDriver).newInstance();
        conn = DriverManager.getConnection("java:oracle:thin:@localhost:1521:freevoc","....",".....");
        
        
        rsdate =stmt2.executeQuery("select distinct to_char(senddate,'yyyy-mm-dd') from tblsendsmshistory");
        
        while(rsdate.next())
        {                        
         String datefrom = rsdate.getString("senddate");
         out.println("FromDate:"+datefrom);
          stmt=conn.createStatement();
         strSQL="select distinct errorcode from tblsendsmshistory where errorcode!='null'";
         rs = stmt.executeQuery(strSQL);
                
         while(rs.next())
         {
         String s =rs.getString("errorcode"); 
                  out.println("错误类型代码:"+s);
                 
                 stmt1 = conn.createStatement();               
                  rs1 = stmt1.executeQuery("select count(*) from tblsendsmshistory where errorcode='"+s+"'");
                  rs1.next();
                  out.println("本类型错误统计:"+rs1.getInt(1)+"次");
                  if(rs1!=null)rs1.close();
         if(stmt1!=null)stmt1.close(); }
         if(rs!=null)rs.close();
         if(stmt!=null)stmt.close();

}        if(rsdate!=null)rsdate.close();
        if(stmt2!=null)stmt2.close();         if(conn!=null)conn.close();%>
<body>
</body>
</html>
抛出:
message description The server encountered an internal error () that prevented it from fulfilling this request.exception org.apache.jasper.JasperException
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:373)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
root cause java.lang.NullPointerException
org.apache.jsp.total_jsp._jspService(org.apache.jsp.total_jsp:86)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:99)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:295)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:245)
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)