1-) Java - MYSQL VERİ TABANI TÜM TABLOYU SİLER

Object[][] obj = null;

Connection con = GetConnection();

try {

Statement stmt;

String strSQL;

strSQL = "DELETE FROM fatura";

stmt = con.createStatement();

stmt.execute(strSQL);

stmt.close();

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

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

while (rs.next()) {

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

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

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

obj[icount][3] = rs.getString("birim_fiyat");

obj[icount][4] = rs.getString("malzeme");

obj[icount][5] = rs.getString("miktar");

obj[icount][6] = rs.getString("tutar");

obj[icount][7] = rs.getString("proje_no");

obj[icount][8] = rs.getString("tarih");

obj[icount][9] = rs.getString("resim");

icount = icount + 1;

}

} catch (Exception e) {

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

}

fatura_table.setModel(model);

jLabel17.setIcon(iconyok);