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);
}
}
public void iserir(Cliente c) {
PreparedStatement ps;
try {
ps =
con.prepareStatement(
"INSERT INTO CLIENTE (id,nome,endereco,telefone,cidade,uf) VALUES (? , ?, ?, ?, ?, ?)");
ps.setInt(1, c.getId());
ps.setString(2, c.getNome());
ps.setString(3, c.getEndereco());
ps.setString(4, c.getTelefone());
ps.setString(5, c.getCidade());
ps.setObject(6, c.getUf().getNome());
ps.executeUpdate();
ps.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
public void atualizar(Cliente c) {
PreparedStatement ps;
try {
ps =
con.prepareStatement(
"UPDATE CLIENTE SET NOME = ?,ENDERECO = ?,TELEFONE = ?,UF = ? WHERE ID ="
+ c.getId());
ps.setInt(1, c.getId());
ps.setString(2, c.getNome() + "");
ps.setString(3, c.getEndereco() + "");
ps.setString(4, c.getTelefone() + "");
ps.setString(5, c.getCidade() + "");
ps.setObject(6, c.getUf() + "");
ps.executeUpdate();
ps.close();
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "Erro ao atualizar dados do cliente!");
}
}
