IP Project

ARMY DATABASE

Design:

SOURCE CODE: Import Statements: import java.sql.DriverManager; import com.mysql.jdc.Conn com.mysql.jdc.Connection; ection; import com.mysql.jdc.State com.mysql.jdc.Statement; ment; import java.sql.Res!ltSet;

import java".s#ing.tale.De$a!lt%aleModel; import java".s#ing.&Option'ane;

Code $or (dding )e# Record: String name*salary*do*pension*designation;  

name+j%e"t,ield-.get%e"t/;

  i$name.isEmpty//   &Option'ane.s0o#MessageDialogt0is* 1)ame not Entered1/;  salary+j%e"t,ield2.get%e"t/;   i$salary.isEmpty//   &Option'ane.s0o#MessageDialogt0is* 1Salary not Entered1/;  do+j%e"t,ield3.get%e"t/;   i$do.isEmpty//   &Option'ane.s0o#MessageDialogt0is* 1D.O.4. not Entered1/; pension+j%e"t,ield5.get%e"t/;

  i$pension.isEmpty//   &Option'ane.s0o#MessageDialogt0is* 1'ension not Entered1/; designation+j%e"t,ield6.get%e"t/;   i$name.isEmpty//   &Option'ane.s0o#MessageDialogt0is* 1Designation not Entered1/;

else 7 try 7 Class.$or)ame1java.sql.DriverManager1/; Connection con+Connection/ DriverManager.getConnection 1jdc:mysql:88local0ost:3398Indian(rmy1*1ro ot1*1-2351/;

 Statement stmt+Statement/ con.createStatement/;   Res!ltSet rs+stmt.e"ec!te!ery1SEERE Soldiers)ame+name1/;

int ,o!nd+9;  

#0ilers.ne"t// 7 String name-+rs.getString1)ame1/;

  String salary-+rs.getString1Salary1/; String do-+rs.getString1do1/;   String pension-+rs.getString1pension1/;   String designation-+rs.getString1Designation1/;

i$ name.eq!alsnamet// 7  

,o!nd??;

 

j%e"t,ield2.set%e"t11?Salary/;

 

j%e"t,ield3.set%e"t11?D.O.4./;

 

j%e"t,ield5.set%e"t11?'ension/;

 j%e"t,ield6.set%e"t11?Designation/;  

rea@; A

 

else 7

 

contin!e; A

A  

i$,o!nd++9/

 &Option'ane.s0o#MessageDialogt0is*1Sorry )o s!c0 name in contact list1/; A catc0E"ception e/ 7   &Option'ane.s0o#MessageDialogt0is* e.getMessage//; A A A Code ,or Display: private void  jRadio4!tton-(ction'er$ormedjava.a#t.event .(ctionEvent evt/ 7 De$a!lt%aleModel model+ De$a!lt%aleModel/  

j%ale-.getModel/; try

7  

Class.$or)ame1java.sql.DriverManager1/; Connection con+Connection/

 

DriverManager.getConnection

  1jdc:mysql:88local0ost:3398cse-1* 1root1*1-2351/; Statement stmt+Statement/ con.createStatement/; String %name;  

i$jRadio4!tton-.isSelected//

   

%name+1soldier1; else

 

%name+1OBcial1;

String q!ery+1SE
String name+rs.getString1name1/; String Salary+rs.getString1Salary1/; String D.O.4.+rs.getString1D.O.4.1/;   String 'ension+rs.getString1'ension1/;   String Designation+rs.getString1Designation1/; model.addRo#ne# Oject 7name* Salary* D.O.4.* 'ension* DesignationA/; A A catc0E"ception e/ 7   &Option'ane.s0o#MessageDialogt0is* e.getMessage//; A A

A

private void  jRadio4!tton2(ction'er$ormedjava.a#t.event .(ctionEvent evt/ 7 De$a!lt%aleModel model+ De$a!lt%aleModel/  

j%ale-.getModel/; int ro#s+model.getRo#Co!nt/;

  i$ro#sF9/ 7  

model.removeRo#9/; A

A

$orint i+9; iGro#s;i??/

O!tp!t

BIBLIOGRAPHY 

-/S!mita (rora In$ormatics 'ractices Class -2 %e"t 4oo@ 2/)CER% %e"t 4oo@ 3/Hi@as !pta In$ormatics 'ractices Class -2 %e"t 4oo@

 ACKNOWLEDGEMENT  I wish to express my deep gratitude and sinere than!s to "rinipa#$ Mr%"rasad$ &hree &!anda Centra# &hoo#$ 'ttarha##i$ (anga#ore%I sinere#y appreiate this magnanimity )y ta!ing me into there *o#d *or whih I sha## remain inde)ted to them% I extend my hearty than!s to Mrs % "riya and Mrs%+amya$ I%"% #eturers$ who guided me to the suess*u# omp#etion o* this  pro,et% I ta!e this opportunity to express my deep sense o*

gratitude *or his in-a#ua)#e guidane$ onstant enouragement$ onstruti-e omments$ sympatheti attitude and immense moti-ation$ whih has sustained my e.orts at a## stages o* this pro,et wor!% I an/t *orget to o.er my sinere than!s to my #assmates who he#ped me to arry out this  pro,et wor! suess*u##y 0 *or their -a#ua)#e ad-ie 0 support$ whih I reei-ed *rom them time to time%

DECLA+ATION

I do here)y de#are that this  pro,et wor! has )een origina##y arried under the guidane and super-ision o*  Mrs%"riya and Mrs%+amya $ &hree &!anda Centra# "u)#i &hoo#$ (ang#ore%

I),ORM(%ICS 'R(C%ICES

(RMJ D(%(4(SE