Page 290 - IT-802_class_12
P. 290
9. While browsing commodities on the website, buyers may wish to buy some commodities at a later point of time. At
this point, he may add certain commodities to the wish list. For achieving this, function insert_wish of class WishList
may be invoked. Also, the buyer may want to delete certain commodities from the wish list. This may be achieved
using function delete_wish. At later point in time, buyer may view his wishlist using function display_wishlist.
package shopping_application;
public class WishList
public void insert_wish (Stringwish_tuple[])
//Add functionally to insert a row of wish named
//wish tuple
//SQL command to be used: insert
public void delete_wish (int wish_id, string wish)
//Add functionally to delete a wish of buyer with id //buyer id
//SQL command to be used: delete
public void display_wish (int buyer_id)
//Add functionally to display wish list of buyer with id
//buyer id
//SQL command to be used: select
10. When a buyer adds commodities to be purchased in the shopping cart, he has to go through a series of events.
Add items in shopping cart
Select Buy option
Provide your details
(or login into account)
Choose payment option
(Make payment if not cash on
delivery)
11. In case, if the customer is not already logged in, he is asked to login or to enter his details. After that, he may
choose to pay through any of the available payment modes. All the details of payment are stored in table PAYMENT
using function insert_payment of class Payment. In case, the customer wants to opt for cash on delivery, attribute
Payment_date is set to the date on which the product is delivered.
package shopping_application;
public class payment
{ public void insert_payment (String payment_tup1eC] )
288 Touchpad Information Technology-XII

