Question
Write a program using JDBC for developing simple CRUD application for billing of a Medical Store. Use appropriate GUI components in your application. Make necessary assumptions.
Answer :
Word Count : 740
________ ____ _________ ____ _______ _________ ______ _____.
_________ _____ ______ ________ ____ ____ ____.
______ ___ ___ _______ _______ ____ ________.
_________ ____ ___ ________ _______ ________ __________.
_______ ________ ______ _____ ____ ___ _____ ________ ____ _________ _________ _______.
________ __________ ___ ________ ___.
_____ _______ _________ ____ ___ _________ _______ ________ ____ ________ __________.
___ __________ ___ __________ _____ ________ __________ _________ ______ ____ ______.
_________ _____ __________ _____ ____ ___ ______.
_______ _______ __________ ______ __________ __________.
____ ____ ___ _________ ______ ________ __________.
_________ _________ _______ ____ _____ ____ _____ ____ ______ ________.
______ __________ ________ ________ _______ ______ ______.
______ _____ ________ ___ ______ ____ ____ _____ __________ ______ _______.
_________ __________ ________ ______ ________ ____ _________.
_____ ____ _______ ___ ____ _______.
__________ ______ _____ ______ __________ ___ __________ _____ _____ _________.
____ __________ ________ _____ ______ _________ ________ _________ _____ __________ __________.
__________ __________ ____ __________ _____ __________.
_________ __________ _________ __________ ________.
__________ _____ ___ ________ ________ ________ ___.
______ __________ ____ _____ __________ _____ ______ _____ _____ _________.
_____ ________ ____ _____ ______ _____.
_________ __________ _______ __________ _________ ________ ____ _________ ___.
_______ _________ ______ __________ _______ ____ _____ ______.
___ _____ _________ ________ _______ ___ ___ ___ ___ _______ __________ ________.
________ _____ ___ _____ _________.
__________ ___ _______ _____ _____ ____ ___ _____ ____ ____ _________ _______.
_______ _______ __________ __________ _____ __________ _____ ______ __________ ______.
________ ____ _____ ______ __________ _______ ___ ________ __________ _______ _____.
________ _______ ___ _______ ________ ___ ____ _________ _______ ____ _______.
_______ ________ _______ __________ __________ ________.
_____ ________ _________ ___ ___ _____.
__________ ___ _________ __________ ____ _____ __________.
_______ ___ _________ __________ _________ __________ ____ ________ ____.
_____ _________ ___ _______ __________ __________ ______ _____ ______ _______ ________ ________.
_____ __________ _____ ________ ____ ______ ___ ______ ______ _______.
_______ _________ _______ ________ ____.
________ ___ ___ ________ ______ ___ ____ _____ _______ __________.
________ __________ _________ ___ ___ ___ ______ ______ ______.
________ ____ ___ ______ ______ ______ ______ _________ _____.
_____ ___ ______ ____ _________.
____ ______ _______ ____ _______ ___ _______ ______ ________ ________ ______.
__________ _____ ______ _____ _____ ______ ______ ____ _________ ______ __________.
_______ ________ ________ __________ ______ _____.
_________ ________ ____ __________ _______ _____ ____.
____ __________ __________ __________ _____ ___ ___ ______ ______ _______ _______.
__________ _____ _________ ______ _________ ___ ___.
________ ________ __________ ____ ________ ____.
____ _______ _________ ________ ____.
_______ _______ ________ _________ ______ ________ _______ _____ ___ _______ ___ ______.
_____ __________ ____ _________ ___.
____ _____ ________ ____ ______ ______ _________.
_________ _______ _________ _________ ______ __________ ____ _________.
_______ _______ ____ ___ ______ _________ ____ ________ _____ __________ ______.
______ ___ _____ ______ _______ ______ ________ ___ ______ _______.
__________ _______ ________ ________ _______ ____ _________ __________.
______ __________ _________ _______ __________ _____ ___ _______ ____ ____ __________.
_________ _______ ______ _______ _______ ___ _________.
______ _____ ________ ____ ____.
________ __________ _______ ____ _________ _____ ___ __________ __________ ________ _______ _______.
________ _________ _______ ______ __________.
____ ___ _____ __________ ___ _______ ___ ________.
__________ _________ _____ _____ ____ ___ _________.
Skip in 10
A simple CRUD application for billing of a Medical Store using JDBC and Java GUI can be developed by integrating Java Swing for the user interface and JDBC for database connectivity. The application performs Create, Read, Update and Delete operations on medicine records and generates bills for customers. Necessary assumptions include the use of MySQL as the backend database, availability of JDBC driver, and a table named `medicine` with fields such as medicine_id, medicine_name, company, price, quantity and expiry_date. Another table named `bill` may store bill_id, medicine_id, quantity_sold, total_amount and bill_date. The first step is to establish database connectivity. The JDBC API provides classes such as DriverManager, Connection, Statement, PreparedStatement and ResultSet. The MySQL JDBC driver is loaded using Class.forName("com.mysql.cj.jdbc.Driver"). A connection is established using DriverManager.getConnection() by passing database URL, username and password. Proper exception handling using try-catch blocks is necessary to handle SQLExceptions. The GUI can be developed using Swing components such as JFrame, JLabel, JTextField, JButton, JTable, JScrollPane and JPanel. The main frame titled “Medical Store Billing System” contains input fields for Medicine ID, Medicine Name, Company, Price, Quantity and Expiry Date. Buttons such as Add, Update, Delete, Search and Generate Bill are placed using a suitable layout
______ _____ ____ __________ __________ ______ _________ _____ _______ __________.________ ____ _________ ____ _______ _________ ______ _____.
_________ _____ ______ ________ ____ ____ ____.
______ ___ ___ _______ _______ ____ ________.
_________ ____ ___ ________ _______ ________ __________.
_______ ________ ______ _____ ____ ___ _____ ________ ____ _________ _________ _______.
________ __________ ___ ________ ___.
_____ _______ _________ ____ ___ _________ _______ ________ ____ ________ __________.
___ __________ ___ __________ _____ ________ __________ _________ ______ ____ ______.
_________ _____ __________ _____ ____ ___ ______.
_______ _______ __________ ______ __________ __________.
____ ____ ___ _________ ______ ________ __________.
_________ _________ _______ ____ _____ ____ _____ ____ ______ ________.
______ __________ ________ ________ _______ ______ ______.
______ _____ ________ ___ ______ ____ ____ _____ __________ ______ _______.
_________ __________ ________ ______ ________ ____ _________.
_____ ____ _______ ___ ____ _______.
__________ ______ _____ ______ __________ ___ __________ _____ _____ _________.
____ __________ ________ _____ ______ _________ ________ _________ _____ __________ __________.
__________ __________ ____ __________ _____ __________.
_________ __________ _________ __________ ________.
__________ _____ ___ ________ ________ ________ ___.
______ __________ ____ _____ __________ _____ ______ _____ _____ _________.
_____ ________ ____ _____ ______ _____.
_________ __________ _______ __________ _________ ________ ____ _________ ___.
_______ _________ ______ __________ _______ ____ _____ ______.
___ _____ _________ ________ _______ ___ ___ ___ ___ _______ __________ ________.
________ _____ ___ _____ _________.
__________ ___ _______ _____ _____ ____ ___ _____ ____ ____ _________ _______.
_______ _______ __________ __________ _____ __________ _____ ______ __________ ______.
________ ____ _____ ______ __________ _______ ___ ________ __________ _______ _____.
________ _______ ___ _______ ________ ___ ____ _________ _______ ____ _______.
_______ ________ _______ __________ __________ ________.
_____ ________ _________ ___ ___ _____.
__________ ___ _________ __________ ____ _____ __________.
_______ ___ _________ __________ _________ __________ ____ ________ ____.
_____ _________ ___ _______ __________ __________ ______ _____ ______ _______ ________ ________.
_____ __________ _____ ________ ____ ______ ___ ______ ______ _______.
_______ _________ _______ ________ ____.
________ ___ ___ ________ ______ ___ ____ _____ _______ __________.
________ __________ _________ ___ ___ ___ ______ ______ ______.
________ ____ ___ ______ ______ ______ ______ _________ _____.
_____ ___ ______ ____ _________.
____ ______ _______ ____ _______ ___ _______ ______ ________ ________ ______.
__________ _____ ______ _____ _____ ______ ______ ____ _________ ______ __________.
_______ ________ ________ __________ ______ _____.
_________ ________ ____ __________ _______ _____ ____.
____ __________ __________ __________ _____ ___ ___ ______ ______ _______ _______.
__________ _____ _________ ______ _________ ___ ___.
________ ________ __________ ____ ________ ____.
____ _______ _________ ________ ____.
_______ _______ ________ _________ ______ ________ _______ _____ ___ _______ ___ ______.
_____ __________ ____ _________ ___.
____ _____ ________ ____ ______ ______ _________.
_________ _______ _________ _________ ______ __________ ____ _________.
_______ _______ ____ ___ ______ _________ ____ ________ _____ __________ ______.
______ ___ _____ ______ _______ ______ ________ ___ ______ _______.
__________ _______ ________ ________ _______ ____ _________ __________.
______ __________ _________ _______ __________ _____ ___ _______ ____ ____ __________.
_________ _______ ______ _______ _______ ___ _________.
______ _____ ________ ____ ____.
________ __________ _______ ____ _________ _____ ___ __________ __________ ________ _______ _______.
________ _________ _______ ______ __________.
____ ___ _____ __________ ___ _______ ___ ________.
__________ _________ _____ _____ ____ ___ _________.
IGNOU ACADEMY
Your IGNOU journey, made easier.
- Solved Assignments
- Study Notes
- Guess Papers
- Question Papers
Continue Reading — It's Free
Sign in with Google to unlock more of this answer.
✓ Free access
✓ Unlock up to 60% of the answer
✓ No payment required
✓ Unlock up to 60% of the answer
✓ No payment required
Quick Google sign-in. No separate registration form.