1-) Java - JAVAFX TABLEVİEW İÇİNE MSSQL DEKİ VERİLERİ YAZMAK İÇİN GEREKLİ OLAN KODLAR

//CLASS BAŞLANGIÇ AYRI CLASS OLACAK NEW CLASS DE BUNA

public class table_firma {

private final SimpleIntegerProperty id;

private final SimpleStringProperty firma_adi;

private final SimpleStringProperty satis;

private final SimpleStringProperty ortaklik;

private final SimpleStringProperty web;

private final SimpleStringProperty mail;

public table_firma(int id, String firma_adi, String satis, String ortaklik, String web, String mail) {

this.id = new SimpleIntegerProperty(id);

this.firma_adi = new SimpleStringProperty(firma_adi);

this.satis = new SimpleStringProperty(satis);

this.ortaklik = new SimpleStringProperty(ortaklik);

this.web = new SimpleStringProperty(web);

this.mail = new SimpleStringProperty(mail); }

public Integer getId() {

return id.get(); }

public String getFirma_adi() {

return firma_adi.get(); }

public String getSatis() {

return satis.get(); }

public String getOrtaklik() {

return ortaklik.get(); }

public String getWeb() {

return web.get(); }

public String getMail() {

return mail.get(); }

public void setId(Integer idd) {

id.set(idd); }

public void setFirma_adi(String firma) {

firma_adi.set(firma); }

public void setSatis(String satiss) {

satis.set(satiss); }

public void setOrtaklik(String ortak) {

ortaklik.set(ortak); }

public void setWeb(String webb) {

web.set(webb); }

public void setMail(String maill) {

mail.set(maill); }}

//CLASS BİTİŞ

//AŞŞAĞIDAKİ KODLARI CONTROL ALANINA YAZ

@FXML

TableView table_firma;

@FXML

TableColumn firma_id;

@FXML

TableColumn firma_firma_adi;

@FXML

TableColumn firma_satis;

@FXML

TableColumn firma_ortalik;

@FXML

TableColumn firma_web;

@FXML

TableColumn firma_mail;

final ObservableList firma_date = FXCollections.observableArrayList();

//VERİ TABANIMDAKİ VERİLERİ TABLEVİEW E YAZAR

@FXML

public void firma_goster() {

firma_date.clear();

try {

firma_id.setCellValueFactory(new PropertyValueFactory<>("id"));

firma_firma_adi.setCellValueFactory(new PropertyValueFactory<>("firma_adi"));

firma_satis.setCellValueFactory(new PropertyValueFactory<>("satis"));

firma_ortalik.setCellValueFactory(new PropertyValueFactory<>("ortaklik"));

firma_web.setCellValueFactory(new PropertyValueFactory<>("web"));

firma_mail.setCellValueFactory(new PropertyValueFactory<>("mail"));

Connection con = GetConnection();

String sql = "select * from firma_kayit1";

Statement stmt = con.createStatement();

ResultSet rs = stmt.executeQuery(sql);

while (rs.next()) {

System.out.println("isim = " + rs.getString("id"));

int id1 = rs.getInt("id");

String firma = rs.getString("firma_adi");

String satis = rs.getString("satis");

String ortak = rs.getString("ortaklik");

String web = rs.getString("web");

String mail = rs.getString("mail");

table_firma ekle = new table_firma(id1, firma, satis, ortak, web, mail);

firma_date.add(ekle);

table_firma.setItems(firma_date); }

} catch (SQLException ex) {

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