crud

PHOTO EMBED

Wed Jun 19 2024 18:04:50 GMT+0000 (Coordinated Universal Time)

Saved by @gabriellesoares

 @Override
    public Cliente save(Cliente cliente) {
        String query = "INSERT INTO clientes (nome, email, senha, pagamento) VALUES (?, ?, ?, ?)";
        try (PreparedStatement stmt = connection.prepareStatement(query, Statement.RETURN_GENERATED_KEYS)) {
            stmt.setString(1, cliente.getNome());
            stmt.setString(2, cliente.getEmail());
            stmt.setString(3, cliente.getSenha());
            stmt.setString(4, cliente.getPagamento().toString());
            stmt.executeUpdate();

            ResultSet rs = stmt.getGeneratedKeys();
            if (rs.next()) {
                cliente.setId(rs.getInt(1));
            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return cliente;
    }
content_copyCOPY