package classes;
//// Meus imports
import java.awt.event.ActionListener;
import javax.swing.*;
import java.awt.event.ActionEvent;
import java.awt.event.KeyEvent;
import java.sql.*;
import java.awt.*;
import java.awt.event.KeyListener;
public class ProjetoEnivelton extends JFrame {
/// meus fields
final JMenuBar barra=new JMenuBar ();
final JMenu menu=new JMenu("arquivo");
final JTextField jt1=new JTextField();
final JTextField jt2=new JTextField();
final JTextField jt3=new JTextField();
final JTextField jt4=new JTextField();
final JTextField jt5=new JTextField();
// textarea
//final JMenu menu=new JMenu("arquivo");
final JTextField jt6=new JTextField();
final JTextField jt7=new JTextField();
final JTextField jt8=new JTextField();
final JTextField jt9=new JTextField();
final JTextArea ja1=new JTextArea();
public static void main(String[] args) {
ProjetoEnivelton tab = new ProjetoEnivelton();
tab.setVisible(true);
}
public ProjetoEnivelton() {
super();
getContentPane().setLayout(null);
this.setSize(530,450);
this.setLocationRelativeTo(null);
this.setTitle("super mercados");
getContentPane().add(barra);
setJMenuBar(barra);
barra.add(menu);
JMenuItem sair=new JMenuItem("Sair");
menu.add(sair);
////////////aba1
final JTabbedPane tabbedPane = new JTabbedPane();
tabbedPane.setBounds(0, 0, 502, 371);
getContentPane().add(tabbedPane);
final JPanel panel = new JPanel();
panel.setLayout(null);
tabbedPane.addTab("Ajuda", null, panel, null);
ja1.setText
(" - para inserir digite corretamente nos campos e click em adicionar. \n\n - para excluir digite apenas o nome e clique em excluir.\n\n - para localizar digite apenas o nome na aba debito da mesma forma. \n\n-----------------------(preste aten��o nas liga��es do codigo de cada tabela)------------------------ ");
ja1.setBounds(0,0 ,500 ,370 );
panel.add(ja1);
//ABA 2 (debito)
final JPanel panel_3 = new JPanel();
panel_3.setLayout(null);
tabbedPane.addTab("cliente", null, panel_3, null);
// adicionar registro a tabela
final JButton inserir=new JButton("adicionar");
inserir.setBounds(100,110 ,100 ,20 );
panel_3.add(inserir);
//apagar registro
final JButton limpar=new JButton("limpar");
limpar.setBounds(200,110 ,100 ,20 );
panel_3.add(limpar);
//jtextfields /////////////////////////////////////////////////////////
//add fields codigo
final JLabel cod = new JLabel();
cod.setText(" cod:");
cod.setBounds(130, 00,50,20);
panel_3.add(cod);
jt1.setBounds(180,00 ,100 ,20 );
panel_3.add(jt1);
//add fields nome
final JLabel nome = new JLabel();
nome.setText(" nome:");
nome.setBounds(130, 22,50,20);
panel_3.add(nome);
jt2.setBounds(180,22 ,100 ,20 );
panel_3.add(jt2);
// add fields endereço
final JLabel end = new JLabel();
end.setText(" end:");
end.setBounds(130, 44,50,20);
panel_3.add(end);
jt3.setBounds(180,44 ,100 ,20 );
panel_3.add(jt3);
//add fields tel
final JLabel tel = new JLabel();
tel.setText(" tel:");
tel.setBounds(130, 66,50,20);
panel_3.add(tel);
jt4.setBounds(180,66 ,100 ,20 );
cod.setText(" cod:");
panel_3.add(jt4);
//add fields sexo
final JLabel sexo = new JLabel();
sexo.setText(" sexo:");
sexo.setBounds(130, 88,50,20);
panel_3.add(sexo);
jt5.setBounds(180,88 ,100 ,20 );
panel_3.add(jt5);
//ABA 3 (dados do cliente)
final JPanel panel_1 = new JPanel();
panel_1.setLayout(null);
tabbedPane.addTab("debito", null, panel_1, null);
final JLabel cod1 = new JLabel();
cod1.setText(" cod_debito:");
cod1.setBounds(100, 04,100,20);
panel_1.add(cod1);
jt6.setBounds(200,04 ,100 ,20 );
panel_1.add(jt6);
//add fields cod_c
final JLabel nome1 = new JLabel();
nome1.setText(" cod_cliente:");
nome1.setBounds(100, 26,100,20);
panel_1.add(nome1);
jt7.setBounds(200,26 ,100 ,20 );
panel_1.add(jt7);
// add fields valor
final JLabel end1 = new JLabel();
end1.setText(" valor_da_divida:");
end1.setBounds(100, 48,150,20);
panel_1.add(end1);
jt8.setBounds(200,48 ,100 ,20 );
panel_1.add(jt8);
//add fields data
final JLabel tel1 = new JLabel();
tel1.setText(" data_pagamento:");
tel1.setBounds(100, 70,150,20);
panel_1.add(tel1);
jt9.setBounds(200,70,100 ,20 );
panel_1.add(jt9);
final JButton inserir2=new JButton("adicionar");
inserir2.setBounds(100,92 ,100 ,20);
panel_1.add(inserir2);
final JButton limpar2=new JButton("limpar");
limpar2.setBounds(200,92 ,100 ,20);
panel_1.add(limpar2);
///////////////////////////////////////////////////////////////////////
sair.addActionListener(
new ActionListener(){
public void actionPerformed(ActionEvent event){
//colocar botoes em portugues
Object opcao[]={"Sim","Não"};
int i=JOptionPane.showOptionDialog(null,"Deseja sair?","Sair",JOptionPane.YES_NO_OPTION,JOptionPane.QUESTION_MESSAGE,null,opcao,opcao[0]);
if (i==JOptionPane.YES_OPTION)
System.exit(0);
}
}
);
//////////////////////////////////////////////////////////////////////////////////////////
limpar.addActionListener(
new ActionListener(){
public void actionPerformed( ActionEvent e )
{
jt1.setText( "" );
jt2.setText( "" );
jt3.setText( "" );
jt4.setText( "" );
jt5.setText( "" );
}}
);
limpar2.addActionListener(
new ActionListener(){
public void actionPerformed( ActionEvent e )
{
jt6.setText( "" );
jt7.setText( "" );
jt8.setText( "" );
jt9.setText( "" );
}}
);
////////////////////////////////////////////////////////////////////////////////////////
jt1.addKeyListener(new KeyListener(){
public void keyTyped(KeyEvent e) {
char c = e.getKeyChar();
if(!Character.isDigit(c)){
e.consume();
}
}
public void keyPressed(KeyEvent e) {
}
public void keyReleased(KeyEvent e) {
// TODO Auto-generated method stub
}
});
///////////////////////////////////////////////////////////////////////
jt6.addKeyListener(new KeyListener(){
public void keyTyped(KeyEvent e) {
char c = e.getKeyChar();
if(!Character.isDigit(c)){
e.consume();
}
}
public void keyPressed(KeyEvent e) {
}
public void keyReleased(KeyEvent e) {
// TODO Auto-generated method stub
}
});
/////////////////////////////////////////////////////////////////////
jt7.addKeyListener(new KeyListener(){
public void keyTyped(KeyEvent e) {
char c = e.getKeyChar();
if(!Character.isDigit(c)){
e.consume();
}
}
public void keyPressed(KeyEvent e) {
}
public void keyReleased(KeyEvent e) {
// TODO Auto-generated method stub
}
});
///////////////////////////////////////////////////////////////////
jt8.addKeyListener(new KeyListener(){
public void keyTyped(KeyEvent e) {
char c = e.getKeyChar();
if(!Character.isDigit(c)){
e.consume();
}
}
public void keyPressed(KeyEvent e) {
}
public void keyReleased(KeyEvent e) {
// TODO Auto-generated method stub
}
});
////////////////////////////////////////////////////////////////////////
jt4.addKeyListener(new KeyListener(){
public void keyTyped(KeyEvent e) {
char c = e.getKeyChar();
if(!Character.isDigit(c)){
e.consume();
}
}
public void keyPressed(KeyEvent e) {
}
public void keyReleased(KeyEvent e) {
// TODO Auto-generated method stub
}
});
////////////////////////////////////////////////////////////////////////
inserir.addActionListener((ActionListener) new ActionListener(){
public void actionPerformed(ActionEvent event){
inserirTabela();//chama metodo para inserção
}});
this.setSize(502,371);
inserir2.addActionListener((ActionListener) new ActionListener(){
public void actionPerformed(ActionEvent e){
inserirdebito();//chama metodo para inserção
}});
this.setSize(502,371);
}
//cria o metodo que insere dados
private void inserirTabela(){
//parter a ser resovida
private boolean verificarCamposPreenchidos(){
if(jt1.getText().equals("")){
JOptionPane.showMessageDialog(null,"campo codigo vazio");
return false;
}
if(jt2.getText().equals("")){
JOptionPane.showMessageDialog(null,"campo nome vazio");
return false;
}
if(jt3.getText().equals("")) {
JOptionPane.showMessageDialog(null,"campo endereço vazio");
return false;
}
if(jt4.getText().equals("")) {
JOptionPane.showMessageDialog(null,"campo telefone vazio");
return false;
}
if(jt5.getText().equals("")) {
JOptionPane.showMessageDialog(null,"campo vazio");
return false;
}
return true;
}
//////////////////////////////////////////////////////////////////////////////
Connection con=null;
PreparedStatement ps=null;
try{
//inicializa a conexão
con=DriverManager.getConnection("jdbc:odbc:BD1");
//aqui insere dados
ps=con.prepareStatement("insert into Cliente(codigo,nome,endereco,telefone,sexo)values(?,?,?,?,?);");
//pega o dado do JTextField
ps.setString(1,jt1.getText());
ps.setString(2,jt2.getText());
ps.setString(3,jt3.getText());
ps.setString(4,jt4.getText());
ps.setString(5,jt5.getText());
//coloca os dados no bd
ps.executeUpdate();
//limpa JTextField
jt1.setText("");
jt2.setText("");
jt3.setText("");
jt4.setText("");
jt5.setText("");
//coloca o foco no componente jt1
jt1.requestFocus();
JOptionPane.showMessageDialog(null,"Registro Inserido","Registro",JOptionPane.INFORMATION_MESSAGE);
}
catch(Exception event){
event.printStackTrace();
JOptionPane.showMessageDialog(null,"Conex�o n�o estabelecida ou campo repitido \n certifique se digitou corretamente\n" +event.toString(),"Falha",JOptionPane.ERROR_MESSAGE);
}
finally{
try{
if(ps!=null){
ps.close();//termina a inserção
}
if(con!=null){
con.close();//termina a inserção
}
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Erro Geral","Erro",JOptionPane.ERROR_MESSAGE);
}
///////////////////////////////////////////////////////////////////////
}
}
//cria o metodo que insere dados
private void inserirdebito(){
Connection con=null;
PreparedStatement ps=null;
try{
//inicializa a conexão
con=DriverManager.getConnection("jdbc:odbc:BD1");
//aqui insere dados
ps=con.prepareStatement("insert into debito(cod_D,cod_c,valor,data)values(?,?,?,?);");
//pega o dado do JTextField
ps.setString(1,jt6.getText());
ps.setString(2,jt7.getText());
ps.setString(3,jt8.getText());
ps.setString(4,jt9.getText());
//coloca os dados no bd
ps.executeUpdate();
//limpa JTextField
jt6.setText("");
jt7.setText("");
jt8.setText("");
jt9.setText("");
//coloca o foco no componente jt1
jt6.requestFocus();
JOptionPane.showMessageDialog(null,"Registro Inserido","Registro",JOptionPane.INFORMATION_MESSAGE);
}
catch(Exception e){
e.printStackTrace();
JOptionPane.showMessageDialog(null,"Conex�o n�o estabelecida ou campo repitido \n certifique se digitou corretamente\n" +e.toString(),"Falha",JOptionPane.ERROR_MESSAGE);
}
finally{
try{
if(ps!=null){
ps.close();//termina a inserção
}
if(con!=null){
con.close();//termina a inserção
}
}
catch(SQLException ex){
JOptionPane.showMessageDialog(null,"Erro Geral","Erro",JOptionPane.ERROR_MESSAGE);
}
}
}
}
