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
Please don't hesitate to ask for assistance from experts get your Java assignments done if you need someone to help with your Java homework online
Related Projects
Library Management System Project in C++
Library Management System Project in Python
Tags: Source Code, Java Project, Beginner Projects, Academic Projects
