// Checkout public String checkOut(String memno) { String res = " "; int count = 0; try { String query = "Select * from customerdetails WHERE membershipno=?"; ps = con.prepareStatement(query); ps.setString(1, memno); rs = ps.executeQuery(); while (rs.next()) { count++; System.out.println(count); } CustomerDBConnection c = new CustomerDBConnection(); // checking if the max allowed count has already been reached in the customerdetails DB System.out.println("calculating the movies checkedout...."); String result2 = c.checkedOutMovies(memno, count); // if it hasnt if (result2.equals("true")) { System.out.println("checking count in cart..."); // get the count of movies in the cart int count_cart = c.checkCart(memno); System.out.println(count_cart); // compare with the max_allowed System.out.println("checking validity for checkout...."); res = c.checkValidity(memno, count, count_cart); } } catch (Exception e) { e.printStackTrace(); } finally { try { rs.close(); ps.close(); // con.close(); } catch (SQLException e) { e.printStackTrace(); } } return res; }
public String addtoCart(String memNo, int movieId) { String res = " "; ResultSet rs = null; PreparedStatement ps = null; try { // con = getConnection(); CustomerDBConnection c = new CustomerDBConnection(); String result = c.checkCart(memNo, movieId); if (result.equals("true")) { String result2 = c.decreaseQuantity(movieId); if (result2.equals("true")) { String query = "Insert into cart(memNo,movieID) values(?,?)"; ps = con.prepareStatement(query); ps.setString(1, memNo); System.out.println(memNo); ps.setInt(2, movieId); System.out.println(movieId); ps.executeUpdate(); 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()) { 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); String rent = rs.getString(6); String cat = rs.getString(7); String quant = rs.getString(8); res += movieID + ";" + name + ";" + banner + ";" + description + ";" + releaseDate + ";" + cat + ";" + quant + "##"; } } } else { res = "false"; } } catch (Exception e) { e.printStackTrace(); } return res; }