Bom dia pessoal…
Estou com o seguinte erro, alguem pode me ajudar resolver este erro.
[code]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[/code]
Segue a JSP.
[code]<%@ 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”>
<label for="textfield"></label> N°: <input name="adicionaUsuario.idUsuario" type="text" id="idUsuario" size="10" />
Nome: <label for="textfield2"></label> <input name="textfield2" type="text" id="textfield2" size="65" />
<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" />
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>
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>
<div id="botao"><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" />
</div> </form> </div> </body> </html>[/code] segue a Action[code]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;
}
}
[/code]
Segue a DAO.
[code]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);
}
}[/code]