Database-TeamProject

• 데이터베이스 자바앱 제작 팀프로젝트(23년 1학기 수강)
• 2023.05 ~ 2023.06
• 3 people team project

📝Introduction of Project

The project is to create a Java application using JDBC and a MySQL database.

The application will allow users to retrieve, insert, update, and delete data in the database.

🔗Start Guide

How to Connect DB

• URL : localhost:3306/pj
• ID : root
• PW : 0224

Usage

1. Run the Main class located in the "database" package.
2. The application will display a menu with various options.
3. Select an option by entering the corresponding number.
4. Follow the instructions provided by the application for each operation.
5. To exit the application, choose the "Exit" option from the menu.

📐Stacks

• JDBC
• MySQL
• JAVA

🗒️ER-Diagram

📌Functionality

1. insertProduct method of ProductInsertMenu class : Allows user to add a new product to the database.
2. OrderProduct method of OrderApplication class : Allows user to place an order for a product.
3. showCustomerOrderHistory method of OrderHistory class : Displays the order history for a customer.
4. orderDeletion method of OrderDeletion class : Deletes an order from the database.
5. ProductSearchApp method of ProductSearchApp class : Searches for products in a specific category.
6. aggregationquery method of AggregationQuery class : Performs an aggregation query on the database.
7. orderupdate method of OrderUpdate class : Updates an existing order in the database.
8. main method of Main class: Presents a menu to the user, and based on the user's choice, performs various operations such as inserting products, ordering products, displaying order history, deleting orders, searching products by category, performing aggregation queries, and updating orders until the user chooses to exit, after which it closes the database connection.