Scribd
Upload
7 views4 pages

Java Project Scenario

The document outlines a project to develop a Student Management System desktop application that allows users to manage student records through features such as adding, viewing, updating, and deleting details. It includes a login module for admin authentication, a dashboard for navigation, and utilizes Java Swing, AWT, and JDBC for GUI and database connectivity. Additionally, it provides an overview of other potential systems like Library Management, Inventory, Hospital Patient Records, Hotel Booking, and ATM Simulation, each with their own modules and database designs.

Uploaded by

gauri31agarwal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
7 views4 pages

Java Project Scenario

The document outlines a project to develop a Student Management System desktop application that allows users to manage student records through features such as adding, viewing, updating, and deleting details. It includes a login module for admin authentication, a dashboard for navigation, and utilizes Java Swing, AWT, and JDBC for GUI and database connectivity. Additionally, it provides an overview of other potential systems like Library Management, Inventory, Hospital Patient Records, Hotel Booking, and ATM Simulation, each with their own modules and database designs.

Uploaded by

gauri31agarwal
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Project Scenario: Student Management System

Objective

To build a desktop application for managing student records with features like adding,
viewing, updating, and deleting details. The GUI will be built using Swing and AWT, and
the data will be stored in a relational database.

Modules / Features

1. Login Module
o Admin authentication (username & password).
o Verifies credentials from the database.
o Simple login window using Swing JFrame + AWT components.
2. Dashboard
o After login, the user sees a main window with buttons like:
 Add Student
 View Students
 Update Student
 Delete Student
 Logout
3. Add Student
o A form with fields: Roll No, Name, Department, Email, Phone.
o Save button → stores into database (using JDBC).
4. View Students
o JTable displays all records from the student table.
o Option to search by roll number or name.
5. Update Student
o Select a student from the table.
o Load data into editable text fields.
o Update button → applies changes in DB.
6. Delete Student
o Select a student → delete from DB.

Technologies Used

 Java Swing: For GUI (JFrame, JButton, JTextField, JTable, JLabel).


 Java AWT: For layouts, event handling.
 JDBC: For database connectivity.
 Database: MySQL or SQLite (studentdb with table students).
Database Design

Table: students

Column Type Constraint


roll_no INT PRIMARY KEY
name VARCHAR(50) NOT NULL
dept VARCHAR(30)
email VARCHAR(50) UNIQUE
phone VARCHAR(15)

Table: admin

Column Type Constraint


username VARCHAR(20) PRIMARY KEY
password VARCHAR(20) NOT NULL
1. Library Management System
 Use Case: Manage books in a library.
 Modules:
o Login: Admin & Student login.
o Book Management: Add, update, delete, search books.
o Borrow/Return: Students can borrow books, due dates are tracked.
o Penalty Tracking: Fine calculation for late returns.
 Database Tables: books, students, borrow_records.
 Swing Features: JTable for book list, JTabbedPane for switching between Admin and
Student views.

2️. Inventory / Shop Billing System


 Use Case: Small retail store managing products & sales.
 Modules:
o Product Management: Add/update stock.
o Billing: Generate bills when customers purchase items.
o Sales Reports: Daily/Monthly reports in JTable.
 Database Tables: products, sales, bills.
 Swing Features: JTable for bill preview, JOptionPane for receipts.

3️. Hospital Patient Record System


 Use Case: Maintain patient details in a hospital/clinic.
 Modules:
o Patient Registration: Add patient details.
o Doctor Allocation: Assign doctor to a patient.
o Medical History: Store patient’s treatment history.
o Billing: Track treatment and billing records.
 Database Tables: patients, doctors, appointments, billing.
 Swing Features: JTabbedPane for “Patient”, “Doctors”, “Billing”.

4️. Hotel Booking System


 Use Case: Manage room reservations.
 Modules:
o Room Management: Add/update room details.
o Booking: Book rooms with check-in/check-out.
o Customer Records: Store guest information.
o Invoice Generation.
 Database Tables: rooms, customers, bookings.
 Swing Features: Calendar/date picker, JTable for available rooms.
5️. ATM Simulation (Banking System)
 Use Case: ATM operations for bank accounts.
 Modules:
o Login: Account authentication using PIN.
o Transactions: Deposit, Withdraw, Balance Inquiry.
o Mini Statement: Show last 5 transactions.
 Database Tables: accounts, transactions.
 Swing Features: Keypad-like GUI with buttons, JPasswordField for PIN.

You might also like