Advertisement
Guest User

Untitled

a guest
Nov 14th, 2019
113
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.96 KB | None | 0 0
  1. public void getData(JTable tblData,String kondisi){
  2.         JMySQL.cn = JMySQL.getKoneksi();          
  3.         JMySQL.tblMode = (DefaultTableModel) tblData.getModel();
  4.         JMySQL.tblMode.getDataVector().removeAllElements();
  5.         if(!kondisi.equals("")){
  6.             kondisi = " where "+kondisi;
  7.         }
  8.         try{
  9.             JMySQL.pr = JMySQL.cn.prepareStatement("select *from mahasiswa "+kondisi);
  10.             JMySQL.pr.executeQuery();
  11.             JMySQL.rs = JMySQL.pr.getResultSet();
  12.             while(JMySQL.rs.next()){
  13.                this.nim = JMySQL.rs.getString("nim");
  14.                this.nama = JMySQL.rs.getString("nama");
  15.                this.alamat = JMySQL.rs.getString("alamat");
  16.                JMySQL.tblMode.addRow(new Object[]{this.nim,this.nama,this.alamat});
  17.             }
  18.         }catch (Exception e){
  19.             JOptionPane.showMessageDialog(null, e);
  20.         }
  21.         JMySQL.tutupKoneksi(JMySQL.cn, JMySQL.pr, JMySQL.rs);
  22.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement