Bom dia pessoal..
Estou com o seguinte erro, alguem pode me ajudar resolver este erro.
type Exception report
message
description The server encountered an internal error () that prevented it from fulfilling this request.
exception
java.lang.NullPointerException
br.com.Museu.Dao.Bancos.UsuarioDAO.inserirUsuario(UsuarioDAO.java:28)
br.com.Museu.dados.action.AdicionaUsuarioAction.execute(AdicionaUsuarioAction.java:18)
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:441)
com.opensymphony.xwork2.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:280)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:243)
com.opensymphony.xwork2.interceptor.DefaultWorkflowInterceptor.doIntercept(DefaultWorkflowInterceptor.java:165)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.validator.ValidationInterceptor.doIntercept(ValidationInterceptor.java:252)
org.apache.struts2.interceptor.validation.AnnotationValidationInterceptor.doIntercept(AnnotationValidationInterceptor.java:68)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ConversionErrorInterceptor.intercept(ConversionErrorInterceptor.java:122)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ParametersInterceptor.doIntercept(ParametersInterceptor.java:195)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.StaticParametersInterceptor.intercept(StaticParametersInterceptor.java:179)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.MultiselectInterceptor.intercept(MultiselectInterceptor.java:75)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.CheckboxInterceptor.intercept(CheckboxInterceptor.java:94)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.FileUploadInterceptor.intercept(FileUploadInterceptor.java:235)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ModelDrivenInterceptor.intercept(ModelDrivenInterceptor.java:89)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ScopedModelDrivenInterceptor.intercept(ScopedModelDrivenInterceptor.java:130)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.debugging.DebuggingInterceptor.intercept(DebuggingInterceptor.java:267)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ChainingInterceptor.intercept(ChainingInterceptor.java:126)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.PrepareInterceptor.doIntercept(PrepareInterceptor.java:138)
com.opensymphony.xwork2.interceptor.MethodFilterInterceptor.intercept(MethodFilterInterceptor.java:87)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.I18nInterceptor.intercept(I18nInterceptor.java:165)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.interceptor.ServletConfigInterceptor.intercept(ServletConfigInterceptor.java:164)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.AliasInterceptor.intercept(AliasInterceptor.java:179)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
com.opensymphony.xwork2.interceptor.ExceptionMappingInterceptor.intercept(ExceptionMappingInterceptor.java:176)
com.opensymphony.xwork2.DefaultActionInvocation.invoke(DefaultActionInvocation.java:237)
org.apache.struts2.impl.StrutsActionProxy.execute(StrutsActionProxy.java:52)
org.apache.struts2.dispatcher.Dispatcher.serviceAction(Dispatcher.java:488)
org.apache.struts2.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:395)
note The full stack trace of the root cause is available in the Apache Tomcat/7.0.12 logs.
--------------------------------------------------------------------------------
Apache Tomcat/7.0.12
Segue a JSP.
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<link href="cadastros.css" rel="stylesheet" type="text/css" />
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title>
<script type="text/javascript">
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
</script>
</head>
<body>
<h3>Cadastra de Usuarios e de Funcionarios</h3>
<div>
<form action="adicionaUsuario" method="post" dir="ltr">
<p>
<label for="textfield"></label>
N°:
<input name="adicionaUsuario.idUsuario" type="text" id="idUsuario" size="10" />
</p>
<p>Nome:
<label for="textfield2"></label>
<input name="textfield2" type="text" id="textfield2" size="65" />
</p>
<p>
<label for="textfield3"></label>
Endereço:
<input name="textfield3" type="text" id="textfield3" size="35" />
N°:
<label for="textfield4"></label>
<input name="textfield4" type="text" id="textfield4" size="5" />
Bairro:
<label for="textfield5"></label>
<input name="textfield5" type="text" id="textfield5" size="20" />
</p>
<p>CEP:
<label for="textfield6"></label>
<input name="textfield6" type="text" id="textfield6" size="20" />
Complemento:
<label for="textfield7"></label>
<input name="textfield7" type="text" id="textfield7" size="25" />
Estado:
<select name="jumpMenu" id="jumpMenu" onchange="MM_jumpMenu('parent',this,0)">
<option>item1</option>
<option>item2</option>
<option>item3</option>
<option>item4</option>
</select>
</p>
<p>Usuario:
<label for="textfield8"></label>
<input name="textfield8" type="text" id="textfield8" size="15" />
Senha:
<label for="textfield9"></label>
<input name="textfield9" type="text" id="textfield9" size="15" />
Permição:
<label for="textfield10"></label>
<select name="jumpMenu2" id="jumpMenu2" onchange="MM_jumpMenu('parent',this,0)">
<option>Administrador</option>
</select>
Status:
<select name="jumpMenu3" id="jumpMenu3" onchange="MM_jumpMenu('parent',this,0)">
<option>Adminitido</option>
</select>
</p>
<div id="botao">
<p>
<input type="submit" name="button" id="button" value="Salvar Novo" />
<input type="submit" name="button2" id="button2" value="Alterar dados" />
<input type="submit" name="button3" id="button3" value="Deletar Registro" />
</p>
</div>
</form>
</div>
</body>
</html>
package br.com.Museu.dados.action;
import org.apache.struts2.convention.annotation.Action;
import org.apache.struts2.convention.annotation.Result;
import com.sun.xml.internal.bind.v2.runtime.Name;
import br.com.Museu.Dao.Bancos.UsuarioDAO;
import br.com.Museu.dados.usuarios;
public class AdicionaUsuarioAction {
private usuarios usuariodadosaction;
@Action(value="adicionaUsuario",results={
@Result(name="ok", location="/CadastroUsuarios.jsp")
})
public String execute(){
new UsuarioDAO().inserirUsuario(usuariodadosaction);
return "OK";
}
public usuarios getUsuarios(){
return this.usuariodadosaction;
}
public void setUsuarios(usuarios usuariodadosaction){
this.usuariodadosaction = usuariodadosaction;
}
}
Segue a DAO.
public UsuarioDAO (){
this.connection = new ConnectionFactory().getConnection();
}
public void inserirUsuario(usuarios usuariosdados){
String sql = "insert into usuarios (bairro, cp, cidade, data, endereco, estado, funcao, log, nome, numero, permicao, senha," +
" status, telefone, usuario, idusuario) values (?,?,?,?,?,?,?,?,?,?,?,?,?," +
"?,?,?)";
try {
PreparedStatement stmt = this.connection.prepareStatement(sql);
stmt.setString(1, usuariosdados.getBairroUsuario());
stmt.setString(2, usuariosdados.getCepUsuario());
stmt.setString(3, usuariosdados.getCidadeUsuario());
stmt.setString(4, usuariosdados.getDataCadastroUsuario());
stmt.setString(5, usuariosdados.getEnderecoUsuario());
stmt.setString(6, usuariosdados.getEstadoUsuario());
stmt.setString(7, usuariosdados.getFuncao());
stmt.setString(8, usuariosdados.getLogUsuario());
stmt.setString(9, usuariosdados.getNomeUsuario());
stmt.setString(10, usuariosdados.getNumeroUsuario());
stmt.setString(11, usuariosdados.getPermissaoUsuario());
stmt.setString(12, usuariosdados.getSenhaUsuario());
stmt.setString(13, usuariosdados.getStatusUsuario());
stmt.setString(14, usuariosdados.getTelefone());
stmt.setString(15, usuariosdados.getUsuario());
stmt.setString(16, usuariosdados.getIdUsuario());
stmt.execute();
stmt.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}