1-) Java - MYSQL EKLEME İD Yİ PRİMARY KEY YAPINCA BUNU KULLAN

String aciklama, web, bas_tarihi, bit_tarihi, firma_adi;

bas_tarihi = new SimpleDateFormat("yyyy/MM/dd").format(kampanya_bas.getDate());

bit_tarihi = new SimpleDateFormat("yyyy/MM/dd").format(kampanya_bit.getDate());

aciklama = kampanya_aciklama.getText();

web = kampanya_web.getText();

firma_adi = kampanya_firma.getSelectedItem().toString();

try (Connection conn = GetConnection()) {

String sql = "INSERT INTO kampanya_kayit (id,firma_adi,aciklama,web,bas_tarihi,bit_tarihi) values (?,?,?,?,?,?)";

PreparedStatement statement = conn.prepareStatement(sql);

ResultSet rs1 = statement.executeQuery("SELECT COUNT(*) AS rowcount FROM kampanya_kayit");

rs1.next();

int icount1 = rs1.getInt("rowcount");

System.out.println("sayim" + icount1);

statement.setInt(1, icount1 + 1);

statement.setString(2, firma_adi);

statement.setString(3, aciklama);

statement.setString(4, web);

statement.setString(5, bas_tarihi);

statement.setString(6, bit_tarihi);

int row = statement.executeUpdate();

if (row > 0) {

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

}

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

rs.next();

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

rs.close();

rs = statement.executeQuery("SELECT * FROM kampanya_kayit");//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("aciklama");

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

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

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

icount = icount + 1;

}

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

conn.close();

} catch (SQLException ex) {

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

}