gente é o siguinte estou fazendo um programinha e não estou conseguindo inserir um dado pelo JTexfield para a tabela Mysql
gostaria que vcs dessem uma olhadinha e veja porquer está dando esse erro.
essa classe o form onde havera o evento
package c;
import java.lang.String.*;
public class test extends javax.swing.JFrame {
public test() {
initComponents();
}
@SuppressWarnings("unchecked")
// <editor-fold defaultstate="collapsed" desc="Generated Code">
private void initComponents() {
jPanel1 = new javax.swing.JPanel();
jLabel10 = new javax.swing.JLabel();
jLabel1 = new javax.swing.JLabel();
jLabel2 = new javax.swing.JLabel();
jLabel3 = new javax.swing.JLabel();
TNome = new javax.swing.JTextField();
TNascimento = new javax.swing.JTextField();
TNumero = new javax.swing.JTextField();
jButton1 = new javax.swing.JButton();
jButton2 = new javax.swing.JButton();
jLabel4 = new javax.swing.JLabel();
TAno = new javax.swing.JTextField();
jLabel5 = new javax.swing.JLabel();
jLabel6 = new javax.swing.JLabel();
TCurso = new javax.swing.JTextField();
TSerie = new javax.swing.JTextField();
jLabel7 = new javax.swing.JLabel();
TTurno = new javax.swing.JTextField();
jLabel8 = new javax.swing.JLabel();
jLabel9 = new javax.swing.JLabel();
TTurma = new javax.swing.JTextField();
jPanel2 = new javax.swing.JPanel();
jPanel3 = new javax.swing.JPanel();
jLabel11 = new javax.swing.JLabel();
jButton3 = new javax.swing.JButton();
jButton4 = new javax.swing.JButton();
jButton5 = new javax.swing.JButton();
jButton6 = new javax.swing.JButton();
jButton7 = new javax.swing.JButton();
jButton8 = new javax.swing.JButton();
setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
setTitle("CEM");
setBackground(new java.awt.Color(0, 51, 255));
getContentPane().setLayout(null);
jPanel1.setBackground(new java.awt.Color(17, 47, 237));
jLabel10.setFont(new java.awt.Font("Ubuntu", 1, 24));
jLabel10.setForeground(new java.awt.Color(247, 245, 18));
jLabel10.setText("Cadastro do Aluno");
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(303, 303, 303)
.addComponent(jLabel10, javax.swing.GroupLayout.PREFERRED_SIZE, 269, javax.swing.GroupLayout.PREFERRED_SIZE)
.addContainerGap(300, Short.MAX_VALUE))
);
jPanel1Layout.setVerticalGroup(
jPanel1Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGroup(jPanel1Layout.createSequentialGroup()
.addContainerGap()
.addComponent(jLabel10, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
.addContainerGap())
);
getContentPane().add(jPanel1);
jPanel1.setBounds(0, 0, 872, 50);
jLabel1.setText("Nome");
getContentPane().add(jLabel1);
jLabel1.setBounds(10, 127, 42, 18);
jLabel2.setText("data de Nascimento ");
getContentPane().add(jLabel2);
jLabel2.setBounds(10, 177, 144, 18);
jLabel3.setText("numero");
getContentPane().add(jLabel3);
jLabel3.setBounds(296, 177, 55, 18);
getContentPane().add(TNome);
TNome.setBounds(88, 122, 374, 28);
getContentPane().add(TNascimento);
TNascimento.setBounds(178, 172, 100, 28);
getContentPane().add(TNumero);
TNumero.setBounds(407, 172, 55, 28);
jButton1.setText("Novo");
jButton1.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton1ActionPerformed(evt);
}
});
getContentPane().add(jButton1);
jButton1.setBounds(246, 352, 86, 30);
jButton2.setText("Cadastra");
jButton2.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton2ActionPerformed(evt);
}
});
getContentPane().add(jButton2);
jButton2.setBounds(12, 352, 100, 30);
jLabel4.setText("Id");
getContentPane().add(jLabel4);
jLabel4.setBounds(40, 84, 12, 18);
getContentPane().add(TAno);
TAno.setBounds(70, 212, 90, 28);
jLabel5.setText("Ano");
getContentPane().add(jLabel5);
jLabel5.setBounds(10, 222, 27, 18);
jLabel6.setText("Curso");
getContentPane().add(jLabel6);
jLabel6.setBounds(250, 222, 41, 18);
TCurso.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
TCursoActionPerformed(evt);
}
});
getContentPane().add(TCurso);
TCurso.setBounds(300, 212, 170, 28);
getContentPane().add(TSerie);
TSerie.setBounds(210, 212, 30, 28);
jLabel7.setText("Série");
getContentPane().add(jLabel7);
jLabel7.setBounds(170, 222, 35, 18);
getContentPane().add(TTurno);
TTurno.setBounds(340, 252, 130, 28);
jLabel8.setText("Turno");
getContentPane().add(jLabel8);
jLabel8.setBounds(290, 262, 42, 18);
jLabel9.setText("Turma");
getContentPane().add(jLabel9);
jLabel9.setBounds(10, 262, 45, 18);
getContentPane().add(TTurma);
TTurma.setBounds(60, 252, 220, 28);
jPanel2.setBackground(new java.awt.Color(253, 9, 5));
jPanel2.setForeground(new java.awt.Color(253, 10, 10));
javax.swing.GroupLayout jPanel2Layout = new javax.swing.GroupLayout(jPanel2);
jPanel2.setLayout(jPanel2Layout);
jPanel2Layout.setHorizontalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 872, Short.MAX_VALUE)
);
jPanel2Layout.setVerticalGroup(
jPanel2Layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
.addGap(0, 10, Short.MAX_VALUE)
);
getContentPane().add(jPanel2);
jPanel2.setBounds(0, 56, 872, 10);
jPanel3.setBackground(new java.awt.Color(242, 255, 4));
jPanel3.setLayout(null);
jLabel11.setFont(new java.awt.Font("Ubuntu", 1, 15));
jLabel11.setText("Notas Bimestrais");
jPanel3.add(jLabel11);
jLabel11.setBounds(100, 10, 140, 18);
getContentPane().add(jPanel3);
jPanel3.setBounds(484, 72, 388, 30);
jButton3.setText("4 Bimestre");
getContentPane().add(jButton3);
jButton3.setBounds(710, 242, 140, 30);
jButton4.setText("1 Bimestre");
jButton4.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton4ActionPerformed(evt);
}
});
getContentPane().add(jButton4);
jButton4.setBounds(518, 132, 140, 30);
jButton5.setText("2 Bimestre");
getContentPane().add(jButton5);
jButton5.setBounds(708, 132, 140, 30);
jButton6.setText("3 Bimestre");
getContentPane().add(jButton6);
jButton6.setBounds(520, 242, 140, 30);
jButton7.setText("Cancelar");
jButton7.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton7ActionPerformed(evt);
}
});
getContentPane().add(jButton7);
jButton7.setBounds(144, 352, 74, 30);
jButton8.setText("Sair");
jButton8.addActionListener(new java.awt.event.ActionListener() {
public void actionPerformed(java.awt.event.ActionEvent evt) {
jButton8ActionPerformed(evt);
}
});
getContentPane().add(jButton8);
jButton8.setBounds(361, 352, 109, 30);
pack();
}// </editor-fold>
private void jButton2ActionPerformed(java.awt.event.ActionEvent evt) {
Conexao b = new Conexao();
b.iniciaConexao();
String nome = TNome.getText();
int nascimento = Integer.parseInt (TNascimento.getText());
int numero =Integer.parseInt (TNumero.getText());
int ano = Integer.parseInt (TAno.getText());
String curso = TCurso.getText();
String serie = TSerie.getText();
String turno = TTurno.getText();
String turma = TTurma.getText();
b.CadastraDados( nome, nascimento, numero, ano, curso, serie, turno, turma);
}
private void TCursoActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton4ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton1ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton7ActionPerformed(java.awt.event.ActionEvent evt) {
// TODO add your handling code here:
}
private void jButton8ActionPerformed(java.awt.event.ActionEvent evt) {
this.dispose();
}
/**
* @param args the command line arguments
*/
public static void main(String args[]) {
java.awt.EventQueue.invokeLater(new Runnable() {
public void run() {
new test().setVisible(true);
}
});
}
// Variables declaration - do not modify
private javax.swing.JTextField TAno;
private javax.swing.JTextField TCurso;
private javax.swing.JTextField TNascimento;
private javax.swing.JTextField TNome;
private javax.swing.JTextField TNumero;
private javax.swing.JTextField TSerie;
private javax.swing.JTextField TTurma;
private javax.swing.JTextField TTurno;
private javax.swing.JButton jButton1;
private javax.swing.JButton jButton2;
private javax.swing.JButton jButton3;
private javax.swing.JButton jButton4;
private javax.swing.JButton jButton5;
private javax.swing.JButton jButton6;
private javax.swing.JButton jButton7;
private javax.swing.JButton jButton8;
private javax.swing.JLabel jLabel1;
private javax.swing.JLabel jLabel10;
private javax.swing.JLabel jLabel11;
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.JLabel jLabel9;
private javax.swing.JPanel jPanel1;
private javax.swing.JPanel jPanel2;
private javax.swing.JPanel jPanel3;
// End of variables declaration
}
esta outra classe faz a conexao e a insert into
package c;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class Conexao {
private static Connection conn;
private static ResultSet rs;
private static PreparedStatement ps;
private static Statement st;
public Statement getSt() {
return st;
}
public void iniciaConexao() {
try {
Class.forName("com.mysql.jdbc.Driver");
//objeto responsavel por inicia o banco
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/1anomedio", "root", "123456");
st = (Statement) conn.createStatement();
} catch (Exception e) {
System.out.println("Ero ao conectar ao Banco");
}
}
public void CadastraDados( long Id, String nome, int Nascimento, int Numero, int Ano, String Curso, String Serie, String Turno, String Turma) {
try {
iniciaConexao();
try {
String sql = "INSERT INTO Tbl_Aluno (null, Nome_Aluno, Data_Nascimento, Numerochamada, Ano, Curso, Serie, Turno, Turma) VALUES (?);";
ps = conn.prepareStatement(sql);
ps.setLong(1, Id);
ps.setString(2, nome);
ps.setInt(3, Nascimento);
ps.setInt(4, Numero);
ps.setInt(5, Ano);
ps.setString(6, Curso);
ps.setString(7, Serie);
ps.setString(8, Turno);
ps.setString(9, Turma);
ps.execute();
} catch (Exception e) {
}
} catch (Exception e) {
fechaConexao();
}
}
void fechaConexao() {
try {
conn.close();
} catch (SQLException e) {
}
}
}