package zinn;
import java.sql.SQLException;
import java.util.logging.Level;
import java.util.logging.Logger;
import javax.swing.JOptionPane;
import java.lang.String;
import java.sql.Connection;
import java.sql.CallableStatement;
import java.sql.Connection;
import java.util.Date;
import javax.swing.*;
import javax.swing.text.MaskFormatter;
/**
*
* @author will
*/
public class Cad_cliente extends javax.swing.JFrame {
MaskFormatter maskFone; //Mascara para Telefone
MaskFormatter mascData; //Mascara para data
MaskFormatter mascCep; // Mascara para cep
//Pegando data do Micro
Date data_sis = new Date();
/** Creates new form Cad_cliente */
public Cad_cliente() {
initComponents();
//Tudo que eu quero que venha no incio tem que ser aqui
try{
mascData = new MaskFormatter("##/##/####");
mascData.setValidCharacters("[telefone removido]");
mascData.setPlaceholderCharacter(' ');
mascData.install(dat_nasc);
mascData.install(dat_cad);
}catch(Exception e){}
try{
mascCep = new MaskFormatter("#####-###");
mascCep.setValidCharacters("[telefone removido]");
mascData.setPlaceholderCharacter(' ');
mascCep.install(cep);
}catch (Exception e){}
try{
maskFone= new MaskFormatter("####-####");
maskFone.setValidCharacters("[telefone removido]");
maskFone.setPlaceholderCharacter(' ');
maskFone.install(tel_serv);
maskFone.install(tel_res);
maskFone.install(tel_cel);
}catch (Exception e){}
//Inserindo data do Sistema no campo Dat_cad
try{
dat_cad.getText(data_sis); //erro aqui
}catch(Exception e){}
//*********************///*********************************///**********************
//Puxando dados para o combobox
//preencher seu combo :
//*********************///*********************************///**********************
public boolean validaCpf(String valid_cpf) //erro aqui (illegal start of expression)
{
int soma = 0;
try {
Long.parseLong(valid_cpf);
} catch (Exception e) {
JOptionPane.showMessageDialog(null,"Somente números s�o permitidos no CPF","ERRO",JOptionPane.ERROR_MESSAGE);
this.cpf.requestFocus();
return false;
}
if(valid_cpf.length() == 11) {
for (int i=0; i < 9; i++)
soma += (10 - i) * (valid_cpf.charAt(i) - '0');
soma = 11 - (soma % 11);
if (soma > 9) soma = 0;
if (soma == (valid_cpf.charAt(9) - '0')) {
soma = 0;
for (int i=0; i < 10; i++)
soma += (11 - i) * (valid_cpf.charAt(i) - '0');
soma = 11 - (soma % 11);
if (soma > 9) soma = 0;
if (soma == (valid_cpf.charAt(10) - '0')) {
return true;
}
}
}
JOptionPane.showMessageDialog(null,"CPF Inválido","ERRO",JOptionPane.ERROR_MESSAGE);
return false;
}
/** This method is called from within the constructor to
* initialize the form.
* WARNING: Do NOT modify this code. The content of this method is
* always regenerated by the Form Editor.
*/
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
oticaPUEntityManager = javax.persistence.Persistence.createEntityManagerFactory("oticaPU").createEntityManager();
jPanel1 = new javax.swing.JPanel();
jLabel2 = new javax.swing.JLabel();
ord_serv = new javax.swing.JTextField();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel22 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
end = new javax.swing.JTextField();
nome = new javax.swing.JTextField();
jLabel15 = new javax.swing.JLabel();
bairro = new javax.swing.JTextField();
jLabel17 = new javax.swing.JLabel();
ddd = new javax.swing.JTextField();
jLabel9 = new javax.swing.JLabel();
jLabel23 = new javax.swing.JLabel();
jLabel11 = new javax.swing.JLabel();
est_rg = new javax.swing.JComboBox();
jLabel18 = new javax.swing.JLabel();
jLabel24 = new javax.swing.JLabel();
jLabel12 = new javax.swing.JLabel();
rg = new javax.swing.JTextField();
jLabel25 = new javax.swing.JLabel();
jLabel13 = new javax.swing.JLabel();
cpf = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
cidade = new javax.swing.JComboBox();
jLabel16 = new javax.swing.JLabel();
estado = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
jLabel10 = new javax.swing.JLabel();
nome_pai = new javax.swing.JTextField();
jLabel19 = new javax.swing.JLabel();
jLabel14 = new javax.swing.JLabel();
jLabel20 = new javax.swing.JLabel();
jLabel26 = new javax.swing.JLabel();
nome_mae = new javax.swing.JTextField();
concluir_cad_cliente = new javax.swing.JButton();
Limpar = new javax.swing.JButton();
fechar_tela_cad_cli = new javax.swing.JButton();
jLabel21 = new javax.swing.JLabel();
dat_nasc = new javax.swing.JFormattedTextField();
dat_cad = new javax.swing.JFormattedTextField();
tel_serv = new javax.swing.JFormattedTextField();
tel_res = new javax.swing.JFormattedTextField();
tel_cel = new javax.swing.JFormattedTextField();
cep = new javax.swing.JFormattedTextField();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setName("Form"); // NOI18N
org.jdesktop.application.ResourceMap resourceMap = org.jdesktop.application.Application.getInstance(zinn.ZinnApp.class).getContext().getResourceMap(Cad_cliente.class);
jPanel1.setBorder(javax.swing.BorderFactory.createTitledBorder(new javax.swing.border.LineBorder(new java.awt.Color(0, 0, 0), 2, true), resourceMap.getString("jPanel1.border.title"), javax.swing.border.TitledBorder.DEFAULT_JUSTIFICATION, javax.swing.border.TitledBorder.DEFAULT_POSITION, resourceMap.getFont("jPanel1.border.titleFont"))); // NOI18N
jPanel1.setName("jPanel1"); // NOI18N
jLabel2.setFont(resourceMap.getFont("jLabel2.font")); // NOI18N
jLabel2.setText(resourceMap.getString("jLabel2.text")); // NOI18N
jLabel2.setName("jLabel2"); // NOI18N
ord_serv.setText(resourceMap.getString("ord_serv.text")); // NOI18N
ord_serv.setName("ord_serv"); // NOI18N
jLabel3.setText(resourceMap.getString("jLabel3.text")); // NOI18N
jLabel3.setName("jLabel3"); // NOI18N
jLabel4.setText(resourceMap.getString("jLabel4.text")); // NOI18N
jLabel4.setName("jLabel4"); // NOI18N
jLabel22.setForeground(resourceMap.getColor("jLabel22.foreground")); // NOI18N
jLabel22.setText(resourceMap.getString("jLabel22.text")); // NOI18N
jLabel22.setName("jLabel22"); // NOI18N
jLabel5.setText(resourceMap.getString("jLabel5.text")); // NOI18N
jLabel5.setName("jLabel5"); // NOI18N
end.setText(resourceMap.getString("end.text")); // NOI18N
end.setName("end"); // NOI18N
nome.setText(resourceMap.getString("nome.text")); // NOI18N
nome.setName("nome"); // NOI18N
nome.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
nomeActionPerformed(evt);
}
});
jLabel15.setText(resourceMap.getString("jLabel15.text")); // NOI18N
jLabel15.setName("jLabel15"); // NOI18N
bairro.setText(resourceMap.getString("bairro.text")); // NOI18N
bairro.setName("bairro"); // NOI18N
jLabel17.setText(resourceMap.getString("jLabel17.text")); // NOI18N
jLabel17.setName("jLabel17"); // NOI18N
ddd.setText(resourceMap.getString("ddd.text")); // NOI18N
ddd.setName("ddd"); // NOI18N
jLabel9.setText(resourceMap.getString("jLabel9.text")); // NOI18N
jLabel9.setName("jLabel9"); // NOI18N
jLabel23.setForeground(resourceMap.getColor("jLabel23.foreground")); // NOI18N
jLabel23.setText(resourceMap.getString("jLabel23.text")); // NOI18N
jLabel23.setName("jLabel23"); // NOI18N
jLabel11.setText(resourceMap.getString("jLabel11.text")); // NOI18N
jLabel11.setName("jLabel11"); // NOI18N
est_rg.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "", "AC", "AL", "AP", "AM", "BA", "CE", "DF", "GO", "ES", "MA", "MT", "MS", "MG", "PA", "PB", "PR", "PE", "PI", "RJ", "RN", "RS", "RO", "RR", "SP", "SC", "SE", "TO" }));
est_rg.setName("est_rg"); // NOI18N
jLabel18.setText(resourceMap.getString("jLabel18.text")); // NOI18N
jLabel18.setName("jLabel18"); // NOI18N
jLabel24.setForeground(resourceMap.getColor("jLabel24.foreground")); // NOI18N
jLabel24.setText(resourceMap.getString("jLabel24.text")); // NOI18N
jLabel24.setName("jLabel24"); // NOI18N
jLabel12.setText(resourceMap.getString("jLabel12.text")); // NOI18N
jLabel12.setName("jLabel12"); // NOI18N
rg.setText(resourceMap.getString("rg.text")); // NOI18N
rg.setName("rg"); // NOI18N
jLabel25.setForeground(resourceMap.getColor("jLabel25.foreground")); // NOI18N
jLabel25.setText(resourceMap.getString("jLabel25.text")); // NOI18N
jLabel25.setName("jLabel25"); // NOI18N
jLabel13.setText(resourceMap.getString("jLabel13.text")); // NOI18N
jLabel13.setName("jLabel13"); // NOI18N
cpf.setText(resourceMap.getString("cpf.text")); // NOI18N
cpf.setName("cpf"); // NOI18N
jLabel7.setText(resourceMap.getString("jLabel7.text")); // NOI18N
jLabel7.setName("jLabel7"); // NOI18N
jLabel6.setText(resourceMap.getString("jLabel6.text")); // NOI18N
jLabel6.setName("jLabel6"); // NOI18N
cidade.setModel(new javax.swing.DefaultComboBoxModel(new String[] { "Item 1", "Item 2", "Item 3", "Item 4" }));
cidade.setName("cidade"); // NOI18N
jLabel16.setText(resourceMap.getString("jLabel16.text")); // NOI18N
jLabel16.setName("jLabel16"); // NOI18N
estado.setText(resourceMap.getString("estado.text")); // NOI18N
estado.setName("estado"); // NOI18N
jLabel8.setText(resourceMap.getString("jLabel8.text")); // NOI18N
jLabel8.setName("jLabel8"); // NOI18N
jLabel10.setText(resourceMap.getString("jLabel10.text")); // NOI18N
jLabel10.setName("jLabel10"); // NOI18N
nome_pai.setText(resourceMap.getString("nome_pai.text")); // NOI18N
nome_pai.setName("nome_pai"); // NOI18N
jLabel19.setText(resourceMap.getString("jLabel19.text")); // NOI18N
jLabel19.setName("jLabel19"); // NOI18N
jLabel14.setText(resourceMap.getString("jLabel14.text")); // NOI18N
jLabel14.setName("jLabel14"); // NOI18N
jLabel20.setText(resourceMap.getString("jLabel20.text")); // NOI18N
jLabel20.setName("jLabel20"); // NOI18N
jLabel26.setForeground(resourceMap.getColor("jLabel26.foreground")); // NOI18N
jLabel26.setText(resourceMap.getString("jLabel26.text")); // NOI18N
jLabel26.setName("jLabel26"); // NOI18N
nome_mae.setText(resourceMap.getString("nome_mae.text")); // NOI18N
nome_mae.setName("nome_mae"); // NOI18N
concluir_cad_cliente.setIcon(resourceMap.getIcon("concluir_cad_cliente.icon")); // NOI18N
concluir_cad_cliente.setText(resourceMap.getString("concluir_cad_cliente.text")); // NOI18N
concluir_cad_cliente.setName("concluir_cad_cliente"); // NOI18N
concluir_cad_cliente.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
concluir_cad_clienteActionPerformed(evt);
}
});
Limpar.setIcon(resourceMap.getIcon("Limpar.icon")); // NOI18N
Limpar.setText(resourceMap.getString("Limpar.text")); // NOI18N
Limpar.setActionCommand(resourceMap.getString("Limpar.actionCommand")); // NOI18N
Limpar.setName("Limpar"); // NOI18N
Limpar.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
LimparMouseClicked(evt);
}
});
fechar_tela_cad_cli.setIcon(resourceMap.getIcon("fechar_tela_cad_cli.icon")); // NOI18N
fechar_tela_cad_cli.setText(resourceMap.getString("fechar_tela_cad_cli.text")); // NOI18N
fechar_tela_cad_cli.setName("fechar_tela_cad_cli"); // NOI18N
fechar_tela_cad_cli.addMouseListener(new java.awt.event.MouseAdapter() {
public void mouseClicked(java.awt.event.MouseEvent evt) {
fechar_tela_cad_cliMouseClicked(evt);
}
});
jLabel21.setForeground(resourceMap.getColor("jLabel21.foreground")); // NOI18N
jLabel21.setText(resourceMap.getString("jLabel21.text")); // NOI18N
jLabel21.setName("jLabel21"); // NOI18N
dat_nasc.setText(resourceMap.getString("dat_nasc.text")); // NOI18N
dat_nasc.setName("dat_nasc"); // NOI18N
dat_cad.setText(resourceMap.getString("dat_cad.text")); // NOI18N
dat_cad.setName("dat_cad"); // NOI18N
tel_serv.setText(resourceMap.getString("tel_serv.text")); // NOI18N
tel_serv.setName("tel_serv"); // NOI18N
tel_res.setText(resourceMap.getString("tel_res.text")); // NOI18N
tel_res.setName("tel_res"); // NOI18N
tel_cel.setText(resourceMap.getString("tel_cel.text")); // NOI18N
tel_cel.setName("tel_cel"); // NOI18N
cep.setText(resourceMap.getString("cep.text")); // NOI18N
cep.setName("cep"); // NOI18N
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 12, Short.MAX_VALUE)
.addComponent(jLabel23)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel11)
.addGap(12, 12, 12))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel21)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel2)))
.addGap(662, 662, 662))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addContainerGap(606, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(ord_serv, javax.swing.GroupLayout.PREFERRED_SIZE, 57, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel3))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel4)
.addComponent(dat_cad, javax.swing.GroupLayout.PREFERRED_SIZE, 79, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap())
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(248, 248, 248)
.addComponent(cep, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(387, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(dat_nasc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(612, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(71, 71, 71)
.addComponent(tel_serv, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(56, 56, 56)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(tel_res, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel8))
.addGap(78, 78, 78)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel10)
.addComponent(tel_cel, javax.swing.GroupLayout.PREFERRED_SIZE, 131, javax.swing.GroupLayout.PREFERRED_SIZE))
.addContainerGap(168, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(nome_mae, javax.swing.GroupLayout.DEFAULT_SIZE, 754, Short.MAX_VALUE))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(4, 4, 4)
.addComponent(jLabel22)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel5)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 653, javax.swing.GroupLayout.PREFERRED_SIZE))
.addComponent(end, javax.swing.GroupLayout.DEFAULT_SIZE, 754, Short.MAX_VALUE)
.addComponent(nome, javax.swing.GroupLayout.DEFAULT_SIZE, 754, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING, false)
.addComponent(jLabel15)
.addComponent(bairro, javax.swing.GroupLayout.PREFERRED_SIZE, 193, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel17)
.addComponent(ddd, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel9)
.addGap(75, 75, 75)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(156, 156, 156)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(est_rg, javax.swing.GroupLayout.PREFERRED_SIZE, 75, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(jLabel18))))
.addGap(18, 18, 18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel24)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel12))
.addComponent(rg, javax.swing.GroupLayout.PREFERRED_SIZE, 178, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel25)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel13))
.addComponent(cpf, javax.swing.GroupLayout.PREFERRED_SIZE, 200, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel7)
.addGap(114, 114, 114)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(jLabel6)
.addComponent(cidade, 0, 254, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel16)
.addGap(71, 71, 71))
.addComponent(estado, javax.swing.GroupLayout.DEFAULT_SIZE, 100, Short.MAX_VALUE)))))
.addComponent(nome_pai, javax.swing.GroupLayout.Alignment.TRAILING, javax.swing.GroupLayout.DEFAULT_SIZE, 754, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel19)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 648, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, jPanel1Layout.createSequentialGroup()
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 424, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(concluir_cad_cliente)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(Limpar)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(fechar_tela_cad_cli))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel14)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 679, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGroup(jPanel1Layout.createSequentialGroup()
.addComponent(jLabel26)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel20)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 627, javax.swing.GroupLayout.PREFERRED_SIZE)))
.addContainerGap()))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel4)
.addComponent(jLabel3))
.addGap(5, 5, 5)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(dat_cad, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(ord_serv, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel21)
.addComponent(jLabel2))
.addGap(121, 121, 121)
.addComponent(cep, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel8)
.addComponent(jLabel10))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(tel_serv, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tel_res, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(tel_cel, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel23)
.addComponent(jLabel11, javax.swing.GroupLayout.DEFAULT_SIZE, 22, Short.MAX_VALUE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(dat_nasc, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(109, 109, 109)
.addComponent(nome_mae, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(111, 111, 111))
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(92, 92, 92)
.addComponent(nome, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(10, 10, 10)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel5)
.addComponent(jLabel22))
.addGap(6, 6, 6)
.addComponent(end, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel15)
.addComponent(jLabel7)
.addComponent(jLabel6)
.addComponent(jLabel16))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(bairro, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(cidade, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(estado, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel17)
.addComponent(jLabel9))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(ddd, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(13, 13, 13)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
.addComponent(jLabel18)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel24)
.addComponent(jLabel12)
.addComponent(jLabel25)
.addComponent(jLabel13)))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(rg, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(est_rg, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(cpf, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
.addGap(12, 12, 12)
.addComponent(jLabel14)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addComponent(jLabel19)
.addGap(4, 4, 4)
.addComponent(nome_pai, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(jLabel20)
.addComponent(jLabel26))
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 87, Short.MAX_VALUE)
.addGroup(jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(fechar_tela_cad_cli)
.addComponent(Limpar)
.addComponent(concluir_cad_cliente))
.addContainerGap()))
);
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
layout.setVerticalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(layout.createSequentialGroup()
.addComponent(jPanel1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE))
);
pack();
}// </editor-fold>
private void fechar_tela_cad_cliMouseClicked(java.awt.event.MouseEvent evt) {
if(JOptionPane.showConfirmDialog(null,"Deseja fechar a tela de cadastro?","CONFIRMAÇÃO",JOptionPane.YES_NO_OPTION)==0){
this.dispose();
}
// TODO add your handling code here:
}
private void LimparMouseClicked(java.awt.event.MouseEvent evt) {
// TODO add your handling code here:
nome.setText("");
end.setText("");
bairro.setText("");
cep.setText("");
ddd.setText("");
tel_serv.setText("");
tel_res.setText("");
tel_cel.setText("");
dat_nasc.setText("");
cpf.setText("");
rg.setText("");
nome_pai.setText("");
nome_mae.setText("");
}
private void concluir_cad_clienteActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
CallableStatement CS = null;
Connection conn = new coneccao().conectar();
if (conn != null) {
try {
ord_serv.getText();
dat_cad.getText();
nome.getText();
end.getText();
bairro.getText();
cep.getText();
//Verificar como pegar o id cidade
ddd.getText();
tel_serv.getText();
tel_res.getText();
tel_cel.getText();
dat_nasc.getText();
est_rg.getSelectedItem().toString();
rg.getText();
cpf.getText();
nome_pai.getText();
nome_mae.getText();
if (nome.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "Campo NOME Obrigat�rio!");
nome.requestFocus();
} else {
if (end.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "Campo Endereço Obrigat�rio!");
end.requestFocus();
} else {
if (bairro.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "Campo Bairro Obrigat�rio!");
bairro.requestFocus();
} else {
if (cidade.getSelectedItem().toString().equals("")) {
JOptionPane.showMessageDialog(null, "Campo Cidade Obrigat�rio!");
cidade.requestFocus();
} else {
if (dat_nasc.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "Campo Data de Nascimento é Obrigat�rio!");
dat_nasc.requestFocus();
} else {
if (rg.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "Campo RG Obrigat�rio!");
rg.requestFocus();
} else {
if (nome_mae.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "Campo Nome da Mãe é Obrigat�rio!");
nome_mae.requestFocus();
} else {
if (cpf.getText().trim().equals("")) {
JOptionPane.showMessageDialog(null, "Campo CPF é Obrigarório!");
cpf.requestFocus();
} else {
if (validaCpf(cpf.getText())) {
}
}
}
}
}
}
}
}
}
CS = conn.prepareCall("{call inserecliente(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) }");
CS.setString(1, ord_serv.getText());
CS.setString(2, dat_cad.getText());
CS.setString(3, nome.getText());
CS.setString(4, end.getText());
CS.setString(5, bairro.getText());
CS.setString(6, cep.getText());
//CS.setString(7, nome_mae.getText()); Ver id cidade
CS.setString(8, ddd.getText());
CS.setString(9, tel_serv.getText());
CS.setString(10, tel_res.getText());
CS.setString(11, tel_cel.getText());
CS.setString(12, dat_nasc.getText());
CS.setString(13, (String) est_rg.getSelectedItem());
CS.setString(14, rg.getText());
CS.setString(15, cpf.getText());
CS.setString(16, nome_pai.getText());
CS.setString(17, nome_mae.getText());
CS.executeUpdate();
conn.close();
} catch (SQLException ex) {
Logger.getLogger(Cad_cliente.class.getName()).log(Level.SEVERE, null, ex);
//Montar mensagem para erro linha de cima joga no log do sistema
}
} else {
JOptionPane.showMessageDialog(null,"Não foi possivel conctar ao banco!");
}
// codigo.setText("");
// cs= preparecall{ ?,?,?}
// cs.String(1,nome.getText());
}
private void nomeActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new Cad_cliente().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton Limpar;
private javax.swing.JTextField bairro;
private javax.swing.JFormattedTextField cep;
private javax.swing.JComboBox cidade;
private javax.swing.JButton concluir_cad_cliente;
private javax.swing.JTextField cpf;
private javax.swing.JFormattedTextField dat_cad;
private javax.swing.JFormattedTextField dat_nasc;
private javax.swing.JTextField ddd;
private javax.swing.JTextField end;
private javax.swing.JComboBox est_rg;
private javax.swing.JTextField estado;
private javax.swing.JButton fechar_tela_cad_cli;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
private javax.swing.JLabel jLabel12;
private javax.swing.JLabel jLabel13;
private javax.swing.JLabel jLabel14;
private javax.swing.JLabel jLabel15;
private javax.swing.JLabel jLabel16;
private javax.swing.JLabel jLabel17;
private javax.swing.JLabel jLabel18;
private javax.swing.JLabel jLabel19;
private javax.swing.JLabel jLabel2;
private javax.swing.JLabel jLabel20;
private javax.swing.JLabel jLabel21;
private javax.swing.JLabel jLabel22;
private javax.swing.JLabel jLabel23;
private javax.swing.JLabel jLabel24;
private javax.swing.JLabel jLabel25;
private javax.swing.JLabel jLabel26;
private javax.swing.JLabel jLabel3;
private javax.swing.JLabel jLabel4;
private javax.swing.JLabel jLabel5;
private javax.swing.JLabel jLabel6;
private javax.swing.JLabel jLabel7;
private javax.swing.JLabel jLabel8;
private javax.swing.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JTextField nome;
private javax.swing.JTextField nome_mae;
private javax.swing.JTextField nome_pai;
private javax.swing.JTextField ord_serv;
private javax.persistence.EntityManager oticaPUEntityManager;
private javax.swing.JTextField rg;
private javax.swing.JFormattedTextField tel_cel;
private javax.swing.JFormattedTextField tel_res;
private javax.swing.JFormattedTextField tel_serv;
// End of variables declaration
}