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