public void editCliente(Cliente cliente) {
String sql =
"update cliente"
+ "set nome = ?, rg = ?, dataNasc = ?, telefone = ?, celular = ?, "
+ "email = ?, cep = ?, rua = ?, numero = ?, bairro = ?, cidade = ?, uf = ?"
+ "where idCpfCliente = ?";
try {
PreparedStatement stmt = conexao.prepareStatement(sql);
stmt.setString(1, cliente.getNome());
stmt.setString(2, cliente.getRg());
stmt.setDate(3, new Date(cliente.getDataNasc().getTimeInMillis()));
stmt.setString(4, cliente.getTelefone());
stmt.setString(5, cliente.getCelular());
stmt.setString(6, cliente.getEmail());
stmt.setInt(7, cliente.getCep());
stmt.setString(8, cliente.getRua());
stmt.setInt(9, cliente.getNumero());
stmt.setString(10, cliente.getBairro());
stmt.setString(11, cliente.getCidade());
stmt.setString(12, cliente.getUf());
stmt.setLong(13, cliente.getIdCpfCliente());
stmt.execute();
stmt.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
public void addCliente(Cliente cliente) {
String sql =
"insert into cliente"
+ "(idCpfCliente, nome, rg, dataNasc, telefone, celular, email, cep, rua, numero, bairro, cidade, uf)"
+ "values(?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
try {
PreparedStatement stmt = conexao.prepareStatement(sql);
stmt.setLong(1, cliente.getIdCpfCliente());
stmt.setString(2, cliente.getNome());
stmt.setString(3, cliente.getRg());
stmt.setDate(4, new Date(cliente.getDataNasc().getTimeInMillis()));
stmt.setString(5, cliente.getTelefone());
stmt.setString(6, cliente.getCelular());
stmt.setString(7, cliente.getEmail());
stmt.setInt(8, cliente.getCep());
stmt.setString(9, cliente.getRua());
stmt.setInt(10, cliente.getNumero());
stmt.setString(11, cliente.getBairro());
stmt.setString(12, cliente.getCidade());
stmt.setString(13, cliente.getUf());
stmt.execute();
stmt.close();
} catch (SQLException e) {
throw new RuntimeException(e);
}
}
