/*
* To change this license header, choose License Headers in Project Properties.
* To change this template file, choose Tools | Templates
* and open the template in the editor.
*/
package br.com.sistema.view;
import br.com.sistema.dao.ClientesDAO;
import br.com.sistema.dao.FornecedoresDAO;
import br.com.sistema.model.Clientes;
import br.com.sistema.model.Fornecedores;
import br.com.sistema.model.Utilitarios;
import br.com.sistema.model.ValidaCPFeCNPJ;
import java.awt.Color;
import java.awt.Component;
import java.awt.event.KeyEvent;
import java.util.List;
import javax.swing.JFrame;
import javax.swing.JOptionPane;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.table.DefaultTableModel;
/**
*
* @author Tampelini
*/
public class FrmFornecedores
extends javax.
swing.
JFrame {
//Metodo Listar na tabela
public void listar() {
FornecedoresDAO dao = new FornecedoresDAO();
List<Fornecedores> lista = dao.listarFornecedores();
dados.setNumRows(0);
for (Fornecedores c : lista) {
c.getId(),
c.getNome(),
c.getCnpj(),
c.getEmail(),
c.getTelefone(),
c.getCelular(),
c.getCep(),
c.getEndereco(),
c.getNumero(),
c.getComplemento(),
c.getBairro(),
c.getCidade(),
c.getUf()
});
}
}
public FrmFornecedores() {
initComponents();
this.
getContentPane().
setBackground(Color.
WHITE);
}
/**
* 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.
*/
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1
= new javax.
swing.
JPanel();
jLabel1
= new javax.
swing.
JLabel();
painel_dados
= new javax.
swing.
JPanel();
jLabel3
= new javax.
swing.
JLabel();
jLabel4
= new javax.
swing.
JLabel();
txtcel = new javax.swing.JFormattedTextField();
txtfixo = new javax.swing.JFormattedTextField();
jLabel6
= new javax.
swing.
JLabel();
txtcnpj = new javax.swing.JFormattedTextField();
jLabel7
= new javax.
swing.
JLabel();
btnbusca
= new javax.
swing.
JButton();
jLabel8
= new javax.
swing.
JLabel();
jLabel2
= new javax.
swing.
JLabel();
txtbairro = new javax.swing.JFormattedTextField();
jLabel9
= new javax.
swing.
JLabel();
txtcidade = new javax.swing.JFormattedTextField();
jLabel10
= new javax.
swing.
JLabel();
jLabel11
= new javax.
swing.
JLabel();
jLabel12
= new javax.
swing.
JLabel();
txtnumero = new javax.swing.JFormattedTextField();
jLabel13
= new javax.
swing.
JLabel();
txtcep = new javax.swing.JFormattedTextField();
jLabel14
= new javax.
swing.
JLabel();
cbuf = new javax.swing.JComboBox<>();
jLabel15
= new javax.
swing.
JLabel();
jPanel4
= new javax.
swing.
JPanel();
tabelaFornecedores
= new javax.
swing.
JTable();
jLabel16
= new javax.
swing.
JLabel();
btnpesquisar
= new javax.
swing.
JButton();
btnnovo
= new javax.
swing.
JButton();
btnsalvar
= new javax.
swing.
JButton();
btneditar
= new javax.
swing.
JButton();
btnexcluir
= new javax.
swing.
JButton();
setTitle("Cadastro de Clientes");
public void windowActivated
(java.
awt.
event.
WindowEvent evt
) {
formWindowActivated(evt);
}
});
jPanel1.
setBackground(new java.
awt.
Color(0,
102,
204));
jLabel1.
setFont(new java.
awt.
Font("Tahoma",
0,
24)); // NOI18N
jLabel1.
setForeground(new java.
awt.
Color(255,
255,
255));
jLabel1.setText("Cadastro de Fornecedores");
javax.swing.GroupLayout jPanel1Layout = new javax.swing.GroupLayout(jPanel1);
jPanel1.setLayout(jPanel1Layout);
jPanel1Layout.setHorizontalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(23, 23, 23)
.addComponent(jLabel1)
.
addContainerGap(javax.
swing.
GroupLayout.
DEFAULT_SIZE,
Short.
MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addGap(21, 21, 21)
.addComponent(jLabel1)
.
addContainerGap(20,
Short.
MAX_VALUE))
);
jTabbedPane1.
setBackground(new java.
awt.
Color(255,
255,
255));
jTabbedPane1.
addMouseListener(new java.
awt.
event.
MouseAdapter() {
public void mouseClicked
(java.
awt.
event.
MouseEvent evt
) {
jTabbedPane1MouseClicked(evt);
}
});
painel_dados.
setBackground(new java.
awt.
Color(255,
255,
255));
painel_dados.
setBorder(javax.
swing.
BorderFactory.
createEmptyBorder(1,
1,
1,
1));
painel_dadosComponentShown(evt);
}
});
jLabel3.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel3.setText("Nome:");
jLabel4.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel4.setText("E-mail:");
try {
txtcel.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("(##) #### - ####")));
ex.printStackTrace();
}
txtcel.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
try {
txtfixo.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("(##) #### - ####")));
ex.printStackTrace();
}
txtfixo.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
jLabel6.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel6.setText("CNPJ:");
try {
txtcnpj.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("##.###.###/####-##")));
ex.printStackTrace();
}
txtcnpj.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
txtcnpj.
addFocusListener(new java.
awt.
event.
FocusAdapter() {
public void focusLost
(java.
awt.
event.
FocusEvent evt
) {
txtcnpjFocusLost(evt);
}
});
jLabel7.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel7.setText("Telefone (fixo):");
btnbusca.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
btnbusca.setText("Pesquisar");
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
btnbuscaActionPerformed(evt);
}
});
jLabel8.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel8.setText("Celular:");
txtcodigo.setEditable(false);
txtcodigo.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
txtnome.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
txtnomeActionPerformed(evt);
}
});
txtemail.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
jLabel2.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel2.setText("Código:");
txtend.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
txtcomplemento.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
txtbairro.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
jLabel9.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel9.setText("CEP:");
txtcidade.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
txtcidadeActionPerformed(evt);
}
});
jLabel10.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel10.setText("Endereço:");
jLabel11.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel11.setText("Complemento:");
jLabel12.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel12.setText("Bairro:");
txtnumero.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
jLabel13.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel13.setText("Nº:");
try {
txtcep.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("#####-###")));
ex.printStackTrace();
}
txtcep.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
txtcep.
addKeyListener(new java.
awt.
event.
KeyAdapter() {
public void keyPressed
(java.
awt.
event.
KeyEvent evt
) {
txtcepKeyPressed(evt);
}
});
jLabel14.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel14.setText("UF:");
cbuf.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
cbuf.
setModel(new javax.
swing.
DefaultComboBoxModel<>(new String[] { "AC",
"AL",
"AP",
"AM",
"BA",
"CE",
"DF",
"ES",
"GO",
"MA",
"MT",
"MS",
"MG",
"PA",
"PB",
"PR",
"PE",
"PI",
"RJ",
"RN",
"RS",
"RO",
"RR",
"SC",
"SP",
"SE",
"TO" }));
jLabel15.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel15.setText("Cidade:""Dados Pessoais", painel_dados);
jPanel4.
setBackground(new java.
awt.
Color(255,
255,
255));
jPanel4.
addFocusListener(new java.
awt.
event.
FocusAdapter() {
public void focusGained
(java.
awt.
event.
FocusEvent evt
) {
jPanel4FocusGained(evt);
}
});
jPanel4.
addMouseListener(new java.
awt.
event.
MouseAdapter() {
public void mouseClicked
(java.
awt.
event.
MouseEvent evt
) {
jPanel4MouseClicked(evt);
}
});
jPanel4ComponentShown(evt);
}
});
tabelaFornecedores
= new javax.
swing.
JTable(){
public boolean isCellEditable(int rowIndex, int mColIndex) {
return false;
}
};
tabelaFornecedores.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
},
"Código", "Nome", "CNPJ", "E-mail", "Telefone", "Celular", "Cep", "Endereço", "Nº", "Comp", "Bairro", "Cidade", "UF"
}
));
tabelaFornecedores.
addMouseListener(new java.
awt.
event.
MouseAdapter() {
public void mouseClicked
(java.
awt.
event.
MouseEvent evt
) {
tabelaFornecedoresMouseClicked(evt);
}
});
jScrollPane1.setViewportView(tabelaFornecedores);
jLabel16.
setFont(new java.
awt.
Font("Tahoma",
0,
12)); // NOI18N
jLabel16.setText("Nome:");
txtpesquisa.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
txtpesquisa.
addKeyListener(new java.
awt.
event.
KeyAdapter() {
public void keyPressed
(java.
awt.
event.
KeyEvent evt
) {
txtpesquisaKeyPressed(evt);
}
});
btnpesquisar.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
btnpesquisar.setText("Pesquisar");
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
btnpesquisarActionPerformed(evt);
}
});
javax.swing.GroupLayout jPanel4Layout = new javax.swing.GroupLayout(jPanel4);
jPanel4.setLayout(jPanel4Layout);
jPanel4Layout.setHorizontalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addContainerGap()
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.
addComponent(jScrollPane1, javax.
swing.
GroupLayout.
DEFAULT_SIZE,
959,
Short.
MAX_VALUE)
.addGroup(jPanel4Layout.createSequentialGroup()
.addComponent(jLabel16)
.addGap(9, 9, 9)
.addComponent(txtpesquisa, javax.swing.GroupLayout.PREFERRED_SIZE, 316, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(18, 18, 18)
.addComponent(btnpesquisar)
.
addGap(0,
0,
Short.
MAX_VALUE)))
.addContainerGap())
);
jPanel4Layout.setVerticalGroup(
jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(35, 35, 35)
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel4Layout.createSequentialGroup()
.addGap(5, 5, 5)
.addComponent(jLabel16))
.addGroup(jPanel4Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
.addComponent(txtpesquisa, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btnpesquisar)))
.addGap(32, 32, 32)
.
addComponent(jScrollPane1, javax.
swing.
GroupLayout.
DEFAULT_SIZE,
243,
Short.
MAX_VALUE)
.addGap(35, 35, 35))
);
jTabbedPane1.addTab("Consulta de Fornecedores", jPanel4);
btnnovo.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
btnnovo.setText("+ Novo");
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
btnnovoActionPerformed(evt);
}
});
btnsalvar.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
btnsalvar.setText("Salvar");
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
btnsalvarActionPerformed(evt);
}
});
btneditar.setEnabled( false );// desabilita o botão editar
btneditar.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
btneditar.setText("Editar");
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
btneditarActionPerformed(evt);
}
});
btnexcluir.setEnabled( false );//desabilita o botão escluir
btnexcluir.
setFont(new java.
awt.
Font("Tahoma",
0,
14)); // NOI18N
btnexcluir.setText("Excluir");
public void actionPerformed
(java.
awt.
event.
ActionEvent evt
) {
btnexcluirActionPerformed(evt);
}
});
javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
getContentPane().setLayout(layout);
layout.setHorizontalGroup(
layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.
addComponent(jPanel1, javax.
swing.
GroupLayout.
DEFAULT_SIZE, javax.
swing.
GroupLayout.
DEFAULT_SIZE,
Short.
MAX_VALUE)
.addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
.
addContainerGap(javax.
swing.
GroupLayout.
DEFAULT_SIZE,
Short.
MAX_VALUE)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap())
.addGroup(layout.createSequentialGroup()
.addGap(271, 271, 271)
.addComponent(btnnovo, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(6, 6, 6)
.addComponent(btnsalvar, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(10, 10, 10)
.addComponent(btneditar, javax.swing.GroupLayout.PREFERRED_SIZE, 108, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(10, 10, 10)
.addComponent(btnexcluir, javax.swing.GroupLayout.PREFERRED_SIZE, 108, 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)
.addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
.addComponent(jTabbedPane1, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
.addGap(41, 41, 41)
.addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addComponent(btnnovo, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btnsalvar, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btneditar, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE)
.addComponent(btnexcluir, javax.swing.GroupLayout.PREFERRED_SIZE, 42, javax.swing.GroupLayout.PREFERRED_SIZE))
.
addContainerGap(27,
Short.
MAX_VALUE))
);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void txtcidadeActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
// TODO add your handling code here:
}
private void btnbuscaActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
// botao buscar cliente por nome
String nome
= txtnome.
getText();
Fornecedores obj = new Fornecedores();
FornecedoresDAO dao = new FornecedoresDAO();
obj = dao.consultaPorNome(nome);
if (obj.getNome() != null) {
//Exibi os dados do obj nos campos de texto
txtcodigo.
setText(String.
valueOf(obj.
getId()));
txtnome.setText(obj.getNome());
txtcnpj.setText(obj.getCnpj());
txtemail.setText(obj.getEmail());
txtfixo.setText(obj.getTelefone());
txtcel.setText(obj.getCelular());
txtcep.setText(obj.getCep());
txtend.setText(obj.getEndereco());
txtnumero.
setText(String.
valueOf(obj.
getNumero()));
txtcomplemento.setText(obj.getComplemento());
txtbairro.setText(obj.getBairro());
txtcidade.setText(obj.getCidade());
cbuf.setSelectedItem(obj.getUf());
} else {
JOptionPane.
showMessageDialog(null,
"Fornecedor não encontrado!");
}
}
private void txtcepKeyPressed
(java.
awt.
event.
KeyEvent evt
) {
//Programacao do keypress
if (evt.
getKeyCode() == KeyEvent.
VK_ENTER) {
Clientes obj = new Clientes();
ClientesDAO dao = new ClientesDAO();
obj = dao.buscaCep(txtcep.getText());
txtend.setText(obj.getEndereco());
txtbairro.setText(obj.getBairro());
txtcidade.setText(obj.getCidade());
cbuf.setSelectedItem(obj.getUf());
}
}
private void btnpesquisarActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
// Botao pesquisar
String nome
= "%" + txtpesquisa.
getText() + "%";
FornecedoresDAO dao = new FornecedoresDAO();
List<Fornecedores> lista = dao.listarFornecedoresPorNome(nome);
dados.setNumRows(0);
for (Fornecedores c : lista) {
c.getId(),
c.getNome(),
c.getCnpj(),
c.getEmail(),
c.getTelefone(),
c.getCelular(),
c.getCep(),
c.getEndereco(),
c.getNumero(),
c.getComplemento(),
c.getBairro(),
c.getCidade(),
c.getUf()
});
}
}
private void txtnomeActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
// TODO add your handling code here:
}
private void btnsalvarActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
// boto salvar
int lib = 0;
if(txtnome.getText().equals("")){//campo nome vazio
msg += "\n Nome ";
lib++;
}
if(txtcnpj.getText().equals(" . . / - ")){//campo cpf vazio
msg += "\n CNPJ ";
lib++;
//JOptionPane.showMessageDialog(null, " Campo CPF está Vazio ", "ERRO AO CADASTRAR ", HEIGHT);
}
if(txtcep.getText().equals(" - ")){//campo cep vazio
msg += "\n CEP ";
lib++;
//JOptionPane.showMessageDialog(null, " Campo CEP está Vazio ", "ERRO AO CADASTRAR ", HEIGHT);
}
if(txtcel.getText().equals("( ) - ")){//campo celular vazio
msg += "\n Celular ";
lib++;
//JOptionPane.showMessageDialog(null, " Campo Celular está Vazio ", "ERRO AO CADASTRAR ", HEIGHT);
}
if (txtnumero.getText().equals("")){//se o numero da residencia estiver nulo seta 0
txtnumero.setText("0");
}
if (lib == 0){
Fornecedores obj = new Fornecedores();
obj.setNome(txtnome.getText());
obj.setCnpj(txtcnpj.getText());
obj.setEmail(txtemail.getText());
obj.setTelefone(txtfixo.getText());
obj.setCelular(txtcel.getText());
obj.setCep(txtcep.getText());
obj.setEndereco(txtend.getText());
obj.
setNumero(Integer.
parseInt(txtnumero.
getText()));
obj.setComplemento(txtcomplemento.getText());
obj.setBairro(txtbairro.getText());
obj.setCidade(txtcidade.getText());
obj.setUf(cbuf.getSelectedItem().toString());
FornecedoresDAO dao = new FornecedoresDAO();
dao.cadastrarFornecedores(obj);
new Utilitarios().LimpaTela(painel_dados);
}else{
msg += "\n\n Estão Vazios.";
JOptionPane.
showMessageDialog(null, msg,
"ERRO AO CADASTRAR ", HEIGHT
);
}
}
private void formWindowActivated
(java.
awt.
event.
WindowEvent evt
) {
// Carrega a lista
listar();
}
private void tabelaFornecedoresMouseClicked
(java.
awt.
event.
MouseEvent evt
) {
//Pega os dados
if (evt.getClickCount() == 2) {
jTabbedPane1.setSelectedIndex(0);
txtcodigo.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 0).toString());
txtnome.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 1).toString());
txtcnpj.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 2).toString());
txtemail.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 3).toString());
txtfixo.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 4).toString());
txtcel.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 5).toString());
txtcep.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 6).toString());
txtend.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 7).toString());
txtnumero.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 8).toString());
txtcomplemento.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 9).toString());
txtbairro.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 10).toString());
txtcidade.setText(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 11).toString());
cbuf.setSelectedItem(tabelaFornecedores.getValueAt(tabelaFornecedores.getSelectedRow(), 12).toString());
}
}
private void btneditarActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
// botao editar
int op;
op
= JOptionPane.
showConfirmDialog(null,
"Você tem certeza que deseja editar?");
if (op == 0) {
Fornecedores obj = new Fornecedores();
obj.setNome(txtnome.getText());
obj.setCnpj(txtcnpj.getText());
obj.setEmail(txtemail.getText());
obj.setTelefone(txtfixo.getText());
obj.setCelular(txtcel.getText());
obj.setCep(txtcep.getText());
obj.setEndereco(txtend.getText());
obj.
setNumero(Integer.
parseInt(txtnumero.
getText()));
obj.setComplemento(txtcomplemento.getText());
obj.setBairro(txtbairro.getText());
obj.setCidade(txtcidade.getText());
obj.setUf(cbuf.getSelectedItem().toString());
obj.
setId(Integer.
parseInt(txtcodigo.
getText()));
FornecedoresDAO dao = new FornecedoresDAO();
dao.alterarFornecedor(obj);
new Utilitarios().LimpaTela(painel_dados);
btnsalvar.setEnabled( true );// habilita o botão salvar
btneditar.setEnabled( false );// desabilita o botão editar
btnexcluir.setEnabled( false );// desabilita o botão escluir
btnnovo.setEnabled( true );// habilita o botão escluir
}
}
private void btnexcluirActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
// botao excluir
int op;
op
= JOptionPane.
showConfirmDialog(null,
"Você tem certeza que deseja excluir?");
if (op == 0) {
Fornecedores obj = new Fornecedores();
obj.
setId(Integer.
parseInt(txtcodigo.
getText()));
FornecedoresDAO dao = new FornecedoresDAO();
dao.excluirFornecedor(obj);
new Utilitarios().LimpaTela(painel_dados);
btnsalvar.setEnabled( true );// habilita o botão salvar
btneditar.setEnabled( false );// desabilita o botão editar
btnexcluir.setEnabled( false );// desabilita o botão escluir
btnnovo.setEnabled( true );// habilita o botão escluir
}
}
private void txtpesquisaKeyPressed
(java.
awt.
event.
KeyEvent evt
) {
String nome
= "%" + txtpesquisa.
getText() + "%";
FornecedoresDAO dao = new FornecedoresDAO();
List<Fornecedores> lista = dao.listarFornecedoresPorNome(nome);
dados.setNumRows(0);
for (Fornecedores c : lista) {
c.getId(),
c.getNome(),
c.getCnpj(),
c.getEmail(),
c.getTelefone(),
c.getCelular(),
c.getCep(),
c.getEndereco(),
c.getNumero(),
c.getComplemento(),
c.getBairro(),
c.getCidade(),
c.getUf()
});
}
}
private void btnnovoActionPerformed
(java.
awt.
event.
ActionEvent evt
) {
new Utilitarios().LimpaTela(painel_dados);
btnsalvar.setEnabled( true );// habilita o botão salvar
btneditar.setEnabled( false );// desabilita o botão editar
btnexcluir.setEnabled( false );// desabilita o botão escluir
btnnovo.setEnabled( true );// habilita o botão escluir
}
private void jTabbedPane1MouseClicked
(java.
awt.
event.
MouseEvent evt
) {
// TODO add your handling code here:
}
private void jPanel4MouseClicked
(java.
awt.
event.
MouseEvent evt
) {
// TODO add your handling code here:
}
private void jPanel4FocusGained
(java.
awt.
event.
FocusEvent evt
) {
// TODO add your handling code here:
}
private void jPanel4ComponentShown
(java.
awt.
event.
ComponentEvent evt
) {
// TODO add your handling code here:
btnsalvar.setEnabled( false );// desabilita o botão salvar
btneditar.setEnabled( false );// desabilita o botão editar
btnexcluir.setEnabled( false );// desabilita o botão escluir
btnnovo.setEnabled( false );// desabilita o botão escluir
}
private void painel_dadosComponentShown
(java.
awt.
event.
ComponentEvent evt
) {
// TODO add your handling code here:
if(txtcodigo.getText().equals("")){
btnsalvar.setEnabled( true );// habilita o botão salvar
btneditar.setEnabled( false );// desabilita o botão editar
btnexcluir.setEnabled( false );// desabilita o botão escluir
btnnovo.setEnabled( true );// habilita o botão escluir
}else{
btnsalvar.setEnabled( false );// desabilita o botão salvar
btneditar.setEnabled( true );// habilita o botão editar
btnexcluir.setEnabled( true );// habilita o botão escluir
btnnovo.setEnabled( true );// habilita o botão escluir
}
}
private void txtcnpjFocusLost
(java.
awt.
event.
FocusEvent evt
) {
// TODO add your handling code here:
// ao sair do jtextfield verifica se o CNPJ é valid
ValidaCPFeCNPJ model = new ValidaCPFeCNPJ();
Fornecedores obj = new Fornecedores();
if(txtcnpj.getText().equals(" . . / - ")){// compara se a txtCNPJ está vazia
}
else{
if (obj.equalsCpf(txtcnpj.getText())) {// se for false...
JOptionPane.
showMessageDialog(null,
"CNPJ Já Cadastrado");
}else{
boolean testecpf = model.isCNPJ(txtcnpj.getText());// envia o CNPJ para a validação
if (testecpf == false) {// se for false...
txtcnpj.setText(obj.getCpf());//seta null no campo cpf
}
}
}
}
/**
* @param args the command line arguments
*/
public static void main
(String args
[]) {
/* Set the Nimbus look and feel */
//<editor-fold defaultstate="collapsed" desc=" Look and feel setting code (optional) ">
/* If Nimbus (introduced in Java SE 6) is not available, stay with the default look and feel.
* For details see http://download.oracle.com/javase/tutorial/uiswing/lookandfeel/plaf.html
*/
try {
if ("Windows".equals(info.getName())) {
javax.
swing.
UIManager.
setLookAndFeel(info.
getClassName());
break;
}
}
java.util.logging.Logger.getLogger(FrmFornecedores.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
java.util.logging.Logger.getLogger(FrmFornecedores.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
java.util.logging.Logger.getLogger(FrmFornecedores.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
java.util.logging.Logger.getLogger(FrmFornecedores.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
//</editor-fold>
/* Create and display the form */
public void run() {
new FrmFornecedores().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.
swing.
JButton btnbusca
;
private javax.
swing.
JButton btneditar
;
private javax.
swing.
JButton btnexcluir
;
private javax.
swing.
JButton btnnovo
;
private javax.
swing.
JButton btnpesquisar
;
private javax.
swing.
JButton btnsalvar
;
private javax.swing.JComboBox<String> cbuf;
private javax.
swing.
JLabel jLabel1
;
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 jLabel2
;
private javax.
swing.
JLabel jLabel3
;
private javax.
swing.
JLabel jLabel4
;
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.
JPanel jPanel4
;
private javax.
swing.
JPanel painel_dados
;
private javax.
swing.
JTable tabelaFornecedores
;
private javax.swing.JFormattedTextField txtbairro;
private javax.swing.JFormattedTextField txtcel;
private javax.swing.JFormattedTextField txtcep;
private javax.swing.JFormattedTextField txtcidade;
private javax.swing.JFormattedTextField txtcnpj;
private javax.swing.JFormattedTextField txtfixo;
private javax.swing.JFormattedTextField txtnumero;
// End of variables declaration
}