Medical Store Management System using Java in Netbeans

This is a Medical Store Management System using Java in Netbeans. The Medical Store Management System using Java in Netbeans is intended for the use of the pharmacists of the company.

This Medical Store Management System will allow the pharmacist to record items that are being purchase by the customer. Also, the Medical Store Management System is capable of viewing the item that is already sold.

The Medical Store Management System has several features that is suited especially in pharmacy store it maintain the details of medical store such as stock and account.

This The Medical Store Management System in Netbeans is so designed as to ease the work load of medical shop professionals.

The Medical Store Management System using Java in Netbeans was developed using java programming language in Netbeans IDE, and the database application used was XAMPP(MySQL).

The main features of the system available to the user are the following:

Medicines – can add, update, delete medicine

Companies – can add, update, delete company

Sale Records – can add, view, delete details

Category – can add product category

Password – can change the password of the user

User – can create another user

The following are the software that you’ll need in order for this program to run:
1. Java Development Kit Software
2. XAMPP

You can download the JDK in this website link http://www.oracle.com/technetwork/pt/java/javase/downloads/index.html

and the xampp software can be found in this link https://www.apachefriends.org/download.html 

About The Medical Store Management System In Java

<figure class="wp-block-table is-style-stripes">
<table>
<tbody>
<tr>
<td><strong>Project Name:</strong></td>
<td>Medical Store Management System</td>
</tr>
<tr>
<td><strong>Language/s Used:</strong></td>
<td>JAVA</td>
</tr>
<tr>
<td><strong>Database:</strong></td>
<td>MySQL</td>
</tr>
<tr>
<td><strong>Type:</strong></td>
<td>Desktop Application</td>
</tr>
<tr>
<td><strong>Developer:</strong></td>
<td>IT SOURCECODE</td>
</tr>
<tr>
<td><strong>Updates:</strong></td>
<td>0</td>
</tr>
</tbody>
</table><figcaption><em><strong>Medical Store Management System In Java</strong>- Project Information</em></figcaption></figure>

For questions, any other concerns, or thesis/capstone creation with documentation, you can leave a comment below.

To download the source code, click here.

Related topic(s) that you may like:

1.) Create Login Form in Java
2.) Create MySQL Connection in Java

Technology stack and requirements

To run this Java project on your development machine, you need:

• Java Development Kit (JDK) 17 or higher. Download from adoptium.net (Eclipse Temurin) or oracle.com. JDK 21 LTS is recommended for new projects.
• Apache NetBeans or IntelliJ IDEA. Free IDEs with Java support, debugging, and GUI form designer.
• MySQL Server or MariaDB. Standalone install, or bundled with XAMPP for easier setup.
• MySQL Connector/J. JDBC driver JAR file included in the project’s lib folder or downloadable from dev.mysql.com.
• Git (optional). For version control if you want to extend the project.

Installing the source code

1. Extract the ZIP archive to a folder outside Program Files.
2. Open the project in NetBeans or IntelliJ. Choose File then Open Project and select the extracted folder.
3. Import the database. Open phpMyAdmin (with XAMPP) or MySQL Workbench, create a new database, and import the .sql file from the archive.
4. Update the JDBC connection string. Open the DatabaseConnection.java (or config file) and set your database host, name, user, and password.
5. Add the MySQL Connector JAR to the classpath. Right-click Libraries then Add JAR, select mysql-connector-java-x.x.x.jar.
6. Run the project. Press F6 (NetBeans) or Shift+F10 (IntelliJ) to run the main class.

Using this project for your BSIT capstone

• Chapter 1 (Introduction). Discuss the real-world problem this Java system solves. Cite Philippine business or academic use cases.
• Chapter 2 (RRL). Compare this project against 5-10 similar published works. Cite ACM, IEEE, or IJERT journal papers.
• Chapter 3 (Methodology). Include Use Case Diagram, DFD, ER Diagram, Class Diagram, and Sequence Diagram.
• Chapter 4 (Results). Screenshot each Swing form or JavaFX view with a caption explaining its role.
• Chapter 5 (Conclusion). Identify features for Version 2 (Spring Boot web version, REST API, mobile app).

Modules typical of Medical Store Management System using Java in Netbeans

• Patient registration. Personal info, contact, medical history, allergies, insurance.
• Appointment scheduling. Doctor + date + time slot booking with reminder options.
• Consultation notes. Doctor input for chief complaint, diagnosis, prescription.
• Pharmacy dispensing. Link prescriptions to inventory, deduct dispensed items.
• Billing. Compute charges, apply insurance, print official receipt.

Common enhancements for capstone review

• Electronic health records. Complete patient history across visits accessible to any authorized doctor.
• Telemedicine. Embed video-call widget via Zoom SDK or WebRTC for remote consultations.
• Data Privacy Act compliance. Audit trail and role-based access to meet RA 10173.
• Spring Boot rewrite. Modernize to REST API + React front-end for scalability.

Project timeline for BSIT capstone

Typical BSIT teams complete a Java project of this scope in one full academic semester. Suggested timeline:

• Weeks 1-2. Requirements gathering, interview with target user, Chapter 1 documentation.
• Weeks 3-4. Design: use case, DFD, class diagram, ER diagram, mockup screens.
• Weeks 5-8. Core development: database in MySQL, main JFrames in NetBeans, CRUD operations.
• Weeks 9-11. Reports, printing, user roles. Test with sample data.
• Weeks 12-13. Documentation: Chapter 3-5 with screenshots.
• Week 14. Mock defense with adviser, corrections, final panel.

Panel questions this project typically gets

• Why did you choose Java over other languages? Prepare an answer about Java’s ecosystem (Swing/JavaFX for UI, JDBC for DB, Spring for modernization).
• How does the system handle concurrent access? Explain JDBC transactions, connection pooling, and locking.
• What is your backup and disaster recovery plan? Document backup script + demo restore.
• How would you deploy this in production? JAR bundling, Windows installer via Launch4j, or Spring Boot cloud deployment.

Deployment options after the defense

• Standalone JAR. Package with dependencies via Maven shade plugin, distribute as a single .jar file.
• Windows installer. Wrap the JAR with Launch4j + NSIS for a proper .exe installer.
• Spring Boot web rewrite. Migrate to Spring Boot + Thymeleaf for browser-based deployment.
• Docker container. Package with Dockerfile for portable deployment on any Docker-capable host.

Common defense pitfalls to avoid

• Empty database. Pre-populate 20-50 realistic records for meaningful demos.
• Missing error handling. Wrap SQL calls in try-catch with user-friendly messages.
• SQL injection vulnerability. Use PreparedStatement everywhere, never string-concatenate queries.
• No printable output. Add JasperReports for panel-expected printable reports.