A Java-Based CLI for TV Inventory Management

This command-line application facilitates the management of a TV shop's inventory and sales. It provides distinct interfaces for Dealers (selling stock to the shop) and Customers (purchasing TVs), backed by an Oracle Database.

Category	Technologies
Language
Database
Connectivity
IDE

• 👥 Role-Based Access:
  • Shopkeeper/Admin: Manage overall stock and sales.
  • Dealer: Interface for suppliers to sell/add new TV units to the inventory.
  • Customer: Interface for browsing available TVs and making purchases.
• 🔐 Secure Login: Authentication system for different user roles.
• 💾 Persistent Storage: Uses Oracle Database to store inventory levels, sales records, and user data.

The source code is located in the TV Purchasing App directory:

• TV.java: Main entry point and orchestration logic.
• login.java: Handles user authentication and connection initiation.
• menufordealer.java: The dashboard and options for TV Dealers.
• menuforuser.java: The purchasing interface for Customers.

1. Oracle Database Setup

   • Install Oracle Database (e.g., Express Edition).
   • Ensure the JDBC driver is available in your classpath.
   • Create the necessary tables (refer to the code for schema details).

2. IDE Configuration (NetBeans)

   • Create a new Java Project in NetBeans.
   • Copy the files from TV Purchasing App into your project's src folder.
   • Add the Oracle JDBC Driver (ojdbc8.jar) to your project's libraries.

3. Run the Application

   • Execute TV.java to start the application.

Simplifying electronics retail management.