O erro está no "con" a aí?

package fichamatricula.GUI.Cadastro;

import com.mysql.jdbc.PreparedStatement;

import com.mysql.jdbc.Statement;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

/**
*

@author Gilson
*/
public class Cad_Escola extends javax.swing.JInternalFrame {

public Cad_Escola() {
initComponents();
```
}

private Connection con;

private java.sql.Statement comando;
```

//  @SuppressWarnings(“unchecked”)

// 

private void initComponents() {

jEscola = new javax.swing.JLabel();
    txNomeEscola = new javax.swing.JTextField();
    jCodigoEscola = new javax.swing.JLabel();
    txCodigo = new javax.swing.JTextField();
    jEnderecoEscola = new javax.swing.JLabel();
    txEnderecoEscola = new javax.swing.JTextField();
    jBairroEscola = new javax.swing.JLabel();
    txBairroEscola = new javax.swing.JTextField();
    jMunicipilEscola = new javax.swing.JLabel();
    txMunicipioEscola = new javax.swing.JTextField();
    jCepEscola = new javax.swing.JLabel();
    jTelefone1Escola = new javax.swing.JLabel();
    bListaCadEscola = new javax.swing.JButton();
    bSalvarCadEscola = new javax.swing.JButton();
    bAlterarCadEscola = new javax.swing.JButton();
    txCepEscola = new javax.swing.JFormattedTextField();
    txTelefone1Escola = new javax.swing.JFormattedTextField();
    bFecharCad_Escola = new javax.swing.JButton();
    jUfEscola = new javax.swing.JLabel();
    txUfEscola = new javax.swing.JTextField();
    jTelefone2Escola = new javax.swing.JLabel();
    txTelefone2Escola = new javax.swing.JFormattedTextField();
    jNumeroEscola = new javax.swing.JLabel();
    txNumeroEscola = new javax.swing.JTextField();
    jNomeEscola = new javax.swing.JLabel();
    jEmailCadEscola = new javax.swing.JLabel();
    txEmailEscola = new javax.swing.JTextField();

    setTitle("CADASTRO DA ESCOLA");

    jCodigoEscola.setText("CÓD.:");

    jEnderecoEscola.setText("ENDEREÇO: ");

    jBairroEscola.setText("BAIRRO:");

    jMunicipilEscola.setText("MUNICÍPIO: ");

    jCepEscola.setText("CEP:");

    jTelefone1Escola.setText("TELEFONE 1 ");

    bListaCadEscola.setText("Lista");

    bSalvarCadEscola.setText("Salvar");
    bSalvarCadEscola.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            bSalvarCadEscolaActionPerformed(evt);
        }
    });

    bAlterarCadEscola.setText("Alterar");
    bAlterarCadEscola.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            bAlterarCadEscolaActionPerformed(evt);
        }
    });

    try {
        txCepEscola.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("#####-###")));
    } catch (java.text.ParseException ex) {
        ex.printStackTrace();
    }

    try {
        txTelefone1Escola.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("(##)####-####")));
    } catch (java.text.ParseException ex) {
        ex.printStackTrace();
    }

    bFecharCad_Escola.setText("Fechar");
    bFecharCad_Escola.addActionListener(new java.awt.event.ActionListener() {
        public void actionPerformed(java.awt.event.ActionEvent evt) {
            bFecharCad_EscolaActionPerformed(evt);
        }
    });

    jUfEscola.setText("UF");

    jTelefone2Escola.setText("TELEFONE 2");

    try {
        txTelefone2Escola.setFormatterFactory(new javax.swing.text.DefaultFormatterFactory(new javax.swing.text.MaskFormatter("(##)####-####")));
    } catch (java.text.ParseException ex) {
        ex.printStackTrace();
    }

    jNumeroEscola.setText("N°");

    jNomeEscola.setText("NOME DA ESCOLA");

    jEmailCadEscola.setText("EMAIL");

    javax.swing.GroupLayout layout = new javax.swing.GroupLayout(getContentPane());
    getContentPane().setLayout(layout);
    layout.setHorizontalGroup(
        layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup()
            .addContainerGap()
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                .addGroup(layout.createSequentialGroup()
                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.TRAILING)
                        .addGroup(layout.createSequentialGroup()
                            .addComponent(bFecharCad_Escola)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                            .addComponent(bListaCadEscola)
                            .addGap(18, 18, 18)
                            .addComponent(bAlterarCadEscola)
                            .addGap(18, 18, 18)
                            .addComponent(bSalvarCadEscola))
                        .addGroup(javax.swing.GroupLayout.Alignment.LEADING, layout.createSequentialGroup()
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addComponent(jEnderecoEscola)
                                .addComponent(jEscola)
                                .addComponent(jNomeEscola)
                                .addComponent(jMunicipilEscola))
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                .addGroup(layout.createSequentialGroup()
                                    .addComponent(txMunicipioEscola, javax.swing.GroupLayout.PREFERRED_SIZE, 273, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addGap(18, 18, 18)
                                    .addComponent(jUfEscola)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(txUfEscola, javax.swing.GroupLayout.PREFERRED_SIZE, 28, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, javax.swing.GroupLayout.DEFAULT_SIZE, Short.MAX_VALUE)
                                    .addComponent(jCepEscola)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(txCepEscola, javax.swing.GroupLayout.PREFERRED_SIZE, 66, javax.swing.GroupLayout.PREFERRED_SIZE)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED)
                                    .addComponent(jTelefone1Escola)
                                    .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                    .addComponent(txTelefone1Escola, javax.swing.GroupLayout.PREFERRED_SIZE, 103, javax.swing.GroupLayout.PREFERRED_SIZE))
                                .addGroup(layout.createSequentialGroup()
                                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addGroup(layout.createSequentialGroup()
                                            .addComponent(txEnderecoEscola)
                                            .addGap(20, 20, 20))
                                        .addComponent(txNomeEscola, javax.swing.GroupLayout.PREFERRED_SIZE, 358, javax.swing.GroupLayout.PREFERRED_SIZE))
                                    .addGap(0, 0, Short.MAX_VALUE)
                                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                                        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                                            .addComponent(jCodigoEscola)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                            .addComponent(txCodigo, javax.swing.GroupLayout.PREFERRED_SIZE, 163, javax.swing.GroupLayout.PREFERRED_SIZE))
                                        .addGroup(javax.swing.GroupLayout.Alignment.TRAILING, layout.createSequentialGroup()
                                            .addComponent(jNumeroEscola)
                                            .addGap(18, 18, 18)
                                            .addComponent(txNumeroEscola, javax.swing.GroupLayout.PREFERRED_SIZE, 35, javax.swing.GroupLayout.PREFERRED_SIZE)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                            .addComponent(jBairroEscola)
                                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                                            .addComponent(txBairroEscola, javax.swing.GroupLayout.PREFERRED_SIZE, 174, javax.swing.GroupLayout.PREFERRED_SIZE)))))))
                    .addGap(24, 24, 24))
                .addGroup(layout.createSequentialGroup()
                    .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
                        .addGroup(layout.createSequentialGroup()
                            .addComponent(jTelefone2Escola)
                            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.UNRELATED)
                            .addComponent(txTelefone2Escola, javax.swing.GroupLayout.PREFERRED_SIZE, 90, javax.swing.GroupLayout.PREFERRED_SIZE))
                        .addGroup(layout.createSequentialGroup()
                            .addComponent(jEmailCadEscola)
                            .addGap(18, 18, 18)
                            .addComponent(txEmailEscola, javax.swing.GroupLayout.PREFERRED_SIZE, 471, javax.swing.GroupLayout.PREFERRED_SIZE)))
                    .addGap(0, 0, Short.MAX_VALUE))))
    );
    layout.setVerticalGroup(
        layout.createParallelGroup(javax.swing.GroupLayout.Alignment.LEADING)
        .addGroup(layout.createSequentialGroup()
            .addGap(48, 48, 48)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jEscola)
                .addComponent(txNomeEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(jCodigoEscola)
                .addComponent(txCodigo, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(jNomeEscola))
            .addGap(18, 18, 18)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jEnderecoEscola)
                .addComponent(txEnderecoEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(jBairroEscola)
                .addComponent(txBairroEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(jNumeroEscola)
                .addComponent(txNumeroEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGap(18, 18, 18)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jMunicipilEscola)
                .addComponent(txMunicipioEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(jCepEscola)
                .addComponent(jTelefone1Escola)
                .addComponent(txCepEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(txTelefone1Escola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE)
                .addComponent(jUfEscola)
                .addComponent(txUfEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGap(18, 18, 18)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jTelefone2Escola)
                .addComponent(txTelefone2Escola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addGap(18, 18, 18)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(jEmailCadEscola)
                .addComponent(txEmailEscola, javax.swing.GroupLayout.PREFERRED_SIZE, javax.swing.GroupLayout.DEFAULT_SIZE, javax.swing.GroupLayout.PREFERRED_SIZE))
            .addPreferredGap(javax.swing.LayoutStyle.ComponentPlacement.RELATED, 72, Short.MAX_VALUE)
            .addGroup(layout.createParallelGroup(javax.swing.GroupLayout.Alignment.BASELINE)
                .addComponent(bListaCadEscola)
                .addComponent(bSalvarCadEscola)
                .addComponent(bAlterarCadEscola)
                .addComponent(bFecharCad_Escola))
            .addGap(30, 30, 30))
    );

    pack();
}// </editor-fold>                        

private void bFecharCad_EscolaActionPerformed(java.awt.event.ActionEvent evt) {                                                  
     this.dispose();
}                                                 

private void bSalvarCadEscolaActionPerformed(java.awt.event.ActionEvent evt) {                                                 
     Connection String = null; 
    try {
        Class.forName("org.postgresql.Driver").getInterfaces(); //carrega o Driver)
    } catch (ClassNotFoundException ex) {
        System.out.println("Conseguir carregar o Driver");
    }
    try {
        Connection conn=DriverManager.getConnection("jdbc:mysql://localhost/escola","postgres","gilson");
    } catch (SQLException ex) {
       System.out.println("Conseguir conectar ao banco?");
    }
               
           String query="INSERT INTO escola(codesc,nomeesc,codigoesc,enderecoesc,bairroesc,numeroesc, municipioesc,"
   + "ufesc,cepesc,telefone1esc,telefone2esc,emailesc)VALUE(?,?,?,?,?,?,?,?,?,?,?,?)";
      try
    {     
        PreparedStatement stmt =  con.prepareStatement(query); 
    
    stmt.setString(1,txNomeEscola.getText());
    stmt.setString(2,txCodigo.getText());
    stmt.setString(3,txEnderecoEscola.getText());
    stmt.setString(4,txNumeroEscola.getText());
    stmt.setString(5,txBairroEscola.getText());
    stmt.setString (6,txMunicipioEscola.getText());
    stmt.setString(7,txUfEscola.getText());
    stmt.setString(8,txCepEscola.getText());
    stmt.setString(9, txTelefone1Escola.getText());
    stmt.setString(10,txTelefone2Escola.getText());
    stmt.setString(11,txEmailEscola.getText());

//Executa o comando no banco de dados
stmt.executeUpdate();

//fechar o comando conexao

// con.close();
    stmt.close();
    } catch (SQLException ex) {
       System.out.println("Não foi possivel encontar a classe?");
    
     

    }

      
              
    
}                                                

private void bAlterarCadEscolaActionPerformed(java.awt.event.ActionEvent evt) {                                                  
    // TODO add your handling code here:
}                                                 

// Variables declaration - do not modify                     
private javax.swing.JButton bAlterarCadEscola;
private javax.swing.JButton bFecharCad_Escola;
private javax.swing.JButton bListaCadEscola;
private javax.swing.JButton bSalvarCadEscola;
private javax.swing.JLabel jBairroEscola;
private javax.swing.JLabel jCepEscola;
private javax.swing.JLabel jCodigoEscola;
private javax.swing.JLabel jEmailCadEscola;
private javax.swing.JLabel jEnderecoEscola;
private javax.swing.JLabel jEscola;
private javax.swing.JLabel jMunicipilEscola;
private javax.swing.JLabel jNomeEscola;
private javax.swing.JLabel jNumeroEscola;
private javax.swing.JLabel jTelefone1Escola;
private javax.swing.JLabel jTelefone2Escola;
private javax.swing.JLabel jUfEscola;
private javax.swing.JTextField txBairroEscola;
private javax.swing.JFormattedTextField txCepEscola;
private javax.swing.JTextField txCodigo;
private javax.swing.JTextField txEmailEscola;
private javax.swing.JTextField txEnderecoEscola;
private javax.swing.JTextField txMunicipioEscola;
private javax.swing.JTextField txNomeEscola;
private javax.swing.JTextField txNumeroEscola;
private javax.swing.JFormattedTextField txTelefone1Escola;
private javax.swing.JFormattedTextField txTelefone2Escola;
private javax.swing.JTextField txUfEscola;
// End of variables declaration

}

4 Respostas

Topicos relacionados