Fiz um outro sistema mais simples pra testa se a conexão pegava e armazenava as informações no banco de dados , deu certo.
mas quando fui fazer sistema , segui os mesmos passos mais na hora de cadastra dava erro:
Exception in thread “AWT-EventQueue-0” java.lang.RuntimeException: java.sql.SQLException: Data truncated for column ‘nr_cpf’ at row 1.
Classe UsuarioDAO
package dao;
import factory.ConnectionFactory;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import javax.swing.JOptionPane;
import modelo.Usuario;
public class UsuarioDAO {
private Connection connection;
long id;
String nome, dtNascimento, eMail, cpf, sexo,senha;
public UsuarioDAO() {
this.connection = new ConnectionFactory().getConnection();
}
public void insert(Usuario usuario){
String sql = "INSERT INTO tb_usuario(nm_nome,dt_nascimento,e_mail,nr_cpf,sexo,nr_senha) VALUES(?,?,?,?,?,?)";
System.out.print(usuario.getDtNascimento());
try {
PreparedStatement stmt = connection.prepareStatement(sql);
stmt.setString(1, usuario.getNome());
stmt.setString(2, usuario.getDtNascimento());
stmt.setString(3, usuario.geteMail());
stmt.setString(4, usuario.getCpf());
stmt.setString(5, usuario.getSexo());
stmt.setString(6, usuario.getSenha());
stmt.execute();
stmt.close();
JOptionPane.showMessageDialog(null, "USUARIO " + nome + "CADASTRADO COM SUCESSO!");
}
catch (SQLException u) {
throw new RuntimeException(u);
}
}
}
Classe TelaCadastro
package view;
import dao.UsuarioDAO;
import javax.swing.JOptionPane;
import modelo.Usuario;
public class TelaCadastro extends javax.swing.JFrame {
public TelaCadastro() {
initComponents();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
jLabel4 = new javax.swing.JLabel();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
txtNome = new javax.swing.JTextField();
txtEmail = new javax.swing.JTextField();
jPSenha = new javax.swing.JPasswordField();
txtDataNasc = new javax.swing.JFormattedTextField();
txtCpf = new javax.swing.JFormattedTextField();
jLabel7 = new javax.swing.JLabel();
jBLimpar = new javax.swing.JButton();
jRMasculino = new javax.swing.JRadioButton();
jRFeminino = new javax.swing.JRadioButton();
jBCadastrar = new javax.swing.JButton();
jBRetornar = new javax.swing.JButton();
jLabel8 = new javax.swing.JLabel();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setMinimumSize(new java.awt.Dimension(500, 441));
setResizable(false);
getContentPane().setLayout(null);
jLabel1.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jLabel1.setForeground(new java.awt.Color(255, 255, 255));
jLabel1.setText("NOME:");
getContentPane().add(jLabel1);
jLabel1.setBounds(40, 80, 34, 14);
jLabel2.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jLabel2.setForeground(new java.awt.Color(255, 255, 255));
jLabel2.setText("DATA NASCIMENTO:");
getContentPane().add(jLabel2);
jLabel2.setBounds(40, 110, 110, 30);
jLabel3.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jLabel3.setForeground(new java.awt.Color(255, 255, 255));
jLabel3.setText("E-MAIL:");
getContentPane().add(jLabel3);
jLabel3.setBounds(40, 150, 43, 30);
jLabel4.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jLabel4.setForeground(new java.awt.Color(255, 255, 255));
jLabel4.setText("CPF:");
getContentPane().add(jLabel4);
jLabel4.setBounds(40, 190, 30, 20);
jLabel5.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jLabel5.setForeground(new java.awt.Color(255, 255, 255));
jLabel5.setText("SEXO:");
getContentPane().add(jLabel5);
jLabel5.setBounds(40, 230, 40, 20);
jLabel6.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jLabel6.setForeground(new java.awt.Color(255, 255, 255));
jLabel6.setText("SENHA:");
getContentPane().add(jLabel6);
jLabel6.setBounds(40, 260, 40, 30);
txtNome.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtNomeActionPerformed(evt);
}
});
getContentPane().add(txtNome);
txtNome.setBounds(100, 70, 370, 30);
getContentPane().add(txtEmail);
txtEmail.setBounds(100, 150, 370, 30);
getContentPane().add(jPSenha);
jPSenha.setBounds(100, 260, 370, 30);
try {
txtDataNasc.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("##/##/####")));
} catch (java.text.ParseException ex) {
ex.printStackTrace();
}
txtDataNasc.setDragEnabled(true);
txtDataNasc.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
txtDataNascActionPerformed(evt);
}
});
getContentPane().add(txtDataNasc);
txtDataNasc.setBounds(170, 110, 299, 30);
try {
txtCpf.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("###.###.###-##")));
} catch (java.text.ParseException ex) {
ex.printStackTrace();
}
getContentPane().add(txtCpf);
txtCpf.setBounds(100, 190, 370, 30);
jLabel7.setFont(new java.awt.Font("Tahoma", 1, 48)); // NOI18N
jLabel7.setForeground(new java.awt.Color(255, 255, 255));
jLabel7.setText("CADASTRO");
getContentPane().add(jLabel7);
jLabel7.setBounds(110, 0, 265, 58);
jBLimpar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBLimpar.setText("LIMPAR");
jBLimpar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBLimparActionPerformed(evt);
}
});
getContentPane().add(jBLimpar);
jBLimpar.setBounds(100, 310, 120, 40);
jRMasculino.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jRMasculino.setForeground(new java.awt.Color(255, 255, 255));
jRMasculino.setText("MASCULINO");
getContentPane().add(jRMasculino);
jRMasculino.setBounds(100, 230, 100, 23);
jRFeminino.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jRFeminino.setForeground(new java.awt.Color(255, 255, 255));
jRFeminino.setText("FEMININO");
getContentPane().add(jRFeminino);
jRFeminino.setBounds(230, 230, 90, 23);
jBCadastrar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBCadastrar.setText("CADASTRAR");
jBCadastrar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBCadastrarActionPerformed(evt);
}
});
getContentPane().add(jBCadastrar);
jBCadastrar.setBounds(280, 310, 110, 40);
jBRetornar.setFont(new java.awt.Font("Tahoma", 1, 11)); // NOI18N
jBRetornar.setIcon(new javax.swing.ImageIcon(getClass().getResource("/view/Back.png"))); // NOI18N
jBRetornar.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jBRetornarActionPerformed(evt);
}
});
getContentPane().add(jBRetornar);
jBRetornar.setBounds(420, 350, 50, 40);
jLabel8.setIcon(new javax.swing.ImageIcon(getClass().getResource("/view/Papel-de-Parede-fundo-azul-petroleo-com-mosaicos-35673.jpg"))); // NOI18N
jLabel8.setText("jLabel8");
getContentPane().add(jLabel8);
jLabel8.setBounds(0, 0, 500, 440);
pack();
setLocationRelativeTo(null);
}// </editor-fold>
private void jBLimparActionPerformed(java.awt.event.ActionEvent evt) {
txtNome.setText("");
txtDataNasc.setText("");
txtEmail.setText("");
txtCpf.setText("");
jRMasculino.setText("");
jRFeminino.setText("");
jPSenha.setText("");
}
private void jBCadastrarActionPerformed(java.awt.event.ActionEvent evt) {
Usuario usuarios = new Usuario();
usuarios.setNome(txtNome.getText());
usuarios.setDtNascimento(txtDataNasc.getText());
usuarios.seteMail(txtEmail.getText());
usuarios.setCpf(txtCpf.getText());
usuarios.setSexo(jRMasculino.getText());
usuarios.setSexo(jRFeminino.getText());
usuarios.setSenha(jPSenha.getText());
if((txtNome.getText().isEmpty()) || (txtDataNasc.getText().isEmpty())|| (txtEmail.getText().isEmpty())|| (txtCpf.getText().isEmpty())||(jRMasculino.getText().isEmpty())||(jRFeminino.getText().isEmpty())||(jPSenha.getText().isEmpty())){
JOptionPane.showMessageDialog(null, "CAMPOS VAZIO, FAVOR PREENCHE-LOS PARA CONTINUAR","ERRO.!!",JOptionPane.ERROR_MESSAGE);
System.out.println(txtNome);
}
else{
this.hide();
TelaInicial t = new TelaInicial();
t.setVisible(true);
UsuarioDAO u = new UsuarioDAO();
u.insert(usuarios);
JOptionPane.showMessageDialog(this, "Cadastrado com sucesso!!!");
}
}
private void txtDataNascActionPerformed(java.awt.event.ActionEvent evt) {
}
private void txtNomeActionPerformed(java.awt.event.ActionEvent evt) {
}
private void jBRetornarActionPerformed(java.awt.event.ActionEvent evt) {
TelaInicial ti = new TelaInicial();
ti.setVisible(true);
this.pack();
dispose();
}
/**
* @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 {
for (javax.swing.UIManager.LookAndFeelInfo info : javax.swing.UIManager.getInstalledLookAndFeels()) {
if ("Nimbus".equals(info.getName())) {
javax.swing.UIManager.setLookAndFeel(info.getClassName());
break;
}
}
} catch (ClassNotFoundException ex) {
java.util.logging.Logger.getLogger(TelaCadastro.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (InstantiationException ex) {
java.util.logging.Logger.getLogger(TelaCadastro.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (IllegalAccessException ex) {
java.util.logging.Logger.getLogger(TelaCadastro.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
} catch (javax.swing.UnsupportedLookAndFeelException ex) {
java.util.logging.Logger.getLogger(TelaCadastro.class.getName()).log(java.util.logging.Level.SEVERE, null, ex);
}
//</editor-fold>
/* Create and display the form */
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new TelaCadastro().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JButton jBCadastrar;
private javax.swing.JButton jBLimpar;
private javax.swing.JButton jBRetornar;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel2;
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.JPasswordField jPSenha;
private javax.swing.JRadioButton jRFeminino;
private javax.swing.JRadioButton jRMasculino;
private javax.swing.JFormattedTextField txtCpf;
private javax.swing.JFormattedTextField txtDataNasc;
private javax.swing.JTextField txtEmail;
private javax.swing.JTextField txtNome;
// End of variables declaration
}