1-) Java - MSSQL GÜNCELLEME GUNCELLEME UPDATE YAPMA

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();

firma_goster();

} catch (SQLException ex) {

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

} }

//--------------------------------------------------------------------

public void firma_goster() {

try {

Connection con = GetConnection();

Statement stmt = con.createStatement();

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

rs.next();

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

rs.close();

rs = stmt.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)}));

con.close();

} catch (SQLException ex) {

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