出现的新问题！！ 求助！！

Question

type Exception reportmessage description The server encountered an internal error () that prevented it from fulfilling this request.exception java.lang.NullPointerException
action.ZhuCeAction.execute(ZhuCeAction.java:36)
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
java.lang.reflect.Method.invoke(Method.java:597)
com.opensymphony.xwork2.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:452)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:291)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:254)
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:248)
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:263)
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:248)
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:133)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:207)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:190)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:243)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:100)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:141)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:142)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:166)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:98)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:176)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:190)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:187)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:248)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:485)
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
note The full stack trace of the root cause is available in the Apache Tomcat/6.0.13 logs.
--------------------------------------------------------------------------------Apache Tomcat/6.0.13
----------------------谁有jdbc+struts2+jsp的源代码 ，不要太大 4M左右就行！ 加分的 谢谢 

Answer 1

注册页面出个空指针异常就放弃了？就直接要源码了？
还是看看ZhuCeAction.java:36这里吧

Answer 2

同意楼上的，是ZhuCeAction出问题了

Answer 3

 没看出来什么问题啊！！ 你们帮我看看吧 
注册Action如下 :
package action;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import connect.DBConnect;
import bean.userbean;
import connect.DBConnect;
import com.opensymphony.xwork2.ActionSupport;
public class ZhuCeAction extends ActionSupport  {
private String username;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassward() {
return password;
}
public void setPassward(String passward) {
this.password = passward;
}
private String password;
public String execute() throws Exception {

String sql = "insert into users(username,password) values('" + username
+ "','" + password + "')";
System.out.println(sql);
DBConnect dbConn = new DBConnect();

ResultSet rs = dbConn.query(sql);
//ZhuCeAction a=new ZhuCeAction();
//saveResult(rs);//.saveResult(rs);
saveResult(rs);
rs.close();
dbConn.close();
return SUCCESS;
}
public void saveResult(ResultSet rs) throws SQLException{
List<userbean> books = new ArrayList<userbean>();
while (rs.next()) {
userbean book = new userbean();
book.setUsername(rs.getString("username"));
book.setPassword(rs.getString("password"));
books.add(book);
}
 }


}

注册页面jsp如下：
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%><%@taglib prefix="s" uri="/struts-tags"%><%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  
  
  <body>
  <center><font size="5" style="color:#DBDB70">用户注册</font></center>
<img src="p3.jpg" width="1330" height="100"/>
     
    <form action="zhuce.action" method="post">
    
    <table align="center">
    <tr><td>用户名：</td><td><input type="text" name="username"/></td></tr>
     <tr><td>密码：</td><td><input type="text" name="password"/></td></tr>
      <tr><td></td><td><input type="submit" name="submit" value="注册"/></td></tr>
      </table>
      </form>
  </body>
</html>
---------------------------------------------------------------------------------
谢谢 各位 看看什么问题饿~ 我是菜鸟啊 如果有源代码的可以发给我一下 再过几个小时就要交jsp+struts+jdbc项目了  [email protected] 谢啦 

Answer 4

检查过你的rs没有？dbConn的query方法也能完成插入操作吗？

Answer 5

public String execute() throws Exception {String sql = "insert into users(username,password) values('" + username
+ "','" + password + "')";//这个sql语句是插入的
System.out.println(sql);
DBConnect dbConn = new DBConnect();ResultSet rs = dbConn.query(sql);//这里到底是插入还是查询？用上面的sql怎么查询resultset？
//ZhuCeAction a=new ZhuCeAction();
//saveResult(rs);//.saveResult(rs);
saveResult(rs);//rs应该为空吧。你看下。
rs.close();
dbConn.close();
return SUCCESS;
}

Answer 6

------------------------------------------我太菜啦 再过几个小时就要交项目啦--------------
注册ACTION我只让让他往数据库里插入数据，改了一下：
package action;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;
import connect.DBConnect;
import bean.userbean;
import connect.DBConnect;
import com.opensymphony.xwork2.ActionSupport;
public class ZhuCeAction extends ActionSupport  {
private String username;
public String getUsername() {
return username;
}
public void setUsername(String username) {
this.username = username;
}
public String getPassward() {
return password;
}
public void setPassward(String passward) {
this.password = passward;
}
private String password;
public String execute() throws Exception {

String sql = "insert into users(username,password) values('" + username
+ "','" + password + "')";
System.out.println(sql);
DBConnect dbConn = new DBConnect();

//ResultSet rs = dbConn.query(sql);
//ZhuCeAction a=new ZhuCeAction();
//saveResult(rs);//.saveResult(rs);
//saveResult(rs);
//rs.close();
//dbConn.close();
//return SUCCESS;
return SUCCESS;
}
//public void saveResult(ResultSet rs) throws SQLException{
// List<userbean> books = new ArrayList<userbean>();
// while (rs.next()) {
// userbean book = new userbean();
// book.setUsername(rs.getString("username"));
// book.setPassword(rs.getString("password"));
/// books.add(book);
//}

 }




----------------------------------------------------------------------------------
运行结果：type Status reportmessage No result defined for action action.ZhuCeAction and result successdescription The requested resource (No result defined for action action.ZhuCeAction and result success) is not available.------------------------------------------------------------------------------------
我太菜啦 怎么办那？、

Answer 7

是不是JSP页面接收到的字符问题？

Answer 8

1.SQL没有执行，所以没有往数据库里插入数据
2.有没有在struts的配置文件中定义success？默认为success

Answer 9

---------------------------------------------------------------------------------------
我配置的SUCCESS  多谢帮助 我再看看吧 ~