contoh source code java netbeans IDE untuk memanggil database

public void koneksidb(){

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbc");
            con = DriverManager.getConnection("jdbc:odbc:dbilham");
            st = con.createStatement();
        } catch (Exception e) {
        }
    }

Contoh source code java netbeans IDE untuk menampilkan TABEL

public void tampiltabel(){

           Object [] row = {"No","NoKTP","NoKK","Nama","Jekel","Tanggal","Hari","Tempat","sebab","Desa"};
     tbl = new DefaultTableModel(null,row);
     jTable2.setModel(tbl);
     jTable2.setBorder(null);
     jScrollPane2.setViewportView(jTable2);
     jScrollPane2.setVisible(true);
      String a="",b="",c="",d="",f="",g="",h="",i="",j="",k="";
     int no = 1;

        try {
            rs =st.executeQuery("select *from dbmeninggal ");
            while (rs.next()) {

                a = ""+no++;
                b = rs.getString(1);
                c = rs.getString(2);
                d = rs.getString(3);
                f = rs.getString(4);
                g = rs.getString(5);
                h = rs.getString(6);
                i = rs.getString(7);
                j = rs.getString(8);
                k = rs.getString(9);
                Object [] tampil = {a,b,c,d,f,g,h,i,j,k};
                tbl.addRow(tampil);
                }
        } catch (Exception e) {
        }


     }

Contoh source code java netbeans IDE untuk TOMBOL DELETE

private void hapusActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_hapusActionPerformed
        int ok = JOptionPane.showConfirmDialog(null, "Anda Yakin Akan Menghapus Data Ini ??? ","",JOptionPane.YES_NO_OPTION);
        if (ok==0){

            try {
                koneksidb();
                sql = "delete from dbmeninggal where no_ktp='"+vnoktp.getSelectedItem().toString()+"'";
                st.execute(sql);
                kosong();
                JOptionPane.showMessageDialog(null, "Data Sudah Dihapus");

            } catch (Exception e) {   JOptionPane.showMessageDialog(null, ""+e);
            }
            tampiltabel();

        }
    }//GEN-LAST:event_hapusActionPerformed

Contoh source code java netbeans IDE untuk TOMBOL EDIT

private void veditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_veditActionPerformed
        String a="",b="",c="",d="",f="",g="",h="",i="",j="";
        a = vnoktp.getSelectedItem().toString();
        b = vno_kk.getSelectedItem().toString();
        c = vnama.getText();
        d = vjekel.getText();
        f = vtglwafat.getDateFormatString();
        g = vhari.getSelectedItem().toString();
        h = vtmp.getText();
        i = vsbb.getText();
        j = vdesa.getSelectedItem().toString();




        int ok = JOptionPane.showConfirmDialog(null, "Anda Yakin  Data Ini Akan Diedit ??? ","",JOptionPane.YES_NO_OPTION);
        if (ok==0){

            try {
                koneksidb();
                sql = "update dbmeninggal set no_ktp='"+a+"',no_kk='"+b+"',nama='"+c+"',jekel='"+d+"',tgl='"+f+"',hari='"+g+"',tempat='"+h+"',sebab='"+i+"',desa='"+j+"' where no_ktp ='"+a+"'";
                st.execute(sql);
                kosong();
                JOptionPane.showMessageDialog(null, "Data Telah Diedit");
            } catch (Exception e) {JOptionPane.showMessageDialog(null, ""+e);
            } tampiltabel();
        }//GEN-LAST:event_veditActionPerformed
    }

Contoh source code java netbeans IDE untuk TOMBOL SAVE

private void simpanActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_simpanActionPerformed
        int ok =JOptionPane.showConfirmDialog(null, "Apakah Anda yakin Akan Menyimpan Data Ini...??","",JOptionPane.YES_NO_OPTION);
        String a="",b="",c="",d="",f="",g="",h="",i="",j="";
        {
            a=vnoktp.getSelectedItem().toString();
            b=vno_kk.getSelectedItem().toString();
            c=vnama.getText();
            d=vjekel.getText();
            g=vhari.getSelectedItem().toString();
            h=vtmp.getText();
            i=vsbb.getText();
            j=vdesa.getSelectedItem().toString();

            if (ok==0){
                try{
                    koneksidb();
                    sql ="insert into dbmeninggal values('"+a+"','"+b+"','"+c+"','"+d+"','"+tanggalwafat+"','"+g+"','"+h+"','"+i+"','"+j+"')";
                    st.execute(sql);
                    kosong();
                    JOptionPane.showMessageDialog(null,"Data Disimpan");
                }catch (Exception e) { JOptionPane.showMessageDialog(null, ""+e);
                }tampiltabel();}
        }
    }//GEN-LAST:event_simpanActionPerformed

    private void vkluarActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_vkluarActionPerformed
        dispose();
}//GEN-LAST:event_vkluarActionPerformed

    private void veditActionPerformed(java.awt.event.ActionEvent evt) {//GEN-FIRST:event_veditActionPerformed
        String a="",b="",c="",d="",f="",g="",h="",i="",j="";
        a = vnoktp.getSelectedItem().toString();
        b = vno_kk.getSelectedItem().toString();
        c = vnama.getText();
        d = vjekel.getText();
        f = vtglwafat.getDateFormatString();
        g = vhari.getSelectedItem().toString();
        h = vtmp.getText();
        i = vsbb.getText();
        j = vdesa.getSelectedItem().toString();




        int ok = JOptionPane.showConfirmDialog(null, "Anda Yakin  Data Ini Akan Diedit ??? ","",JOptionPane.YES_NO_OPTION);
        if (ok==0){

            try {
                koneksidb();
                sql = "update dbmeninggal set no_ktp='"+a+"',no_kk='"+b+"',nama='"+c+"',jekel='"+d+"',tgl='"+f+"',hari='"+g+"',tempat='"+h+"',sebab='"+i+"',desa='"+j+"' where no_ktp ='"+a+"'";
                st.execute(sql);
                kosong();
                JOptionPane.showMessageDialog(null, "Data Telah Diedit");
            } catch (Exception e) {JOptionPane.showMessageDialog(null, ""+e);
            } tampiltabel();
        }    }