Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void perintahSelectStatement() {
- PreparedStatement pernyataan;
- ResultSet hasil;
- String namaDB = "latihan_java";
- String namaTable = "data_user";
- try {
- Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/" + namaDB + "?" + "user=root");
- // Select Statement bermula disini
- pernyataan = conn.prepareStatement("SELECT * FROM " + namaTable);
- hasil = pernyataan.executeQuery();
- int nomer = 1;
- while (hasil.next()) {
- // mengambil kolom username dan filename dari table mysql
- System.out.print("data ke " + nomer + " " + hasil.getString("username") + " " + hasil.getString("filename"));
- nomer++;
- }
- pernyataan.close();
- conn.close();
- } catch (Exception ex) {
- JOptionPane.showMessageDialog(this, "Error ketika koneksi mysql!\n" + ex.getMessage());
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement