Listar dados do Banco de Dados no JComboBox

Java

02/03/2016

Bom Dia galera,

Estou precisando listar dados do meu Banco de Dados no meu JComboBox e não estou conseguindo de jeito nenhum. Segue a linha de código abaixo:

Classe principal:
 boxPerfil = new JComboBox();
        boxPerfil.setBounds(110, 140, 100, 20);
        listarPerfil();

public void listarPerfil(){
        try{
            String perfil;
            boxPerfil.removeAllItems();
            objRs = objUsuario.perfil();
            if(objRs != null){
                while(objRs.next()){
                    perfil = objRs.getString("descricao");
                    boxPerfil.addItem(objRs.getString(perfil));
                }
            }
            else{
                JOptionPane.showMessageDialog(null, "objRs não possui nenhum item.");
            }
        }
        catch(SQLException e){
            JOptionPane.showMessageDialog(null, "ERRO");
            e.printStackTrace();
        }
    }


Conexão com o Banco de dados :
public ResultSet perfil(){
        try{
            
            objCon = con.conectar();
            String sqlPerfil = "SELECT * FROM crm_perfil";
            PreparedStatement objPerfil = objCon.prepareStatement(sqlPerfil);
            objRs = objPerfil.executeQuery();
            
            if(!objRs.next()){
                objRs = null;
            }
            else{
                objRs.first();
            }
        }
        
        catch(SQLException ex){
            JOptionPane.showMessageDialog(null, "ERRO SQL", "ERRO", JOptionPane.ERROR_MESSAGE);
            ex.printStackTrace();
        }
        
        return objRs;
    }


Erro:
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
	at Usuario.CadastrarU.listarPerfil(CadastrarU.java:86)
	at Usuario.CadastrarU.<init>(CadastrarU.java:60)
	at MenuPrincipal.MenuPrincipal$3.actionPerformed(MenuPrincipal.java:148)
	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.AbstractButton.doClick(AbstractButton.java:376)
	at javax.swing.plaf.basic.BasicMenuItemUI.doClick(BasicMenuItemUI.java:833)
	at javax.swing.plaf.basic.BasicMenuItemUI$Handler.mouseReleased(BasicMenuItemUI.java:877)
	at java.awt.Component.processMouseEvent(Component.java:6535)
	at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
	at java.awt.Component.processEvent(Component.java:6300)
	at java.awt.Container.processEvent(Container.java:2236)
	at java.awt.Component.dispatchEventImpl(Component.java:4891)
	at java.awt.Container.dispatchEventImpl(Container.java:2294)
	at java.awt.Component.dispatchEvent(Component.java:4713)
	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:2750)
	at java.awt.Component.dispatchEvent(Component.java:4713)
	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:76)
	at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
	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:76)
	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)


Alguém poderia me ajudar ?
Johann Albino

Johann Albino

Curtidas 0
POSTAR