程序为:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%!
String driver="sun.jdbc.odbc.JdbcOdbcDriver";
String url="jdbc:odbc:mldn";
String user="sa";
String password="";
Connection conn=null;
Statement pstmt=null;
ResultSet rs=null;
String sql=null;
%>
<%
try
{
Class.forName(driver);
}catch(Exception e){e.printStackTrace();}
try
{
conn=DriverManager.getConnection(url);
}catch(Exception e){e.printStackTrace();}
try
{
pstmt=conn.createStatement();
conn.setAutoCommit(false);
pstmt.addBatch("use long INSERT INTO person (姓名,id) VALUES ('LXH_A',28)");
pstmt.addBatch("use long INSERT INTO person (姓名,id) VALUES ('LXH_b',22)");
pstmt.addBatch("use long INSERT INTO person (姓名,id) VALUES ('LXH_c',23)");
pstmt.executeBatch();
conn.commit();
}catch(Exception e)
{
try
{
conn.rollback();
}catch(Exception ee){}
out.println("数据库关闭失败!!!") ;
}
try
{
rs.close();
pstmt.close();
conn.close();
}catch(Exception e){e.printStackTrace();}
%>
错误为:
java.lang.NullPointerException
at org.apache.jsp.jdbc2_jsp._jspService(jdbc2_jsp.java:97)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:337)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Unknown Source)