当前位置:编程学习 > JAVA >>

JDBC时出错,菜鸟求帮忙

description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.NullPointerException
com.OnlineExama.struts2.DBConn.executeQuery(DBConn.java:109)
com.OnlineExama.struts2.LoginAction3.myExecute(LoginAction3.java:38)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
java.lang.reflect.Method.invoke(Unknown Source)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:453)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:292)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:255)
org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:256)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:176)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:265)
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:138)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:211)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:90)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:145)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:171)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:192)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:249)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:54)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:510)
org.apache.struts2.dispatcher.ng.ExecuteOperations.executeAction(ExecuteOperations.java:77)
org.apache.struts2.dispatcher.ng.filter.StrutsPrepareAndExecuteFilter.doFilter(StrutsPrepareAndExecuteFilter.java:91)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.32 logs.

--------------------编程问答-------------------- 代码错了  好好检查 --------------------编程问答-------------------- 没有这个方法。映射不到。
com.OnlineExama.struts2.DBConn.executeQuery这个方法有问题啊
--------------------编程问答-------------------- 看不懂 --------------------编程问答-------------------- 没有代码,鬼才能知道哪出错了 --------------------编程问答-------------------- NullPointerException --------------------编程问答-------------------- nullpointerException --------------------编程问答-------------------- 额,这……怎么改,看不懂 --------------------编程问答-------------------- 空指针问题, --------------------编程问答-------------------- 估计是你的哪一部分代码写错了,最有可能的是大小写,刚开始学习的时候也碰到过这样的问题。 --------------------编程问答-------------------- 很多时候空指针异常光用眼睛看代码是没有用的,楼主啊,多用一用调试工具吧。debug一下,跟踪出那个变量为空了,再找其原因吖。。。 --------------------编程问答-------------------- 用debug走一下就知道哪为空了啊 你这不贴代码也没法知道哪的事啊 --------------------编程问答-------------------- java.lang.NullPointerException
com.OnlineExama.struts2.DBConn.executeQuery(DBConn.java:109)
这写的不是很明显吗?DBConn类的109行报了空指针异常,你看看那行代码是不是调用的方法,那个对象是null,没有实例化呗,不行你就把这个类的executeQuery方法贴出来给看看,别忘了标上109行在哪啊!!
还有你调这个方法应该传参数进来的,在这个方法的第一行把参数打印出来看看 --------------------编程问答-------------------- 空指针异常,看看出错行里的那个变量为null,然后顺藤摸瓜。 --------------------编程问答-------------------- 嗯是个菜鸟 --------------------编程问答-------------------- nullpointerException --------------------编程问答-------------------- NullPointerException 
--------------------编程问答--------------------
引用 12 楼  的回复:
java.lang.NullPointerException
com.OnlineExama.struts2.DBConn.executeQuery(DBConn.java:109)
这写的不是很明显吗?DBConn类的109行报了空指针异常,你看看那行代码是不是调用的方法,那个对象是null,没有实例化呗,不行你就把这个类的executeQuery方法贴出来给看看,别忘了标上109行在哪啊……

public ResultSet executeQuery(String sql) {
      ResultSet rs;
      try {
          if (conn == null) {
              creatConnection();
          }
          Statement stmt = conn.createStatement();  //109行
          try {
              rs = stmt.executeQuery(sql);
          } catch (SQLException e) {
              System.out.println(e.getMessage());
              return null;
          }
      } catch (SQLException e) {
          System.out.println(e.getMessage());
          System.out.println("executeQueryError!");
          return null;
      }
      return rs;
  } --------------------编程问答-------------------- creatConnection();
这个方法初始化conn对象应该没有成功,所有在109行用conn调用createStatement()方法会报空指针的错误 --------------------编程问答-------------------- 明显空对象异常,如果你的数据库能用MYECLIPSE连上,那是你查的那东西在数据库里没有那字段,要不就是你传的查询参数是空的 --------------------编程问答--------------------
补充:Java ,  Web 开发
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,