KODING TAMPIL DATA
- Buatlah new “JFrameFrom”
- Add file JAR "mysql connector" ke dalam Libraries
Add Jar - Buatlah public Connection = conn dan Statement = stt. Dan masukkan koding import.
Koding Import - Database dalam koding berikut “tugas_spk” dengan nama tabel database “alternatif”.
- Berikut adalah Koding Public Void tampildata() dan bukadatabase().
- Lalu buatlah Koding Public Connection dan letakkan koding Public void ke dalam "initComponent;"
- Lalu run file atau tekan Shift + F6. Maka hasilnya adalah sebagai berikut :
Koding bukadatabase() :
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public void bukadatabase(){ | |
try{ | |
Class.forName("com.mysql.jdbc.Driver"); | |
conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/tugas_spk","root",""); // Nama database yang saya buat adalah "tugas_spk" | |
stt = conn.createStatement(); | |
}catch(Exception e){ | |
JOptionPane.showInternalMessageDialog(null, "Koneksi Gagal"); | |
} | |
} |
Koding tampildata() :
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public void tampildata(){ | |
String query; | |
DefaultTableModel tabel_alternatif = new DefaultTableModel(); | |
tabel_alternatif.addColumn("Kode Alternatif"); //Judul Tabel Pertama | |
tabel_alternatif.addColumn("Nama Alternatif"); //Judul Tabel Kedua | |
try{ | |
//koneksi(); | |
stt = conn.createStatement(); | |
query = "Select * from alternatif order by ID_Alternatif asc"; // Memanggil tabel dari database dengan nama tabel "alternatif" | |
ResultSet rs = stt.executeQuery(query); | |
while (rs.next()) | |
{ | |
tabel_alternatif.addRow(new Object[]{ | |
rs.getString(1), // Menampilkan record "pertama" pada database ke dalam JTable | |
rs.getString(2), // Menampilkan record "kedua" pada database ke dalam JTable | |
}); | |
} | |
ta.setModel(tabel_alternatif); | |
}catch (Exception e){ | |
JOptionPane.showMessageDialog(null, "Ada Kesalahan"); | |
} | |
} |
![]() |
Koding initComponent |
![]() |
Koding Java Ramanda |
Tags
Javaa