Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- try{
- String url = "jdbc:mysql://localhost/minimarket";
- String user = "root";
- String pass = "";
- Class.forName("com.mysql.jdbc.Driver");
- Connection conn = DriverManager.getConnection(url, user, pass);
- Statement stmt = conn.createStatement();
- ResultSet rsl = stmt.executeQuery("SELECT * FROM keranjang WHERE pemesan='"+login.userid+"'");
- if(rsl.next()){
- String nb = rsl.getString("nama_barang");
- String dtl = rsl.getString("detail");
- String beratt = rsl.getString("berat");
- String hrga = rsl.getString("harga");
- String jmlh = rsl.getString("jumlah");
- stmt.executeUpdate("UPDATE barang SET stok=stok+'"+jmlh+"' WHERE nama_barang='"+nb+"' AND detail='"+dtl+"' AND berat='"+beratt+"'");
- stmt.executeUpdate("DELETE FROM keranjang WHERE pemesan ='"+login.userid+"' AND nama_barang='"+nb+"'");
- }
- conn.close();
- }
- catch (Exception error){
- }
- System.exit(0);
Add Comment
Please, Sign In to add comment