Advertisement
fgroupindonesia

Perintah Update Statement

Jul 12th, 2017
123
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Java 0.88 KB | None | 0 0
  1. private void perintahUpdateStatement(String usernameMasuk, String filenameBaru) {
  2.  
  3.         PreparedStatement pernyataan;
  4.         ResultSet hasil;
  5.         String namaDB = "latihan_java";
  6.         String namaTable = "data_user";
  7.         String kondisi = " WHERE username = ?";
  8.  
  9.         try {
  10.             Connection conn = DriverManager.getConnection("jdbc:mysql://localhost/" + namaDB + "?" + "user=root");
  11.  
  12.             // Update Statement bermula disini
  13.             pernyataan = conn.prepareStatement("UPDATE " + namaTable + " SET filename = ?" + kondisi);
  14.             pernyataan.setString(1, filenameBaru);
  15.             pernyataan.setString(2, usernameMasuk);
  16.        
  17.             pernyataan.executeUpdate();
  18.  
  19.             pernyataan.close();
  20.             conn.close();
  21.  
  22.         } catch (Exception ex) {
  23.             JOptionPane.showMessageDialog(this, "Error ketika koneksi mysql!\n" + ex.getMessage());
  24.         }
  25.  
  26.     }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement