qq空间抢车位没有了吗:jsp连SQL出现异常

来源:百度文库 编辑:中科新闻网 时间:2024/04/29 18:37:39
type Exception report

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:370)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

root cause

java.lang.NullPointerException
org.apache.jsp.dazahui.danbiao.xindiv_jsp._jspService(org.apache.jsp.dazahui.danbiao.xindiv_jsp:94)
org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:322)
org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
javax.servlet.http.HttpServlet.service(HttpServlet.java:802)

note The full stack trace of the root cause is available in the Apache Tomcat/5.5.11 logs.

-------------------------------------
以下是代码:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>

<%
Connection conn = null;

Statement stmt1 = null;
Statement stmt2 = null;
Statement stmt3 = null;

ResultSet rs1=null;
ResultSet rs2=null;
ResultSet rs3=null;

String sql1="";
String sql2="";
String sql3="";

String dbString = "com.microsoft.jdbc.sqlserver.SQLServerDriver";
String url = "jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=dazahui";
String user = "dzh";
String password = "dzh";

try
{
Class.forName(dbString);
conn = DriverManager.getConnection(url,user,password);
stmt1 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_READ_ONLY);
stmt2 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_READ_ONLY);
stmt3 = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE ,ResultSet.CONCUR_READ_ONLY);
}
catch(ClassNotFoundException e)
{
out.println(e.getMessage());
}
catch(SQLException e)
{
out.println(e.getMessage());
}
%>

a

<%
if(rs1!=null) {rs1.close();}
if(rs2!=null) {rs2.close();}
if(rs3!=null) {rs3.close();}

stmt1.close();
stmt2.close();
stmt3.close();

conn.close();
%>

建立了数据库dazahui,登陆名和密码都是dzh
驱动包也放了。。。但不知道为什么出现异常!
问题解决过一次,就是把还原后的用户删掉在创建一个,但今天还原的时候又出这问题了!!!按照你的说法我看了下,在空指针所指行是rs1=stmt1.executeQuery(sql1);后来发现身边好几个朋友都出了这问题,程序的源代码没问题,因为在学校都试过,都是老师写的,在学校就能用,没想到回家就不能用了!

报空指针错误,看你的tomcat\work\Catalina\localhost\_\org\apache\jsp\danbiao.xindiv_jsp:94行指在什么地方,应该是有个对象还是Null时,你就用了它。