Java - SQL Error Updating All Users

Question

Java - SQL Error Updating All Users

Navigation

#1 by (5 votes)

3

Good morning,

I have the following problem my updateUsuario SQL is updating all how do I just update the User that you have accessed?

public class Acessar {

public static Connection con = dao.ConectarDB.getConexao();

public static String doLogin(model.Acessar usuario) {

    // Variáveis
    PreparedStatement ps = null;
    String sql = null; 
    ResultSet rs = null;
    ResultSet autenticacao = null;
    ResultSet grupo = null;
    sql = "select * from usuario where nome=? and senha=?";

    try {

        // Validar Usuário
        ps = ConectarDB.getConexao().prepareStatement(sql);
        ps.setString(1, usuario.getNome());
        ps.setString(2, usuario.getSenha());
        rs = ps.executeQuery();
        autenticacao = rs; 

        // Validar Grupo
        ps = null;
        sql = null;
        rs = null;
        sql = "select * from usuario where grupo=?";

        try {
            ps = con.prepareStatement(sql); 
            ps.setString(1, "Suporte");
            rs = ps.executeQuery();
            grupo = rs;

        } catch (SQLException ex) {
           ex.printStackTrace();
           return null;
        }

        // Resultado da Autenticação
        if(autenticacao.next()) {

            // Autenticado!

            // Resultado do Grupo
            if(grupo.next()) {

            } else {
                return null;
            }

            return "lider";

        } else {
            return "erro";
        }            

    } catch (SQLException ex) {
        ex.printStackTrace();
        return "erro";
    }

}

// (Corrigir) Está atualizando todos os Usuários!
public void atualizarUsuario(model.Acessar acesso) {

    // Variáveis
    PreparedStatement ps = null;
    String sql = "update usuario set acesso=?";

    // Inserção
    try {
        ps = con.prepareStatement(sql);
        ps.setDate(1, new Date(acesso.getAcesso().getTime()));
        ps.executeUpdate();

    } catch (SQLException ex) {
       ex.printStackTrace();
    }
}

}

sql java postgresql window-builder

asked by anonymous 02.12.2015 / 11:43

1 answer

Is MySQL built into EasyPHP? [closed] Difference between SQL Server Express versions?

score 5 · Accepted Answer

In your SQL string you need to specify which user you want to update using the where clause for this. In addition, you need to pass this user as a parameter in your UpdateUsers method.

Something like this:

public void atualizarUsuario(model.Acessar acesso, Usuario usuario) {

    // Variáveis
    PreparedStatement ps = null;
    String sql = "update usuario set acesso=? where nome=?";

    // Inserção
    try {
        ps = con.prepareStatement(sql);
        ps.setDate(1, new Date(acesso.getAcesso().getTime()));
        ps.setString(2, usuario.getNome());
        ps.executeUpdate();

    } catch (SQLException ex) {
       ex.printStackTrace();
    }
}

I do not know your model, so I'm updating the user based on the name (as you log in), but this can obviously cause problems when two users have the same name.