1-) Java - MSSQL EKLEME YAPMA

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 sql = "INSERT INTO firma_kayit1 (firma_adi,satis,ortaklik,web,mail) values (?,?,?,?,?)";

PreparedStatement statement = conn.prepareStatement(sql);

statement.setString(1, ad);

statement.setString(2, satis);

statement.setString(3, ortaklik);

statement.setString(4, web);

statement.setString(5, mail);

int row = statement.executeUpdate();

if (row > 0) {

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

}

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