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 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 static void main(String[] args) {
// TODO Auto-generated method stub
if (args.length != 1) {
System.out.println();
} else {
XMLOutputFactory factory = XMLOutputFactory.newFactory();
try (FileOutputStream fos = new FileOutputStream(args[0])) {
XMLStreamWriter writer = factory.createXMLStreamWriter(fos, "UTF-8");
writer.writeStartDocument();
writer.writeCharacters("\n");
writer.writeStartElement("clientes");
writer.writeCharacters("\n");
Cliente c1 =
new Cliente("Diego", "Torres", "andalucia", "*****@*****.**", "333333333", 12341234);
Cliente c2 =
new Cliente(
"Pedro", "Martinez", "calle martos", "*****@*****.**", "333332233", 53441234);
List<Cliente> listaClientes = new ArrayList<>();
listaClientes.add(c1);
listaClientes.add(c2);
for (Cliente cliente : listaClientes) {
writer.writeStartElement("cliente");
writer.writeAttribute("dni", cliente.getNombre());
writer.writeStartElement("nombre");
writer.writeCharacters(cliente.getNombre());
writer.writeEndElement();
writer.writeStartElement("apellidos");
writer.writeCharacters(cliente.getApellidos());
writer.writeEndElement();
writer.writeStartElement("direccion");
writer.writeCharacters(cliente.getDireccion());
writer.writeEndElement();
writer.writeStartElement("email");
writer.writeCharacters(cliente.getEmail());
writer.writeEndElement();
writer.writeStartElement("telefono");
writer.writeCharacters(cliente.getTelefono());
writer.writeEndElement();
}
writer.writeEndElement();
writer.writeEndDocument();
writer.close();
} catch (IOException | XMLStreamException e) {
// TODO Auto-generated catch block
Logger.getLogger(GestionXML.class.getName()).log(Level.SEVERE, null, e);
}
}
}
public VistaEditarCliente(java.awt.Frame parent, boolean modal, Cliente cliente) {
super(parent, modal);
this.cliente = cliente;
initComponents();
tfNombre.setText(cliente.getNombre());
tfApellidos.setText(cliente.getApellidos());
tfDireccion.setText(cliente.getDireccion());
tfTelefono.setText(cliente.getTelefono());
tfEmail.setText(cliente.getEmail());
tfDNI.setText(cliente.getDni());
this.btLimpiar.setEnabled(false);
}
