Advertisement
fgroupindonesia

Perintah Select Statement

Jul 12th, 2017
147
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 1.01 KB | None | 0 0
  1. private void perintahSelectStatement() {
  2.  
  3.         PreparedStatement pernyataan;
  4.         ResultSet hasil;
  5.         String namaDB = "latihan_java";
  6.         String namaTable = "data_user";
  7.  
  8.         try {
  9.             Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/" + namaDB + "?" + "user=root");
  10.  
  11.             // Select Statement bermula disini
  12.             pernyataan = conn.prepareStatement("SELECT * FROM " + namaTable);
  13.  
  14.             hasil = pernyataan.executeQuery();
  15.  
  16.             int nomer = 1;
  17.  
  18.             while (hasil.next()) {
  19.  
  20.                 // mengambil kolom username dan filename dari table mysql
  21.                 System.out.print("data ke " + nomer + " " + hasil.getString("username") + " " + hasil.getString("filename"));
  22.  
  23.                 nomer++;
  24.             }
  25.  
  26.             pernyataan.close();
  27.             conn.close();
  28.  
  29.         } catch (Exception ex) {
  30.             JOptionPane.showMessageDialog(this, "Error ketika koneksi mysql!\n" + ex.getMessage());
  31.         }
  32.  
  33.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement