Scribd
Upload
30 views28 pages

Project Library Management

Class 23 project on information technology

Uploaded by

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

Project Library Management

Class 23 project on information technology

Uploaded by

navjotkaur3590
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 28

SVJC DAV PUBLIC SCHOOL-

DASUYA

PROJECT SYNOPSIS ON:

“LIBRARY MANAGEMENT”
SVJC DAV PUBLIC SCHOOL-
DASUYA

Submitted to: DINESH THAKUR

Submitted by:

Name:

class:

Roll no:
Session:
Certificate

This is to certify that the project entitled “ Library Management”


is a confide work done by ______________ of class XII____
session 2024-25 in the partial fulfillment of CBSE examination
2025 and has been carried out under my direct supervision and
guidance.

Name of the subject teacher:


DINESH THAKUR
Index

Sr. No. Frames

1. Login

2. Main

3. Book Details

4. Student Details

6. Issue Record
Login Frame

import [Link].*;
public class Login extends [Link] {

/** Creates new form Login */


public Login() {
initComponents();
}

private void jButton1ActionPerformed([Link] evt) {


// TODO add your handling code here:
String un,pw;
un=[Link]();
pw=[Link]();
if([Link]("lib")& [Link]("lib"))
{
MainFrame Mf1=new MainFrame();
[Link](false);
[Link](true);
}
else
{
[Link](null,"Invalid User Name or Password");
}

private void jButton2ActionPerformed([Link] evt) {


// TODO add your handling code here:
[Link](0);
//[Link](false);
}
Main Frame

public class MainFrame extends [Link] {

/** Creates new form MainFrame */


public MainFrame() {
initComponents();
}

private void jButton1ActionPerformed([Link] evt) {


// TODO add your handling code here:
BooksDetails Bd1=new BooksDetails();
[Link](false);
[Link](true);
}

private void jButton2ActionPerformed([Link] evt) {


// TODO add your handling code here:
StudentDetails Sd1=new StudentDetails();
[Link](false);
[Link](true);
}

private void jButton3ActionPerformed([Link] evt) {


// TODO add your handling code here:
TeacherRecord Td1=new TeacherRecord();
[Link](false);
[Link](true);
}

private void jButton4ActionPerformed([Link] evt) {


// TODO add your handling code here:
IssueDetails id1=new IssueDetails();
[Link](false);
[Link](true);
}

private void jButton5ActionPerformed([Link] evt) {


// TODO add your handling code here:
ReturnDetails rd1=new ReturnDetails();
[Link](false);
[Link](true);
}
Books Details

import [Link];
import [Link].*;
import [Link].*;
public class BooksDetails extends [Link] {
Connection con;
Statement
stmt;
ResultSet rs;

/** Creates new form BooksDetails */


public BooksDetails() {
initComponents();
try
{
//[Link]("[Link]");
[Link]("[Link]");
con=
[Link]("jdbc:mysql://localhost/library","root","a");
stmt = [Link]();
String qu="select * from booksdet";
rs=[Link](qu);
[Link]();
jButton1ActionPerformed(null);
}
catch(Exception e)
{
[Link]("Handling the errors");
}
}
private void jButton2ActionPerformed([Link] evt) {
// TODO add your handling code here:
MainFrame Mf1=new MainFrame();
[Link](false);
[Link](true);
}

private void jButton1ActionPerformed([Link] evt) {


// TODO add your handling code
here: try {
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));

[Link](false);
[Link](false);
} catch(Exception e)
{ [Link](e
);
}
}

private void jButton3ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}
}

private void jButton4ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();
if([Link]())
{
[Link](null, "End of Data");
[Link]();
return;
}
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}

private void jButton5ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();
if([Link]())
{
[Link](null, "End of Data");
[Link]();
return;
}
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}

private void jButton6ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}
}

private void jButton7ActionPerformed([Link] evt) {


// TODO add your handling code here:
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");

[Link](true);
[Link](true);

[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);

private void jButton8ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
stmt=[Link]();
String q;
q="insert into booksdet values (" + [Link]()+",'"+
[Link]()+"','"+[Link]()+"','"+ [Link]()+"','"+
[Link]()+"','"+[Link]()+"','"+ [Link]()+"')";
//[Link]("insert into studet values(2,'jatin','1998-10-10')");
[Link](q);
[Link](q);
rs=[Link]("select * from booksdet");
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));

[Link](false);
[Link](false);

[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
}
catch(Exception e)
{
[Link](e);
}

private void jButton9ActionPerformed([Link] evt) {


// TODO add your handling code here:
[Link](false);
[Link](false);

[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);

try
{
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));

}
catch(Exception e)
{
[Link](e);
}

private void jButton10ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
String del;
del=("delete from booksdet where bookno="+[Link]());
//[Link]("delete from studet where rno=2");
[Link](del);
rs=[Link]("select * from booksdet");
[Link]();
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}

private void jButton11ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
stmt=[Link]();
String q;
q="update booksdet set BookTitle='"+ [Link]()+"',Publisher ='"+
[Link]()+"', PurchaseDate='"+[Link]()+"',
Author='"+[Link]()+"', pages='"+[Link]()+"',
price='"+[Link]()+"' where bookno="+[Link]();
//[Link](q);
[Link](q);
rs=[Link]("select * from booksdet");
[Link]();
}
catch(Exception e)
{
[Link](e);
}

}
Students Details

import [Link];
import [Link].*;
import [Link].*;
public class StudentDetails extends [Link]
{ Connection con;
Statement
stmt;
ResultSet rs;

/** Creates new form BooksDetails */


public StudentDetails() {
initComponents();
try
{
//[Link]("[Link]");
[Link]("[Link]");
con=
[Link]("jdbc:mysql://localhost/library","root","a");
stmt = [Link]();
String qu="select * from Sturecord";
rs=[Link](qu);
[Link]();
jButton1ActionPerformed(null);
}
catch(Exception e)
{
[Link]("Handling the errors");
}
}
private void jButton2ActionPerformed([Link] evt) {
// TODO add your handling code here:
MainFrame Mf1=new MainFrame();
[Link](false);
[Link](true);
}

private void jButton1ActionPerformed([Link] evt) {


// TODO add your handling code
here: try {
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));

[Link](false);
[Link](false);
} catch(Exception e)
{ [Link](e
);
}
}

private void jButton3ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}
}

private void jButton4ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();
if([Link]())
{
[Link](null, "End of Data");
[Link]();
return;
}
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}

private void jButton5ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();
if([Link]())
{
[Link](null, "End of Data");
[Link]();
return;
}
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}

private void jButton6ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}
}

private void jButton7ActionPerformed([Link] evt) {


// TODO add your handling code here:
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");

[Link](true);
[Link](true);

[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);

private void jButton8ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
stmt=[Link]();
String q;
q="insert into stuRecord values (" + [Link]()+",'"+
[Link]()+"','"+[Link]()+"','"+ [Link]()+"','"+
[Link]()+"','"+[Link]()+"','"+ [Link]()+"')";
//[Link]("insert into studet values(2,'jatin','1998-10-10')");
[Link](q);
[Link](q);
rs=[Link]("select * from stuRecord");
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));

[Link](false);
[Link](false);

[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
}
catch(Exception e)
{
[Link](e);
}

private void jButton9ActionPerformed([Link] evt) {


// TODO add your handling code here:
[Link](false);
[Link](false);

[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);

try
{
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));

}
catch(Exception e)
{
[Link](e);
}

private void jButton10ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
String del;
del=("delete from stuRecord where studentid="+[Link]());
//[Link]("delete from studet where rno=2");
[Link](del);
rs=[Link]("select * from stuRecord");
[Link]();
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
}
catch(Exception e)
{
[Link](e);
}

private void jButton11ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
stmt=[Link]();
String q;
q="update stuRecord set rollno ='"+ [Link]()+"',name ='"+
[Link]()+"', class='"+[Link]()+"', section
='"+[Link]()+"', phont='"+[Link]()+"', address
='"+[Link]()+"' where studentId="+[Link]();
//[Link](q);
[Link](q);
rs=[Link]("select * from stuRecord");
[Link]();
}
catch(Exception e)
{
[Link](e);
}

}
Issue Details

import [Link];
import [Link].*;
import [Link].*;
public class IssueDetails extends [Link]
{ Connection con;
Statement
stmt;
ResultSet rs;

/** Creates new form BooksDetails */


public IssueDetails() {
initComponents();
try
{
//[Link]("[Link]");
[Link]("[Link]");
con=
[Link]("jdbc:mysql://localhost/library","root","a");
stmt = [Link]();
String qu="select * from issueDet";
rs=[Link](qu);
[Link]();
jButton1ActionPerformed(null);
}
catch(Exception e)
{
[Link]("Handling the errors");
}
}

private void jButton2ActionPerformed([Link] evt) {


// TODO add your handling code here:
MainFrame Mf1=new MainFrame();
[Link](false);
[Link](true);
}

private void jButton1ActionPerformed([Link] evt) {


// TODO add your handling code
here: try {
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));

[Link](false);
[Link](false);
} catch(Exception e)
{ [Link](e
);
}
}

private void jButton3ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));

}
catch(Exception e)
{
[Link](e);
}
}

private void jButton4ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();
if([Link]())
{
[Link](null, "End of Data");
[Link]();
return;
}
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));

}
catch(Exception e)
{
[Link](e);
}

private void jButton5ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();
if([Link]())
{
[Link](null, "End of Data");
[Link]();
return;
}
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));

}
catch(Exception e)
{
[Link](e);
}

private void jButton6ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));

}
catch(Exception e)
{
[Link](e);
}
}

private void jButton7ActionPerformed([Link] evt) {


// TODO add your handling code here:
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");

[Link](true);
[Link](true);

[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);

private void jButton8ActionPerformed([Link] evt) {


// TODO add your handling code here:
try
{
stmt=[Link]();
String q;
q="insert into issueDet values (" + [Link]()+",'"+
[Link]()+"','"+[Link]()+"','"+ [Link]()+"','"+
[Link]()+"')";
//[Link]("insert into studet values(2,'jatin','1998-10-10')");
[Link](q);
[Link](q);
rs=[Link]("select * from issueDet");
[Link]();

[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));

[Link](false);
[Link](false);

[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
}
catch(Exception e)
{
[Link](e);
}

private void jButton9ActionPerformed([Link] evt) {


// TODO add your handling code here:
[Link](false);
[Link](false);

[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);

try
{
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));
}
catch(Exception e)
{
[Link](e);
}

private void jButton10ActionPerformed([Link] evt) {


try
{
String del;
del=("delete from issueDet where bookno="+[Link]());
//[Link]("delete from studet where rno=2");
[Link](del);
rs=[Link]("select * from issueDet");
[Link]();
[Link]([Link](1));
[Link]([Link](2));
[Link]([Link](3));
[Link]([Link](4));
[Link]([Link](5));

}
catch(Exception e)
{
[Link](e);
}

private void jButton11ActionPerformed([Link] evt)


{ try
{
stmt=[Link]();
String q;
q="update issueDet set BookName ='"+ [Link]()+"',MemID='"+
[Link]()+"', Name ='"+[Link]()+"', IssueDate
='"+[Link]()+"' where bookno="+[Link]();
//[Link](q);
[Link](q);
rs=[Link]("select * from issueDet");
[Link]();
}
catch(Exception e)
{
[Link](e);
}

You might also like