Advanced Java Lab Manual Exercises
Advanced Java Lab Manual Exercises
SRM UNIVERSITY
MC0617 – ADVANCEDJAVA - LABMANUAL
LAB LESSON PLAN
SWING
1. Login form 31/1/2011 6/1/2011
2. Biodata 3/1/2011 13/1/2011
3. SRM Organization structure using 10/1/2011 20/1/2011
JTree
4. JTabbedPane(Loginform,Registration,.) 17/1/2011& 24/2/2011 27/1/2011&3/2/2011
RMI
5. Banking Application 7/2/2011 10/2/2011
6. Banking Application using JFRAME 14/2/2011 17/2/2011
JDBC
7. Inventory Control 21/2/2011&28/2/2011 24/2/2011
SERVLET
8 Simple programs 17//2011 3/3/2011
SessionTracking 7/3/2011 10/3/2011
9 Employee Information with JDBC 14/3/2011&21/3/2011 17/3/2011&24/3/2011
JSP
10. Simple Programs 28/3/2011 31/3/2011
11 Student Mark List 4/4/2011&11/4/2011 7/4/2011&14/4/2011
BEANS
12 Simple Program 18/4/2011 21/4/2011
13 Custom Bean 18/4/2011 21/4/2011
Model Exam 25/4/2011 28/4/2011
1. [Link]
2. Mr [Link] Prabakaran
1. LOGIN FORM
Program:-
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
logindemo1()
{
c=getContentPane();
[Link](null);
Font f=new Font("Book Antiqua",[Link],40);
Font f1=new Font("Times New Roman",[Link],16);
label=new
EtchedBorder([Link],[Link],[Link]);
Toolkit tk=[Link]();
Dimension wz=[Link]();
int w=[Link]-100;
int h=[Link]-50;
p=new JPanel();
p1=new JPanel();
[Link](false);
[Link](false);
[Link](p);
[Link](null);
[Link](p1);
[Link](null);
l1=new JLabel();
[Link](f1);
[Link]("Login ID");
[Link]([Link]);
t1=new JTextField(15);
l2=new JLabel();
[Link]("Password");
[Link](f1);
[Link]([Link]);
t2=new JPasswordField(15);
l3=new JLabel("LOGIN FORM",[Link]);
[Link]([Link]);
[Link](f);
b2=new JButton("EXIT");
[Link]([Link]);
[Link](0,0,(w+100),h);
[Link](0,0,(w+100),h);
[Link](380,100,500,220);
[Link](400,300,450,280);
[Link](50,50,100,30);
[Link](50,100,100,30);
[Link](200,50,200,30);
[Link](200,100,200,30);
[Link](10,30,1250,50);
[Link](10,100,350,450);
[Link](930,100,300,450);
[Link](120,180,100,30);
[Link](250,180,100,30);
[Link](l1);
[Link](t1);
[Link](l2);
[Link](t2);
[Link](b1);
[Link](b2);
[Link](l3);
[Link](l6);
[Link](l7);
[Link](l8);
[Link](l5);
[Link](this);
[Link](this);
[Link](new Color(224,144,175));
setDefaultCloseOperation([Link].DISPOSE_ON_CLOSE);
}
Output :-
2. REGISTRATION FORM
Program:-
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
reglib1()
{
try
{
head=new
EtchedBorder([Link],[Link],[Link]);
panel1=new TitledBorder(new
LineBorder([Link]),"",TitledBorder.DEFAULT_JUSTIFICATION,TitledBorde
[Link],new Font("Book Antiqua",[Link],16),[Link]);
panel2=new TitledBorder(new LineBorder([Link])," Qualification
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
panel3=new TitledBorder(new LineBorder([Link])," Experience
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
panel4=new TitledBorder(new LineBorder([Link])," Research
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
panel5=new TitledBorder(new LineBorder([Link])," Paper
Presentation
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
cn=[Link]();
[Link](null);
[Link](new Color(110,208,228));
Toolkit tk=[Link]();
Dimension wz=[Link]();
int w=[Link]-100;
int h=[Link]-50;
p=new JPanel();
[Link](new Color(110,208,228));
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
[Link](p);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](head);
[Link](panel1);
[Link](panel2);
[Link](panel3);
[Link](panel4);
[Link](panel5);
[Link](head);
for(int i=1;i<=9;i++)
{
[Link]("0"+[Link](i));
}
for(int i=10;i<=31;i++)
{
[Link]([Link](i));
}
d2=new JComboBox();
for(int i=1;i<=9;i++)
{
[Link]("0"+[Link](i));
}
for(int i=10;i<=12;i++)
{
[Link]([Link](i));
}
d3=new JComboBox();
for(int i=1980;i<2011;i++)
{
[Link]([Link](i));
}
d4=new JComboBox();
for(int i=1;i<=9;i++)
{
[Link]("0"+[Link](i));
}
for(int i=10;i<=31;i++)
{
[Link]([Link](i));
}
d5=new JComboBox();
for(int i=1;i<=9;i++)
{
[Link]("0"+[Link](i));
}
for(int i=10;i<=12;i++)
{
[Link]([Link](i));
}
d6=new JComboBox();
for(int i=1980;i<2011;i++)
{
[Link]([Link](i));
}
l5=new JLabel("Department");
[Link](new Font("Book Antiqua",[Link],16));
c1=new JComboBox(s1);
l9=new JLabel("University/College");
[Link](new Font("Book Antiqua",[Link],16));
t4=new JTextField(15);
l12=new JLabel("Title");
[Link](new Font("Book Antiqua",[Link],16));
ta=new JTextArea("",4,15);
[Link]([Link](""));
l14=new JLabel("Place");
[Link](new Font("Book Antiqua",[Link],16));
t8=new JTextField(15);
b1=new JButton("SUBMIT");
b5=new JButton("CLEAR");
b4=new JButton("EXIT");
[Link](200,70,900,540);
[Link](20,10,860,130);
[Link](20,150,860,65);
[Link](20,225,860,105);
[Link](20,340,860,65);
[Link](20,415,860,110);
[Link](200,620,900,60);
[Link](0,0,(w+100),h);
[Link](0,0,(w+100),h);
[Link](10,10,1250,40);
[Link](40,10,150,30);
[Link](195,10,200,30);
[Link](460,10,150,30);
[Link](615,10,200,30);
[Link](40,50,150,30);
[Link](195,50,60,30);
[Link](265,50,60,30);
[Link](335,50,60,30);
[Link](460,50,150,30);
[Link](615,50,60,30);
[Link](685,50,60,30);
[Link](755,50,60,30);
[Link](40,90,150,30);
[Link](195,90,200,30);
[Link](40,20,150,30);
[Link](195,20,200,30);
[Link](460,20,150,30);
[Link](615,20,200,30);
[Link](40,20,150,30);
[Link](195,20,200,30);
[Link](460,20,150,30);
[Link](615,20,200,30);
[Link](40,60,150,30);
[Link](195,60,200,30);
[Link](460,60,150,30);
[Link](615,60,200,30);
[Link](40,20,150,30);
[Link](195,20,200,30);
[Link](460,20,150,30);
[Link](615,20,200,30);
[Link](40,20,150,30);
[Link](195,20,620,70);
[Link](250,15,100,30);
[Link](370,15,100,30);
[Link](490,15,100,30);
[Link](p2);
[Link](p3);
[Link](p4);
[Link](p5);
[Link](p6);
[Link](l1);
[Link](t1);
[Link](l2);
[Link](t2);
[Link](l3);
[Link](d1);
[Link](d2);
[Link](d3);
[Link](l4);
[Link](d4);
[Link](d5);
[Link](d6);
[Link](l5);
[Link](c1);
[Link](l6);
[Link](c2);
[Link](l7);
[Link](c3);
[Link](l8);
[Link](c4);
[Link](l9);
[Link](t4);
[Link](l10);
[Link](c5);
[Link](l11);
[Link](t5);
[Link](l13);
[Link](c6);
[Link](l14);
[Link](t8);
[Link](l12);
[Link](ta);
[Link](b1);
[Link](b4);
[Link](b5);
[Link](p1);
[Link](l15);
[Link](p7);
[Link](pl);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
}
catch(Exception e)
{
[Link](e);
}
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
dispose();
[Link](0);
}
});
if([Link]()==b4)
{
dispose();
}
if([Link]()==b5)
{
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("01");
[Link]("01");
[Link]("1980");
[Link]("01");
[Link]("01");
[Link]("1980");
[Link]("MCA");
[Link]("MCA");
[Link]("BCA");
[Link]("0");
[Link]("0");
[Link]("IT");
}
public static void main(String arg[])
{
try
{
reglib1 frame=new reglib1();
[Link](1280,720);
[Link](true);
}
catch(Exception e)
{
[Link](null,[Link]());
}
}
Output :-
3. ELECTRICITY BILL
Program:-
import [Link].*;
import [Link].*;
import [Link].*;
elec()
{
p1=new JPanel();
[Link](new GridLayout(9,2));
[Link](new Color(255,255,200));
p2=new JPanel();
[Link](new FlowLayout());
[Link](new Color(255,255,200));
c=getContentPane();
[Link](new Color(255,255,200));
[Link](new Color(255,255,200));
l3=new JLabel("Month");
[Link](new Font("Bookman Old Style",[Link],20));
[Link](new Color(150,0,0));
l4=new JLabel("Purpose");
[Link](new Font("Bookman Old Style",[Link],20));
[Link](new Color(150,0,0));
t1=new JTextField(15);
t2=new JTextField(15);
t3=new JTextField(15);
t4=new JTextField(15);
t5=new JTextField(15);
t6=new JTextField(15);
c1=new JComboBox(s1);
[Link](new Color(255,255,255));
c2=new JComboBox(s2);
[Link](new Color(255,255,255));
b1=new JButton("Submit");
[Link](new Color(250,220,170));
[Link](new Font("Bookman Old Style",[Link],16));
b2=new JButton("Reset");
[Link](new Color(250,220,170));
[Link](new Font("Bookman Old Style",[Link],16));
b3=new JButton("Display");
[Link](new Color(250,220,170));
[Link](new Font("Bookman Old Style",[Link],16));
[Link](false);
[Link](false);
[Link](false);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](l1);
[Link](t1);
[Link](l2);
[Link](t2);
[Link](l3);
[Link](c1);
[Link](l4);
[Link](c2);
[Link](l5);
[Link](t3);
[Link](l6);
[Link](t4);
[Link](l7);
[Link](t5);
[Link](l8);
[Link](t6);
[Link](p1,[Link]);
[Link](p2,[Link]);
setBounds(200,100,600,200);
setTitle("Electricity Bill");
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
setResizable(false);
if([Link]().equals("")||[Link]().equals("")||[Link]().equals("")||t4.
getText().equals(""))
{
[Link](null,"Please
Fill the full detail");
else
{
double p,c,unit,amt;
p=[Link]([Link]());
c=[Link]([Link]());
unit=c-p;
if(p>c)
{
amt=(50*.75)+(50*1)+((unit-100)*2);
else
amt=(50*.75)+(50*1)+(150*2)+((unit-250)*3);
[Link]([Link](amt));
}
if([Link]()=="Business")
{
if(unit>=1 && unit<=50)
amt=unit*2;
else
amt=(50*2)+(50*3)+(150*4)+((unit-250)*5);
[Link]([Link](amt));
}
[Link](this,"Submitted Successfully");
[Link](true);
[Link](false);
}
}
else if([Link]()==b3)
{
String a1,a2,a3,a4,a5,a6,a7,a8;
a1=[Link]();
a2=[Link]();
a3=(String)[Link]();
a4=(String)[Link]();
a5=[Link]();
a6=[Link]();
a7=[Link]();
a8=[Link]();
final String[]
head={"Name","Id","Month","Purpose","[Link]","[Link]","Unit","Amount"};
final String[][] data={{a1,a2,a3,a4,a5,a6,a7,a8}};
table=new JTable(data,head);
[Link]().setBackground(new
Color(250,220,170));
[Link]().setFont(new Font("Book
Antiqua",[Link],14));
int
v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int
h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
[Link](false);
[Link](false);
else if([Link]()==b2)
{
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link](false);
[Link](true);
}
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
setSize(600,200);
}
}
class elecdemoframe
{
public static void main(String arg[])
{
try
{
elec fr=new elec();
[Link](true);
[Link](600,600);
}
catch(Exception e)
{
[Link](null,[Link]());
}
}
}
Output :-
4. BANKING APPLICATION
Program:-
import [Link].*;
import [Link].*;
import [Link].*;
p1=new JPanel();
[Link](new GridLayout(5,2));
t1=new JTextField(15);
t2=new JTextField(10);
t3=new JTextField(15);
c1=new JComboBox(s1);
[Link](l1);
[Link](t1);
[Link](l2);
[Link](c1);
[Link](l3);
[Link](t2);
[Link](l4);
[Link](t3);
[Link](new JLabel(""));
[Link](new JLabel(""));
p2=new JPanel();
[Link](new FlowLayout());
b=new JButton[10];
p3=new JPanel();
[Link](new GridLayout(2,5));
for(int i=0;i<10;i++)
{
b[i]=new JButton([Link](i));
[Link](b[i]);
b[i].addActionListener(this);
}
b1=new JButton("Deposit");
b2=new JButton("Withdraw");
b3=new JButton("Balance");
[Link](this);
[Link](this);
[Link](this);
[Link](b1);
[Link](b2);
[Link](b3);
[Link](p1,[Link]);
[Link](p3,[Link]);
[Link](p2,[Link]);
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
}
}
if([Link]()==b1)
{
balance=balance+[Link]([Link]());
[Link](true);
int i=[Link](null,"Do you
want another transaction in the same account");
if(i==0)
{
[Link]("");
[Link]();
}
}
else if([Link]()==b2)
{
if(([Link]([Link]()))<500)
{
[Link](null,"You
dont have sufficient amount to withdraw");
[Link]("");
}
else
{
balance=[Link]([Link]());
}
}
else if([Link]()==b3)
{
String a1,a2,a3,a4;
a1=[Link]();
a2=(String)[Link]();
a3=[Link]();
a4=[Link](balance);
int
v=ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED;
int
h=ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED;
jsp=new JScrollPane(table,v,h);
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
setSize(600,200);
}
}
Output :-
6. LIBRARY MANAGEMENT SYSTEM
Program:-
a) HOME PAGE
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
choice1()
{
c=[Link]();
[Link](null);
Toolkit tk=[Link]();
Dimension wz=[Link]();
int w=[Link]-100;
int h=[Link]-50;
p=new JPanel();
//[Link](new Color(110,208,228));
p1=new JPanel();
//[Link](new Color(224,144,175));
[Link](p);
[Link](null);
[Link](p1);
[Link](null);
[Link](false);
ImageIcon im=new ImageIcon("[Link]");
ImageIcon ii=new ImageIcon("[Link]");
ImageIcon ib=new ImageIcon("[Link]");
ImageIcon ic=new ImageIcon("[Link]");
head=new
EtchedBorder([Link],[Link],[Link]);
b3=new JButton("Registration");
[Link](new Font("Bookman Old Style",[Link],14));
[Link](440,250,410,400);
[Link](0,0,(w+100),h);
[Link](10,50,1250,30);
[Link](140,50,1000,400);
[Link](10,250,350,400);
[Link](930,250,300,400);
[Link](0,0,(w+100),h);
[Link](50,200,150,30);
[Link](230,200,150,30);
[Link](135,150,150,30);
[Link](b1);
[Link](b2);
[Link](b3);
[Link](p);
[Link](l1);
[Link](l3);
[Link](l4);
[Link](l5);
[Link](l2);
[Link](this);
[Link](this);
[Link](this);
//[Link](new Color(224,144,175));
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
}
class choice
{
public static void main(String arg[])
{
try
{
choice1 frame=new choice1();
[Link](1280,720);
[Link](true);
}
catch(Exception e)
{
[Link](null,[Link]());
}
}
}
b) LOGIN FORM
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
logindemo1(String title)
{
super(title);
tit=title;
c=getContentPane();
[Link](null);
Font f=new Font("Book Antiqua",[Link],40);
Font f1=new Font("Times New Roman",[Link],16);
label=new
EtchedBorder([Link],[Link],[Link]);
Toolkit tk=[Link]();
Dimension wz=[Link]();
int w=[Link]-100;
int h=[Link]-50;
ImageIcon im=new ImageIcon("[Link]");
ImageIcon ii=new ImageIcon("[Link]");
ImageIcon ib=new ImageIcon("[Link]");
ImageIcon ic=new ImageIcon("[Link]");
p=new JPanel();
//[Link](new Color(110,208,228));
p1=new JPanel();
//[Link](new Color(224,144,175));
[Link](false);
[Link](false);
[Link](p);
[Link](null);
[Link](p1);
[Link](null);
l1=new JLabel();
[Link](f1);
[Link]("Login ID");
[Link]([Link]);
t1=new JTextField(15);
l2=new JLabel();
[Link]("Password");
[Link](f1);
[Link]([Link]);
t2=new JPasswordField(15);
l3=new JLabel("ADMINISTRATOR LOGIN",[Link]);
[Link]([Link]);
[Link](f);
b2=new JButton("EXIT");
[Link]([Link]);
//[Link](new Color(254,214,249));
//[Link](new Font("Book Antiqua",[Link],16));
[Link](0,0,(w+100),h);
[Link](0,0,(w+100),h);
[Link](380,100,500,220);
[Link](400,300,450,280);
[Link](50,50,100,30);
[Link](50,100,100,30);
[Link](200,50,200,30);
[Link](200,100,200,30);
[Link](10,30,1250,50);
[Link](10,30,1250,50);
[Link](10,100,350,450);
[Link](930,100,300,450);
[Link](120,180,100,30);
[Link](250,180,100,30);
//[Link](label);
[Link](l1);
[Link](t1);
[Link](l2);
[Link](t2);
[Link](b1);
[Link](b2);
if([Link]("admin")||[Link]("create_admin"))
{
[Link](l3);
}
else
{
[Link](l4);
}
[Link](l6);
[Link](l7);
[Link](l8);
[Link](l5);
[Link](this);
[Link](this);
[Link](new Color(224,144,175));
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
}
[Link](null,"select_con_error.........-
>"+[Link]());
}
try
{
more=[Link]();
while(more)
{
if([Link]("login_id").equalsIgnoreCase(v1)&&
[Link]("pass").equalsIgnoreCase(v2))
{
[Link](this,"Login Successfull");
flag=1;
}
more=[Link]();
}
if(flag==1)
{
userform r=new
userform("admin");
[Link](true);
[Link](1280,720);
setVisible(false);
}
else
{
}
else if([Link]("user"))
{
ss="select * from user_login";
try
{
conestablish1 co=new conestablish1();
rs=[Link](ss);
}
catch(Exception a)
{
[Link](null,"select_con_error.........-
>"+[Link]());
}
try
{
more=[Link]();
while(more)
{
if([Link]("login_id").equalsIgnoreCase(v1)&&
[Link]("pass").equalsIgnoreCase(v2))
{
[Link](this,"Login Successfull");
flag=1;
}
more=[Link]();
}
if(flag==1)
{
userform r=new
userform("user");
[Link](true);
[Link](1280,720);
setVisible(false);
}
else
{
}
catch(Exception e)
{
}
}
else if([Link]("create user"))
{
ss="select * from user_login";
try
{
conestablish1 co=new conestablish1();
rs=[Link](ss);
}
catch(Exception a)
{
[Link](null,"select_con_error.........-
>"+[Link]());
}
try
{
more=[Link]();
while(more)
{
if([Link]("login_id").equalsIgnoreCase(v1))
{
}
catch(Exception e)
{
}
if(flag==1)
{
[Link]("");
[Link]("");
}
else
{
String s="INSERT INTO user_login
VALUES('"+v1+"'";
s+=",'"+v2+"'";
s+=")";
try
{
conestablish1 ins=new
conestablish1();
[Link](s);
}
catch(Exception a)
{
[Link](null,"insert_con_error.........-
>"+[Link]());
}
reglib1 r=new reglib1(v1,"");
[Link](true);
[Link](1280,720);
setVisible(false);
}
}
else if([Link]("create_admin"))
{
ss="select * from admin_login";
try
{
conestablish1 co=new conestablish1();
rs=[Link](ss);
}
catch(Exception a)
{
[Link](null,"select_con_error.........-
>"+[Link]());
}
try
{
more=[Link]();
while(more)
{
if([Link]("login_id").equalsIgnoreCase(v1))
{
}
catch(Exception e)
{
}
if(flag==1)
{
[Link]("");
[Link]("");
}
else
{
String s="INSERT INTO admin_login
VALUES('"+v1+"'";
s+=",'"+v2+"'";
s+=")";
try
{
conestablish1 ins=new
conestablish1();
[Link](s);
}
catch(Exception a)
{
[Link](null,"insert_con_error.........-
>"+[Link]());
}
c) REGISTRATION FORM
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
try
{
t=title;
s=title1;
head=new
EtchedBorder([Link],[Link],[Link]);
panel1=new TitledBorder(new
LineBorder([Link]),"",TitledBorder.DEFAULT_JUSTIFICATION,TitledBorde
[Link],new Font("Book Antiqua",[Link],16),[Link]);
panel2=new TitledBorder(new LineBorder([Link])," Qualification
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
panel3=new TitledBorder(new LineBorder([Link])," Experience
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
panel4=new TitledBorder(new LineBorder([Link])," Research
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
panel5=new TitledBorder(new LineBorder([Link])," Paper
Presentation
",TitledBorder.DEFAULT_JUSTIFICATION,[Link],new
Font("Book Antiqua",[Link],16),[Link]);
cn=[Link]();
[Link](null);
[Link](new Color(110,208,228));
Toolkit tk=[Link]();
Dimension wz=[Link]();
int w=[Link]-100;
int h=[Link]-50;
p=new JPanel();
[Link](new Color(110,208,228));
p1=new JPanel();
//[Link](new Color(110,208,228));
p2=new JPanel();
//[Link](new Color(110,208,228));
p3=new JPanel();
//[Link](new Color(110,208,228));
p4=new JPanel();
//[Link](new Color(110,208,228));
p5=new JPanel();
//[Link](new Color(110,208,228));
p6=new JPanel();
//[Link](new Color(110,208,228));
p7=new JPanel();
[Link](p);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](head);
[Link](panel1);
[Link](panel2);
[Link](panel3);
[Link](panel4);
[Link](panel5);
[Link](head);
/*c=new JComboBox();
for(int i=1;i<10;i++)
{
[Link]("mca0"+[Link](i));
}*/
//[Link](false);
for(int i=1;i<=9;i++)
{
[Link]("0"+[Link](i));
}
for(int i=10;i<=31;i++)
{
[Link]([Link](i));
}
d2=new JComboBox();
for(int i=1;i<=9;i++)
{
[Link]("0"+[Link](i));
}
for(int i=10;i<=12;i++)
{
[Link]([Link](i));
}
d3=new JComboBox();
for(int i=1980;i<2011;i++)
{
[Link]([Link](i));
}
d5=new JComboBox();
for(int i=1;i<=9;i++)
{
[Link]("0"+[Link](i));
}
for(int i=10;i<=12;i++)
{
[Link]([Link](i));
}
d6=new JComboBox();
for(int i=1980;i<2011;i++)
{
[Link]([Link](i));
}
l5=new JLabel("Department");
[Link](new Font("Book Antiqua",[Link],16));
c1=new JComboBox(s1);
l9=new JLabel("University/College");
[Link](new Font("Book Antiqua",[Link],16));
t4=new JTextField(15);
l12=new JLabel("Title");
[Link](new Font("Book Antiqua",[Link],16));
ta=new JTextArea("",4,15);
[Link]([Link](""));
l14=new JLabel("Place");
[Link](new Font("Book Antiqua",[Link],16));
t8=new JTextField(15);
b1=new JButton("ADD");
b2=new JButton("MODIFY");
b5=new JButton("CLEAR");
b4=new JButton("EXIT");
[Link](200,70,900,540);
//[Link](10,10,1250,45);
[Link](20,10,860,130);
[Link](20,150,860,65);
[Link](20,225,860,105);
[Link](20,340,860,65);
[Link](20,415,860,110);
[Link](200,620,900,60);
[Link](0,0,(w+100),h);
[Link](0,0,(w+100),h);
[Link](10,10,1250,40);
[Link](40,10,150,30);
[Link](195,10,200,30);
[Link](460,10,150,30);
[Link](615,10,200,30);
[Link](40,50,150,30);
[Link](195,50,60,30);
[Link](265,50,60,30);
[Link](335,50,60,30);
[Link](460,50,150,30);
[Link](615,50,60,30);
[Link](685,50,60,30);
[Link](755,50,60,30);
[Link](40,90,150,30);
[Link](195,90,200,30);
[Link](40,20,150,30);
[Link](195,20,200,30);
[Link](460,20,150,30);
[Link](615,20,200,30);
[Link](40,20,150,30);
[Link](195,20,200,30);
[Link](460,20,150,30);
[Link](615,20,200,30);
[Link](40,60,150,30);
[Link](195,60,200,30);
[Link](460,60,150,30);
[Link](615,60,200,30);
[Link](40,20,150,30);
[Link](195,20,200,30);
[Link](460,20,150,30);
[Link](615,20,200,30);
[Link](40,20,150,30);
[Link](195,20,620,70);
[Link](250,15,100,30);
[Link](370,15,100,30);
[Link](490,15,100,30);
[Link](610,15,100,30);
[Link](p2);
[Link](p3);
[Link](p4);
[Link](p5);
[Link](p6);
//[Link](p7);
[Link](l1);
[Link](t1);
[Link](l2);
[Link](t2);
[Link](l3);
[Link](d1);
[Link](d2);
[Link](d3);
[Link](l4);
[Link](d4);
[Link](d5);
[Link](d6);
[Link](l5);
[Link](c1);
[Link](l6);
[Link](c2);
[Link](l7);
[Link](c3);
[Link](l8);
[Link](c4);
[Link](l9);
[Link](t4);
[Link](l10);
[Link](c5);
[Link](l11);
[Link](t5);
[Link](l13);
[Link](c6);
[Link](l14);
[Link](t8);
[Link](l12);
[Link](ta);
[Link](b1);
[Link](b2);
[Link](b4);
[Link](b5);
[Link](p1);
[Link](l15);
[Link](p7);
[Link](pl);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
}
catch(Exception e)
{
[Link](e);
}
setDefaultCloseOperation([Link].DISPOSE_ON_CL
OSE);
addWindowListener(new WindowAdapter()
{
public void windowClosing(WindowEvent e)
{
dispose();
[Link](0);
}
});
if([Link]("up"))
{
[Link](false);
[Link](null,[Link]());
}
try
{
while([Link]())
{
if([Link]([Link](1)))
{
[Link]([Link](2));
String db=[Link](3);
String dbd=[Link](0,4);
String dbm=[Link](5,7);
String dby=[Link](8,10);
[Link](dby);
[Link](dbm);
[Link](dbd);
String dj=[Link](4);
String djd=[Link](0,4);
String djm=[Link](5,7);
String djy=[Link](8,10);
[Link](djy);
[Link](djm);
[Link](djd);
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
[Link]([Link](8));
[Link]([Link](9));
[Link]([Link](10));
[Link]([Link](11));
[Link]([Link](12));
[Link]([Link](13));
[Link]([Link](14));
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
}
else
{
[Link](false);
}
}
try
{
conestablish1 ins=new conestablish1();
[Link](s);
[Link](null,"One Record
Added");
}
catch(Exception a)
{
[Link](null,[Link]());
}
userform r=new userform("user");
[Link](1280,720);
[Link](true);
setVisible(false);
}
if([Link]()==b2)
{
String ss1="";
try
{
ss1+="UPDATE Register set ";
ss1+="staff_name='"+[Link]()+"', ";
ss1+="dob='"+[Link]()+"-
"+[Link]()+"-"+[Link]()+"', ";
ss1+="doj='"+[Link]()+"-
"+[Link]()+"-"+[Link]()+"', ";
ss1+="dept='"+[Link]()+"', ";
ss1+="qual_pg='"+[Link]()+"', ";
ss1+="qual_ug='"+[Link]()+"', ";
ss1+="exp_tc='"+[Link]()+"',";
ss1+="univ='"+[Link]()+"', ";
ss1+="exp_ind='"+[Link]()+"', ";
ss1+="org='"+[Link]()+"', ";
ss1+="title='"+[Link]()+"', ";
ss1+="res='"+[Link]()+"', ";
ss1+="place='"+[Link]()+"' ";
ss1+=" WHERE staff_id='"+[Link]()+"' ";
}
catch(Exception e)
{
[Link](null,"in sql.........-
>"+[Link]());
}
try
{
conestablish1 i=new conestablish1();
[Link](ss1);
[Link](null,"One Record
Updated");
setVisible(false);
}
catch(Exception e1)
{
[Link](null,[Link]());
}
}
/*if([Link]()==b3)
{
try
{
String delete="DELETE FROM Register WHERE
staff_id='"+[Link]()+"'";
}
String del="DELETE FROM user_login WHERE
login_id='"+[Link]()+"'";
conestablish1 ins=new conestablish1();
[Link](del);
[Link](null,"One Record
Deleted");
[Link](1);
}
catch(Exception e1)
{
[Link](null,[Link]());
}
}*/
if([Link]()==b4)
{
dispose();
}
if([Link]()==b5)
{
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("01");
[Link]("01");
[Link]("1980");
[Link]("01");
[Link]("01");
[Link]("1980");
[Link]("MCA");
[Link]("MCA");
[Link]("BCA");
[Link]("0");
[Link]("0");
[Link]("IT");
}
public static void main(String arg[])
{
try
{
reglib1 frame=new reglib1("","");
[Link](1280,720);
[Link](true);
}
catch(Exception e)
{
[Link](null,[Link]());
}
}
public void focusGained(FocusEvent e)
{
if([Link]()==t1)
[Link](t);
}
d) MAIN FORM
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
import [Link];
import [Link].*;
//........stock
JLabel sl1,sl2,sl3,sl4,sl5,sl6,sl7,sl8,sl9,sh,sh1;
JTextField st1,st2,st3,st4,st5,st6,st7,st8;
JButton sb1,sb2,sb3,sb4,sb5,sb6;
JPanel sp1,sp2,sp3;
JComboBox c1,c2;
String []s={"Compartment","Department"};
//........issue
JLabel ish,li1,li2,li3,li4;
JTextField ti1,ti2,ti3,ti4;
JButton bi1,bi2;
JPanel pi1,pi2,pi3;
//........renewal
JLabel resh,lre1,lre2,lre3,lre4,lre5;
JTextField tre1,tre2,tre3,tre4,tre5;
JButton bre1,bre2;
JPanel pre1,pre2,pre3;
JComboBox cre1;
//........return
JLabel rtsh,lrt1,lrt2,lrt3,lrt4,lrt5;
JTextField trt1,trt2,trt3,trt4,trt5;
JButton brt1,brt2;
JPanel prt1,prt2,prt3;
JComboBox crt1;
//........staff
JLabel shss,lss1;
JTextField tss1;
JButton bss1,bss2;
JPanel pss1,pss2,pss3;
//.........search
JLabel shs,ls1;
JTextField ts1,ts2,ts3,ts4,ts5;
JButton bs1;
JPanel ps1,ps2,ps3;
JComboBox c3;
JRadioButton r1,r2,r3;
ButtonGroup bg;
//.........admin
JPanel pa1,pa2,pa3;
JLabel la1,sha,la2;
JTextField ta1;
JButton ba1;
JRadioButton ra1,ra2,ra3;
ButtonGroup bag;
Statement smt;
ResultSet rs,rt;
String sql2,t,date,date2,date3,strdate,strdate1,tit;
[Link] d1,d2,dat,dat1,dat2;
Calendar cal;
long tim;
tim=[Link]();
[Link]([Link],3);
dat1=new [Link]([Link]().getTime());
date3=[Link](dat1);
[Link]([Link],3);
dat2=new [Link]([Link]().getTime());
date2=[Link](dat2);
//.......................................................
Toolkit tk=[Link]();
Dimension wz=[Link]();
int w=[Link]-100;
int h=[Link]-50;
label=new
EtchedBorder([Link],[Link],[Link]);
c=[Link]();
[Link](null);
//[Link](new Color(110,208,228));
jtp=new JTabbedPane();
p1=new JPanel();
p2=new JPanel();
p3=new JPanel();
p4=new JPanel();
p5=new JPanel();
p6=new JPanel();
p7=new JPanel();
p8=new JPanel();
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(50,208,228));
if([Link]("user"))
{
[Link]("Staff",p5);
[Link]("Search",p6);
}
else
{
[Link]("Stok Maintenance",p1);
[Link]("Issue of Book",p2);
[Link]("Renewal Book",p3);
[Link]("Return Book",p4);
[Link]("Staff",p5);
[Link]("Admin",p8);
[Link]("Search",p6);
}
[Link](jtp);
[Link](p7);
[Link](0,0,(w+100),(h));
[Link](label);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
[Link](null);
label=new
EtchedBorder([Link],[Link],[Link]);
//.................Exit Panel
[Link](10,50,1280,20);
sxb6=new JButton("EXIT");
[Link](1000,0,80,20);
[Link](sxb6);
[Link](label);
//.........................Stock Maintenance
sp1=new JPanel();
sp2=new JPanel();
sp3=new JPanel();
[Link](null);
[Link](null);
[Link](null);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](false);
[Link](false);
[Link](false);
[Link](0,0,(w+100),(h));
[Link](0,0,(w+100),(h));
[Link](20,120,300,400);
[Link](950,100,300,440);
[Link](350,50,600,50);
[Link](label);
[Link](350,110,600,440);
[Link](label);
[Link](350,560,600,50);
[Link](label);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
st1=new JTextField(10);
st2=new JTextField(10);
st3=new JTextField(10);
st4=new JTextField(10);
st5=new JTextField(10);
st6=new JTextField(10);
st7=new JTextField(10);
c1=new JComboBox(s);
sb1=new JButton("ADD");
sb2=new JButton("VIEW");
sb3=new JButton("MODIFY");
sb4=new JButton("DELETE");
sb5=new JButton("CLEAR");
sb6=new JButton("OK");
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link](20,10,540,30);
[Link](50,150,200,30);
[Link](300,150,240,30);
[Link](250,250,100,30);
[Link](50,30,200,30);
[Link](300,30,240,30);
[Link](50,80,200,30);
[Link](300,80,240,30);
[Link](50,130,200,30);
[Link](300,130,240,30);
[Link](50,180,200,30);
[Link](300,180,240,30);
[Link](50,230,200,30);
[Link](300,230,240,30);
[Link](50,280,200,30);
[Link](300,280,240,30);
[Link](50,330,200,30);
[Link](300,330,240,30);
[Link](50,380,200,30);
[Link](300,380,240,30);
[Link](30,10,100,30);
[Link](140,10,100,30);
[Link](250,10,100,30);
[Link](360,10,100,30);
[Link](470,10,100,30);
[Link](sp1);
[Link](sp2);
[Link](sp3);
[Link](sh);
[Link](sl1);
[Link](st1);
[Link](sl2);
[Link](st2);
[Link](sl3);
[Link](st3);
[Link](sl4);
[Link](st4);
[Link](sl5);
[Link](st5);
[Link](sl6);
[Link](st6);
[Link](sl7);
[Link](st7);
[Link](sl8);
[Link](c1);
[Link](sh1);
[Link](c2);
[Link](sb6);
[Link](sb1);
[Link](sb2);
[Link](sb3);
[Link](sb4);
[Link](sb5);
[Link](s1);
[Link](s2);
[Link](sl);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
//.........................Book Issue
[Link](false);
[Link](false);
[Link](false);
[Link](null);
[Link](null);
[Link](null);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](0,0,(w+100),h);
[Link](0,0,(w+100),h);
[Link](300,50,600,50);
[Link](label);
[Link](300,110,600,260);
[Link](label);
[Link](300,380,600,50);
[Link](label);
[Link](20,10,540,30);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
ti1=new JTextField(10);
ti2=new JTextField(10);
ti3=new JTextField(10);
ti4=new JTextField(10);
bi1=new JButton("ISSUE");
bi2=new JButton("CLEAR");
[Link]([Link]);
[Link]([Link]);
[Link](50,30,200,30);
[Link](300,30,240,30);
[Link](50,80,200,30);
[Link](300,80,240,30);
[Link](50,130,200,30);
[Link](300,130,240,30);
[Link](50,180,200,30);
[Link](300,180,240,30);
[Link](200,10,100,30);
[Link](320,10,100,30);
[Link](pi1);
[Link](pi2);
[Link](pi3);
[Link](ish);
[Link](li1);
[Link](ti1);
[Link](li2);
[Link](ti2);
[Link](li3);
[Link](ti3);
[Link](li4);
[Link](ti4);
[Link](bi1);
[Link](bi2);
[Link](si);
//.........................Book Renewal
pre1=new JPanel();
pre2=new JPanel();
pre3=new JPanel();
[Link](null);
[Link](null);
[Link](null);
[Link](false);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](0,0,(w+100),(h));
[Link](0,0,(w+100),(h));
[Link](300,50,600,50);
[Link](label);
[Link](300,110,600,300);
[Link](label);
[Link](300,420,600,50);
[Link](label);
[Link](20,10,540,30);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
tre1=new JTextField(10);
tre3=new JTextField(10);
tre4=new JTextField(10);
tre5=new JTextField(10);
cre1=new JComboBox();
bre1=new JButton("RENEWAL");
bre2=new JButton("CLEAR");
[Link]([Link]);
[Link]([Link]);
[Link](50,30,200,30);
[Link](300,30,240,30);
[Link](50,80,200,30);
[Link](300,80,240,30);
[Link](50,130,200,30);
[Link](300,130,240,30);
[Link](50,180,200,30);
[Link](300,180,240,30);
[Link](50,230,200,30);
[Link](300,230,240,30);
[Link](200,10,100,30);
[Link](320,10,100,30);
[Link](pre1);
[Link](pre2);
[Link](pre3);
[Link](resh);
[Link](lre1);
[Link](tre1);
[Link](lre2);
[Link](cre1);
[Link](lre3);
[Link](tre3);
[Link](lre4);
[Link](tre4);
[Link](lre5);
[Link](tre5);
[Link](bre1);
[Link](bre2);
[Link](sre);
//.........................Book Return
prt1=new JPanel();
prt2=new JPanel();
prt3=new JPanel();
[Link](null);
[Link](null);
[Link](null);
[Link](false);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](0,0,(w+100),(h));
[Link](0,0,(w+100),(h));
[Link](300,50,600,50);
[Link](label);
[Link](300,110,600,300);
[Link](label);
[Link](300,420,600,50);
[Link](label);
[Link](20,10,540,30);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link](f1);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
[Link]([Link]);
trt1=new JTextField(10);
trt3=new JTextField(10);
trt4=new JTextField(10);
trt5=new JTextField(10);
crt1=new JComboBox();
brt1=new JButton("RETURN");
brt2=new JButton("CLEAR");
[Link]([Link]);
[Link]([Link]);
[Link](50,30,200,30);
[Link](300,30,240,30);
[Link](50,80,200,30);
[Link](300,80,240,30);
[Link](50,130,200,30);
[Link](300,130,240,30);
[Link](50,180,200,30);
[Link](300,180,240,30);
[Link](50,230,200,30);
[Link](300,230,240,30);
[Link](200,10,100,30);
[Link](320,10,100,30);
[Link](prt1);
[Link](prt2);
[Link](prt3);
[Link](rtsh);
[Link](lrt1);
[Link](trt1);
[Link](lrt2);
[Link](crt1);
[Link](lrt3);
[Link](trt3);
[Link](lrt4);
[Link](trt4);
[Link](lrt5);
[Link](trt5);
[Link](brt1);
[Link](brt2);
[Link](srt);
//.........................Search
[Link](null);
[Link](null);
[Link](null);
[Link](false);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](0,0,(w+100),(h));
[Link](0,0,(w+100),(h));
[Link](300,50,600,50);
[Link](label);
[Link](300,110,600,300);
[Link](label);
[Link](300,420,600,50);
[Link](label);
shs=new JLabel("SEARCH",[Link]);
[Link](f);
[Link]([Link]);
[Link](20,10,540,30);
ts1=new JTextField(15);
c3=new JComboBox();
r1=new JRadioButton("Book Title",true);
r2=new JRadioButton("Book Author");
r3=new JRadioButton("Book Code");
bg=new ButtonGroup();
[Link](r1);
[Link](r2);
[Link](r3);
[Link](f1);
[Link]([Link]);
[Link](f1);
[Link]([Link]);
[Link](f1);
[Link]([Link]);
bs1=new JButton("SEARCH");
[Link]([Link]);
[Link](50,30,200,30);
[Link](200,60,200,30);
[Link](200,110,200,30);
[Link](200,160,200,30);
[Link](false);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](200,250,200,30);
[Link](200,250,200,30);
[Link](250,10,100,30);
[Link](false);
[Link](ps1);
[Link](ps2);
[Link](ps3);
[Link](shs);
[Link](ls1);
[Link](ts1);
[Link](r1);
[Link](r2);
[Link](r3);
[Link](c3);
[Link](bs1);
[Link](ss);
//..........................Staff Modification
[Link](null);
[Link](null);
[Link](null);
[Link](false);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](0,0,(w+100),(h));
[Link](0,0,(w+100),(h));
[Link](300,50,600,50);
[Link](300,110,600,160);
[Link](300,280,600,50);
[Link](label);
[Link](label);
[Link](label);
[Link](20,10,540,30);
tss1=new JTextField(15);
[Link](50,60,200,30);
[Link](200,60,200,30);
bss1=new JButton("DELETE");
[Link]([Link]);
bss2=new JButton("MODIFY");
[Link]([Link]);
if([Link]("user"))
{
[Link](false);
}
else
{
[Link](false);
}
[Link](250,10,100,30);
[Link](250,10,100,30);
[Link](pss1);
[Link](pss2);
[Link](pss3);
[Link](shss);
[Link](lss1);
[Link](tss1);
[Link](bss1);
[Link](bss2);
[Link](sss);
//..........................Admin Modification
[Link](null);
[Link](null);
[Link](null);
[Link](false);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](0,0,(w+100),(h));
[Link](0,0,(w+100),(h));
[Link](300,50,600,50);
[Link](label);
[Link](300,110,600,230);
[Link](label);
[Link](300,350,600,50);
[Link](label);
[Link](20,10,540,30);
ra1=new JRadioButton("CREATE",true);
ra2=new JRadioButton("DELETE");
bag=new ButtonGroup();
[Link](ra1);
[Link](ra2);
[Link](f1);
[Link]([Link]);
[Link](f1);
[Link]([Link]);
ba1=new JButton("OK");
[Link]([Link]);
[Link](50,30,200,30);
[Link](200,60,200,30);
[Link](200,110,200,30);
[Link](false);
[Link](false);
//[Link](new Color(110,208,228));
//[Link](new Color(110,208,228));
[Link](50,170,200,30);
[Link](200,170,200,30);
[Link](250,10,100,30);
[Link](pa1);
[Link](pa2);
[Link](pa3);
[Link](sha);
[Link](la1);
[Link](la2);
[Link](ta1);
[Link](ra1);
[Link](ra2);
[Link](ba1);
[Link](sa);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
[Link](this);
if([Link]()==r3)
{
[Link]();
[Link](true);
[Link](false);
try
{
boolean more=[Link]();
while(more)
{
[Link]([Link](3));
more=[Link]();
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
}
if([Link]()==r1||[Link]()==r2)
{
[Link](false);
[Link](true);
}
if([Link]()==bs1)
{
try
{
if([Link]())
{
String s="";
s="select * from stock where
isbn='"+[Link]()+"'";
else
{
String s="";
if([Link]())
s="select * from stock where
b_name='"+[Link]()+"'";
if([Link]())
s="select * from stock where
author='"+[Link]()+"'";
}
}
catch(Exception e)
{
//***************************************************Staff
panel**********************************************
//.................................Delete Button
if([Link]()==bss1)
{
String a=[Link]();
if([Link](""))
{
[Link](null,"Please
enter the Value.");
}
else
{
String sr="Select * from register";
int f=0;
try
{
conestablish1 ci=new conestablish1();
rs=[Link](sr);
}
catch(Exception e2)
{
[Link](null,[Link]());
}
try
{
while([Link]())
{
if([Link]([Link](1)))
{
f=1;
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
if(f==1)
{
String at=[Link]();
String delete="DELETE FROM Register
WHERE staff_id='"+[Link]()+"'";
String del="DELETE FROM user_login
WHERE login_id='"+at+"'";
int
i=[Link](null,"Are you sure to delete this record?");
if(i==0)
{
conestablish1 ins=new
conestablish1();
[Link](delete);
conestablish1 ins1=new
conestablish1();
[Link](del);
}
else
{
//...............................Ok Button
if([Link]()==bss2)
{
if([Link]().equals(""))
{
[Link](null,"Please enter the
Value.");
}
else
{
String sr="Select * from register";
int f=0;
try
{
conestablish1 ci=new conestablish1();
rs=[Link](sr);
}
catch(Exception e2)
{
[Link](null,[Link]());
}
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
{
f=1;
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
if(f==0)
{
[Link](null,"Wrong
Staff ID");
[Link]("");
}
else
{
reglib1 frame=new
reglib1([Link](),"up");
[Link](1280,720);
[Link](true);
[Link]("");
}
}
if([Link]()==sxb6)
{
[Link](1);
}
//************************************************Stock
Panel********************************************
//.....................................Add Button
if([Link]()==sb1)
{
//.............All Fields data is filled or data
if([Link]().equals("")||[Link]().equals("")||[Link]().equals("")||s
[Link]().equals("")||[Link]().equals("")||[Link]().equals("")||[Link]
().equals(""))
{
[Link](null,"Plz Fill the Full
Details");
}
else
{
//...........check ISBN No
}
if(f==1)
{
}
catch(Exception e2)
{
[Link](null,"rs_next.........-
>"+[Link]());
}
//...........................insert record
if(f==0)
{
String s="INSERT INTO stock
VALUES('"+[Link]()+"'";
s+=",'"+date+"'";
s+=",'"+[Link]()+"'";
s+=",'"+[Link]()+"'";
s+=",'"+[Link]()+"'";
s+=",'"+[Link]()+"'";
s+=",'"+[Link]()+"'";
s+=",'"+[Link]()+"'";
s+=",'"+"not issue"+"'";
s+=")";
try
{
conestablish1 ins=new conestablish1();
[Link](s);
[Link](null,"1
Record Added");
}
catch(Exception a)
{
[Link](null,"insert_con_error.........-
>"+[Link]());
}
//[Link]([Link]([Link]([Link]())+1));
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("Complement");
}
}
}
//......................................View Button
if([Link]()==sb2)
{
[Link]();
[Link](true);
[Link](true);
[Link](true);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
[Link](false);
}
catch(Exception e2)
{
[Link](null,"rs_next.........-
>"+[Link]());
}
}
//............................................Ok Button
if([Link]()==sb6)
{
t=(String)[Link]();
[Link](false);
[Link](false);
[Link](false);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](true);
[Link](false);
[Link](false);
[Link](null,"update_next.........->"+[Link]());
}
try
{
while([Link]())
{
if([Link]([Link](3)))
{
[Link]([Link](1));
d1=[Link](2);
SimpleDateFormat sdfDestination
= new SimpleDateFormat("dd-MM-yyyy");
String strDate =
[Link](d1);
[Link](strDate);
[Link](t);
[Link]([Link](4));
[Link]([Link](5));
[Link]([Link](6));
[Link]([Link](7));
[Link]([Link](8));
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
}
//................................................Modify Button
if([Link]()==sb3)
{
String r="";
try
{
r+="UPDATE stock set isbn='"+[Link]()+"',
b_name='"+[Link]()+"', author='"+[Link]()+"', price="+[Link]()+",
rack='"+[Link]()+"', type='"+[Link]()+"' WHERE
acc_id="+[Link]()+" ";
}
catch(Exception e)
{
[Link](null,"in sql.........-
>"+[Link]());
}
try
{
conestablish1 i=new conestablish1();
[Link](r);
[Link](null,"Stock
Updated");
}
catch(Exception e1)
{
[Link](null,"update_con.........->"+[Link]());
}
}
//..........................................Delete Button
if([Link]()==sb4)
{
try
{
String delete="DELETE FROM stock WHERE
acc_id="+[Link]();
}
catch(Exception e1)
{
[Link](null,"in
deletion_con...........:"+[Link]());
}
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
}
//.................................clear Button
if([Link]()==sb5)
{
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link](true);
[Link](true);
[Link](false);
[Link](false);
}
//****************************************************Issue
Panel****************************************************
if([Link]()==bi1)
{
//.............All Fields data is filled or data
if([Link]().equals("")||[Link]().equals("")||[Link]().equals("")||ti
[Link]().equals(""))
{
[Link](null,"Plz Fill the Full
Details");
}
else
{
//....................Staff Id Checking.................
int f=0;
String ss="Select * from register";
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
f=1;
}
}
catch(Exception e2)
{
[Link](null,[Link]());
}
if(f==0)
int f1=0;
String ss1="Select * from stock";
conestablish1 ci1=new conestablish1();
rt=[Link](ss1);
try
{
while([Link]())
{
[Link](null,[Link]());
}
if(f1==0)
else
{
//..............No of Books Issued
Checking.......................
[Link](null,[Link]());
}
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
{
count++;
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
if(count<4)
{
String r="";
[Link](null,[Link]());
}
try
{
String sel=[Link]();
while([Link]())
{
[Link](r);
catch(Exception e1)
{
[Link](null,[Link]());
}
String
p="INSERT INTO issue VALUES('"+[Link]()+"'";
p+=",'"+[Link]()+"'";
p+=",'"+date+"'";
p+=",'"+date2+"'";
p+=")";
try
{
[Link](p);
[Link](null,"Book Issued");
[Link]("");
[Link]("");
[Link]("");
[Link]("");
}
catch(Exception a)
{
[Link](null,[Link]());
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
}
else
{
[Link](null,"You can't issued more books... You
alrady issued 4 books");
}
}
}
}
}
if([Link]()==bi2)
{
[Link]("");
[Link]("");
[Link]("");
[Link]("");
}
//******************************************Return
panel**************************************
if([Link]()==brt1)
{
//.............All Fields data is filled or data
if([Link]().equals("")||[Link]().equals("")||[Link]().equals(""
)||[Link]().equals(""))
{
[Link](null,"Plz Fill the Full
Details");
}
else
{
String sel=(String)[Link]();
try
{
String delete="DELETE FROM issue WHERE
isbn='"+[Link]()+"'";
[Link](null,"Book Returned");
}
catch(Exception e1)
{
[Link](null,[Link]());
}
String upd="UPDATE stock set status='"+"not
issue"+"' WHERE isbn='"+[Link]()+"' ";;
try
{
conestablish1 i=new conestablish1();
[Link](upd);
}
catch(Exception e1)
{
[Link](null,[Link]());
}
[Link](sel);
[Link]("");
[Link]("");
[Link]("");
}
}
if([Link]()==brt2)
{
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]();
}
//************************************Renewal
Panel*****************************************
if([Link]()==bre1)
{
//.............All Fields data is filled or data
if([Link]().equals("")||[Link]().equals("")||[Link]().equals("
")||[Link]().equals(""))
{
[Link](null,"Plz Fill the Full
Detail");
}
else
{
String updt="UPDATE issue set
issue_date='"+date+"',ret_date='"+date3+"' WHERE
isbn='"+[Link]()+"' ";;
try
{
conestablish1 i=new conestablish1();
[Link](updt);
[Link](null,"Book
Renewed");
}
catch(Exception e1)
{
[Link](null,[Link]());
}
[Link]("");
[Link]("");
[Link]("");
}
}
if([Link]()==bre2)
{
[Link]("");
[Link]("");
[Link]("");
[Link]("");
[Link]();
}
//************************************Admin
Panel*****************************************
if([Link]()==ra2)
{
[Link](true);
[Link](true);
}
if([Link]()==ra1)
{
[Link](false);
[Link](false);
}
if([Link]()==ba1)
{
if([Link]())
{
logindemo1 frame=new logindemo1("");
[Link](1280,720);
[Link](true);
}
else
{
String a=[Link]();
if([Link](""))
{
[Link](null,"Please
enter the Value.");
}
else
{
String sr="Select * from admin_login";
int f=0;
try
{
conestablish1 ci1=new conestablish1();
rs=[Link](sr);
}
catch(Exception e2)
{
[Link](null,[Link]());
}
try
{
while([Link]())
{
if([Link]([Link](1)))
{
f=1;
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
if(f==1)
{
String delete="DELETE FROM admin_login
WHERE login_id='"+[Link]()+"'";
int
i=[Link](null,"Are you sure to delete this record?");
if(i==0)
{
conestablish1 ins=new conestablish1();
[Link](delete);
}
}
else
{
[Link](null,"Wrong
Admin ID");
[Link]("");
}
}
}
}
}
try
{
if([Link]()==st2)
{
[Link](date);
}
if([Link]()==st1)
{
int j=0;
String ss="Select * from stock";
try
{
conestablish1 ci=new conestablish1();
rs=[Link](ss);
}
catch(Exception e2)
{
[Link](null,"update_next.........->"+[Link]());
}
try
{
boolean more=[Link]();
if(!more)
{
j=1;
}
else
{
while(more)
{
j=[Link]([Link](1));
more=[Link]();
}
j=j+1;
}
[Link]([Link](j));
}
catch(Exception e2)
{
[Link](null,"rs_next.........-
>"+[Link]());
}
}
}catch(Exception ee)
{
}
if([Link]()==ti3)
{
[Link](date);
}
if([Link]()==ti4)
{
[Link](date2);
}
if([Link]()==tre1)
{
[Link]();
}
if([Link]()==trt1)
{
[Link]();
}
if([Link]()==tre3)
{
[Link](date);
}
if([Link]()==tre4)
{
[Link](date3);
}
if([Link]()==trt3)
{
if([Link]().equals(""))
{
//[Link]();
}
else
{
int f=0;
String ss="Select * from register";
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
f=1;
}
}
catch(Exception e2)
{
[Link](null,[Link]());
}
if(f==0)
{
}
else
{
String sr="Select * from issue";
conestablish1 ci=new conestablish1();
rs=[Link](sr);
try
{
while([Link]())
{
if([Link]().equals([Link](2)))
{
d1=[Link](3);
d2=[Link](4);
SimpleDateFormat sdfDestination
= new SimpleDateFormat("dd-MM-yyyy");
strdate =
[Link](d1);
strdate1 =
[Link](d2);
[Link](strdate);
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
}
}
}
if([Link]()==trt4)
{
if([Link]().equals(""))
{
//[Link]();
}
else
{
[Link](strdate1);
}
}
if([Link]()==trt5)
{
if([Link]().equals(""))
{
}
else
{
int f=0;
String ss="Select * from register";
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
f=1;
}
}
catch(Exception e2)
{
[Link](null,[Link]());
}
if(f==0)
{
}
else
{
long days=([Link]())/(1000*60*60*24);
long fine=0;
if(days>0)
{
fine=days*1;
[Link]([Link](fine));
}
else
[Link]("0");
}
}
}
//...............Fine Field of Renewal
if([Link]()==tre5)
{
if([Link]().equals(""))
{
//[Link]();
}
else
{
int f=0;
String ss="Select * from register";
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
f=1;
}
}
catch(Exception e2)
{
[Link](null,[Link]());
}
if(f==1)
{
String sr="Select * from issue";
conestablish1 ci=new conestablish1();
rs=[Link](sr);
try
{
while([Link]())
{
if([Link]().equals([Link](2)))
{
d2=[Link](4);
}
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
long days=([Link]())/(1000*60*60*24);
long fine=0;
if(days>0)
{
fine=days*1;
[Link]([Link](fine));
}
else
[Link]("0");
}
}
}
}
}
else
{
int f=0;
String ss="Select * from register";
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
f=1;
}
}
catch(Exception e2)
{
[Link](null,[Link]());
}
if(f==0)
{
[Link](null,"Incorrect Staff
ID");
[Link]("");
}
else
{
try
{
while([Link]())
{
if([Link](1).equals([Link]()))
[Link]([Link](2));
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
}
}
}
if([Link]()==trt1)
{
if([Link]().equals(""))
{
//[Link](null,"Enter Staff
ID");
}
else
{
int f=0;
String ss="Select * from register";
try
{
while([Link]())
{
if([Link]().equals([Link](1)))
f=1;
}
}
catch(Exception e2)
{
[Link](null,[Link]());
}
if(f==0)
{
[Link](null,"Incorrect Staff
ID");
}
else
{
try
{
while([Link]())
{
if([Link](1).equals([Link]()))
[Link]([Link](2));
}
}
catch(Exception e2)
{
[Link](null,"rs_next.........->"+[Link]());
}
}
}
}
}
e) REPORT
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
boolean moreRecords=[Link]();
if(!moreRecords)
{
[Link](null,"Book Not Found.");
}
else
{
setVisible(true);
setSize(1280,720);
try{
ResultSetMetaData rsmd=[Link]();
for(int i=1;i<=[Link]();i++)
[Link]([Link](i));
do{
[Link](getNextRow(rs,rsmd));
}while([Link]());
table=new JTable(rows,col);
jsp=new JScrollPane(table);
add(jsp);
}catch(SQLException e){}
f) CONNECTION
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
class connection1
{
String url="jdbc:odbc:anilibrary";
Connection Con;
Statement stmt;
String username="",password="";
public connection1()
{
Statement FConnect()
{
try
{
[Link]("[Link]");
}
catch(Exception f)
{
[Link](null,"class error.......");
}
try
{
Con=[Link](url,username,password);
}
catch(Exception f1)
{
[Link](null,"Connection error.......");
}
try
{
stmt=[Link](ResultSet.TYPE_SCROLL_SENSITIVE,ResultS
et.CONCUR_READ_ONLY);
}
catch(Exception e2)
{
[Link](null,"Statement
error.......");
}
return stmt;
}
void Fdisconnect()
{
try
{
[Link]();
[Link]();
}
catch(Exception e)
{
[Link](null,"disconnect error......."
);
}
}
}
g) CONNECTION ESTABLISH
import [Link].*;
import [Link].*;
import [Link].*;
import [Link].*;
class conestablish1
{
Statement st;
connection1 con=new connection1();
ResultSet rs;
conestablish1()
{
st=[Link]();
}
catch(Exception e)
{
[Link](null,"in
selection............"+[Link]());
}
return(rs);
}
catch(Exception e)
{
[Link](null,"in
updation............"+[Link]());
}
}
}
catch(Exception e)
{
[Link](null,"in
deletion........"+[Link]());
}
}
}
Output :-
7. Creating Own Bean ( JAVA BEAN)
Program:-
a) Java Code
import [Link].*;
import [Link].*;
public Color1()
{
addMouseListener(new MouseAdapter()
{
public void mousePressed(MouseEvent ae)
{
change();
}
});
rectangular=false;
setSize(400,400);
change();
}
if(rectangular)
{
[Link](0,0,w-1,h-1);
}
else
[Link](0,0,w-1,h-1);
}
}
b) MFT Code
Name: [Link]
Java-Bean: True
Output :-
8. GENERIC SERVLET
Program:-
a) HTML Code
<html>
<body>
<center>
<form name="Form1" method="Post"
action="[Link]
<table>
<tr>
<td><b>Employee</td>
<td><input type=textbox name="EmployeeName" size"25">
</td>
</tr>
<tr>
<td><b>Phone No</td>
<td><input type=textbox name="Phone" size"25">
</td>
</tr>
</table>
</form>
</body>
</html>
b) JAVA Code
import [Link].*;
import [Link].*;
import [Link].*;
while([Link]())
{
String pname=(String)[Link]();
[Link](pname+" = ");
String pvalue=[Link](pname);
[Link](pvalue);
}
[Link]();
}
}
Output :-
9. HTTP SERVLET
Program:-
a) HTML Code
<html>
<body>
<center>
<form name="Form1"
action="[Link]
<B>Color</B>
</select>
<br><br>
</form>
</body>
</html>
b) JAVA Code
import [Link].*;
import [Link].*;
import [Link].*;
Output :-