Guest User

Untitled

a guest
Jan 28th, 2019
124
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.26 KB | None | 0 0
  1. try{
  2. String url = "jdbc:mysql://localhost/minimarket";
  3. String user = "root";
  4. String pass = "";
  5. Class.forName("com.mysql.jdbc.Driver");
  6. Connection conn = DriverManager.getConnection(url, user, pass);
  7. Statement stmt = conn.createStatement();
  8.  
  9. ResultSet rsl = stmt.executeQuery("SELECT * FROM keranjang WHERE pemesan='"+login.userid+"'");
  10.  
  11. if(rsl.next()){
  12. String nb = rsl.getString("nama_barang");
  13. String dtl = rsl.getString("detail");
  14. String beratt = rsl.getString("berat");
  15. String hrga = rsl.getString("harga");
  16. String jmlh = rsl.getString("jumlah");
  17. stmt.executeUpdate("UPDATE barang SET stok=stok+'"+jmlh+"' WHERE nama_barang='"+nb+"' AND detail='"+dtl+"' AND berat='"+beratt+"'");
  18. stmt.executeUpdate("DELETE FROM keranjang WHERE pemesan ='"+login.userid+"' AND nama_barang='"+nb+"'");
  19. }
  20.  
  21. conn.close();
  22. }
  23. catch (Exception error){
  24.  
  25. }
  26. System.exit(0);
Add Comment
Please, Sign In to add comment