<%@ 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)
<%@ 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)
解决方案 »
- 关于struts2.0与hibernate,spring的整合
- Java学习的步骤
- 一个很基础的String数组初始化的问题
- 求救高手!!在线苦等。。。。。
- 如何运行jar包目录下文件夹里的类?
- 一道题
- 如何用DirectColorModel构造方法创建其他颜色模型
- 有关encoding的一个问题
- 通用文本转换语言,大家来看看,也许有用
- 谁知道JDBC中thin和oci8这两个driver有什么区别,server_side driver怎么用?
- 用了System.loadlibrary("dllname")之后,怎么释放Dll的资源呢?
- 在swt中,如何改变Image的显示大小(在TreeView或ToolBar中)
org.apache.jsp.total_jsp._jspService(org.apache.jsp.total_jsp:86)
空指针异常,看看total_jsp.java,86行是什么