You may find more details about this project at my personal blog

• User (userId, name, phoneNum)
• Buyer (userId)
• Seller (userId)
• Bank Card (cardNumber, userId, bank, expiryDate)
• Credit Card (cardNumber, organization)
• Debit Card (cardNumber)
• Store (sid, name, startTime, customerGrade, streetAddr, city, province)
• Product (pid, sid, name, brand, type, amount, price, colour, customerReview, modelNumber)
• Order Item (itemid, pid, price, creationTime)
• Order (orderNumber, creationTime, paymentStatus, totalAmount)
• Address (addrid, userid, name, city, postalCode, streetAddr, province, contactPhoneNumber)

• Manage (userid, sid, SetupTime) (userid ref Seller, sid ref Store)
• Save to Shopping Cart (userid, pid, quantity, addtime) (userid ref Buyer, pid ref Product)
• Contain (orderNumber, itemid, quantity) (orderNumber ref Order, itemid ref Order Item)
• Deliver To (addrid, orderNumber, TimeDelivered) (addrid ref Address, orderNumber ref Order)
• Payment (C.cardNumber, orderNumber, payTime) (C.cardNumber ref Credit Card, orderNumber ref Order)

• Table.sql: Create tables for entities and relationships above.
• Insert.sql: Insert datas into tables.
• Modification.sql: Modify the data.

simpleJDBCPostgres.java is only a sample Java to link the Postgresql JDBC driver and connect to the database for your reference.

SQL.java is the acutal program that we wrote to submit the sql execution to the database based on the sample above.

Java_GUI contains the Java programs for creating the GUI.

1. MainFrame.java: Provide main menu for user to choose different function.

2. Register.java: User registration interface.

3. Login.java: User log-in interface.

4. AddAddress.java: Add address for delivery.

5. SearchFrame.java:Search products in database.

6. SaveToCartFrame.java: Add products into shopping cart.

7. SetUpOrderFrame.java: View the shopping cart and create the order.

8. addressFrame.java: Select a delivery address and finish the shopping.