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); } }