Java Library Management System with Swing Source Code

In this post we are going to cover Java Library Management system with Swing. This Library Management System project data to be stored by MySql databse. MySql JDBD driver is used to connect database with application. This Project contains below modules

• Admin Module
• Librarian Module

 

Admin Module: In the  Library Management system as Admin

• Can add a Librarian
• can View/Edit Librarian
• Can delete Librarian
• Logout

 

Librarian Module: As a Librarian he can do

• Can add/view books
• Can issue books
• View issued books
• Return Books
• Can logout

 

This Project created with test database.

This test database contains 3 tables

• books
• issuebooks
• librarian

These tables will store respected librarian, books data.

This complete project is developed with Java Swing as Front End and MySql database as Back End.

 

How to Run this Project:

• Download source code and extract zip file
• Open NetBeans IDE and import project.
• Run Local server (I have used Local server as Xampp)
• Now open services tab and connect mysql database with driver conection.

 

 

 

Code for database connection

import java.sql.Connection; import java.sql.DriverManager; public class DB {     public static Connection getConnection(){         Connection con=null;         try{             Class.forName("com.mysql.jdbc.Driver");             con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");         }catch(Exception e){System.out.println(e);}         return con;     } }

 

 

 

Admin Login Details:

User Name: admin

Password: admin

 

Download Source code

 

Related Projects

Library Management System Project in C++

Library Management System Project in Python

 

Tags: Source Code, Java Project, Beginner Projects, Academic Projects