con都获得了，什么con.createStatement();会出错呢？

[flowerylife]

public ResultSet getResult(String sql){
try{
Statement stmt=con.createStatement();//执行到这儿出错为什么呀？
ResultSet rs=stmt.executeQuery(sql);
return rs;
}

[ftiger]

报什么错？

[flowerylife]

2007-2-10 11:57:21 org.apache.catalina.core.StandardWrapperValve invoke
严重: Servlet.service() for servlet jsp threw exception
java.lang.NullPointerException
at org.apache.jsp.login_jsp._jspService(login_jsp.java:74)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:97)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:334)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:314)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:264)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:833)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:639)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1285)
at java.lang.Thread.run(Thread.java:595)

[flowerylife]

我设置断点，到这儿就出错了

[ftiger]

NullPointerException
你没注意吗？空指针错误
不是你的con没得到就是sql是null
先out.println("sql=" + sql);
看看是不是sql错误

再看 out.println("con =" + con);
就可以知道那个是null

[flowerylife]

我打印过的，得到了con,好象是微软驱动的ResultSet的问题。
我换换jtds的看看。成功了我给你分呀

[flowerylife]

原来得装SP4驱动，唉真麻烦。我怎么给你分

[zqrqq]

给分方法：
进入帖子->点击管理->。。。->给分->提交