Human Resouce Management System

//human resource management systems //developed by m. r. pandey,marathwada institute of technology, bulandshahr,india, [email protected] /* ////////////////

progressbar.java ////////////////////// */

import java.awt.*; import java.awt.event.*; import javax.swing.*; public class progressbar extends jframe implements actionlistener { static progressmonitor pbar; static int counter =0; jbutton b=new jbutton("click here"); public progressbar() { super("progress monitor demo"); setsize(300,400); pbar=new progressmonitor(null,"monitor progress","initializing....",0,100); timer t=new timer(250,this); t.start(); setvisible(true); } public static void main(string args[]) { uimanager.put("progressbar.progresstext","hrms system"); uimanager.put("optionpane.cancelbuttontext","go away"); new progressbar(); welcome f=new welcome(); f.setvisible(true); f.setsize(800,600); f.show(); } public void actionperformed(actionevent e) { swingutilities.invokelater(new update()); if(counter==100) { b.setenabled(false); this.dispose(); } } class update implements runnable { public void run() { if(pbar.iscanceled()) {

pbar.close(); system.exit(1); } pbar.setprogress(counter); pbar.setnote("operation is"+counter+" % complete"); counter+=2; } } }

/* ////////////////

welcome.java ////////////////////// */

import import import import import

java.awt.*; java.awt.toolkit; javax.swing.*; java.awt.event.*; java.awt.color;

public class welcome extends jframe implements actionlistener { public jlabel l,l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l12,l13,l14,l15,l16,l17; public jbutton b; public jpanel panel; font g,h,i; color c; public welcome() { g=new font("",font.bold,25); h=new font("",font.italic,18); i=new font("",font.bold,12); c =new color(210,100,205); getcontentpane().setbackground(color.orange); panel=(jpanel)getcontentpane(); panel.setlayout(null); l=new jlabel("welcome"); l1=new jlabel("to"); l2=new jlabel("wonderful"); l14=new jlabel("world"); l3=new jlabel("of"); l4=new jlabel("human resource management system"); l5=new jlabel("created by:"); l6=new jlabel("mahaveer pandey"); l7=new jlabel("kanchan pandey"); l8=new jlabel("sushil kumar pandey"); l13=new jlabel("manisha pandey"); l9=new jlabel("under the guidance of:"); l10=new jlabel("mr. ajit kumar singh");

l15=new jlabel("mr. n.k.tyagi"); l16=new jlabel("mr. m.r.pandey"); l17=new jlabel("m.i.t., bulandshahr"); l12=new jlabel("marathawada institute of technology bulandshahr, up-203001"); b=new jbutton("click here"); panel.add(l); l.setbounds(300,0,180,60); l.setfont(g); panel.add(l1); l1.setbounds(340,70,100,30); l1.setfont(g); panel.add(l2); l2.setbounds(70,100,200,60); l2.setfont(g); panel.add(l14); l14.setbounds(490,100,130,60); l14.setfont(g); panel.add(l3); l3.setbounds(340,140,100,30); l3.setfont(g); panel.add(l4); l4.setfont(g); l4.setbounds(100,250,700,30); panel.add(l5); l5.setfont(h); l5.setbounds(60,350,150,30); panel.add(l6); l6.setfont(i); l6.setbounds(100,370,150,30); panel.add(l7); l7.setfont(i); l7.setbounds(100,390,150,30); panel.add(l8); l8.setfont(i); l8.setbounds(100,410,150,30); panel.add(l13); l13.setfont(i); l13.setbounds(100,430,150,30); panel.add(l9); l9.setfont(h); l9.setbounds(450,350,200,30); panel.add(l10); l10.setfont(i);

l10.setbounds(470,370,180,30); panel.add(l15); l15.setfont(i); l15.setbounds(470,390,180,30); panel.add(l16); l16.setfont(i); l16.setbounds(470,410,180,30); panel.add(l17); l17.setfont(i); l17.setbounds(470,430,180,30); panel.add(l12); l12.setfont(h); l12.setbounds(180,500,500,30); panel.add(b); b.setbounds(320,300,110,30); b.addactionlistener(this); } public void actionperformed(actionevent a) { string s1="click here"; string str=a.getactioncommand(); if(s1.equals(str)) { login f=new login(); f.setvisible(true); f.setsize(800,600); f.show(); toolkit tk=f.gettoolkit(); dimension wsize=tk.getscreensize(); f.setbounds(wsize.width/5,wsize.height/5,wsize.width/2,wsize.height/2); this.dispose(); } repaint(); } public static void main(string args[]) { welcome f=new welcome(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ////////////////

login.java

////////////////////// */

import java.awt.*; import java.awt.event.*; import javax.swing.*; public { public public public public public public

class login extends jframe implements actionlistener jtextfield t1; textfield t2; jlabel l1,l2,l3; jbutton b1,b2; jpanel panel; font g;

public login() { g=new font("",font.bold,18); getcontentpane().setbackground(color.magenta); panel=(jpanel)getcontentpane(); panel.setlayout(null); l1=new jlabel("login form"); l2=new jlabel("login"); l3=new jlabel("password"); t1=new jtextfield(20); t2=new textfield(20); t2.setechochar('*'); b1=new jbutton("ok"); b2=new jbutton("exit"); panel.add(l1); l1.setfont(g); panel.add(l2); panel.add(l3); panel.add(t1); panel.add(t2); panel.add(b1); panel.add(b2); l1.setbounds(100,5,150,40); l2.setbounds(30,60,100,30); l3.setbounds(30,110,100,30); t1.setbounds(140,60,150,30); t2.setbounds(140,110,150,30); b1.setbounds(140,180,60,30); b2.setbounds(220,180,65,30); t1.addactionlistener(this); t2.addactionlistener(this); b1.addactionlistener(this); b2.addactionlistener(this); } public void actionperformed(actionevent a) {

string string string string string

s1="mrp"; s2="pandey"; s3="ok"; s4="exit"; str=a.getactioncommand();

if(s3.equals(str)) { if(s1.equals(t1.gettext()) && s2.equals(t2.gettext())) { this.dispose(); menu p=new menu(); p.setvisible(true); p.setsize(800,700); p.show(); this.dispose(); } else { if(s3.equals(str)) { t1.settext(""); t2.settext(""); joptionpane.showmessagedialog(null,"please varify the correct login and password","warning",joptionpane.ok_cancel_option); } } } if( str=="exit") { joptionpane.showmessagedialog(null,"the project is still in progress,do u want to quit now","warning",joptionpane.ok_cancel_option); if(s4.equals(str)) { system.exit(0); } repaint(); } } public static void main(string args[]) { login f=new login(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ////////////////

menu.java

////////////////////// */

import import import import import

java.awt.*; java.awt.borderlayout; javax.swing.*; javax.swing.joptionpane.*; java.awt.event.*;

public class menu extends jframe implements actionlistener { public jmenu jb1,jb2,jb3,jb4,jb5,jb6,jb7; public jpanel panel; public imageicon i,j; public jframe jf; public menu() { settitle("main_screen"); setjmenubar(menubar); jb1=new jmenu("about project"); jb7=new jmenu("placement_information"); jb2=new jmenu("training_information"); jb3=new jmenu("important_information"); jb4=new jmenu("available_jobs"); jb5=new jmenu("help"); jb6=new jmenu("exit"); jmenuitem e=new jmenuitem("exit"); menubar.add(jb1); menubar.add(jb7); menubar.add(jb2); menubar.add(jb3); menubar.add(jb4); menubar.add(jb5); menubar.add(jb6); jmenuitem jm1=new jmenuitem("introduction"); jb1.add(jm1); jb6.add(e); jb1.addseparator(); jmenuitem jm2=new jmenuitem("references"); jb1.add(jm2); jmenuitem jm3=new jmenu("trainee_information"); jb2.add(jm3); jmenuitem jm13=new jmenuitem("master_details"); jm3.add(jm13); jmenuitem jm14=new jmenuitem("dpt_details"); jm3.add(jm14); jmenuitem jm6=new jmenuitem("candidate_aggregate"); jb3.add(jm6); jmenuitem jm7=new jmenuitem("shortlisted_candidates"); jb3.add(jm7);

jmenuitem jm5=new jmenuitem("training_plan"); jb4.add(jm5); jmenuitem jm15=new jmenuitem("training_criteria"); jb4.add(jm15); jmenuitem jm9=new jmenuitem("department_training"); jb4.add(jm9); jmenuitem jm8=new jmenuitem("agencies_information"); jb7.add(jm8); jmenuitem jm12=new jmenuitem("training_registration"); jb7.add(jm12); jmenuitem jm10=new jmenuitem("help"); jb5.add(jm10);

panel=(jpanel)getcontentpane( ); panel.setlayout(new borderlayout()); i=new imageicon("ball_ani.gif"); jlabel lb1=new jlabel("",i,jlabel.center); panel.add(lb1,borderlayout.center); e.addactionlistener(this); jm9.addactionlistener(this); jm1.addactionlistener(this); jm2.addactionlistener(this); jm3.addactionlistener(this); jm12.addactionlistener(this); jm5.addactionlistener(this); jm6.addactionlistener(this); jm7.addactionlistener(this); jm8.addactionlistener(this); jm10.addactionlistener(this); jm13.addactionlistener(this); jm14.addactionlistener(this); jm15.addactionlistener(this); } public void actionperformed(actionevent a) { string s1="ok"; string s2="cancel"; string str=a.getactioncommand(); if( str=="exit") { joptionpane.showmessagedialog(null,"are you want to exit click ok","alert",joptionpane.ok_cancel_option); if(str=="exit") { system.exit(0); } if(s2.equals(str)) {

this.dispose(); }

} if(str=="help") { help f=new help(); f.setvisible(true); f.setsize(800,600); f.show(); }

if(str=="introduction") { intro f=new intro(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="references") { ref f=new ref(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="training_plan") { plan f=new plan(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="shortlisted_candidates") { shortlist f=new shortlist(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="training_criteria") { job_req f=new job_req(); f.setvisible(true); f.setsize(800,600); f.show(); }

if(str=="department_training") { train_exe f=new train_exe(); f.setvisible(true);

f.setsize(800,600); f.show(); } if(str=="agencies_information") { placement f=new placement(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="master_details") { masterdetails f=new masterdetails(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="dpt_details") { masterdetails01 f=new masterdetails01(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="candidate_aggregate") { cd_per f=new cd_per(); f.setvisible(true); f.setsize(800,600); f.show(); } if(str=="training_registration") { tr_reg f=new tr_reg(); f.setvisible(true); f.setsize(800,600); f.show(); } } private jmenubar menubar=new jmenubar(); /* mostly menubar class is used in implementing menubar */ public static void main(string args[]) { menu m=new menu(); m.setsize(800,600); m.setvisible(true); m.show(); } } /*

////////////////

introduction.java ////////////////////// */

import import import import import

{

java.awt.*; java.awt.event.*; java.applet.*; javax.swing.*; java.util.*;

public class intro extends jframe implements actionlistener public jpanel pane; public jbutton b1,b2,b3; public textarea t; public intro() { settitle("introduction"); pane=(jpanel)getcontentpane(); pane.setlayout(null); jlabel j=new jlabel(" project introduction "); j.setfont(new font("monotype corsiva",font.italic,16)); j.setbounds(300,20,250,50); pane.add(j);

string val=" "+ "+ "+ "+ "+

" " " " " project title: hrms automation

"+ "introduction:

"+ "the presented project here is made in view overcoming the problems faced by the any export firm regarding maintenance, "+ "recording and keeping of data base, employee information, financial transactions, payroll system, training, recruitment etc. i.e. "+ "general hrms automation.

"+ "this project is an application project i.e. hrms automation system. "+ "application run in a local area network of client where as web site run in wide area networks i.e. world wide web. "+ "application run on user defined window where as website works in a browser.hence this project is an application and not a portal/website. "+ "this project can be widely used in any export firm which contain different departments with various employees having different designations, salary profiles etc. "+ "beside these it is very useful for the organizations having number of branches with a head branch connected by a lan system through its other branches. "+ "these networks need a special kind of security feature. "+ "objective and scope of the study:"+ "objective of doing this project is to enhance my knowledge in the field of distributed technology using j2ee and oracle 8i. "+ "some of the client requirement and objectives of this project is as under: "+ "the main objective of study: "+ "* it should "+ "* it should "+ "* it should "+ "* it should "+ "* it should

contain all the information of company. contain all the information of company infrastructure. contain all the information of company employees. contain all the information of orders. contain all the information of item in stock.

"+ "purpose: "+ "computerized hrms automation system is developed to facilitate the general administration system to manage "+

"the various information of the employees and the processes involved in an export firm. so, that organization "+ "can access accurate information quickly and easily as and when required, thereby improving its operational efficiency "+ "& effectiveness as well. "+ "module description :"+ "hrms automation comprises with the following modules: "+ "1) "2) "3) "4) "5)

manpower planning system. "+ training & planning system. "+ employee information system "+ salary processing system "+ attendance recording system. "+

"here we will work on the first module 'training and planning system' "+ " training division: "+ "� institute training. it maintains all the details, information about the institute or company, which provide the training to the candidates or employees.

" "

"� "� "� "� "�

"+

following are the fields for training:-

"+ master details. "+ institute name. "+ institute details. "+ training criteria (training package). "+ no. of batches. "+ no. of candidate/batch.

"� "� "� "� "�

"+ details of the candidate in each batch. "+ duration of the training. "+ training program. "+ cost of training. "+ faculty assigned for the batch. "+

"� professional training:- it maintain details of various training program undertaken by employee.

"� "� "� "� "� "� "� "� "� "�

"+ department name. "+ department details. "+ no. of employees assigned/department. "+ name of training program. "+ duration of training. "+ in charge details. "+ cost of training. "+ training criteria. "+ training role. "+ employee details. "+

"� training program master:-it contains the name of the training and all details under the particular training program.

" " "� "� "�

"+ required fields are:"+ master details. "+ institute/department name. "+ institute/department details. "+ training criteria (training package). "+

". "� "� "� "� "� "� "�

details of the candidate "+ duration of the training. "+ training program. "+ cost of training. "+ person assigned for the training. "+ no. of employees assigned/department. "+ name of training program. "+ training role (for which post). "+

"� plan:-we can entered training plan/need and duration of training required for employee. "+

"� "� "� "� "� "� "� "� "� "�

"required fields are:-

"+ training name. "+ objective of the training. "+ duration of training. "+ required employees. "+ employee's details. "+ criteria for training. "+ employee assigned for training/in charge. "+ in charge details. "+ modification. "+ trainee data bank.

"+ "� execution of training: - in this option details of training undertaken by employee and their performance is entered. "+ "� "�

" required fields are: "+ training name. "+ training status.

"� "�

"+ performance of the employee. "+ result of the training. "+

"training and planning (recruitment) "+ "recruitment process "

"+

recruitment process is one of the eras of hrms. "+ "recruitment of the employee is not very easy job choosing suitable candidate from the lot of candidate. this selection process is not single step process but consists of multiple processes, which involves different methods of recruitment, maintenance of lot of records. "+ "this recruitment process can be divided in the two groups

"+ " "

internal recruitment "+

external recruitment

"+ "internal recruitment

"+ "internal recruitment basically consider with the recruiting the person internally in an organization this may be giving promotion to the existing employee or recruiting the person by internal reference and this is not very big deal. "+ "external recruitment

"+ " external recruitment is not very easy task. there are different methods of recruiting the person. "+ "

giving advertisement

"+ " "

"+ "+

placement agencies earlier applied "body shoppers

"+ "this recruitment process is not a single step process this may contain several steps like "+ " " " "

"+ "+ "+ "+

precheck initial interview written final interview

"input output forms

"+ "1.job requirement form "+ "2.skill input form "+ "3.job skill requirement "+ "4.advertisement form "+ "5.placement agencies record form "+ "6.body shopper's form "+ "7.short listed candidate "+ "8.candidate performance.

"+ "table structure

"+ "job_requirement "+ "field name "+ "jid "+ "jname "+ "jexperince "+ "jvaccancies "+ "jlocation "+ "jdno "+ "qualification

data type

size

remark

number

3

varchar2

20

number

2

number

4

varchar2

20

number

2

varchar2

20

"+ "skills "+ "field name "+ "sid "+ "sname

data type

size

varchar2

type

5

varchar2

10

"+ "job_skills

"+ "field name "+ "jid "+ "sid "+ "yr_of_exp

"+

data type

size

number varchar2 number

type 3

5 2

primary key

"advertisement

"+ "field name "+ "adid "+ "jid

data type

size

varchar2

5

varchar2

10

type

"+

"candidateperformance "+ "field name "+ "initial_interview "+ "written "+ "final_interview "+ "description "+ " " ;

data type

size

number

3

number number

remark

3 3

varchar2

200

t=new textarea(10,6); t.settext(val); t.setbounds(30,50,700,450); t.setbackground(color.pink); t.setforeground(color.black); font f2=new font("arial",font.italic,12); t.setfont(f2); t.setenabled(true); b1=new jbutton("cancle"); pane.add(b1); b1.setbounds(600,10,100,30); b1.setfont(f2); b1.setbackground(color.blue); b1.setforeground(color.white);

pane.add(t); b1.addactionlistener(this); }

public void actionperformed(actionevent a) { string s3="cancle"; string str=a.getactioncommand(); if(s3.equals(str)) { this.dispose(); } } public static void main(string args[]) { intro f=new intro(); f.setvisible(true); f.setsize(800,600); f.show(); } } /* ////////////////

reference.java ////////////////////// */

import import import import import

java.awt.*; java.awt.event.*; java.applet.*; javax.swing.*; java.util.*;

public class ref extends jframe implements actionlistener { public jpanel pane; public jbutton b1; public textarea t; public ref() { settitle("references prefered"); pane=(jpanel)getcontentpane(); pane.setlayout(null); jlabel j=new jlabel(" references

");

j.setfont(new font("monotype corsiva",font.italic,16)); j.setbounds(300,20,250,50); pane.add(j);

string val=" "+

"

"+

"

"+

"

"+

"

"+

" project title: hrms automation

"+

"references

"+ " 1.

java swing programming published by : rock's publication

" 2.

sql server 7.0

"+

published by : tmh publications

"+ " 3. danesh

"+

java2 complete refference

published by : techmedia

author : arman

" 4. the complete reference of java2 patric naughton, herbert schildt

published by : tata mcgraw hillauthor :

"+ " 5.

html4.0

published by : bpb publications

"+ "for more information mail us at: "+ "[email protected] "+

"web references: "+ "+ "+ "

"http:www.sun.com "http:www.jsptut.com

"; t=new textarea(10,6); t.settext(val); t.setbounds(30,50,700,450); t.setbackground(color.pink); t.setforeground(color.black); font f2=new font("arial",font.italic,12); t.setfont(f2); t.setenabled(true); b1=new jbutton("cancle"); pane.add(b1); b1.setbounds(600,10,100,30); b1.setfont(f2); b1.setbackground(color.blue); b1.setforeground(color.white); pane.add(t); b1.addactionlistener(this); }

public void actionperformed(actionevent a) { string s3="cancle"; string str=a.getactioncommand(); if(s3.equals(str)) { this.dispose(); } } public static void main(string args[]) { ref f=new ref(); f.setvisible(true); f.setsize(800,600); f.show(); } } /* ////////////////

placement.java ////////////////////// */

import import import import

java.awt.*; javax.swing.*; java.sql.*; java.awt.event.*;

public { public public public public public public public

class placement

extends jframe implements actionlistener

jlabel l,l1,l2,l3,l4,l5,l6,l7,l8; jtextfield t1,t2,t4,t5,t6,t7,t8; textarea t3; string ts1,ts2,ts3,ts4,ts5,ts6,ts7,ts8; jbutton b1,b2,b3,b4,b5; jpanel panel; font g;

public placement() { g=new font("",font.bold,18); getcontentpane().setbackground(color.orange); panel=(jpanel)getcontentpane(); panel.setlayout(null); l=new jlabel("placement l1=new jlabel("agencies l2=new jlabel("agencies l3=new jlabel("agencies l4=new jlabel("agencies l5=new jlabel("agencies l6=new jlabel("agencies

agenicies"); id number"); name"); address"); cont_person"); cont_phone"); charge");

l7=new jlabel("agencies e-mail id"); l8=new jlabel("agencies website"); t3=new t4=new t5=new t6=new t7=new t8=new t1=new t2=new

textarea(5,8); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20);

b1=new b2=new b3=new b4=new

jbutton("submit"); jbutton("next"); jbutton("search"); jbutton("clear");

t1.setbounds(200,50,150,30); t2.setbounds(200,100,150,30); t3.setbounds(200,400,150,60); t4.setbounds(200,150,150,30); t5.setbounds(200,200,150,30); t6.setbounds(200,250,150,30); t7.setbounds(200,300,150,30); t8.setbounds(200,350,150,30); panel.add(b1); b1.setbounds(450,400,80,30); panel.add(b2); b2.setbounds(450,450,80,30); panel.add(b3); b3.setbounds(550,400,80,30); panel.add(b4); b4.setbounds(550,450,80,30); panel.add(l); l.setbounds(250,1,300,35); l.setfont(g); panel.add(l1); l1.setbounds(20,50,150,30); panel.add(l2); l2.setbounds(20,100,150,30); panel.add(l3); l3.setbounds(20,400,150,30); l4.setbounds(20,150,150,30); l5.setbounds(20,200,150,30); panel.add(l4); l6.setbounds(20,250,150,30); l7.setbounds(20,300,150,30); panel.add(l5); panel.add(l6); l8.setbounds(20,350,150,30); panel.add(l7); panel.add(l8); panel.add(t1);

panel.add(t2); panel.add(t3); panel.add(t4); panel.add(t5); panel.add(t6); panel.add(t7); panel.add(t8); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); b4.addactionlistener(this); } public void actionperformed(actionevent ae) { string str1=ae.getactioncommand(); if(str1=="next") { tr_reg f=new tr_reg(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); system.out.println(" established.."); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); system.out.println("connection established.. ........"); con.setautocommit(false); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); if(str1=="submit") { ts1=t1.gettext(); ts2=t2.gettext(); ts3=t3.gettext(); ts4=t4.gettext(); ts5=t5.gettext(); int a1=integer.parseint(ts5); ts6=t6.gettext(); int a2=integer.parseint(ts6); ts7=t7.gettext(); ts8=t8.gettext();

system.out.println("query established.."); sm.executeupdate("create table placement(ag_id varchar2(8),ag_name

varchar2(12),ag_add varchar2(15),cont_person varchar(12),cont_no number(12),ag_charge varchar2(7),ag_mail varchar2(20),ag_site varchar2(20))"); system.out.println("table created........"); preparedstatement psm=con.preparestatement("insert into placement_agenci values(?,?,?,?,?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setstring(3,ts3); psm.setstring(4,ts4); psm.setint(5,a1); psm.setint(6,a2); psm.setstring(7,ts7); psm.setstring(8,ts5); int i=psm.executeupdate(); system.out.println("query."); con.commit(); joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t1.settext(""); t2.settext(""); t3.settext(""); t4.settext(""); t5.settext(""); t6.settext(""); t7.settext(""); t8.settext(""); } if(str1=="search") { ts1=t1.gettext(); resultset rs=sm.executequery("select * from placement_agenci where ag_id='"+ts1+"'");

if(rs.next()) { string st1=rs.getstring(1); string st2=rs.getstring(2); string st3=rs.getstring(8); string st4=rs.getstring(3); string st5=rs.getstring(4); string st6=rs.getstring(5); string st7=rs.getstring(6); string st8=rs.getstring(7); t1.settext(st1); t2.settext(st2);

t3.settext(st3); t4.settext(st4); t5.settext(st5); t6.settext(st6); t7.settext(st7); t8.settext(st8);

} else { joptionpane.showmessagedialog(this,"id must be exist,may be id is not available","search is possible",joptionpane.warning_message); } } if(str1=="clear") { t1.settext(""); t2.settext(""); t3.settext(""); t4.settext(""); t5.settext(""); t6.settext(""); t7.settext(""); t8.settext(""); } }

catch(classnotfoundexception e) {

e.printstacktrace(); } catch(sqlexception es){} } public static void main(string args[]) { placement f=new placement(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ////////////////

trainee_registration.java ////////////////////// */

import import import import

java.awt.*; javax.swing.*; java.awt.event.*; java.sql.*;

public class tr_reg extends jframe implements actionlistener,itemlistener { public jlabel l,l1,l2,l3,l4,l5,l6,l7,l8,l9,l10,l11,l12;

public public public public public public public public public public

jtextfield t1,t2,t3,t4,t5,t6,t7,t15; string ts1,ts2,ts3,ts4,ts5,ts6,ts7,ts8,ts9,ts10,ts11,ts12,ts13,ts14,ts15; string s1,s2,s3,s4,s5,s6; jtogglebutton b1,b2,b3; font g; jcombobox ch; checkbox cb1,cb2,cb3,cb4; jpanel panel; jradiobutton r1,r2,r3,r4,r5; buttongroup g1,g2;

public tr_reg() { getcontentpane().setbackground(color.pink); panel=(jpanel)getcontentpane(); panel.setlayout(null); g=new font("",font.bold,18); l=new jlabel("training ragistration form"); l1=new jlabel("name of candidate"); l2=new jlabel("fathers name"); l3=new jlabel("roll number"); l4=new jlabel(" mailing address"); l5=new jlabel("phone number"); l6=new jlabel("permanent address"); l7=new jlabel("proff_qualifications"); l8=new jlabel("hobbies"); l9=new jlabel("gender"); l10=new jlabel("category"); l11=new jlabel("nationality"); l12=new jlabel("candidate_id"); b1=new jtogglebutton("add"); b2=new jtogglebutton("next"); b3=new jtogglebutton("back"); t1=new jtextfield(20); t2=new jtextfield(20); t3=new jtextfield(20); t4=new jtextfield(20); t5=new jtextfield(20); t6=new jtextfield(20); t7=new jtextfield(30); t15=new jtextfield(30); ch=new jcombobox(); panel.add(l); l.setbounds(240,0,380,60); panel.add(l1); l.setfont(g); l1.setbounds(20,40,120,30); panel.add(l2); l2.setbounds(20,100,100,30); panel.add(l3); l3.setbounds(20,160,100,30); panel.add(l4);

l4.setbounds(20,220,100,30); panel.add(l5); l5.setbounds(20,280,100,30); panel.add(l6); l6.setbounds(20,340,100,30); panel.add(l7); l7.setbounds(340,40,150,30); panel.add(l8); l8.setbounds(340,100,100,30); panel.add(l9); l9.setbounds(340,220,100,30); panel.add(l10); l10.setbounds(340,280,100,30); panel.add(l11); l11.setbounds(340,340,100,30); panel.add(l12); l12.setbounds(340,400,100,30); panel.add(t1); t1.setbounds(150,40,100,30); panel.add(t2); t2.setbounds(150,100,100,30); panel.add(t3); t3.setbounds(150,160,100,30); panel.add(t4); t4.setbounds(150,220,100,30); panel.add(t5); t5.setbounds(150,280,100,30); panel.add(t6); t6.setbounds(150,340,100,30); panel.add(t7); t7.setbounds(450,340,100,30); panel.add(t15); t15.setbounds(450,400,100,30); panel.add(b1); b1.setbounds(300,450,80,30); panel.add(b2); b2.setbounds(400,450,80,30); panel.add(b3); b3.setbounds(500,450,80,30); ch.additem("b.tech."); ch.additem("m.tech."); ch.additem("mca"); ch.additem("b.sc.(cs)/m.sc.(cs)"); ch.additem("mba"); panel.add(ch); ch.setbounds(565,40,150,25);

cb1=new cb2=new cb3=new cb4=new

checkbox("painting"); checkbox("music"); checkbox("playing games"); checkbox("solving puzzles");

panel.add(cb1); cb1.setbounds(460,160,100,30); panel.add(cb2); cb2.setbounds(350,160,100,30); panel.add(cb3); cb3.setbounds(350,120,100,30); panel.add(cb4); cb4.setbounds(460,120,100,30); jradiobutton r1=new jradiobutton ("male"); panel.add(r1); r1.setbounds(350,250,45,25); jradiobutton r2=new jradiobutton("female"); panel.add(r2); r2.setbounds(470,250,70,25); g1=new buttongroup(); g1.add(r1); g1.add(r2); jradiobutton r3=new jradiobutton ("gen"); panel.add(r3); r3.setbounds(350,310,70,20); jradiobutton r4=new jradiobutton ("obc"); panel.add(r4); r4.setbounds(470,310,70,20); jradiobutton r5=new jradiobutton ("sc/st"); panel.add(r5); r5.setbounds(590,310,70,20); g2=new buttongroup(); g2.add(r3); g2.add(r4); g2.add(r5); cb1.additemlistener(this); cb2.additemlistener(this); cb3.additemlistener(this); cb4.additemlistener(this); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); r1.addactionlistener(this); r2.addactionlistener(this); r3.addactionlistener(this); r4.addactionlistener(this); r5.addactionlistener(this); } public void itemstatechanged(itemevent a1) { repaint(); }

public void actionperformed(actionevent a) { string str=a.getactioncommand(); if(str=="back") { menu f=new menu(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="next") { masterdetails f=new masterdetails(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="add") { try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); system.out.println(" established.."); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); system.out.println("connection established.. ........"); con.setautocommit(false); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=t1.gettext(); ts2=t2.gettext(); ts3=t3.gettext(); int a1=integer.parseint(ts3); ts4=t4.gettext(); ts5=t5.gettext(); int a2=integer.parseint(ts5); ts6=t6.gettext(); ts7=(string)ch.getselecteditem(); ts8=cb1.getlabel(); ts9=cb2.getlabel(); ts10=cb3.getlabel(); ts11=cb4.getlabel(); string sc=g1.getselection().getactioncommand(); string sc1=g2.getselection().getactioncommand(); ts14=t7.gettext(); ts15=t15.gettext();

system.out.println("query established.."); sm.executeupdate("create table tr_reg(candi_name varchar2(10),fathers_name varchar2(10),roll_no varchar2(10),mailing_add varchar2(12),phone_no number(12),permanent_add varchar2(20),qualifications varchar2(12),hobbie1 varchar2(12),hobbie2 varchar2(12),hobbie3 varchar2(12),hobbie4 varchar2(12),gender varchar2(7),category varchar2(10),nationality varchar2(10),candi_id varchar2(7))"); system.out.println("trinee registration table craeted......."); preparedstatement psm=con.preparestatement("insert into tr_reg values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setint(3,a1); psm.setstring(4,ts4); psm.setint(5,a2); psm.setstring(6,ts6); psm.setstring(7,ts7); psm.setstring(8,ts8); psm.setstring(9,ts9); psm.setstring(10,ts10); psm.setstring(11,ts11); psm.setstring(12,sc); psm.setstring(13,sc1); psm.setstring(14,ts14); psm.setstring(15,ts15); int i=psm.executeupdate(); system.out.println("query."); con.commit(); joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t1.settext(""); t2.settext(""); t3.settext(""); t4.settext(""); t5.settext(""); t6.settext(""); t7.settext(""); }

catch(classnotfoundexception e) {

} }

e.printstacktrace(); } catch(sqlexception es) { es.printstacktrace(); }

public static void main(string args[]) { tr_reg f=new tr_reg(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ////// mastredetails.java(availble training agenda) ///////////// */ import import import import

java.awt.*; javax.swing.*; java.awt.event.*; java.sql.*;

public { public public public public public public public

class masterdetails

extends jframe implements actionlistener

jlabel l,l0,l1,l2,l3,l4,l5,l6,l7,l8,l9; jtextfield t,t0,t1,t2,t3; choice ch1,ch2; string ts1,ts2,ts3,ts4,ts5,ts6,ts7,ts8; font g; list list; jbutton b1,b2,b3;

public jpanel panel; public masterdetails() { getcontentpane().setbackground(color.pink); panel=(jpanel)getcontentpane(); panel.setlayout(null); g=new font("",font.bold,18);

l=new jlabel("available training agenda"); l0=new jlabel("institute name"); l1=new jlabel("training criteria"); l2=new jlabel("number of batches"); l3=new jlabel("number of candidates/batch"); l4=new jlabel("details of candidates in each batch"); l5=new jlabel("duration of training"); l6=new jlabel("cost of training"); l7=new jlabel("training incharge"); l.setfont(g); ch1=new choice(); ch2=new choice();

list list=new list(10,true); t=new jtextfield(20); t0=new jtextfield(20); t1=new jtextfield(20); t2=new jtextfield(20); t3=new jtextfield(20); b1=new jbutton("add"); b2=new jbutton("next"); b3=new jbutton("back"); panel.add(l); l.setbounds(200,5,350,40); panel.add(l0); l0.setbounds(20,50,350,50); panel.add(l1); l1.setbounds(20,100,350,50); panel.add(l2); l2.setbounds(20,150,350,50); panel.add(l3); l3.setbounds(20,200,350,50); panel.add(l4); l4.setbounds(20,250,350,50); panel.add(l5); l5.setbounds(20,300,350,50); panel.add(l6); l6.setbounds(20,350,350,50); panel.add(l7); l7.setbounds(20,400,350,50); list.add("one"); list.add("two"); list.add("three"); list.add("four"); panel.add(list); list.setbounds(420,150,200,50); ch1.additem("b.tech./m.tech."); ch1.additem("bca/mca"); ch1.additem("bba/mba"); panel.add(ch1); ch1.setbounds(420,120,200,50); ch2.additem("60 hours/90 hours"); ch2.additem("45 days"); ch2.additem("6 months"); ch2.additem("12 months"); panel.add(ch2); ch2.setbounds(420,320,200,50); panel.add(t0); t0.setbounds(420,50,120,30); panel.add(t);

t.setbounds(420,260,120,30); t1.setbounds(420,360,120,30); panel.add(t1); t2.setbounds(420,410,120,30); panel.add(t2); t3.setbounds(420,210,120,30); panel.add(t3); panel.add(b1); b1.setbounds(300,450,80,30); panel.add(b2); b2.setbounds(400,450,80,30); panel.add(b3); b3.setbounds(500,450,80,30); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); } public void actionperformed(actionevent a) { string str=a.getactioncommand(); if(str=="back") { tr_reg f=new tr_reg(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="next") { masterdetails01 f=new masterdetails01(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="add") { try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); system.out.println(" established.."); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); system.out.println("connection established.. ........"); con.setautocommit(false); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=t0.gettext(); ts2=ch1.getselecteditem(); ts3=list.getselecteditem();

ts4=t3.gettext(); ts5=t.gettext(); ts6=ch2.getselecteditem(); ts7=t1.gettext(); ts8=t2.gettext(); system.out.println("query established.."); sm.executeupdate("create table mastredetails(insti_name varchar2(20),criteria number(5),total_batches number(2),candi/batch number(2),candi_details/batch varchar2(20),duration varchar2(10),charges number(6),incharge_name varchar2(12))"); system.out.println("query2 established.."); preparedstatement psm=con.preparestatement("insert into masterdetails values(?,?,?,?,?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setstring(3,ts3); psm.setstring(4,ts4); psm.setstring(5,ts5); psm.setstring(6,ts6); psm.setstring(7,ts7); psm.setstring(8,ts5); int i=psm.executeupdate(); system.out.println("query."); con.commit();

joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t0.settext(""); t.settext(""); t1.settext(""); t2.settext(""); t3.settext(""); } {

catch(classnotfoundexception e)

e.printstacktrace(); } catch(sqlexception es){} } } public static void main(string args[]) { masterdetails f=new masterdetails(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ////////

masterdetails01.java(training dpt.info.)

import import import import

java.awt.*; javax.swing.*; java.awt.event.*; java.sql.*;

public { public public public public public public public public

class masterdetails01

///////////// */

extends jframe implements actionlistener

jlabel l,l0,l1,l2,l3,l4,l5,l7,l8,l9,l10; jtextfield t,t0,t1,t2,t3,t4,t5; choice ch1,ch2; font g; string ts1,ts2,ts3,ts4,ts5,ts6,ts7,ts8,ts9,ts10; list list; jbutton b1,b2,b3; jpanel panel;

public masterdetails01() { getcontentpane().setbackground(color.pink); panel=(jpanel)getcontentpane(); panel.setlayout(null); g=new font("",font.bold,18); l=new jlabel("training department information"); l0=new jlabel("department name"); l1=new jlabel("cost of training"); l2=new jlabel("number of departments"); l3=new jlabel("number of employees/batch"); l4=new jlabel("details of employees"); l5=new jlabel("duration of training"); l7=new jlabel("person assigned for training"); l8=new jlabel("name of training program"); l9=new jlabel("department details"); l10=new jlabel("training for which post"); ch1=new choice(); ch2=new choice(); l.setfont(g); list list=new list(10,true); t=new jtextfield(20); t0=new jtextfield(20); t1=new jtextfield(20); t2=new jtextfield(20);

t3=new jtextfield(20); t4=new jtextfield(20); t5=new jtextfield(20); b1=new jbutton("add"); b2=new jbutton("next"); b3=new jbutton("back"); panel.add(l); l.setbounds(250,5,400,40); panel.add(l0); l0.setbounds(20,30,350,50); panel.add(l1); l1.setbounds(20,80,350,50); panel.add(l2); l2.setbounds(20,130,350,50); panel.add(l3); l3.setbounds(20,180,350,50); panel.add(l4); l4.setbounds(20,230,350,50); panel.add(l5); l5.setbounds(20,280,350,50); panel.add(l7); l7.setbounds(20,330,350,50); panel.add(l8); l8.setbounds(20,380,350,50); panel.add(l9); l9.setbounds(20,430,350,50); panel.add(l10); l10.setbounds(20,480,350,50); list.add("one"); list.add("two"); list.add("three"); list.add("four"); panel.add(list); list.setbounds(420,140,200,50); ch1.additem("rs. 10000 upto 20000"); ch1.additem("above 20000 upto 50000"); ch1.additem("above 50000"); panel.add(ch1); ch1.setbounds(420,100,200,50); ch2.additem("60 hours/90 hours"); ch2.additem("45 days"); ch2.additem("6 months"); ch2.additem("12 months"); panel.add(ch2); ch2.setbounds(420,300,200,50); panel.add(t); t.setbounds(420,40,120,30); panel.add(t0); t0.setbounds(420,200,120,30); panel.add(t1); t1.setbounds(420,250,120,30); panel.add(t2); t2.setbounds(420,350,120,30);

panel.add(t3); t3.setbounds(420,400,120,30); panel.add(t4); t4.setbounds(420,450,120,30); panel.add(t5); t5.setbounds(420,500,120,30); panel.add(b1); b1.setbounds(650,400,80,30); panel.add(b2); b2.setbounds(650,450,80,30); panel.add(b3); b3.setbounds(650,500,80,30); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); } public void actionperformed(actionevent a) { string str=a.getactioncommand(); if(str=="back") { masterdetails f=new masterdetails(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="next") { cd_per f=new cd_per(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="add") { try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); system.out.println(" established.."); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); system.out.println("connection established.. ........"); con.setautocommit(false); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=t.gettext(); ts2=ch1.getselecteditem(); ts3=list.getselecteditem();

ts4=t0.gettext(); int a1=integer.parseint(ts4); ts5=t1.gettext(); ts6=ch2.getselecteditem(); ts7=t2.gettext(); ts8=t3.gettext(); ts9=t4.gettext(); ts10=t5.gettext(); system.out.println("query established.."); sm.executeupdate("create table mastredetails01(dpt_name varchar2(20),charges varchar2(6),total_dpts varchar2(10),total_emp/batch varchar2(12),emp_details/batch,duration varchar2(12),incharge_name varchar2(10),taining_name avrchar2(12),dpt_details varchar2(12),train_designation varchar2(12))"); system.out.println("table named masterdatils01 created........."); preparedstatement psm=con.preparestatement("insert into masterdetails01 values(?,?,?,?,?,?,?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setstring(3,ts3); psm.setint(4,a1); psm.setstring(5,ts5); psm.setstring(6,ts6); psm.setstring(7,ts7); psm.setstring(8,ts8); psm.setstring(9,ts9); psm.setstring(10,ts10); int i=psm.executeupdate(); system.out.println("query."); con.commit(); joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t0.settext(""); t.settext(""); t1.settext(""); t2.settext(""); t3.settext(""); t4.settext(""); t5.settext(""); } {

catch(classnotfoundexception e)

e.printstacktrace(); } catch(sqlexception es){} } } public static void main(string args[])

{ masterdetails01 f=new masterdetails01(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ////////

cd_per.java(candiadate performance)

/////////////

import import import import

java.awt.*; javax.swing.*; java.awt.event.*; java.sql.*;

public { public public public public public public

class cd_per extends jframe implements actionlistener jlabel l,l1,l2,l3,l4,l5; jtextfield t4,t1,t2,t3,t5; string ts1,ts2,ts3,ts4,ts5; jpanel panel; font g; jbutton b1,b2,b3,b4;

public cd_per() { g=new font("",font.bold,18); getcontentpane().setbackground(color.pink); panel=(jpanel)getcontentpane(); panel.setlayout(null); l=new jlabel("candidate performnace "); l1=new jlabel("initial_interview"); l2=new jlabel("written"); l3=new jlabel("final_interview"); l4=new jlabel("description"); l5=new jlabel("candidate_id"); b1=new b2=new b3=new b4=new

jbutton("submit"); jbutton("next"); jbutton("search"); jbutton("back");

t1=new t2=new t3=new t4=new t5=new

jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20);

t1.setbounds(200,50,150,30);

*/

t2.setbounds(200,100,150,30); t3.setbounds(200,150,150,30); t4.setbounds(200,200,150,30); t5.setbounds(200,250,150,30); panel.add(b1); b1.setbounds(500,400,80,30); panel.add(b2); b2.setbounds(500,450,80,30); panel.add(b3); b3.setbounds(600,400,80,30); panel.add(b4); b4.setbounds(600,450,80,30); panel.add(l); l.setbounds(250,1,300,35); l.setfont(g); panel.add(l1); l1.setbounds(20,50,150,30); panel.add(l2); l2.setbounds(20,100,150,30); panel.add(l3); l3.setbounds(20,150,150,30); l4.setbounds(20,200,150,30); panel.add(l4); l5.setbounds(20,250,150,30); panel.add(l5); panel.add(t1); panel.add(t2); panel.add(t3); panel.add(t4); panel.add(t5); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); b4.addactionlistener(this); } public void actionperformed(actionevent ae) { string str1=ae.getactioncommand(); if(str1=="next") { shortlist f=new shortlist(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str1=="back") { masterdetails01 f=new masterdetails01(); f.setvisible(true); f.setsize(800,600); f.show();

this.dispose(); } if(str1=="submit") { try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); con.setautocommit(false); system.out.println("connection established.. ........"); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=t1.gettext(); int a1=integer.parseint(ts1); ts2=t2.gettext(); int a2=integer.parseint(ts2); ts3=t3.gettext(); int a3=integer.parseint(ts3); ts4=t4.gettext(); ts5=t5.gettext(); sm.executeupdate("create table performance(ini_interview number(20),written number(20),final_inter number(9),descr varchar2(20))"); system.out.println("query2 established.."); preparedstatement psm=con.preparestatement("insert into can_perfor values(?,?,?,?,?)"); psm.setint(1,a1); psm.setint(2,a2); psm.setint(3,a3); psm.setstring(4,ts4); psm.setstring(5,ts5); int i=psm.executeupdate(); system.out.println("query.........established.."); con.commit(); joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t1.settext(""); t2.settext(""); t3.settext("");

t4.settext(""); t5.settext(""); } catch(classnotfoundexception e) {

e.printstacktrace(); } catch(sqlexception es){} }

} public static void main(string args[]) { cd_per f=new cd_per(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* //////////////////

shortlist.java

///////////// */

import import import import

java.awt.*; javax.swing.*; java.sql.*; java.awt.event.*;

public { public public public public public public public

class shortlist extends jframe implements actionlistener jlabel l,l1,l2,l3,l4,l5,l6,l7; jtextfield t1,t2,t4,t5,t6,t7; string ts1,ts2,ts3,ts4,ts5,ts6,ts7; textarea t3; jbutton b1,b2,b3; jpanel panel; font g;

public shortlist() { g=new font("",font.bold,22); getcontentpane().setbackground(color.pink); panel=(jpanel)getcontentpane(); panel.setlayout(null); l=new jlabel("shortlisted candidates "); l1=new jlabel("candidate's id"); l2=new jlabel("candidate's name"); l3=new jlabel("candidate's address"); l4=new jlabel("candidate's phone"); l5=new jlabel("candidate's resume no."); l6=new jlabel("round of qualified"); l7=new jlabel("candidate's e-mail");

t3=new t4=new t5=new t6=new t7=new t1=new t2=new

textarea(5,8); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20);

b1=new jbutton("submit"); b2=new jbutton("next"); b3=new jbutton("back"); t1.setbounds(200,100,150,30); t2.setbounds(200,150,150,30); t3.setbounds(200,400,150,60); t4.setbounds(200,200,150,30); t5.setbounds(200,250,150,30); t6.setbounds(200,300,150,30); t7.setbounds(200,350,150,30); panel.add(b1); panel.add(b2); panel.add(b3); b1.setbounds(450,200,100,30); b2.setbounds(450,300,100,30); b3.setbounds(450,400,100,30); panel.add(l); l.setbounds(250,10,300,35); l.setfont(g); panel.add(l1); l1.setbounds(20,100,150,30); panel.add(l2); l2.setbounds(20,150,150,30); panel.add(l3); l3.setbounds(20,200,150,30); l4.setbounds(20,250,150,30); l5.setbounds(20,300,150,30); panel.add(l4); l6.setbounds(20,350,150,30); l7.setbounds(20,400,150,30); panel.add(l5); panel.add(l6); panel.add(l7); panel.add(t1); panel.add(t2); panel.add(t3); panel.add(t4); panel.add(t5); panel.add(t6); panel.add(t7); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this);

} public void actionperformed(actionevent ae) { string str1=ae.getactioncommand(); if(str1=="next") { plan f=new plan(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str1=="back") { cd_per f=new cd_per(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str1=="submit") { try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); system.out.println(" established.."); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); system.out.println("connection established.. ........"); con.setautocommit(false); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=t1.gettext(); ts2=t2.gettext(); ts3=t3.gettext(); ts4=t4.gettext(); int a1=integer.parseint(ts4); ts5=t5.gettext(); int a2=integer.parseint(ts5); ts6=t6.gettext(); ts7=t7.gettext(); int a3=integer.parseint(ts6); system.out.println("query established.."); sm.executeupdate("create table shortlist(candi_id varchar2(10) primary key,candi_name varchar2(12),candi_add varchar2(12),candi_phone varchar2(10),resume_no varchar(6),round_no number(2),caindi_mail varchar2(12))"); system.out.println("shortlisted candiadtes info recieved..............");

preparedstatement psm=con.preparestatement("insert into shortlist_cand values(?,?,?,?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setstring(3,ts3); psm.setint(4,a1); psm.setint(5,a2); psm.setint(6,a3); psm.setstring(7,ts7); int i=psm.executeupdate(); system.out.println("query."); con.commit();

joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t1.settext(""); t2.settext(""); t3.settext(""); t4.settext(""); t5.settext(""); t6.settext(""); t7.settext(""); } catch(classnotfoundexception e) {

e.printstacktrace(); } catch(sqlexception es) { } } } public static void main(string args[]) { shortlist f=new shortlist(); f.setvisible(true); f.setsize(800,600); f.show(); } } /* ///////////////

plan.java

/////////////////////// */

import java.awt.*; import javax.swing.*; import java.awt.event.*;

import java.sql.*; import java.util.*; public { public public public public public public public public

class plan extends jframe

implements actionlistener,itemlistener

jlabel l,l1,l2,l3,l4,l5,l6,l7,l8,l9; jtextfield t1,t2,t4,t5,t6,t7,t8,t9; jbutton b1,b2,b3; string ts1,ts2,ts3,ts4,ts5,ts6,ts7,ts8,ts9; string st1,st2,st3,st4,st5,st6,st7,st8,st9; jpanel panel; font g; jcombobox c;

public plan() { g=new font("",font.bold,18); getcontentpane().setbackground(color.orange); panel=(jpanel)getcontentpane(); panel.setlayout(null); l=new jlabel("plan for job training"); l1=new jlabel(" training name"); l2=new jlabel("objective for training"); l3=new jlabel("duration of training"); l4=new jlabel(" required employees"); l5=new jlabel(" employee's id"); l6=new jlabel("criteria for training"); l7=new jlabel("incharge"); l8=new jlabel("incharge details"); l9=new jlabel("modification"); t4=new t5=new t6=new t7=new t8=new t1=new t2=new t9=new

jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20);

c=new jcombobox(); b1=new jbutton("submit"); b2=new jbutton("next"); b3=new jbutton("back"); c.additem("one c.additem("two c.additem("six c.additem("one

month"); month"); month"); year");

t1.setbounds(200,50,150,30); t2.setbounds(200,100,150,30); t4.setbounds(200,200,150,30); t5.setbounds(200,250,150,30); t6.setbounds(200,300,150,30);

t7.setbounds(200,350,150,30); t8.setbounds(200,400,150,30); t9.setbounds(200,450,150,30); c.setbounds(200,150,150,30); panel.add(b1); b1.setbounds(500,400,80,30); panel.add(b2); b2.setbounds(500,450,80,30); panel.add(b3); b3.setbounds(600,400,80,30); panel.add(l); l.setbounds(250,1,300,35); l.setfont(g); panel.add(l1); l1.setbounds(20,50,150,30); panel.add(l2); l2.setbounds(20,100,150,30); panel.add(l3); l3.setbounds(20,150,150,30); l4.setbounds(20,200,150,30); l5.setbounds(20,250,150,30); panel.add(l4); l6.setbounds(20,300,150,30); l7.setbounds(20,350,150,30); panel.add(l5); panel.add(l6); l8.setbounds(20,400,150,30); l9.setbounds(20,450,150,30); panel.add(l7); panel.add(l8); panel.add(l9); panel.add(t1); panel.add(t2); panel.add(t4); panel.add(t5); panel.add(t6); panel.add(t7); panel.add(t8); panel.add(t9); panel.add(c); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); c.additemlistener(this); } public void itemstatechanged(itemevent ie) { } public void actionperformed(actionevent ae)

{ string str=ae.getactioncommand();

if(str=="back") { shortlist f=new shortlist(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="next") { job_req f=new job_req(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str=="submit") { try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); con.setautocommit(false); system.out.println("connection established.. ........"); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=t1.gettext(); ts2=t2.gettext(); ts3=(string)c.getselecteditem(); ts4=t4.gettext(); ts5=t5.gettext(); ts6=t6.gettext(); ts7=t7.gettext(); ts8=t8.gettext(); ts9=t9.gettext(); system.out.println("query2 established.."); sm.executeupdate("create table plan(train_name varchar2(12),tain_objective varchar2(20),duration varchar2(10),emp_required number(3),emp_id varchar2(12),train_criteria varchar2(10),train_incharge varchar2(6),incharge_details varchar2(30),modification varchar2(10))"); system.out.println("plan for job_training established..");

preparedstatement psm=con.preparestatement("insert into plane values(?,?,?,?,?,?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setstring(3,ts3); psm.setstring(4,ts4); psm.setstring(5,ts5); psm.setstring(6,ts6); psm.setstring(7,ts7); psm.setstring(8,ts8); psm.setstring(9,ts9); int i=psm.executeupdate();

con.commit(); joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message);

t1.settext(""); t2.settext(""); /* t3.settext(""); */// as the choice has been encountered// t4.settext(""); t5.settext(""); t6.settext(""); t7.settext(""); t8.settext(""); t9.settext(""); } {

catch(classnotfoundexception e)

e.printstacktrace(); } catch(sqlexception es){} } } public static void main(string args[]) { plan f=new plan(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ///////////////////

job_req.java

////////////////////////// */

import import import import public { public public public public public public

java.awt.*; javax.swing.*; java.awt.event.*; java.sql.*; class job_req extends jframe implements actionlistener jlabel l,l1,l2,l3,l4,l5,l6,l7; jtextfield t1,t2,t3,t4,t5,t6,t7; string ts1,ts2,ts3,ts4,ts5,ts6,ts7; jpanel panel; font g; jbutton b1,b2,b3;

public job_req() { g=new font("",font.bold,18); getcontentpane().setbackground(color.pink); panel=(jpanel)getcontentpane(); panel.setlayout(null); l=new jlabel("requirements for job training"); l1=new jlabel("job id"); l2=new jlabel("job name"); l3=new jlabel("job experience"); l4=new jlabel("job vacancies"); l5=new jlabel("job location"); l6=new jlabel("job dpt. no."); l7=new jlabel("qualification"); b1=new jbutton("submit"); b2=new jbutton("next"); b3=new jbutton("cancel"); t1=new t2=new t3=new t4=new t5=new t6=new t7=new

jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20); jtextfield(20);

t1.setbounds(200,50,150,30); t2.setbounds(200,100,150,30); t3.setbounds(200,150,150,30); t4.setbounds(200,200,150,30); t5.setbounds(200,250,150,30); t6.setbounds(200,300,150,30); t7.setbounds(200,350,150,30); panel.add(b1); b1.setbounds(500,400,80,30); panel.add(b2); b2.setbounds(500,450,80,30); panel.add(b3); b3.setbounds(500,350,80,30);

panel.add(l); l.setbounds(250,1,300,35); l.setfont(g); panel.add(l1); l1.setbounds(20,50,150,30); panel.add(l2); l2.setbounds(20,100,150,30); panel.add(l3); l3.setbounds(20,150,150,30); l4.setbounds(20,200,150,30); panel.add(l4); l5.setbounds(20,250,150,30); panel.add(l5); l6.setbounds(20,300,150,30); panel.add(l6); l7.setbounds(20,350,150,30); panel.add(l7); panel.add(t1); panel.add(t2); panel.add(t3); panel.add(t4); panel.add(t5); panel.add(t6); panel.add(t7); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this); } public void actionperformed(actionevent ae) { string str1=ae.getactioncommand(); if(str1=="cancel") { this.dispose(); } if(str1=="next") { train_exe f=new train_exe(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(str1=="submit") { try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); system.out.println(" established..");

connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); system.out.println("connection established.. ........"); con.setautocommit(false); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=t1.gettext(); ts2=t2.gettext(); ts3=t3.gettext(); ts4=t4.gettext(); ts5=t5.gettext(); ts6=t6.gettext(); ts7=t7.gettext(); system.out.println("query established.."); sm.executeupdate("create table job_req(job_id varchar2(10),job_desig varchar2(12),job_exp varchar2(10),total_vacancies varchar(12),job_location varchar2(12),job_dpt_no varchar2(9),qualification varchar2(10))"); system.out.println("requariments of candiadtes for job is recieved:as.................."); preparedstatement psm=con.preparestatement("insert into job_req values(?,?,?,?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setstring(3,ts3); psm.setstring(4,ts4); psm.setstring(5,ts5); psm.setstring(6,ts6); psm.setstring(7,ts7); int i=psm.executeupdate(); system.out.println("query."); con.commit(); joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t1.settext(""); t2.settext(""); t3.settext(""); t4.settext(""); t5.settext(""); t6.settext(""); t7.settext(""); } catch(exception e) {

e.printstacktrace(); }

} } public static void main(string args[]) { job_req f=new job_req(); f.setvisible(true); f.setsize(800,600); f.show(); } } /* ///////////////////

train_exe.java

////////////////////////// */

import import import import

java.awt.*; javax.swing.*; java.awt.event.*; java.sql.*;

public { public public public public public public public public

class train_exe

extends jframe implements actionlistener

jlabel l,l1,l2,l3,l4,l5; choice ch1,ch2; jradiobutton b1,b2; string ts1,ts2,ts3,ts4; textarea t; font g; jbutton b3,b4; jpanel panel;

public train_exe() { getcontentpane().setbackground(color.pink); panel=(jpanel)getcontentpane(); panel.setlayout(null); g=new font("",font.bold,18); l=new jlabel("job training result"); l1=new jlabel("training name"); l2=new jlabel("training status"); l3=new jlabel("performance of employee"); l4=new jlabel("result of training"); ch1=new choice(); ch2=new choice(); jradiobutton b1=new jradiobutton("on campus",true); jradiobutton b2=new jradiobutton("off campus",false); b3=new jbutton("add"); b4=new jbutton("cancle");

t=new textarea(4,4); panel.add(l); l.setbounds(200,5,350,50); l.setfont(g); panel.add(l1); l1.setbounds(20,50,150,50); panel.add(l2); l2.setbounds(20,120,200,50); panel.add(l3); l3.setbounds(20,190,250,50); panel.add(l4); l4.setbounds(20,260,350,50); ch1.additem("online project training"); ch1.additem("offline project training"); ch1.additem("vocational training"); ch1.additem("dpt.training/workshop"); panel.add(ch1); ch1.setbounds(200,65,250,50); ch2.additem("avegrage"); ch2.additem("good"); ch2.additem("honourable"); panel.add(ch2); ch2.setbounds(200,280,150,60); panel.add(b1); b1.setbounds(200,120,100,30); panel.add(b2); b2.setbounds(350,120,100,30); panel.add(t); t.setbounds(200,190,250,60); panel.add(b3); b3.setbounds(200,400,100,30); panel.add(b4); b4.setbounds(350,400,100,30); b3.addactionlistener(this); b4.addactionlistener(this); } public void actionperformed(actionevent a) { string str=a.getactioncommand();

if(str=="cancle") { this.dispose(); } if(str=="add") {

try { system.out.println("starting established.."); class.forname("sun.jdbc.odbc.jdbcodbcdriver"); system.out.println(" established.."); connection con=drivermanager.getconnection("jdbc:odbc:mrp","scott","tiger"); system.out.println("connection established.. ........"); con.setautocommit(false); statement sm = con.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable); ts1=ch1.getselecteditem(); ts3=t.gettext(); ts4=ch2.getselecteditem(); system.out.println("query established.."); sm.executeupdate("create table execution(train_name varchar2(10),train_status varchar2(12),train_peformance avrcahr2(10),train_result avrchar2(9))"); system.out.println("the selected candiadtes are:......................"); preparedstatement psm=con.preparestatement("insert into train_exe values(?,?,?,?)"); psm.setstring(1,ts1); psm.setstring(2,ts2); psm.setstring(3,ts3); psm.setstring(4,ts4); con.commit();

joptionpane.showmessagedialog(this,"query executed","record inserted",joptionpane.warning_message); system.out.println("query executed"); t.settext(""); } catch(classnotfoundexception e) { e.printstacktrace(); } catch(sqlexception es){} } repaint(); } public static void main(string args[]) { train_exe f=new train_exe(); f.setvisible(true); f.setsize(800,600); f.show(); }

} /* ///////////////////

help.java

//////////////////////////

*/ import java.awt.*; import java.awt.event.*; import java.applet.*; import javax.swing.*; import java.util.*; public class help extends jframe implements actionlistener { public jpanel pane; public jbutton b1,b2,b3; public textarea t; public help() { settitle("help"); pane=(jpanel)getcontentpane(); pane.setlayout(null); jlabel j=new jlabel(" help file "); j.setfont(new font("monotype corsiva",font.italic,30)); j.setbounds(300,20,250,50); pane.add(j); string val=" "+ "+ "+ "+ "+

" " " " " project title: hrms automation

"+ "introduction:

"+ "the presented project here is made in view overcoming the problems faced by the any export firm regarding maintenance, recording and keeping of data base, employee information, financial transactions, payroll system, training, recruitment etc. i.e. 'general hrms automation'. "+ "this project is an application project i.e. hrms automation system. "+ "application run in a local area network of client where as web site run in wide

area networks i.e. world wide web. application run on user defined window where as website works in a browser.hence this project is an application and not a portal/website. "+ "this project can be widely used in any export firm which contain different departments with various employees having different designations, salary profiles etc. beside these it is very useful for the organizations having number of branches with a head branch connected by a lan system through its other branches. these networks need a special kind of security feature. "+ "objective and scope of the study: "+ "objective of doing this project is to enhance my knowledge in the field of distributed technology using j2ee and oracle 8i. some of the client requirement and objectives of this project is as under: -

"+ "the main objective of study: "+ "* it should "+ "* it should "+ "* it should "+ "* it should "+ "* it should

contain all the information of company. contain all the information of company infrastructure. contain all the information of company employees. contain all the information of orders. contain all the information of item in stock.

"+ "purpose: "+ "computerized hrms automation system is developed to facilitate the general administration system to manage the various "+ "information of the employees and the processes involved in an export firm. so, that organization can access accurate information "+ "quickly and easily as and when required, thereby improving its operational efficiency & effectiveness.

"+ "module description :"+ "hrms automation comprises with the following modules: "+

"1) "2) "3) "4) "5)

manpower planning system. "+ training & planning system. "+ employee information system "+ salary processing system "+ attendance recording system. " ; t=new textarea(val,15,20); t.setbounds(50,70,700,400); t.setbackground(color.pink); t.setforeground(color.gray); font f2=new font("arial",font.italic,12); t.setfont(f2); t.setenabled(true); b1=new jbutton("about the project"); b2=new jbutton("shortcut keys"); b3=new jbutton("cancle"); pane.add(b1); pane.add(b2); pane.add(b3); b1.setbounds(100,500,200,30); b2.setbounds(320,500,200,30); b3.setbounds(530,500,100,30);

b1.setfont(f2); b2.setfont(f2); b3.setfont(f2); b1.setbackground(color.black); b1.setforeground(color.white); b2.setbackground(color.black); b2.setforeground(color.white); b3.setbackground(color.blue); b3.setforeground(color.white);

pane.add(t); b1.addactionlistener(this); b2.addactionlistener(this); b3.addactionlistener(this);

} public void actionperformed(actionevent a) { string s1="about the project"; string s2="shortcut keys"; string s3="cancle"; string str=a.getactioncommand(); if(s1.equals(str)) { help1 f=new help1(); f.setvisible(true); f.setsize(800,600);

f.show(); this.dispose(); } if(s2.equals(str)) { help2 f=new help2(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } if(s3.equals(str)) { this.dispose(); } } public static void main(string args[]) { help f=new help(); f.setvisible(true); f.setsize(800,600); f.show(); } } /* ///////////////////

help1.java

////////////////////////// */

import java.awt.*; import javax.swing.*; import java.awt.event.*; public class help1 extends jframe implements actionlistener { public textarea t; public font g; public jbutton b; public jlabel l1; public jpanel panel; public help1() { g=new font("",font.bold,24); string str="

"+ "main requirements of project:-

"+ "computerized hrms automation system is developed to facilitate the general

administration system to manage the various "+ "information of the employees and the processes involved in an export firm. so, that organization can access accurate information "+ "quickly and easily as and when required, thereby improving its operational efficiency & effectiveness.

"+ "module description :"+ "hrms automation comprises with the following modules: "+ "1) "2) "3) "4) "5)

manpower planning system. "+ training & planning system. "+ employee information system "+ salary processing system "+ attendance recording system. " ;

getcontentpane().setbackground(color.gray); panel=(jpanel)getcontentpane(); panel.setlayout(null); t=new textarea(str,600,500); panel.add(t); t.setbounds(50,50,700,500); l1=new jlabel("about project requriments"); panel.add(l1); l1.setbounds(250,5,400,40); l1.setfont(g); l1.setforeground(color.red); b=new jbutton("back"); panel.add(b); b.setbounds(650,5,100,30); b.setbackground (color. blue); b.setfont(new font("",font.bold,18)); b.setforeground(color.pink); b.addactionlistener(this); } public void actionperformed(actionevent a) { string s1="back"; string str=a.getactioncommand(); if(s1.equals(str)) {

help f=new help(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } } public static void main(string args[]) { help1 f=new help1(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ///////////////////

help2.java

////////////////////////// */

import java.awt.*; import javax.swing.*; import java.awt.event.*; public class help2 extends jframe implements actionlistener { public textarea t; public font g; public jbutton b; public jlabel l1; public jpanel panel; public help2() { g=new font("",font.bold,24); string str="press to "+ "ctrl+c copy. "+ "ctrl+x cut. "+ "ctrl+v paste. "+ "ctrl+z undo. "+ "delete delete. "+ "shift+delete delete selected item permanently without placing the item in the recycle bin. "+ "ctrl while dragging an item copy selected item.

"+ "ctrl+shift while dragging an item create shortcut to selected item. "+ "f2 rename selected item. "+ "ctrl+right arrow move the insertion point to the beginning of the next word. "+ "ctrl+left arrow move the insertion point to the beginning of the previous word. "+ "ctrl+down arrow move the insertion point to the beginning of the next paragraph. "+ "ctrl+up arrow move the insertion point to the beginning of the previous paragraph. "+ "ctrl+shift with any of the arrow keys highlight a block of text. "+ "shift with any of the arrow keys select more than one item in a window or on the desktop, or select text within a document. "+ "ctrl+a select all. "+ "f3 search for a file or folder. "+ "alt+enter view properties for the selected item. "+ "alt+f4 close the active item, or quit the active program. "+ "alt+enter displays the properties of the selected object. "+ "alt+spacebar opens the shortcut menu for the active window. "+ "ctrl+f4 close the active document in programs that allow you to have multiple documents open simultaneously. "+ "alt+tab switch between open items. "+ "alt+esc cycle through items in the order they were opened. "+ "f6 cycle through screen elements in a window or on the desktop. "+ "f4 display the address bar list in my computer or windows explorer. "+ "shift+f10 display the shortcut menu for the selected item. "+ "alt+spacebar display the system menu for the active window. "+ "ctrl+esc display the start menu. "+ "alt+underlined letter in a menu name display the corresponding menu. "+ "underlined letter in a command name on an open menu carry out the corresponding command. "+ "f10 activate the menu bar in the active program. "+ "right arrow open the next menu to the right, or open a submenu. "+ "left arrow open the next menu to the left, or close a submenu.

"+ "f5 refresh the active window. "+ "backspace view the folder one level up in my computer or windows explorer. "+ "esc cancel the current task. "+ " "; getcontentpane().setbackground(color.yellow); panel=(jpanel)getcontentpane(); panel.setlayout(null); t=new textarea(str,600,500); panel.add(t); t.setbounds(50,50,700,500); l1=new jlabel("shortcut keys"); panel.add(l1); l1.setbounds(250,5,400,40); l1.setfont(g); l1.setforeground(color.red); b=new jbutton("back"); panel.add(b); b.setbounds(650,5,100,30); b.setbackground(color.blue); b.setfont(new font("",font.bold,18)); b.setforeground(color.white); b.addactionlistener(this); } public void actionperformed(actionevent a) { string s1="back"; string str=a.getactioncommand(); if(s1.equals(str)) { help f=new help(); f.setvisible(true); f.setsize(800,600); f.show(); this.dispose(); } } public static void main(string args[]) { help2 f=new help2(); f.setvisible(true); f.setsize(800,600); f.show(); } }

/* ////////// all hrms-codes end here

////////////////////