1-) Java - MSSQL ARAMA

public void firma_bilgileri_ara() {

String arama_tipi = kampanya_ara.getSelectedItem().toString();//colomn ismi misal "proje_no" ya göre

String aranacak = kampanya_ara1.getText();//burada da proje_no=12 olan yani 12 yi arar

try {

Connection con2 = GetConnection();

Statement stmt = con2.createStatement();//malzeme="sads"

ResultSet rs = null;

rs = stmt.executeQuery("SELECT COUNT(*) AS rowcount7 FROM firma_kayit1 where " + arama_tipi + "='" + aranacak + "'");//aramada hata var

rs.next();

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

rs.close();

rs = stmt.executeQuery("SELECT * FROM firma_kayit1 where " + arama_tipi + "='" + aranacak + "'");//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_tablo1.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)}));

con2.close();

} catch (SQLException ex) {

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

}

}