1-) Java - MYSQL GÜNCELLEME UPDATE ETME

int value;

private void firma_tabloMouseClicked(java.awt.event.MouseEvent evt) {

//BURADA JTABLEYE TIKLANINCA OLAYINDA TIKLADIGIM SATIRIN İD DEĞERİNİ ALIYOR

//JTABLEDE id diye SUTUN İSMİ OLMAK ZORUNDA

TableModel tm = firma_tablo.getModel();

int j, max = 0;

for (j = 0; j < tm.getColumnCount(); j++) {

if (tm.getColumnName(j) == "id")//TABLODAKİ SUTUN İSMİ id OLANIN

{

break;

}

}

value = Integer.parseInt(tm.getValueAt(firma_tablo.getSelectedRow(), j).toString());

System.out.println("degeri " + value);

}

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

String ad, satis, ortaklik, web, mail;

ad = firma_adi.getText();

satis = firma_satis.getText();

ortaklik = firma_ortak.getText();

web = firma_web.getText();

mail = firma_mail.getText();

try (Connection conn = GetConnection()) {

String query = "update firma_kayit1 set firma_adi='" + ad + "',satis='" + satis + "',ortaklik='" + ortaklik + "'"

+ ",web='" + web + "',mail='" + mail + "' where id=" + value;

PreparedStatement preparedStmt = conn.prepareStatement(query);

preparedStmt.executeUpdate();

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

rs.next();

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

rs.close();

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

Object[][] obj = new Object[icount][6];

icount = 0;

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

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

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

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

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

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

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

icount = icount + 1; }

firma_tablo.setModel(new javax.swing.table.DefaultTableModel(obj, new String[]{firma_tablo.getColumnName(0), firma_tablo.getColumnName(1), firma_tablo.getColumnName(2), firma_tablo.getColumnName(3), firma_tablo.getColumnName(4), firma_tablo.getColumnName(5)}));

conn.close();

} catch (SQLException ex) {

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

} }