1-) Java - VERİ TABANI ACCESE KAYDET,SİL,TÜM KAYITLARI GÖSTER,YAŞI 23 DEN BÜYÜK OLANLAR,PUPUP MENU İLE SİL?.7.1 NETBEANSDA ÇALIŞIYOR?.

BUNU YAZMAN LAZIM YOKSA VERİ TABANINA BAĞLANTIYI SAĞLAYAMASSIN HİÇ BİR KODUN ÇALIŞMAZ BU OLMAZSA

//KOD BAŞLANGICI 1

public Connection GetConnection() {

Connection con;

con = null;

try {

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

String database = "jdbc:odbc:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=" + "C:\\Users\\Ramazan\\Documents\\NetBeansProjects\\veri_tabani1\\veri.accdb";

con = DriverManager.getConnection(database, "", ""); }

catch (Exception e) { JOptionPane.showMessageDialog(null, e.toString(), "student DataBase", JOptionPane.INFORMATION_MESSAGE); }

return con; }

VERİ TABANINA KAYDEDER ACCES DOSYASI OLMASI LAZIM ADI VERİ ALANLARI AD VE YAS

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

Connection con = GetConnection();

try {

Statement stmt;

String strSQL, ad, yas;

ad = jTextField1.getText();

yas = jTextField2.getText();

strSQL = "INSERT INTO kisi(ad,yas) VALUES('" + ad + "'," + yas + ")";

stmt = con.createStatement();

stmt.execute(strSQL);

stmt.close();

JOptionPane.showMessageDialog(null, "veriler kaydedildi"); }

catch (Exception e) { JOptionPane.showMessageDialog(null, e.getMessage()); } }

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

//VERİ TABANINDAKİ İSME GÖRE SİLER

Connection con = GetConnection();

try {

Statement stmt;

String strSQL, ad, yas;

ad = jTextField1.getText();

yas = jTextField2.getText();

strSQL = "DELETE FROM kisi where ad='" + ad + "'";

stmt = con.createStatement();

stmt.execute(strSQL);

stmt.close();

JOptionPane.showMessageDialog(null, "veriler silindi"); }

catch (Exception e) { JOptionPane.showMessageDialog(null, e.getMessage()); } }

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

//TÜM KAYITLARI GÖSTERİR VERİTABANINDAKİ

try {

Connection con2 = GetConnection();

Statement stmt = con2.createStatement();

Object[][] obj;

ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS rowcount FROM kisi");//kisi tablosunda secim yap ne war ne yoksa sayisini al satir sayisini al

rs.next();

int icount = rs.getInt("rowcount");

rs.close();

rs = stmt.executeQuery("SELECT * FROM kisi");//kisi tablosunun hepsini getir

obj = new Object[icount][3];

icount = 0;

while ((rs != null) && rs.next()) {

obj[icount][0] = icount + 1;

obj[icount][1] = rs.getString("ad");

obj[icount][2] = rs.getString("yas");

icount = icount + 1; } con2.close();

jTable1.setModel(new javax.swing.table.DefaultTableModel(obj, new String[]{"S.no :", "ad:", "yas:"})); }

catch (SQLException ex) { Logger.getLogger(veri_t.class.getName()).log(Level.SEVERE, null, ex); } }           

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

//VERİ TABANINDAKİ YAŞI TEXTFİELDE GİRİLEN DEGERDEN BUYUK OLANLARI TABLOYA GETİRİR

try {

Connection con2 = GetConnection();

Statement stmt = con2.createStatement();

Object[][] obj;

ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS rowcount FROM kisi where yas>" + jTextField3.getText());//kisi tablosunda secim yap ne war ne yoksa sayisini al satir sayisini al

rs.next();

int icount = rs.getInt("rowcount");

rs.close();

rs = stmt.executeQuery("SELECT * FROM kisi where yas>" + jTextField3.getText());//kisi tablosunun hepsini getir

obj = new Object[icount][3];

icount = 0;

while ((rs != null) && rs.next()) {

obj[icount][0] = icount + 1;

obj[icount][1] = rs.getString("ad");

obj[icount][2] = rs.getString("yas");

icount = icount + 1; } con2.close();

jTable1.setModel(new javax.swing.table.DefaultTableModel(obj, new String[]{"S.no :", "ad:", "yas:"}));

} catch (SQLException ex) {

Logger.getLogger(veri_t.class.getName()).log(Level.SEVERE, null, ex); } }

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

//POPUP MENU TABLOYA SAĞTIKLA SİL DE O KAYITI VERİ TABANINDAN SİLER

Object[][] obj = null;

Connection con = GetConnection();

try {

Statement stmt;

String strSQL, ad, yas;

ad = String.valueOf(jTable1.getValueAt(jTable1.getSelectedRow(), 1));

yas = jTextField2.getText();

strSQL = "DELETE FROM kisi where ad='" + ad + "'";

stmt = con.createStatement();

stmt.execute(strSQL);

stmt.close();

ResultSet rs = stmt.executeQuery("SELECT COUNT(*) AS rowcount FROM kisi");

int icount = rs.getInt("rowcount");

while (rs.next()) {

obj[icount][0] = icount + 1;

obj[icount][1] = rs.getString("ad");

obj[icount][2] = rs.getString("yas");

icount = icount + 1; } }

catch (Exception e) { JOptionPane.showMessageDialog(null, "veriler silindi"); } }

private void formWindowOpened(java.awt.event.WindowEvent evt) {

// popup menu yu jtableye odakla

jTable1.setComponentPopupMenu(jPopupMenu1);

jMenuItem1.setText("SİL"); }

//KOD BİTİŞİ 1