NetBeans com banco de Dados Access

Programação Java
#1

Olá estou precisando da ajuda de alguem, estou fazendo um trabalho final de curso na minha faculdade só que estou com um problemão não estou conseguindo colocar o meu banco de dados para funcionar gostaria que alguem me ajuda-se.

" Um dos problemas é o formulário está correto como todo o codigo fonte mas o problema é que , coloquei um codigo no meu botão cadastrar chamando o banco de dados, o progrma está compilando normal mas quando cadastro e aperto o botão cadastrar ele fica pensando tipo cadastrando no banco mas quando fecho o meu projeto ele me da um erro :

:oops: SQLException [Microsoft][Driver ODBC para Microsoft Access] Tipo de dados imcompatível na expressão de critério.

o codigo é esse :

private void cadBat(){
String url = “jdbc:odbc:SysCat”;
Connection con ;
Statement stmt;

    try {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    } catch( java.lang.ClassNotFoundException e) {
        System.err.print("ClassNotFoundException: ");
        System.err.println(e.getMessage( ) );
    }
  
    try {
        
        con = DriverManager.getConnection(url);
        
        stmt = con.createStatement( ) ;
        stmt.executeUpdate("insert into BATIZADO ( txtNome, txtDatNasc, txtIdade, txtTelefone, txtNomePai, txtTelPai, txtNomeMae, txtTelMae, cmbCasados, txtNomeIgreja, txtNomePad, txtTelPad, txtNomeMad, txtTelMad, cmbCasadosPadMad, txtNomeIgrejaPads, cmbLivro, txtPagina, txtFolha, txtDatBat, txtNomePadre) values( '"+ txtNome+"' , '"+txtDatNasc+"' , '"+txtIdade+"' , '"+txtTelefone+"' , '"+txtNomePai+"' , '"+txtTelPai+"' , '"+txtNomeMae+"', '"+txtTelMae+"', '"+cmbCasados+"', '"+txtNomeIgreja+"', '"+txtNomePad+"', '"+txtTelPad+"', '"+txtNomeMad+"', '"+txtTelMad+"', '"+cmbCasadosPadMad+"', '"+txtNomeIgrejaPads+"', '"+cmbLivro+"', '"+txtPagina+"', '"+txtFolha+"', '"+txtDatBat+"', '"+txtNomePadre+"' ) " );
                     
        

        stmt.close();
        con.close();
        
       
    }
     catch(SQLException ex) {
     System.err.println("SQLException " + ex.getMessage());
        
    }
 

}

depois chama o metodo dentro do botão Cadastrar :

private void btnCadastrarActionPerformed(java.awt.event.ActionEvent evt) {

cadBat();
       
}
#2

pela mensagem parece q a query tá errado mesmo…

tenta fazer o seguinte:

stmt = con.createStatement( ) ;
String query = “insert into BATIZADO ( txtNome, txtDatNasc, txtIdade, txtTelefone, txtNomePai, txtTelPai, txtNomeMae, txtTelMae, cmbCasados, txtNomeIgreja, txtNomePad, txtTelPad, txtNomeMad, txtTelMad, cmbCasadosPadMad, txtNomeIgrejaPads, cmbLivro, txtPagina, txtFolha, txtDatBat, txtNomePadre) values( '”+ txtNome+"’ , ‘"+txtDatNasc+"’ , ‘"+txtIdade+"’ , ‘"+txtTelefone+"’ , ‘"+txtNomePai+"’ , ‘"+txtTelPai+"’ , ‘"+txtNomeMae+"’, ‘"+txtTelMae+"’, ‘"+cmbCasados+"’, ‘"+txtNomeIgreja+"’, ‘"+txtNomePad+"’, ‘"+txtTelPad+"’, ‘"+txtNomeMad+"’, ‘"+txtTelMad+"’, ‘"+cmbCasadosPadMad+"’, ‘"+txtNomeIgrejaPads+"’, ‘"+cmbLivro+"’, ‘"+txtPagina+"’, ‘"+txtFolha+"’, ‘"+txtDatBat+"’, ‘"+txtNomePadre+"’ ) " ;
System.out.println(query);
stmt.executeUpdate(query);

Isso vai imprimir a query no prompt… pega ela e executa direto no banco pra ver se vai. se der pau, é o teu SQL q tá errado…

#3

consegui e que está faltando passar o

agora está dando esse erão :

insert into BATIZADO ( txtNome, txtDatNasc, txtIdade, txtTelefone, txtNomePai, txtTelPai, txtNomeMae, txtTelMae, cmbCasados, txtNomeIgreja, txtNomePad, txtTelPad, txtNomeMad, txtTelMad, cmbCasadosPadMad, txtNomeIgrejaPads, cmbLivro, txtPagina, txtFolha, txtDatBat, txtNomePadre) values( ‘javax.swing.JTextField[,60,10,300x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’ , ‘javax.swing.JTextField[,500,10,140x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’ , ‘javax.swing.JTextField[,60,40,100x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’ , ‘javax.swing.JTextField[,250,40,100x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’ , ‘javax.swing.JTextField[,100,110,320x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’ , ‘javax.swing.JTextField[,510,110,130x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’ , ‘javax.swing.JTextField[,100,140,320x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,510,140,130x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JComboBox[,80,170,70x20,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=null,alignmentY=null,border=,flags=328,maximumSize=,minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=Sim]’, ‘javax.swing.JTextField[,250,170,390x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,130,240,290x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,510,240,130x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,130,270,290x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,510,270,130x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JComboBox[,80,300,70x20,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=null,alignmentY=null,border=,flags=328,maximumSize=,minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=Sim]’, ‘javax.swing.JTextField[,260,300,380x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JComboBox[,210,370,70x20,layout=javax.swing.plaf.metal.MetalComboBoxUI$MetalComboBoxLayoutManager,alignmentX=null,alignmentY=null,border=,flags=328,maximumSize=,minimumSize=,preferredSize=,isEditable=false,lightWeightPopupEnabled=true,maximumRowCount=8,selectedItemReminder=1]’, ‘javax.swing.JTextField[,360,370,70x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,510,370,63x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,380,410,120x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’, ‘javax.swing.JTextField[,200,440,400x20,layout=javax.swing.plaf.basic.BasicTextUI$UpdateHandler,alignmentX=null,alignmentY=null,border=javax.swing.plaf.BorderUIResource$CompoundBorderUIResource@126d3df,flags=296,maximumSize=,minimumSize=,preferredSize=,caretColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],disabledTextColor=javax.swing.plaf.ColorUIResource[r=153,g=153,b=153],editable=true,margin=javax.swing.plaf.InsetsUIResource[top=0,left=0,bottom=0,right=0],selectedTextColor=javax.swing.plaf.ColorUIResource[r=0,g=0,b=0],selectionColor=javax.swing.plaf.ColorUIResource[r=204,g=204,b=255],columns=0,columnWidth=0,command=,horizontalAlignment=LEADING]’ )
SQLException [Microsoft][Driver ODBC para Microsoft Access] Tipo de dados imcompatível na expressão de critério.

#4

não é um erro…

txtNome deve ser o teu JTextField, não?? se for chame o método getText() do txtNome para pegar o valor e não o objeto… faça isso para todos os JTextFields.

#5