public String removefromCart(String memNo, int movieID) {
String res = " ";
// Connection con = null
ResultSet rs = null;
PreparedStatement ps = null;
try {
String query1 =
"Select c.movieID,moviename,banner,description,releasedate,rent,category,quantity FROM movie m,cart c WHERE m.idMovie = c.movieId and c.memNo=?";
ps = con.prepareStatement(query1);
ps.setString(1, memNo);
rs = ps.executeQuery();
while (rs.next()) {
System.out.println("inside resultset");
int movieId = rs.getInt(1);
String name = rs.getString(2);
String banner = rs.getString(3);
String description = rs.getString(4);
String releaseDate = rs.getString(5);
int rent = rs.getInt(6);
String cat = rs.getString(7);
int quant = rs.getInt(8);
res +=
movieId
+ ";"
+ name
+ ";"
+ banner
+ ";"
+ description
+ ";"
+ releaseDate
+ ";"
+ rent
+ ";"
+ cat
+ ";"
+ quant;
}
String query = "Delete FROM cart Where memNo=? And movieID=?";
ps = con.prepareStatement(query);
ps.setString(1, memNo);
System.out.println(memNo);
ps.setInt(2, movieID);
System.out.println(movieID);
ps.executeUpdate();
CustomerDBConnection c = new CustomerDBConnection();
c.addQuantity(movieID);
} catch (Exception e) {
e.printStackTrace();
res = "false";
} finally {
try {
ps.close();
// con.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
return res;
}
