Erro — GUJ

Bom dia, estou tentando salvar dados em minha tabela e está me dando o seguinte erro:

Exception in thread “AWT-EventQueue-0” java.lang.NullPointerException

at modeloDao.DaoAluno.Salvar(DaoAluno.java:29)

at visao.FormularioAluno.jButtonSalvarActionPerformed(FormularioAluno.java:337)

at visao.FormularioAluno.access$600(FormularioAluno.java:17)

at visao.FormularioAluno$7.actionPerformed(FormularioAluno.java:244)

at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)

at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)

at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)

at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)

at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)

at java.awt.Component.processMouseEvent(Component.java:6533)

at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)

at java.awt.Component.processEvent(Component.java:6298)

at java.awt.Container.processEvent(Container.java:2236)

at java.awt.Component.dispatchEventImpl(Component.java:4889)

at java.awt.Container.dispatchEventImpl(Container.java:2294)

at java.awt.Component.dispatchEvent(Component.java:4711)

at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)

at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)

at java.awt.Container.dispatchEventImpl(Container.java:2280)

at java.awt.Window.dispatchEventImpl(Window.java:2746)

at java.awt.Component.dispatchEvent(Component.java:4711)

at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)

at java.awt.EventQueue.access$500(EventQueue.java:97)

at java.awt.EventQueue$3.run(EventQueue.java:709)

at java.awt.EventQueue$3.run(EventQueue.java:703)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:90)

at java.awt.EventQueue$4.run(EventQueue.java:731)

at java.awt.EventQueue$4.run(EventQueue.java:729)

at java.security.AccessController.doPrivileged(Native Method)

at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:80)

at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)

at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)

at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)

at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

Meu conexao:

package modeloConection;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

public class ConexaoBD {

public Statement stm;
public ResultSet rs;
private final String DRIVER = "com.mysql.jdbc.Driver";
private final String URL = "jdbc:mysql://179.188.16.208:3306/mundoideal123";
private final String USER = "mundoideal123";
private final String PASS = "******";
public Connection con;

    

public Connection conexao(){

try {

Class.forName(“com.mysql.jdbc.Driver”);

return DriverManager.getConnection(URL, USER, PASS);

} catch (SQLException | ClassNotFoundException ex) {

JOptionPane.showMessageDialog(null, ex);

}

return null;

}

public void executaSql(String sql){
    try {
        stm = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,rs.CONCUR_READ_ONLY);
        rs = stm.executeQuery(sql);
    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, "Erro:\n"+ex.getMessage());
    }
}

public void desconectar(){
    try {
        con.close();
        //JOptionPane.showMessageDialog(null, "Desconectado com sucesso!!");
    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, "Erro ao fechar conexão com bando de dados:\n"+ex.getMessage());
    }
}

}

meu DAO:

package modeloDao;

import modeloConection.ConexaoBD;

import java.sql.PreparedStatement;

import java.sql.SQLException;

import java.util.logging.Level;

import java.util.logging.Logger;

import javax.swing.JOptionPane;

import modeloBeans.BeansAluno;

/**
*

@author Gui
*/
public class DaoAluno {

ConexaoBD conex = new ConexaoBD();
BeansAluno mod = new BeansAluno();

public void Salvar(BeansAluno mod){

conex.conexao();

try {

PreparedStatement pst;

pst = conex.con.prepareStatement(“insert into alunos(nome_aluno,nome_pai,nome_mae,telefone_aluno1,telefone_aluno2,serie,nascimento,endereco,remedios) values(?,?,?,?,?,?,?,?,?)”);

pst.setString(1,mod.getNome());

pst.setString(2,mod.getNomePai());

pst.setString(3,mod.getNomeMae());

pst.setInt(4, mod.getTelefone1());

pst.setInt(5, mod.getTelefone2());

pst.setString(6, mod.getSerie());

pst.setString(7, mod.getNascimento());

pst.setString(8, mod.getRua());

pst.setString(9, mod.getRemedio());

pst.execute();

JOptionPane.showMessageDialog(null, "Dados Inseridos com sucesso");
    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, "Erro ao inserir dados"+ex);
    }
    
    
    conex.desconectar();
}

public BeansAluno buscaAluno(BeansAluno mod){
    conex.conexao();
    conex.executaSql("Select *from alunos WHERE nome_aluno like'%"+mod.getPesquisa()+"%'");
    try {
        conex.rs.first();
        mod.setCodigo(conex.rs.getInt("cod_aluno"));
        mod.setNome(conex.rs.getString("nome_aluno"));
        mod.setNomeMae(conex.rs.getString("nome_pai"));
        mod.setNomePai(conex.rs.getString("nome_mae"));
        mod.setTelefone1(conex.rs.getInt("telefone_aluno1"));
        mod.setTelefone2(conex.rs.getInt("telefone_aluno2"));
        mod.setSerie(conex.rs.getString("serie"));
        mod.setRua(conex.rs.getString("endereco"));
        mod.setRemedio(conex.rs.getString("remedios"));
        mod.setNascimento(conex.rs.getString("nascimento"));
        
    } catch (SQLException ex) {
        JOptionPane.showMessageDialog(null, "Erro ao buscar aluno:\n"+ex);
    }
    
    
    conex.desconectar();
    return mod;
    
}

}

Alguém pode me ajudar?

4 Respostas

Topicos relacionados