Olá pessoal,
uma duvida criei um link em uma pagina jsp
onde recebo o numero do usuario para depois
se for deletar essa linha passo esse numero
mas quando debugei na classe o numero é sempre
zero.
alguem poderia me ajudar onde estou errando…
abs
<h:commandLink value="#{usuario.id}" action="#{cadastro.remover}">
<h:outputText value="Excluir"></h:outputText>
</h:commandLink>
public class Usuario {
private int id ;
private String login="";
private String senha="";
private String mail="";
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getLogin() {
return login;
}
public void setLogin(String login) {
this.login = login;
}
public String getSenha() {
return senha;
}
public void setSenha(String senha) {
this.senha = senha;
}
public String getMail() {
return mail;
}
public void setMail(String mail) {
this.mail = mail;
}
public String incluir() {
try {
Connection cn = Conexao.obterConexao();
PreparedStatement statement = null;
statement = cn.prepareStatement("insert into usuario (login,senha,mail) values (?,?,?)");
statement.setString(1,login);
statement.setString(2,senha);
statement.setString(3,mail);
statement.execute();
cn.close();
return "sucesso";
} catch (SQLException e) {
e.printStackTrace();
return "falha";
}
}
/* (non-Javadoc)
* @see daca.service.PersistenteIF#remove(java.lang.String)
*/
public String remover() {
try {
Connection cn = Conexao.obterConexao();
PreparedStatement statement = null;
System.out.println("id="+id);
statement = cn.prepareStatement("delete from usuario where id=?");
statement.setInt(1,id);
statement.execute();
cn.close();
return "sucesso";
} catch (SQLException e) {
e.printStackTrace();
return "falha";
}
}
/* (non-Javadoc)
* @see daca.service.PersistenteIF#selectTodos()
*/
public List getLista() {
Connection cn = Conexao.obterConexao();
List lista = new ArrayList();
try {
ResultSet rs = cn.createStatement().executeQuery("select id,login,senha,mail from usuario");
while(rs.next()){
Usuario u = new Usuario();
u.setId(rs.getInt(1));
u.setLogin(rs.getString(2));
u.setSenha(rs.getString(3));
u.setMail(rs.getString(4));
lista.add(u);
}
} catch (Exception e) {
e.printStackTrace();
}
return lista;
}
}
<faces-config>
<application>
<locale-config>
<default-locale>br</default-locale>
</locale-config>
<message-bundle>daca.bundle.Messages</message-bundle>
</application>
<navigation-rule>
<from-view-id>/login.jsp</from-view-id>
<navigation-case>
<from-outcome>sucesso</from-outcome>
<to-view-id>/login.jsp</to-view-id>
</navigation-case>
<navigation-case>
<from-outcome>falha</from-outcome>
<to-view-id>/teste.jsp</to-view-id>
</navigation-case>
</navigation-rule>
<managed-bean>
<managed-bean-name>cadastro</managed-bean-name>
<managed-bean-class>daca.bean.Usuario</managed-bean-class>
<managed-bean-scope>session</managed-bean-scope>
</managed-bean>
