Skip to content

Instantly share code, notes, and snippets.

@fatkhuliyan
Created March 5, 2018 13:41
Show Gist options
  • Save fatkhuliyan/f9f335fab2cd61c06ca3dd96de3325dc to your computer and use it in GitHub Desktop.
Save fatkhuliyan/f9f335fab2cd61c06ca3dd96de3325dc to your computer and use it in GitHub Desktop.
Java getdata
public void ambilData() {
refresh();
String [] kolom = {"Kode_Obat","Nama_Obat","Jenis","Stock","Satuan","Harga_Beli","Harga_Jual"};
ob.setColumnIdentifiers(kolom);
try {
String sql = "SELECT * FROM tb_obat";
ResultSet rs = stat.executeQuery(sql);
while (rs.next()) {
String Kode_Obat = rs.getString("Kode_Obat");
String Nama_Obat = rs.getString("Nama_Obat");
String Jenis = rs.getString("Jenis");
String Stock = rs.getString("Stock");
String Satuan = rs.getString("Satuan");
String Harga_Beli = rs.getString("Harga_Beli");
String Harga_Jual = rs.getString("Harga_Jual");
String [] data = {Kode_Obat,Nama_Obat,Jenis,Stock,Satuan,Harga_Beli,Harga_Jual};
ob.addRow(data);
}
} catch (SQLException e) {
JOptionPane.showMessageDialog(null, "Terjadi Kesalahan "+e);
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment