This is the back-end of an e-commerce website project created for EECS 4413, which focuses on building e-commerce systems.
I was responsible for developing the back-end of the website, which includes designing the database and ensuring the correct functionality of all URLs. This ensures that the front-end can effortlessly fetch the required data.
I used GitHub Desktop and cloned the project to my eclipse-workspace. Then, I opened Eclipse and created a new web dynamic project with the name 'TeamM_BE,' ensuring that the name matched the cloned directory exactly. Once I made the necessary changes, I went back to the GitHub Desktop app and pushed the changes to the origin.
Server home page
http://teamm4413.us-east-1.elasticbeanstalk.com/
Loggin url (Passwords are hashed)
http://teamm4413.us-east-1.elasticbeanstalk.com/[email protected]&password=password123
Logout is eiter one of these two
http://teamm4413.us-east-1.elasticbeanstalk.com/[email protected]
http://teamm4413.us-east-1.elasticbeanstalk.com/logout
Sign up url, needs email, password fn and ln
http://teamm4413.us-east-1.elasticbeanstalk.com/[email protected]&password=111&fn=name&ln=lname
Browse all items or products
http://teamm4413.us-east-1.elasticbeanstalk.com/browse
View speicific item with an ID
http://teamm4413.us-east-1.elasticbeanstalk.com/browse?id=2
View all comments by providing id of the item and review=true flag.
http://teamm4413.us-east-1.elasticbeanstalk.com/browse?id=2&review=true
This just returns a message if the user is logged in or not, and if logged in, it might say "there is no item selected"
http://teamm4413.us-east-1.elasticbeanstalk.com/review
Writing a review to a specific item
http://teamm4413.us-east-1.elasticbeanstalk.com/review?item_id=1&comment=This%20is%20a%20great%20product&stars=3
This should add an item to cart only if the user is logged in, must also add quantity of the items It also checks the amount the user is adding and it checks that there are enough resources. Its is limited to 10.
http://teamm4413.us-east-1.elasticbeanstalk.com/browse?id=2&add=true&quantity=1
Can remove a specific Item from the cart only if it exists in the cart.
http://teamm4413.us-east-1.elasticbeanstalk.com/browse?id=2&add=false
To view cart from a logged in user simply the following link:
http://teamm4413.us-east-1.elasticbeanstalk.com/login?cart=true
Adding payment methods: User must be logged in to view payment methods with the following link:
http://teamm4413.us-east-1.elasticbeanstalk.com/pay_methods
Adding payment methods would be:
http://teamm4413.us-east-1.elasticbeanstalk.com/pay_methods?card_number=847584093048&card_holder=someone&cvv=334&street=street1&city=city1&zip=or4hgf&phone=5554443333&exp_date=2025-10-10
User must be logged in to do that, otherwise, it won't add anything (After login in, user would be saved in the session).
Making a purchase is once the customer added items to their cart Also there quantity of item decrement after purchase.
http://teamm4413.us-east-1.elasticbeanstalk.com/orders?purchase=true
Show all orders only if the admin is logged in (Customer account can won't be able to see anything)
http://teamm4413.us-east-1.elasticbeanstalk.com/orders
If a customer account logged in (they can see their orders)
http://teamm4413.us-east-1.elasticbeanstalk.com/orders?history=true
try {
Class.forName("com.mysql.cj.jdbc.Driver");
con = DriverManager.getConnection("jdbc:mysql://id-db-teamm.ciity4oybruj.us-east-1.rds.amazonaws.com:3306/db_teamm","admin","adminOfTeamM-");
} catch(Exception e) {
e.printStackTrace();
}
The 'database.sql' file contains the necessary table creation and insert queries.
You can access the er diagram through https://app.diagrams.net/ and import file TeamM_ER_Diagram.drawio located in the main directory of the project.
Front-End URL:
http://elasticbeanstalk-us-east-1-363292851522.s3-website-us-east-1.amazonaws.com/