Fórum Inserir dados no BD mysql-eclipse #434447

package br.edu.devmedia.jdbc.gui;  
import java.awt.Component;  
import java.awt.event.ActionEvent;  
import java.awt.event.ActionListener;  
import java.text.DateFormat;  
import java.text.ParseException;  
  
import javax.swing.BorderFactory;  
import javax.swing.ButtonGroup;  
import javax.swing.GroupLayout;  
import javax.swing.JButton;  
import javax.swing.JComponent;  
import javax.swing.JLabel;  
import javax.swing.JPanel;  
import javax.swing.JRadioButton;  
import javax.swing.JTabbedPane;  
import javax.swing.JTextField;  
import javax.swing.LayoutStyle;  
import javax.swing.SwingConstants;  
  
import javax.swing.WindowConstants;  
import javax.swing.border.BevelBorder;  
import javax.swing.border.TitledBorder;  
import javax.swing.SwingUtilities;  
  
import br.edu.devmedia.jdbc.bo.PessoaBO;  
import br.edu.devmedia.jdbc.dto.PessoaDTO;  
import br.edu.devmedia.jdbc.util.MensagensUtil;  
  
  
/** 
* This code was edited or generated using CloudGarden's Jigloo 
* SWT/Swing GUI Builder, which is free for non-commercial 
* use. If Jigloo is being used commercially (ie, by a corporation, 
* company or business for any purpose whatever) then you 
* should purchase a license for each developer using Jigloo. 
* Please visit[url="http://www.cloudgarden.com"]www.cloudgarden.com[/url] for details. 
* Use of Jigloo implies acceptance of these licensing terms. 
* A COMMERCIAL LICENSE HAS NOT BEEN PURCHASED FOR 
* THIS MACHINE, SO JIGLOO OR THIS CODE CANNOT BE USED 
* LEGALLY FOR ANY CORPORATE OR COMMERCIAL PURPOSE. 
*/  
public class MainFrame extends javax.swing.JFrame {  
  
   /** 
    *  
    */  
     
   private static final long serialVersionUID = 7973973234717597809L;  
   private JTabbedPane mainTabbedPane;  
   private JLabel lblSexo;  
   private JRadioButton rbtFeminino;  
   private JRadioButton rbtMasculino;  
   private JLabel lblEndereco;  
   private JTextField txtEndereco;  
   private JLabel lblCpf;  
   private JTextField txtCpf;  
   private JTextField txtNome;  
   private JLabel lblNome;  
   private JPanel panelListagem;  
   private JPanel panelCadastro;  
   private ButtonGroup grpSexo;  
   private JButton btnLimpar;  
   private JButton btnCadastrar;  
   private JLabel lblNasc;  
   private JTextField txtNasc;  
     
   //Format de dates  
   private DateFormat dateFormat = SimpleDateFormat("dd/mm/yyyy");  
  
   /** 
   * Auto-generated main method to display this JFrame 
   */  
   public static void main(String[] args) {  
      SwingUtilities.invokeLater(new Runnable() {  
         public void run() {  
            MainFrame inst = new MainFrame();  
            inst.setLocationRelativeTo(null);  
            inst.setVisible(true);  
         }  
      });  
   }  
     
   private DateFormat SimpleDateFormat(String string) {  
      // TODO Auto-generated method stub  
      return null;  
   }  
  
   public MainFrame() {  
      super();  
      initGUI();  
   }  
     
   private void initGUI() {  
      try {  
         GroupLayout thisLayout = new GroupLayout((JComponent)getContentPane());  
         getContentPane().setLayout(thisLayout);  
         setDefaultCloseOperation(WindowConstants.DISPOSE_ON_CLOSE);  
         this.setTitle("Principal");  
         {  
            mainTabbedPane = new JTabbedPane();  
            {  
               panelCadastro = new JPanel();  
               GroupLayout panelCadastroLayout = new GroupLayout((JComponent)panelCadastro);  
               panelCadastro.setLayout(panelCadastroLayout);  
               mainTabbedPane.addTab("Cadastro", null, panelCadastro, null);  
               panelCadastro.setPreferredSize(new java.awt.Dimension(355, 235));  
               {  
                  lblNome = new JLabel();  
                  lblNome.setText("Nome:");  
               }  
               {  
                  txtNome = new JTextField();  
               }  
               {  
                  txtEndereco = new JTextField();  
               }  
               {  
                  rbtMasculino = new JRadioButton();  
                  rbtMasculino.setText("Masculino");  
                  rbtMasculino.setSelected(true);  
                  getGrpSexo().add(rbtMasculino);  
               }  
               {  
                  rbtFeminino = new JRadioButton();  
                  rbtFeminino.setText("Feminino");  
                  getGrpSexo().add(rbtFeminino);  
               }  
               {  
                  lblSexo = new JLabel();  
                  lblSexo.setText("Sexo:");  
               }  
               {  
                  lblEndereco = new JLabel();  
                  lblEndereco.setText("Endereço:");  
               }  
               {  
                  txtCpf = new JTextField();  
               }  
               {  
                  lblCpf = new JLabel();  
                  lblCpf.setText("CPF:");  
               }  
               panelCadastroLayout.setVerticalGroup(panelCadastroLayout.createSequentialGroup()  
                  .addContainerGap()  
                  .addGroup(panelCadastroLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)  
                      .addComponent(txtNome, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblNome, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE))  
                  .addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)  
                  .addGroup(panelCadastroLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)  
                      .addComponent(txtCpf, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblCpf, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE))  
                  .addGap(17)  
                  .addGroup(panelCadastroLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)  
                      .addComponent(txtEndereco, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblEndereco, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE))  
                  .addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)  
                  .addGroup(panelCadastroLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)  
                      .addComponent(rbtMasculino, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(rbtFeminino, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblSexo, GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE))  
                  .addGap(16)  
                  .addGroup(panelCadastroLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)  
                      .addComponent(getJTextField1(), GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(getJLabel1(), GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE))  
                  .addPreferredGap(LayoutStyle.ComponentPlacement.UNRELATED)  
                  .addGroup(panelCadastroLayout.createParallelGroup(GroupLayout.Alignment.BASELINE)  
                      .addComponent(getBtnCadastrar(), GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, 25, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(getBtnLimpar(), GroupLayout.Alignment.BASELINE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE, GroupLayout.PREFERRED_SIZE))  
                  .addContainerGap(15, 15));  
               panelCadastroLayout.setHorizontalGroup(panelCadastroLayout.createSequentialGroup()  
                  .addContainerGap()  
                  .addGroup(panelCadastroLayout.createParallelGroup()  
                      .addComponent(getJLabel1(), GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 57, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblSexo, GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 57, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblEndereco, GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 57, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblCpf, GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 57, GroupLayout.PREFERRED_SIZE)  
                      .addComponent(lblNome, GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 57, GroupLayout.PREFERRED_SIZE))  
                  .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)  
                  .addGroup(panelCadastroLayout.createParallelGroup()  
                      .addGroup(GroupLayout.Alignment.LEADING, panelCadastroLayout.createSequentialGroup()  
                          .addComponent(getJTextField1(), GroupLayout.PREFERRED_SIZE, 180, GroupLayout.PREFERRED_SIZE)  
                          .addGap(0, 12, Short.MAX_VALUE))  
                      .addGroup(GroupLayout.Alignment.LEADING, panelCadastroLayout.createSequentialGroup()  
                          .addComponent(getBtnCadastrar(), GroupLayout.PREFERRED_SIZE, 100, GroupLayout.PREFERRED_SIZE)  
                          .addGap(21)  
                          .addComponent(getBtnLimpar(), GroupLayout.PREFERRED_SIZE, 59, GroupLayout.PREFERRED_SIZE)  
                          .addGap(0, 12, Short.MAX_VALUE))  
                      .addGroup(panelCadastroLayout.createSequentialGroup()  
                          .addPreferredGap(getJTextField1(), rbtMasculino, LayoutStyle.ComponentPlacement.INDENT)  
                          .addGroup(panelCadastroLayout.createParallelGroup()  
                              .addGroup(GroupLayout.Alignment.LEADING, panelCadastroLayout.createSequentialGroup()  
                                  .addComponent(rbtMasculino, GroupLayout.PREFERRED_SIZE, 93, GroupLayout.PREFERRED_SIZE)  
                                  .addPreferredGap(LayoutStyle.ComponentPlacement.RELATED)  
                                  .addComponent(rbtFeminino, GroupLayout.PREFERRED_SIZE, 82, GroupLayout.PREFERRED_SIZE))  
                              .addComponent(txtEndereco, GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 180, GroupLayout.PREFERRED_SIZE)  
                              .addComponent(txtCpf, GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 180, GroupLayout.PREFERRED_SIZE)  
                              .addComponent(txtNome, GroupLayout.Alignment.LEADING, GroupLayout.PREFERRED_SIZE, 180, GroupLayout.PREFERRED_SIZE))  
                          .addGap(0, 0, Short.MAX_VALUE)))  
                  .addContainerGap(82, 82));  
               panelCadastroLayout.linkSize(SwingConstants.HORIZONTAL, new Component[] {getBtnCadastrar(), getBtnLimpar()});  
               panelCadastroLayout.linkSize(SwingConstants.HORIZONTAL, new Component[] {lblEndereco, lblCpf, lblNome});  
            }  
            {  
               panelListagem = new JPanel();  
               mainTabbedPane.addTab("Listagem", null, panelListagem, null);  
               GroupLayout panelListagemLayout = new GroupLayout((JComponent)panelListagem);  
               panelListagem.setLayout(panelListagemLayout);  
               panelListagem.setPreferredSize(new java.awt.Dimension(252, 185));  
               panelListagemLayout.setVerticalGroup(panelListagemLayout.createSequentialGroup());  
               panelListagemLayout.setHorizontalGroup(panelListagemLayout.createSequentialGroup());  
            }  
         }  
         thisLayout.setVerticalGroup(thisLayout.createSequentialGroup()  
            .addContainerGap()  
            .addComponent(mainTabbedPane, 0, 259, Short.MAX_VALUE)  
            .addContainerGap());  
         thisLayout.setHorizontalGroup(thisLayout.createSequentialGroup()  
            .addContainerGap(32, 32)  
            .addComponent(mainTabbedPane, GroupLayout.PREFERRED_SIZE, 360, GroupLayout.PREFERRED_SIZE)  
            .addContainerGap(54, Short.MAX_VALUE));  
         pack();  
         this.setSize(462, 321);  
      } catch (Exception e) {  
          //add your error handling code here  
         e.printStackTrace();  
      }  
   }  
     
   private ButtonGroup getGrpSexo() {  
      if(grpSexo == null) {  
         grpSexo = new ButtonGroup();  
      }  
      return grpSexo;  
   }  
     
   private JTextField getJTextField1() {  
      if(txtNasc == null) {  
         txtNasc = new JTextField();  
      }  
      return txtNasc;  
   }  
     
   private JLabel getJLabel1() {  
      if(lblNasc == null) {  
         lblNasc = new JLabel();  
         lblNasc.setText("Dt. Nasc:");  
      }  
      return lblNasc;  
   }  
     
   private JButton getBtnCadastrar() {  
      if(btnCadastrar == null) {  
         btnCadastrar = new JButton();  
         btnCadastrar.setText("Cadastrar");  
         btnCadastrar.addActionListener(new ActionListener() {  
            public void actionPerformed(ActionEvent evt) {  
               PessoaDTO pessoaDTO = new PessoaDTO();  
               try {  
                  pessoaDTO.setNome(txtNome.getText());  
                  pessoaDTO.setEndereco(txtEndereco.getText());  
                  pessoaDTO.setCpf(Long.parseLong(txtCpf.getText()));     
  
                  String nasc = txtNasc.getText();  
                  pessoaDTO.setDtNascimento(dateFormat.parse(nasc));  
                  char sexo = rbtMasculino.isSelected() ? 'M' : 'F';  
                  pessoaDTO.setSexo(sexo);  
  
                  PessoaBO pessoaBO = new PessoaBO();  
                  pessoaBO.cadastrar(pessoaDTO);  
                  MensagensUtil.addMsg(MainFrame.this, "Cadastro efetuado com sucesso!");     
               } catch(Exception e) {  
                  e.printStackTrace();  
                  MensagensUtil.addMsg(MainFrame.this, e.getMessage());              
               }  
            }  
         });  
      }  
      return btnCadastrar;  
   }  
     
   private JButton getBtnLimpar() {  
      if(btnLimpar == null) {  
         btnLimpar = new JButton();  
         btnLimpar.setText("Limpar");  
         btnLimpar.addActionListener(new ActionListener() {  
            public void actionPerformed(ActionEvent evt) {  
               txtNome.setText("");  
               txtCpf.setText("");  
               txtEndereco.setText("");  
               txtNasc.setText("");  
               txtNome.setText("");  
               rbtMasculino.setSelected(true);  
            }  
         });  
      }  
      return btnLimpar;  
   }  
  
}  


Read more: http://javafree.uol.com.br/topic-889086-Eclipse-Jigloo-e-MySql-nao-insere-dados.html#ixzz2KWNA2etE

package br.edu.devmedia.jdbc.bo;  
  
import br.edu.devmedia.jdbc.dao.PessoaDAO;  
import br.edu.devmedia.jdbc.dto.PessoaDTO;  
import br.edu.devmedia.jdbc.exception.NegocioException;  
  
public class PessoaBO {  
     
   public void cadastrar(PessoaDTO pessoaDTO) throws NegocioException {  
      try {  
         PessoaDAO pessoaDAO = new PessoaDAO();  
         pessoaDAO.inserir(pessoaDTO);  
      }   catch(Exception exception)   {  
         throw new NegocioException(exception.getMessage());  
      }  
   }  
  
}  


Read more: http://javafree.uol.com.br/topic-889086-Eclipse-Jigloo-e-MySql-nao-insere-dados.html#ixzz2KWNGfUzr