NetBeans e banco de dados

Programação Java
#1

E ae pessoal, tudo bom!!?

Eu estou aprendendo a mexer no Netbeans, isso é, fuçar né… hehehe

Ë muito legal, facinho de montar os esquemas… mas quando tento colcoar alguma coisas que inclua banco de dados, da pau… e pior que nem dapara sabe rque pau que é… é fogo… ele me seta uma linha que não tem explicação e da um erro de NullPoiterException… o erro é este:

java.lang.NullPointerException 
    at cadastro.dao.CadastroDB.save(CadastroDB.java:33) 

    at cadastro.CadastroEndereco.insertCadastroDB(CadastroEndereco.java:254) 
    at cadastro.CadastroEndereco.access$000(CadastroEndereco.java:15) 
    at cadastro.CadastroEndereco$1.actionPerformed(CadastroEndereco.java:160) 
    at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1786) 
    at javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.java:1839) ...

e por ae vai…

vou colocar as 3 classes aqui para vocês verem:
que erro absurdo é esse… funciona direitinho de uum outro jeito…

package cadastro.dao; 

import java.sql.*; 

/** 
 * 
 * @author br_1004 
 */ 
public class ConnectionManager { 
    
    public static final String STR_DRIVER = "com.mysql.jdbc.Driver"; 
    private static final String NOME_BANCO = "cadastroendereco"; 
    public static final String STR_CON = "jdbc:mysql://192.168.1.90:3306/"+NOME_BANCO+"?user=root&password=root"; 
    private static final String USUARIO = "root"; 
    private static final String SENHA = "root"; 
    public static String teste = ""; 
    
    public Connection getConexao() {                
        
        Connection conn = null; 
        
        try { 
            Class.forName(STR_DRIVER).newInstance(); 
            conn = DriverManager.getConnection(STR_CON); 
            System.out.println("Conectado"); 
            return conn; 
        } catch (ClassNotFoundException e) { 
            String errorMsg = "Driver nao encontrado"; 
        } catch (SQLException e) { 
            String errorMsg = "Erro ao obter conexão"; 
        } catch (InstantiationException e) { 
         // TODO Auto-generated catch block 
         e.printStackTrace(); 
      } catch (IllegalAccessException e) { 
         // TODO Auto-generated catch block 
         e.printStackTrace(); 
      } 
        return conn; 
    } 
    
    public void close(Connection conn) { 
        try { 
            if (conn != null) { 
                conn.close(); 
            } 
        } catch (Exception e) { 
            String errorMsg = "Nao foi possivel dfechar a conexao com o banco"; 
        } 
    } 
    
    public void close(Connection conn, Statement stmt) { 
       
      try { 
         if (stmt != null) { 
            stmt.close();             
         } 
          
      } catch (Exception e) { 
         System.out.println("Não foi possível fechar a cnexão com o banco"); 
         e.printStackTrace(); 
      } 
      close(conn); 
   } 
    
   public void close(Connection conn, Statement stmt, ResultSet rs) { 
       
      try { 
         if (rs != null) { 
            rs.close();             
         } 
          
      } catch (Exception e) { 
         System.out.println("Não foi possível fechar a cnexão com o banco"); 
         e.printStackTrace(); 
      } 
      close(conn, stmt); 
   } 
    
    
} 
 
package cadastro.dao; 

import java.sql.*; 
import cadastro.beans.Cadastro; 
/** 
 * 
 * @author br_1004 
 */ 
public class CadastroDB { 
    
    public void save(Cadastro cadastro) { 
        ConnectionManager cm = new ConnectionManager(); 
        
        Connection conn = cm.getConexao(); 
        Statement stmt; 
        String sql = "INSERT INTO cadastro (nome,sobrenome,endereco,numero,"; 
        sql += " bairro,cidade,uf,fone,cel,fax) "; 
        sql += " VALUES ('"+cadastro.getNome()+"','"+cadastro.getSobrenome()+"'"; 
        sql += " ,'"+cadastro.getEndereco()+"',"+cadastro.getNumero(); 
        sql += " ,'"+cadastro.getBairro()+"','"+cadastro.getCidade()+"'"; 
        sql += " ,'"+cadastro.getUf()+"','"+cadastro.getFone()+"'"; 
        sql += " ,'"+cadastro.getCel()+"','"+cadastro.getFax()+"')";                
        
        System.out.println(ConnectionManager.teste); 
        
        try {              
            stmt = conn.createStatement(); 
            stmt.executeUpdate(sql); 
            System.out.println("SQL = " + sql); 
            System.out.println("Produto inserido no banco de dados" + cadastro); 
                      
        } catch (SQLException e) { 
            System.out.println("Erro de sql!!!!!"); 
            e.printStackTrace(); 
        } finally { 
           cm.close(conn); 
        } 
    }    
} 

package cadastro; 

import cadastro.dao.*; 
import cadastro.beans.*; 
/** 
 * 
 * @author  br_1004 
 */ 
public class CadastroEndereco extends javax.swing.JFrame { 
    
    /** Creates new form CadastroEndereco */ 
    public CadastroEndereco() { 
        initComponents(); 
    } 
    
    /** This method is called from within the constructor to 
     * initialize the form. 
     * WARNING: Do NOT modify this code. The content of this method is 
     * always regenerated by the Form Editor. 
     */ 
    private void initComponents() {                          
        Label = new javax.swing.JLabel(); 
        jLabel1 = new javax.swing.JLabel(); 
        jLabel2 = new javax.swing.JLabel(); 
        jLabel3 = new javax.swing.JLabel(); 
        jLabel4 = new javax.swing.JLabel(); 
        enderecoTextField = new javax.swing.JTextField(); 
        nomeTextField = new javax.swing.JTextField(); 
        sobrenomeTextField = new javax.swing.JTextField(); 
        jLabel5 = new javax.swing.JLabel(); 
        jLabel6 = new javax.swing.JLabel(); 
        jLabel7 = new javax.swing.JLabel(); 
        bairroTextField = new javax.swing.JTextField(); 
        cidadeTextField = new javax.swing.JTextField(); 
        ufTextField = new javax.swing.JTextField(); 
        foneTextField = new javax.swing.JTextField(); 
        jLabel8 = new javax.swing.JLabel(); 
        celTextField = new javax.swing.JTextField(); 
        jLabel9 = new javax.swing.JLabel(); 
        faxTextField = new javax.swing.JTextField(); 
        jLabel10 = new javax.swing.JLabel(); 
        numeroTextField = new javax.swing.JTextField(); 
        jLabel11 = new javax.swing.JLabel(); 
        jLabel12 = new javax.swing.JLabel(); 
        incluirButton = new javax.swing.JButton(); 
        sairButton = new javax.swing.JButton(); 
        resetarButton1 = new javax.swing.JButton(); 
        menuBar = new javax.swing.JMenuBar(); 
        fileMenu = new javax.swing.JMenu(); 
        openMenuItem = new javax.swing.JMenuItem(); 
        saveMenuItem = new javax.swing.JMenuItem(); 
        saveAsMenuItem = new javax.swing.JMenuItem(); 
        exitMenuItem = new javax.swing.JMenuItem(); 
        editMenu = new javax.swing.JMenu(); 
        cutMenuItem = new javax.swing.JMenuItem(); 
        copyMenuItem = new javax.swing.JMenuItem(); 
        pasteMenuItem = new javax.swing.JMenuItem(); 
        deleteMenuItem = new javax.swing.JMenuItem(); 
        helpMenu = new javax.swing.JMenu(); 
        contentsMenuItem = new javax.swing.JMenuItem(); 
        aboutMenuItem = new javax.swing.JMenuItem(); 

        getContentPane().setLayout(new org.netbeans.lib.awtextra.AbsoluteLayout()); 

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE); 
        setBackground(new java.awt.Color(204, 204, 204)); 
        Label.setFont(new java.awt.Font("Verdana", 1, 10)); 
        Label.setIcon(new javax.swing.ImageIcon("C:\\Meus documentos\\Programas\\Messenger\\emoticons\\good.jpg")); 
        Label.setText("Cadastro Endere\u00e7os"); 
        getContentPane().add(Label, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 10, -1, -1)); 

        jLabel1.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel1.setText("Nome:"); 
        getContentPane().add(jLabel1, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 50, -1, 20)); 

        jLabel2.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel2.setText("Sobrenome:"); 
        getContentPane().add(jLabel2, new org.netbeans.lib.awtextra.AbsoluteConstraints(180, 50, -1, 20)); 

        jLabel3.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel3.setText("Endere\u00e7o:"); 
        getContentPane().add(jLabel3, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 90, -1, 20)); 

        jLabel4.setFont(new java.awt.Font("Verdana", 0, 12)); 
        jLabel4.setText("________________________________________________"); 
        getContentPane().add(jLabel4, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 20, -1, -1)); 

        enderecoTextField.setText("endereco"); 
        getContentPane().add(enderecoTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(70, 90, 190, -1)); 

        nomeTextField.setText("nome"); 
        getContentPane().add(nomeTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 50, 120, -1)); 

        sobrenomeTextField.setText("sobrenome"); 
        getContentPane().add(sobrenomeTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(250, 50, 140, -1)); 

        jLabel5.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel5.setText("Bairro:"); 
        getContentPane().add(jLabel5, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 130, -1, 20)); 

        jLabel6.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel6.setText("Cidade:"); 
        getContentPane().add(jLabel6, new org.netbeans.lib.awtextra.AbsoluteConstraints(190, 130, -1, 20)); 

        jLabel7.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel7.setText("UF:"); 
        getContentPane().add(jLabel7, new org.netbeans.lib.awtextra.AbsoluteConstraints(340, 130, -1, 20)); 

        bairroTextField.setText("bairro"); 
        getContentPane().add(bairroTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 130, 130, -1)); 

        cidadeTextField.setText("cidade"); 
        getContentPane().add(cidadeTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(240, 130, 90, -1)); 

        ufTextField.setText("uf"); 
        getContentPane().add(ufTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(360, 130, 30, -1)); 

        foneTextField.setText("fone"); 
        getContentPane().add(foneTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(50, 170, 80, -1)); 

        jLabel8.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel8.setText("Fone:"); 
        getContentPane().add(jLabel8, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 170, -1, 20)); 

        celTextField.setText("cel"); 
        getContentPane().add(celTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 170, 90, -1)); 

        jLabel9.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel9.setText("Cel:"); 
        getContentPane().add(jLabel9, new org.netbeans.lib.awtextra.AbsoluteConstraints(140, 170, -1, 20)); 

        faxTextField.setText("fax"); 
        getContentPane().add(faxTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(297, 170, 90, -1)); 

        jLabel10.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel10.setText("Fax:"); 
        getContentPane().add(jLabel10, new org.netbeans.lib.awtextra.AbsoluteConstraints(270, 170, -1, 20)); 

        numeroTextField.setText("numero"); 
        getContentPane().add(numeroTextField, new org.netbeans.lib.awtextra.AbsoluteConstraints(317, 90, 70, -1)); 

        jLabel11.setFont(new java.awt.Font("Verdana", 0, 10)); 
        jLabel11.setText("Numero:"); 
        getContentPane().add(jLabel11, new org.netbeans.lib.awtextra.AbsoluteConstraints(270, 90, -1, 20)); 

        jLabel12.setFont(new java.awt.Font("Verdana", 0, 12)); 
        jLabel12.setText("________________________________________________"); 
        getContentPane().add(jLabel12, new org.netbeans.lib.awtextra.AbsoluteConstraints(10, 200, -1, -1)); 

        incluirButton.setFont(new java.awt.Font("Verdana", 0, 10)); 
        incluirButton.setText("Incluir"); 
        incluirButton.addActionListener(new java.awt.event.ActionListener() { 
            public void actionPerformed(java.awt.event.ActionEvent evt) { 
                insertCadastroDB(evt); 
            } 
        }); 

        getContentPane().add(incluirButton, new org.netbeans.lib.awtextra.AbsoluteConstraints(170, 220, -1, -1)); 

        sairButton.setFont(new java.awt.Font("Verdana", 0, 10)); 
        sairButton.setText("Sair"); 
        sairButton.addActionListener(new java.awt.event.ActionListener() { 
            public void actionPerformed(java.awt.event.ActionEvent evt) { 
                fechar(evt); 
            } 
        }); 

        getContentPane().add(sairButton, new org.netbeans.lib.awtextra.AbsoluteConstraints(340, 220, -1, -1)); 

        resetarButton1.setFont(new java.awt.Font("Verdana", 0, 10)); 
        resetarButton1.setText("resetar"); 
        resetarButton1.addActionListener(new java.awt.event.ActionListener() { 
            public void actionPerformed(java.awt.event.ActionEvent evt) { 
                resetaTextFelds(evt); 
            } 
        }); 

        getContentPane().add(resetarButton1, new org.netbeans.lib.awtextra.AbsoluteConstraints(250, 220, 80, -1)); 

        fileMenu.setText("File"); 
        openMenuItem.setText("Open"); 
        fileMenu.add(openMenuItem); 

        saveMenuItem.setText("Save"); 
        fileMenu.add(saveMenuItem); 

        saveAsMenuItem.setText("Save As ..."); 
        fileMenu.add(saveAsMenuItem); 

        exitMenuItem.setText("Exit"); 
        exitMenuItem.addActionListener(new java.awt.event.ActionListener() { 
            public void actionPerformed(java.awt.event.ActionEvent evt) { 
                exitMenuItemActionPerformed(evt); 
            } 
        }); 

        fileMenu.add(exitMenuItem); 

        menuBar.add(fileMenu); 

        editMenu.setText("Edit"); 
        cutMenuItem.setText("Cut"); 
        editMenu.add(cutMenuItem); 

        copyMenuItem.setText("Copy"); 
        editMenu.add(copyMenuItem); 

        pasteMenuItem.setText("Paste"); 
        editMenu.add(pasteMenuItem); 

        deleteMenuItem.setText("Delete"); 
        editMenu.add(deleteMenuItem); 

        menuBar.add(editMenu); 

        helpMenu.setText("Help"); 
        contentsMenuItem.setText("Contents"); 
        helpMenu.add(contentsMenuItem); 

        aboutMenuItem.setText("About"); 
        helpMenu.add(aboutMenuItem); 

        menuBar.add(helpMenu); 

        setJMenuBar(menuBar); 

        pack(); 
    }                        

    private void fechar(java.awt.event.ActionEvent evt) {                        
        System.exit(0); 
    }                        

    private void insertCadastroDB(java.awt.event.ActionEvent evt) {                                  
        Cadastro cadastro = new Cadastro(); 
        cadastro.setNome(this.nomeTextField.getText()); 
        cadastro.setSobrenome(this.sobrenomeTextField.getText()); 
        cadastro.setEndereco(this.enderecoTextField.getText()); 
        cadastro.setNumero(Integer.parseInt(this.numeroTextField.getText())); 
        cadastro.setBairro(this.bairroTextField.getText()); 
        cadastro.setCidade(this.cidadeTextField.getText()); 
        cadastro.setUf(this.ufTextField.getText()); 
        cadastro.setFone(this.foneTextField.getText()); 
        cadastro.setCel(this.celTextField.getText()); 
        cadastro.setFax(this.faxTextField.getText()); 
        
        CadastroDB cdb = new CadastroDB(); 
        cdb.save(cadastro); 
    }                                  

    private void resetaTextFelds(java.awt.event.ActionEvent evt) {                                  
        this.nomeTextField.setText(""); 
        this.sobrenomeTextField.setText(""); 
        this.enderecoTextField.setText(""); 
        this.numeroTextField.setText(""); 
        this.bairroTextField.setText(""); 
        this.cidadeTextField.setText(""); 
        this.ufTextField.setText(""); 
        this.foneTextField.setText(""); 
        this.celTextField.setText(""); 
        this.faxTextField.setText(""); 
    }                                
    
    private void exitMenuItemActionPerformed(java.awt.event.ActionEvent evt) {                                              
        System.exit(0); 
    }                                            
    
    /** 
     * @param args the command line arguments 
     */ 
    public static void main(String args[]) { 
        java.awt.EventQueue.invokeLater(new Runnable() { 
            public void run() { 
                new CadastroEndereco().setVisible(true); 
            } 
        }); 
    } 
    
    // Variables declaration - do not modify                      
    private javax.swing.JLabel Label; 
    private javax.swing.JMenuItem aboutMenuItem; 
    private javax.swing.JTextField bairroTextField; 
    private javax.swing.JTextField celTextField; 
    private javax.swing.JTextField cidadeTextField; 
    private javax.swing.JMenuItem contentsMenuItem; 
    private javax.swing.JMenuItem copyMenuItem; 
    private javax.swing.JMenuItem cutMenuItem; 
    private javax.swing.JMenuItem deleteMenuItem; 
    private javax.swing.JMenu editMenu; 
    private javax.swing.JTextField enderecoTextField; 
    private javax.swing.JMenuItem exitMenuItem; 
    private javax.swing.JTextField faxTextField; 
    private javax.swing.JMenu fileMenu; 
    private javax.swing.JTextField foneTextField; 
    private javax.swing.JMenu helpMenu; 
    private javax.swing.JButton incluirButton; 
    private javax.swing.JLabel jLabel1; 
    private javax.swing.JLabel jLabel10; 
    private javax.swing.JLabel jLabel11; 
    private javax.swing.JLabel jLabel12; 
    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.JMenuBar menuBar; 
    private javax.swing.JTextField nomeTextField; 
    private javax.swing.JTextField numeroTextField; 
    private javax.swing.JMenuItem openMenuItem; 
    private javax.swing.JMenuItem pasteMenuItem; 
    private javax.swing.JButton resetarButton1; 
    private javax.swing.JButton sairButton; 
    private javax.swing.JMenuItem saveAsMenuItem; 
    private javax.swing.JMenuItem saveMenuItem; 
    private javax.swing.JTextField sobrenomeTextField; 
    private javax.swing.JTextField ufTextField; 
    // End of variables declaration                    
    
}

Ai meu Deus… o que será que acuntece…
VAlws pessoal!!
T+!!

[color=“green”][size=“9”]*Editado para adiconar o BBCode, procure sempre utilizar as tags, facilita a visualização do código… http://www.portaljava.com/home/modules.php?name=Forums&file=faq&mode=bbcode[/size][/color]

#2

Aeeeee!!!

Ow pessoal desculpem… é que no desespero gente procura as respostas o mais rapido, é que pensei que assim seria mais facil o pessoal ver para me responder.

Eu achei o erro, o codigo esta totalmente certo, o unico problema e que eu não tinha adicionado no lugar certo a biblioteca do mysql no netbeans, assim que eu adicionei, funcionou uma beleza!!

Falowww!!

#3