Download - Furniture Report Sh - Copy (2)SUNIL
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
1/146
A
PROJECT REPORT
ON
FURNITURE SHOWROOM SYSTEM
Submitted in Partial Fulfillment of te Re!uirement"
for te a#ard of te de$ree of
%ACHE&OR OF COMPUTER APP&ICATIONS
Submitted %' ( Pro)e*t +uide(Name ( SUNI& ,UMAR Mr- PRAMO. SHARMA
Name ( OJAS ,UMAR .e"i$nation
Uni/er"it' Roll Number( %CA .e0t-1 SRC
23334531
2333467-
.EPARTMENT OF %CA
SHRI RAM CO&&E+E
MU8AFFARNA+AR
%at* 4699:97
1
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
2/146
.EC&ARATION
I SUNI& ,UMAR and OJAS ,UMAR ereb' de*lare tat te 0ro)e*t re0ort title;FURNITURE SHOWROOM SYSTEM< i" an ori$inal #or= *arried out b' me
under te "u0er/i"ion of Mr- PRAMO. SHARMA- I furter de*lare tat ti"
#or= a" not been "ubmitted to an' oter In"titute>Uni/er"it' for te a#ard of te
de$ree of %a*elor of Com0uter A00li*ation"-
Student Name(
SUNI& ,UMAR
Roll No( 2333453
OJAS ,UMAR
Roll No( 2333467
.ate( ?
2
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
3/146
FORWAR.IN+ &ETTER
Ti" i" to *ertif' tat te 0ro)e*t entitled ;FURNITURE SHOWROOM
SYSTEM
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
4/146
AC,NOW&E.+EMENT
We are etremel' $rateful and remain indebted to our $uide for bein$ a "our*e of
in"0iration and for i" *on"tant "u00ort in te .e"i$n1 Im0lementation and
E/aluation of te 0ro)e*t- We are tan=ful to tem for teir *on"tant *on"tru*ti/e
*riti*i"m and in/aluable "u$$e"tion"1 #i* benefited u" a lot #ile de/elo0in$ te
0ro)e*t on ;FURNITURE SHOWROOM SYSTEM
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
5/146
PREFACE
Ti" 0ro)e*t a" been #ritten in "im0le lan$ua$e- In 0re"entin$ ti" 0ro)e*t matter1
#e a/e tried our be"t to ma=e ti" e0o"ition /er' *lear and *on*i"e- E/er'attem0t a" been made to *reate te intere"t of te *on/erted 0eo0le in 0ro)e*t-
Altou$ te 0re"entation a" made in te one"t manner and te entire uman
#ea=ne"" and te' are if te *on"tru*ti/e "u$$e"tion modifi*ation and error
brou$t to our noti*e #ill be i$l' a00re*iated and $rateful a*=no#led$ed-
Ti" do*ument i" a full information do*ument tat "er/e" for SRS do*ument al"o-
Ti" 0ro)e*t *ontain" all ba"i* fa*ilitie" tat *an be 0ro/ide b' a te*ni*al in"titute
mana$ement "'"tem-
We ad =e0t te fo*u"1 #ile de/elo0in$ te 0ro)e*t1 tat it "ould be 0ro)e*t tat
be im0lemented in an' te*ni*al *olle$e #it onl' "li$t modifi*ation"- %e*au"e it
i" an introdu*tor' 0ro)e*t "o it doe" not *ontain all fa*ilitie" tat 0ro/ided b' a
uni/er"it'-
5
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
6/146
IN.ECONTENT
Pa$e No-
C- 9- Introdu*tion G
9-9 S*o0e of te "'"tem G9-4 Pro)e*t .e"*ri0tion
9-4-9 About Ei"tin$ S'"tem
9-4-4 Im0lementation of Pro0o"ed S'"tem 2
9-? Ad/anta$e" of 0ro)e*t 2
C- 4- Pro)e*t Cate$or' Tool" En/ironment 5
4-9 Pro)e*t Cate$or'
54-4 Front end *o/era$e 96
4-? %a*= end *o/era$e 99
4-7 Soft#are and Hard#are re!uirement"
94
C- ?- Pro)e*t de/elo0ment "ta$e" 9?
?-9 Re*o$nition of need" 9?
?-4 Fea"ibilit' "tud'97
?-? S'"tem Anal'"i" .F." E:R .ia$ram1 PERT Cart et*-D 93
?-7 S'"tem Anal'"i" Stru*ture Cart"1 Stru*ture of .ata Table1 et*-D 4?
?-3 S'"tem .e/elo0ment 47
?-G Te"tin$1 Im0lementation Maintenan*e 43
6
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
7/146
C- 7- Pro)e*t Form" .etail"D ?6
C- 3- Con*lu"ion G2
C- G- Future Enan*ement 6C- %iblio$ra0' 7
7
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
8/146
CHAPTER:9CHAPTER:9
INTRO.UCTIONINTRO.UCTION
8
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
9/146
9-9 INTRO.UCTION>O%JECTIKES OF THE PROJECT
One mu"t =no# #at te 0roblem i" before it *an be "ol/ed a" ne*e""ar' i" te
moter of in/ention of *our"e1 if #e dont =no# #ere to $o1 #e #ill not =no#
#en #e #ill a/e rea*ed tere- Te ba"i" for a *andidate "'"tem i" re*o$nition of
a need for im0ro/in$ an information "'"tem or a 0ro*edure- Ti" need lead" to a
0reliminar' "ur/e' or an initial in/e"ti$ation- It entail" loo=in$ into te
du0li*ation of effort"1 ineffi*ient ei"tin$ 0ro*edure" et*-
Te main 0roblem in te In/entor' Control S'"tem of furniture i" to andle te
dail' tran"a*tion- Tere are t#o ba"i* 0ro*e""e" tat are 0ur*a"in$ of ra# item"
and "ellin$ of item" to *u"tomer"- In addition to te"e t#o 0ro*e""e"1 re*ord" a/e
to be maintained about em0lo'ee1 "taff member"1 a""et"1 dail' e0en"e"- In manual
0ro*e"" *on"ume lot" of time to *om0lete te 0ur*a"in$ and "ellin$ 0ro*e""- Te
"olution of ti" i" to automate te 0ro*e""e" of 0ur*a"in$ and "ellin$-
9-9 SCOPE OF THE PROJECT (:
Ti" 0ro)e*t 0rimaril' a*ie/e" te follo#in$ ob)e*ti/e" on:line(:
9- To el0 te *om0an' "taff in #or=in$ ea"il' and effi*ientl'-
4- To el0 te *om0an' "taff in 0ro/idin$ better "er/i*e to te "tudent and
"taff member" in a Rea"onable time i-e- to 0ro*e"" teir re!ue"t" !ui*=l' #itout
#a"tin$ time in Formin$ lon$ !ueue" b' "tudent" to $et teir )ob doneS-
?- To redu*e te load of #or= on te *om0an' "taff b' 0ro/idin$ automati*
$eneration of te re0ort" et*-
7- To el0 te *om0an' "taff in $eneratin$ re0ort" about "tudent" and "taff a"
#ell-
9
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
10/146
3- To el0 te *om0an' "taff in redu*in$ error" tat i" en*ountered fre!uentl'
durin$ manual o0eration"-
G- To 0ro/ide "e*urit' a" onl' an autoried u"er *an intera*t #it te "'"tem-
9-4 Pro)e*t .e"*ri0tion(:
A JAKA NET%EANS 0ro$rammin$ en/ironment Te Furniture So#room i"
de"i$ned de/elo0ed for "ellin$ te furniture in te "o#room alon$ #it te
*u"tomer and #or=er" detail"- Te "ellin$ furniture 0rodu*t - Wen te *u"tomer
#ant" to 0ur*a"e te de"ired 0rodu*t on te a/ailabilit' ba"i" to te 0rodu*t-
9-4-9 About Ei"tin$ S'"tem(:
In te ei"tin$ "'"tem1 te tran"a*tion are done onl' manuall' but
in 0ro0o"ed "'"tem- We a/e to *om0uteried all te ban=in$ tran"a*tion u"in$
te "oft#are finan*ial mana$ement "'"tem-
Problem" #it ei"tin$ "'"tem (:
&a*= of te "e*ure-
More man 0o#er-
Time *on"umin$-
Manuall' #ole #or=in$
.ama$e of ma*ine due to la*= of attention-
9-4-4 Im0lementation of Pro0o"ed S'"tem(:
Te aim of 0ro0o"ed "'"tem i" de/elo0 a "'"tem of im0ro/ed
fa*ilitie"- Te 0ro0o"ed "'"tem *an o/er*ome all te limitation of te ei"tin$
"'"tem -te "'"tem 0ro/ide 0a0er "e*urit' and redu*e te manual #or= in te
10
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
11/146
librar'-
Ad/anta$e" of 0ro0o"ed "'"tem(:
"e*urit' of data-
En"ure data a**ura*'"-
Pro0er *ontrol of i$er offi*ial "-
Redu*e te dama$e" of ma*ine-
Minimum data entr' manuall'-
Minimum time re!uired-
U"er friendl' and intera*ti/e-
11
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
12/146
CHAPTER:4
PROJECT CATE+ERY
AN.
SOFTWARE TOO&S
4-9 Pro)e*t Cate$or'(:
Com0an' or an' in"titution1 te "e/eral em0lo'ee" a/e to maintain a
number of re*ord" in /ariou" 0art of te or$aniation- In a mar=et1 tere i" a need
to maintain re*ord Toda' *om0uter a" be*ome te ba*=bone of nearl' e/er'
o**u0ation- In e/er' indu"tr' about em0lo'ee"1 edible"1 a""et" man' more-
To do ti" #or= manuall' re!uire" a lot of man0o#er and *on"ume" too mu*
time- Moreo/er one i" ne/er "ure about te effi*ien*' a**ura*' of #or= bein$
12
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
13/146
done and re*ord" bein$ maintained- A bad 0art of ti" "t'le of #or=in$ i" tat1 if a
0er"on *on*erned for a 0arti*ular )ob1 "a' maintainin$ "tudent re*ord1 i" on lea/e1
"ome of te 0ro*e"" $et" "tand"till1 #i* de0end" on te re*ord" =e0t b' tat
em0lo'ee- Tat i"1 #ere automation *ome" in to el0 and allo#" "im0le1 "moot
and mo"t effi*ient1 "e*ure and ea"' to andle fun*tionalit'-
Ti" "'"tem #ill redu*e te #or=load of te #or=er and time of 0ro*e""in$ of data
from one unit to anoter- It al"o #ill el0 te "taff in te dail' tran"a*tion li=e
0rodu*t 0ur*a"in$ and "ellin$ to maintain 0rodu*t re*ord1 information to redu*e
te man0o#er- It al"o 0ro/ide" te fa*ilit' to 0re/ent te unautoried data a**e""
of oter 0er"on" b' *ate$oried te u"er a" normal u"er and admini"trator- Onl'
admini"trator *an delete e/en modif' te re*ord"-
Ti" "'"tem #ill 0ro/e to be ma"ter =e' to mana$e of re*ord"- No# da'" all te
or$aniation" are *on/ertin$ from manual to *om0uteried tran"a*tion"- Ti"
0ro/ide" better "er/i*e" to te em0lo'ee" #it le"" effort tu" in*rea"in$ te
demand of ti" t'0e of "'"tem da' b' da'-
Ti" a" brou$t about mar/elou" *an$e" in te life of uman bein$ and a"
made our life ea"' *omfortable- It a" re/olutionied te #ole era-
Ti" 0ro)e*t ;FURNITURE SHOWROOM < #ill el0 te #or=er 0rodu*t atteir *ommand in e/er' "0ere of teir a*ti/itie" re$ardin$ 0ur*a"in$ and "ellin$
0rodu*t-
4-4 Front End *o/era$e(
FRONT EN.
JAKA NEAT%EANS a" been de/elo0ed b' Mi*roS'"tem- - JAKA NEAT%EANS Lte en/ironment:0ro/ide" inte$ration #it a /ariet' of oter tool"1 in*ludin$
"our*e *ode mana$ement 1*om0onent reu"e tool" and data mani0ulation-
Neat%ean" trul' i" mu* more of a ;0ro$rammin$ en/ironment< tan )u"t a
lan$ua$e- u"in$ ti" en/ironment 1a "in$le de/elo0er *an !ui*=l' *reate a "im0le
a00li*ation a team of de/elo0er" *an *reate a "o "o0i"ti*ated1 di"tributed
13
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
14/146
a00li*ation-
Feature" in JAKA NEAT%EANS G-3
.ata a**e""
Internet feature"
Control"
Com0onent *reation
&an$ua$e
Wiard"
JAKA Neat%ean" a" e/ol/ed to be mu* more tan a lan$ua$e:it i" an a00li*ation
0rodu*in$ ;ma*ine
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
15/146
BACK END
A databa"e i" a *olle*tion of information tat" related to a 0arti*ular "ub)e*t or
0ur0o"e1 "u* a" tra*=in$ *u"tomer order" or maintainin$ a mu"i* *olle*tion -If
'our databa"e i"nt "tored on a *om0uter1 or onl' 0art" of it are 1 'ou ma' be
tra*=in$ information from a /ariet' of "our*e" tat 'ou a/e a/in$ to *oordinate
and or$anie 'our"elf-
For eam0le1 "u00o"e te 0one number" of 'our "u00lier" are "tored in /ariou"
lo*ation"( in a *ard file *ontainin$ "u00lier 0one number"1 in 0rodu*t
information file *abinet1 and in a "0read"eet *ontainin$ order information -if a
"u00lier" 0one number *an$e"1 'ou mi$t a/e to u0date tat information in
all tree 0la*e" in databa"e1 o#e/er1 'ou onl' a/e to u0date tat information in
one 0la*e: te "u00lier" 0one number i" automati*all' u0dated #ere/er 'ou u"e
it in databa"e-
U"in$ Mi*ro"oft A**e""1 'ou *an mana$e all 'our information from a "in$le
databa"e file- #itin te file1 'ou *an u"e(
Table" to "tore 'our data-
uerie" to find and retrie/e )u"t te data 'ou #ant
Form" to /ie#1 add and u0date data in table"-
Re0ort" to anal'e or 0rint data in a "0e*ifi* la'out-
.ata a**e"" 0a$e" to /ie#1 u0date1 or anal'e te databa"e" data from te
internet or an intranet-
15
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
16/146
4-7 Sotf#are and Hard#are Re!uirement
FRONT EN. ( NET%EANS G-3
%AC, EN. ( MS ACCESS
P&ATFORM ( WIN.OWS:P >4666>466?->Windo#" 2
PROCESSOR ( PENTIUM ? OR HI+HER PROCESSOR
RAM MEMORY ( 942M%
MONITOR ( K+A MONITOR OR HI+H RESO&UTION MONITER
HAR. .IS, ( 9+% OF FREE SPACE REUIRE.
,EY%OAR. ( 964 ,EYS
MOUSE ( TRUE MOUSE
NET%EANS I.E ( G-3
MICROSOFT ACCESS ( 466
16
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
17/146
CHAPTER:?
PROJECT .EKE&OPMENT
STA+ESES
?-9 Re*o$nition of need"
A "'"tem *an be defined a" ;A "et of arran$ement of element" tat are
or$anied to a**om0li" "ome metod1 0ro*edure or *ontrol b' 0ro*e""in$
information-> 0aram ar$" te *ommand line ar$ument"
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# &o$informD-"etKi"ibletrueD
D
65
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
66/146
S0la"frm
0a*=a$e furniture0ro)e*t
im0ort )a/a-a#t-
0ubli* *la"" S0la"form etend" )a/a-"#in$-JFrame
0ubli* S0la"formD
initCom0onent"D
0ri/ate /oid *ontiA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
di"0o"eD
Mainform frmVne# MainformD
frm-"o#D
0ri/ate /oid *ontiMou"eMo/ed)a/a-a#t-e/ent-Mou"eE/ent e/tD
*onti-"et%a*=$roundColor-redD
0ri/ate /oid )Panel4Mou"eMo/ed)a/a-a#t-e/ent-Mou"eE/ent e/tD
*onti-"et%a*=$roundColor-*'anD
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# S0la"formD-"etKi"ibletrueD
D
66
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
67/146
MAINFORM
0a*=a$e furniture0ro)e*t
0ubli* *la"" Mainform etend" )a/a-"#in$-JFrame
0ubli* *la"" Mainform etend" )a/a-"#in$-JFrame
0ubli* MainformD
initCom0onent"D
0ri/ate /oid add0rodu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Add0rodu*tform obVne# Add0rodu*tformD
ob-"o#D
0ri/ate /oid .elete0rodu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
.elete0rodu*tform ob)Vne# .elete0rodu*tformD
ob)-"o#D
0ri/ate /oid Modif'Produ*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Modif'0rodu*tform modVne# Modif'0rodu*tformD
mod-"o#D
0ri/ate /oid AddCu"tomerA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
67
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
68/146
>> TO.O add 'our andlin$ *ode ere(
Add*u"tomerform ob)Vne# Add*u"tomerformD
ob)-"o#D
0ri/ate /oid .eleteCu"tomerA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid Modif'Cu"tomerA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Modif'*u"tomerform *uVne# Modif'*u"tomerformD
*u-"o#D
0ri/ate /oid Sear*Cu"tomerA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Sear*Cu"tomerform *"Vne# Sear*Cu"tomerformD
*"-"o#D
0ri/ate /oid AddSu00lierA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Add#or=erform #Vne# Add#or=erformD
#-"o#D
68
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
69/146
0ri/ate /oid .eleteSu00lierA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
.elete#or=erform #Vne# .elete#or=erformD
#-"o#D
0ri/ate /oid Modif'Su00lierA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Modif'Wor=erform ""Vne# Modif'Wor=erformD
""-"o#D
0ri/ate /oid Sear*Su00lierA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Sear*#or=erform #oVne# Sear*#or=erformD
#o-"o#D
0ri/ate /oid .eleteSaleProdu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent
e/tD
>> TO.O add 'our andlin$ *ode ere(
.elete"ale0rodu*tform d"0Vne# .elete"ale0rodu*tformD
d"0-"o#D
0ri/ate /oid Modif'SaleProdu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent
e/tD
>> TO.O add 'our andlin$ *ode ere(
Modif'"ale0rodu*ttable m"0Vne# Modif'"ale0rodu*ttableD
69
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
70/146
m"0-"o#D
0ri/ate /oid Sear*SaleProdu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent
e/tD
>> TO.O add 'our andlin$ *ode ere(
Sear*"ale0rodu*tform "0fVne# Sear*"ale0rodu*tformD
"0f-"o#D
0ri/ate /oid li"tof0rodu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
&i"tof0rodu*tform lo0Vne# &i"tof0rodu*tformD
lo0-"o#D
0ri/ate /oid &i"tof*u"tomerA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
&i"tof*u"tomerform lofVne# &i"tof*u"tomerformD
lof-"o#D
0ri/ate /oid &i"tof"u00lierA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
&i"tOfWor=erform lofVne# &i"tOfWor=erformD
lof-"o#D
0ri/ate /oid &i"tof"aleA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
&i"tof"aleform l"fVne# &i"tof"aleformD
70
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
71/146
l"f-"o#D
0ri/ate /oid *an$e0a""#ordA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid Sto*=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid )MenuItem9A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
S'"tem-eit6D
0ri/ate /oid )MenuItem4A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Can$ePa""#ordform *0fVne# Can$ePa""#ordformD
*0f-"o#D
0ri/ate /oid )MenuItem49A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Sto*=0rodu*t "0Vne# Sto*=0rodu*tD
"0-"o#D
71
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
72/146
0ri/ate /oid Sear*0rodu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Sear*Produ*tform obVne# Sear*Produ*tformD
ob-"o#D
0ri/ate /oid )MenuItem?A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
.elete*u"tomerform d*Vne# .elete*u"tomerformD
d*-"o#D
0ri/ate /oid )MenuItem7A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Sale0rodu*tform4 "0Vne# Sale0rodu*tform4D
"0-"o#D
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# MainformD-"etKi"ibletrueD
D
72
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
73/146
A.. WOR,ER FORM
0a*=a$e furniture0ro)e*t
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
im0ort )a/a-"#in$-
im0ort )a/a-"#in$-table-
0ubli* *la"" Add#or=erform etend" )a/a-"#in$-JFrame
> Create" ne# form Add#or=erform >
0ubli* Add#or=erformD
initCom0onent"D
0ri/ate /oid *ann*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
ti"-ideD
0ri/ate /oid "a/eA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere( int *u"tid
int #or=erid
Strin$ #or=ername1#addre""1#or=erdate1#or=er0one
#or=eridVInte$er-0ar"eInt#id-$etTetDD
#or=ernameV#name-$etTetD
#addre""Vaddre""-$etTetD
#or=er0oneV#0one-$etTetD
#or=erdateV#date-$etTetD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
73
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
74/146
Strin$ !uer'Vin"ert into Wor=ertable
/alue"X#or=eridX1X#or=ernameX1X#addre""X1X#or=erdateX1X#
or=er0oneXD
"tmt-ee*uteU0date!uer'D
*at*E*e0tion eD
>>to add re*ord into li"t of #or=er tabel(
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Strin$ !uer'Vin"ert into &i"tOfWor=er
/alue"X#or=eridX1X#or=ernameX1X#addre""X1X#or=erdateX1X#
or=er0oneXD
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' "a/edD
*at*E*e0tion eD
0ri/ate /oid addre""A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid NetA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
#id-"etTetD
#name-"etTetD
addre""-"etTetD
#date-"etTetD
74
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
75/146
#0one-"etTetD
int 0V6
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from #or=ertableD
#ilere"-netDD
0VInte$er-0ar"eIntre"-$etStrin$#or=erI.DD
#id-"etTetStrin$-/alueOf0X9DD
#name-re!ue"tFo*u"D
#id-enablefal"eD
*at*E*e0tion eD
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int 0V6
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from #or=ertableD
#ilere"-netDD
0VInte$er-0ar"eIntre"-$etStrin$#or=erI.DD
75
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
76/146
#id-"etTetStrin$-/alueOf0X9DD
#name-re!ue"tFo*u"D
#id-enablefal"eD
*at*E*e0tion eD
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Add#or=erformD-"etKi"ibletrueD
D}
76
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
77/146
.E&ETE WOR,ER FORM
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
0ubli* *la"" .elete#or=erform etend" )a/a-"#in$-JFrame
Statement "tmt
Strin$ *id
> Create" ne# form .elete#or=erform >
0ubli* .elete#or=erformD
initCom0onent"D
0ri/ate /oid o=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*idVtt#id-$etTetD
Strin$ !uer'
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
!uer'V"ele*t from Wor=ertable #ere #or=eridVX*idX
Re"ultSet re"V"tmt-ee*uteuer'!uer'D
ifre"-netDD
#name-"etTetre"-$etStrin$#or=ernameDD
addre""-"etTetre"-$etStrin$addre""DD
d)-"etTetre"-$etStrin$do)DD
0n-"etTetre"-$etStrin$0onenoDD
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 Not foundD
77
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
78/146
*at*E*e0tion eD
0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid .eleteA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int *oi*e
Strin$ !uer'
*oi*eVJO0tionPane-"o#Confirm.ialo$null1 Are 'ou "ure to deleteD
if*oi*eVVJO0tionPane-YESOPTIOND
tr'
!uer'Vdelete from #or=ertable #ere #or=eridVX*idX
tt#id-"etTetD
#name-"etTetD
addre""-"etTetD
0n-"etTetD
d)-"etTetD
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' deletedD
78
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
79/146
*at*E*e0tion eD
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# .elete#or=erformD-"etKi"ibletrueD
D
79
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
80/146
MO.IFY WOR,ER FORM
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
0ubli* *la"" Modif'Wor=erform etend" )a/a-"#in$-JFrame
int *id
Statement "tmt
> Create" ne# form Modif'Wor=er >
0ubli* Modif'Wor=erformD
initCom0onent"D
0ri/ate /oid 0one,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[V6 *\V5]]*VV,e'E/ent-K,ENTER ]]
*VV,e'E/ent-K,%AC,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 in/alid 0one noD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
Strin$ "V0one-$etTetD
if"-len$tDZV96D
JO0tionPane-"o#Me""a$e.ialo$null1 0one no $reater tan or le""
tan96D
e/t-*on"umeD
80
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
81/146
0ri/ate /oid addre"",e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere( *ar *
*ar *
*Ve/t-$et,e'CarD
if*VV,e'E/ent-K,ENTERD
0one-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid #nameA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid #name,e'Pre""ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[VA *\V8]]*[Va *\V]]*VV,e'E/ent-K,ENTER]]
*VV,e'E/ent-K,%AC,SPACE]]*VV,e'E/ent-K,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 In/alid nameD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
addre""-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid u0dateA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
81
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
82/146
>> TO.O add 'our andlin$ *ode ere(
Strin$ name1add1d10
*idVInte$er-0ar"eInt#id-$etTetDD
nameV#name-$etTetD
addVaddre""-$etTetDD
dVdo)-$etTetD
0V0one-$etTetD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Strin$ !uer'Vu0date #or=ertable "et
#or=ernameVXnameX1addre""VXaddre""X1do)VXdo)X10onenoVX0o
neX #ere #or=eridVX*idX
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' u0dateD
#id-"etTetD
#name-"etTetD
ti"-addre""-"etTetD
ti"-do)-"etTetD
ti"-0one-"etTetD
#id-re!ue"tFo*u"D
*at*E*e0tion eD
0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
82
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
83/146
0ri/ate /oid o=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*idVInte$er-0ar"eInt#id-$etTetDD
Strin$ !uer'
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
!uer'V"ele*t from #or=ertable #ere #or=eridVX*idX
Re"ultSet re"V"tmt-ee*uteuer'!uer'D
ifre"-netDD
#name-"etTetre"-$etStrin$#or=ernameDD
addre""-"etTetre"-$etStrin$addre""DD
0one-"etTetre"-$etStrin$do)DD
do)-"etTetre"-$etStrin$0onenoDD
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 Not foundD
*at*E*e0tion eD
SEARCH WOR,ER FORM
83
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
84/146
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-"#in$-table-
0ubli* *la"" Sear*#or=erform etend" )a/a-"#in$-JFrame
> Create" ne# form Sear*#or=erform >
0ubli* Sear*#or=erformD
initCom0onent"D
0ri/ate /oid o09A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
lbl-"etTetEnter te Wor=er I.D
t4-"etTetD
t4-re!ue"tFo*u"D
0ri/ate /oid o04A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
lbl-"etTetEnter te #or=er nameD
t4-"etTetD
t4-re!ue"tFo*u"D
0ri/ate /oid "ear*A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O adde 'our andlin$ *ode ere(
.efaultTableModel mV.efaultTableModelD tb4-$etModelD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
84
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
85/146
Statement "tmtV*on-*reateStatementD
Re"ultSet re"
int ro#
ro#Vm-$etRo#CountD
forint iV6i\ro#iXXD
m-remo/eRo#6D
ifo09-i"Sele*tedDD
int "VInte$er-0ar"eIntt4-$etTetDD
Strin$ !uer'VSele*t from #or=ertable #ere #or=eridVX"X
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netDD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$#or=eridD1re"-$etStrin$#or=ernameD1re"-$etStrin$addre""D
1re"-$etStrin$do)D1re"-$etStrin$0onenoDD
el"e ifo04-i"Sele*tedDD
Strin$ "
"Vt4-$etTetD
Strin$ !uer'VSele*t from #or=ertable #ere #or=ernameVX"X
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netDD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$#or=eridD1re"-$etStrin$#or=ernameD1re"-$etStrin$addre""D
1re"-$etStrin$do)D1re"-$etStrin$0onenoDD
85
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
86/146
*at*E*e0tion eD
0ri/ate /oid EITA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
>> 0aram ar$" te *ommand line ar$ument"
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Sear*#or=erformD-"etKi"ibletrueD
D
A.. CUSTOMER
86
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
87/146
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
0ubli* *la"" Add*u"tomerform etend" )a/a-"#in$-JFrame
> Create" ne# form Add*u"tomer >
0ubli* Add*u"tomerformD
initCom0onent"D
0ri/ate /oid "a/eA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int *u"tid
Strin$ *u"tname1addre""10one
*u"tidVInte$er-0ar"eInttt*u"tid-$etTetDD
*u"tnameVtt*u"tname-$etTetD
addre""Vtt*u"tadd-$etTetD
0oneVtt*u"t0one-$etTetD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Strin$ !uer'Vin"ert into *u"tomertable
/alue"X*u"tidX1X*u"tnameX1Xaddre""X1X0oneXD
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' "a/edD
*at*E*e0tion eD
>>add item into li"t of *u"tomer form
>>::::::::::::::::::::::::::::::::::::
87
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
88/146
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Strin$ !uer'Vin"ert into &i"tof*u"tomer
/alue"X*u"tidX1X*u"tnameX1Xaddre""X1X0oneXD
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' "a/edD
*at*E*e0tion eD
0ri/ate /oid netA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
tt*u"tid-"etTetD
tt*u"tname-"etTetD
tt*u"tadd-"etTetD
tt*u"t0one-"etTetD
int 0V6
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from *u"tomertableD
#ilere"-netDD
0VInte$er-0ar"eIntre"-$etStrin$*u"tidDD
88
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
89/146
tt*u"tid-"etTetStrin$-/alueOf0X9DD
tt*u"tname-re!ue"tFo*u"D
tt*u"tid-enablefal"eD
*at*E*e0tion eD
0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int 0V6
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from *u"tomertableD
#ilere"-netDD
0VInte$er-0ar"eIntre"-$etStrin$*u"tidDD
tt*u"tid-"etTetStrin$-/alueOf0X9DD
tt*u"tname-re!ue"tFo*u"D
tt*u"tid-enablefal"eD
*at*E*e0tion eD
89
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
90/146
0ri/ate /oid tt*u"tname,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[VA *\V8]]*[Va *\V]]*VV,e'E/ent-K,ENTER]]
*VV,e'E/ent-K,%AC,SPACE]]*VV,e'E/ent-K,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 In/alid nameD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
tt*u"tadd-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid tt*u"tadd,e'Pre""ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid tt*u"tadd,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
if*VV,e'E/ent-K,ENTERD
90
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
91/146
tt*u"t0one-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid tt*u"t0one,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[V6 *\V5]]*VV,e'E/ent-K,ENTER ]]
*VV,e'E/ent-K,%AC,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 in/alid 0one noD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
Strin$ "Vtt*u"t0one-$etTetD
if"-len$tDZV96D
JO0tionPane-"o#Me""a$e.ialo$null1 0one no $reater tan or le""
tan96D
e/t-*on"umeD
0ri/ate /oid tt*u"tnameA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid tt*u"t0oneA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
91
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
92/146
>> TO.O add 'our andlin$ *ode ere(
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Add*u"tomerformD-"etKi"ibletrueD
D
.E&ETE CUSTOMER
0a*=a$e furniture0ro)e*t
92
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
93/146
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
0ubli* *la"" .elete*u"tomerform etend" )a/a-"#in$-JFrame
Statement "tmt
int *id
> Create" ne# form .elete*u"tomer >
0ubli* .elete*u"tomerformD
initCom0onent"D
0ri/ate /oid .eleteA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int *oi*e
Strin$ !uer'
*oi*eVJO0tionPane-"o#Confirm.ialo$null1 Are 'ou "ure to deleteD
if*oi*eVVJO0tionPane-YESOPTIOND
tr'
!uer'Vdelete from *u"tomertable #ere *u"tidVX*idX
tt*id-"etTetD
#name-"etTetD
Addre""-"etTetD
Poneno-"etTetD
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' deletedD
93
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
94/146
*at*E*e0tion eD
0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid o=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*idVInte$er-0ar"eInttt*id-$etTetDD
Strin$ !uer'
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
!uer'V"ele*t from *u"tomertable #ere *u"tidVX*idX
Re"ultSet re"V"tmt-ee*uteuer'!uer'D
ifre"-netDD
#name-"etTetre"-$etStrin$nameDD
Addre""-"etTetre"-$etStrin$addre""DD
Poneno-"etTetre"-$etStrin$0onenoDD
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 Not foundD
*at*E*e0tion eD
94
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
95/146
MO.IFY CUSTOMER
0a*=a$e furniture0ro)e*t
95
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
96/146
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
0ubli* *la"" Modif'*u"tomerform etend" )a/a-"#in$-JFrame
int *id
Statement "tmt
> Create" ne# form Modif'*u"tomer >
0ubli* Modif'*u"tomerformD
initCom0onent"D
0ri/ate /oid u0dateA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ name1addre""10one
*idVInte$er-0ar"eInttt*id-$etTetDD
nameVttname-$etTetD
addre""Vttaddre""-$etTetDD
0oneVtt0one-$etTetD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Strin$ !uer'Vu0date *u"tomertable "et
nameVXnameX1addre""VXaddre""X10onenoVX0oneX #ere
*u"tidVX*idX
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' u0dateD
tt*id-"etTetD
ttname-"etTetD
ttaddre""-"etTetD
tt0one-"etTetD
96
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
97/146
tt*id-re!ue"tFo*u"D
*at*E*e0tion eD
0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid o=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*idVInte$er-0ar"eInttt*id-$etTetDD
Strin$ !uer'
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
!uer'V"ele*t from *u"tomertable #ere *u"tidVX*idX
Re"ultSet re"V"tmt-ee*uteuer'!uer'D
ifre"-netDD
ttname-"etTetre"-$etStrin$nameDD
ttaddre""-"etTetre"-$etStrin$addre""DD
tt0one-"etTetre"-$etStrin$0onenoDD
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 Not foundD
*at*E*e0tion eD
97
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
98/146
0ri/ate /oid ttname,e'Pre""ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[VA *\V8]]*[Va *\V]]*VV,e'E/ent-K,ENTER]]
*VV,e'E/ent-K,%AC,SPACE]]*VV,e'E/ent-K,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 In/alid nameD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
ttaddre""-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid tt0one,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[V6 *\V5]]*VV,e'E/ent-K,ENTER ]]
*VV,e'E/ent-K,%AC,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 in/alid 0one noD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
98
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
99/146
Strin$ "Vtt0one-$etTetD
if"-len$tDZV96D
JO0tionPane-"o#Me""a$e.ialo$null1 0one no $reater tan or le""
tan96D
e/t-*on"umeD
0ri/ate /oid ttaddre"",e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere( *ar *
*ar *
*Ve/t-$et,e'CarD
if*VV,e'E/ent-K,ENTERD
tt0one-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid ttnameA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Modif'*u"tomerformD-"etKi"ibletrueD
D
SEARCH CUSTOMER FORM
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
99
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
100/146
im0ort )a/a-"#in$-table-
im0ort )a/a-"!l-
0ubli* *la"" Sear*Cu"tomerform etend" )a/a-"#in$-JFrame
> Create" ne# form Sear*Cu"tomerform >
0ubli* Sear*Cu"tomerformD
initCom0onent"D
0ri/ate /oid o09A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
lbl-"etTetEnter te *u"tomer I.D
t4-"etTetD
t4-re!ue"tFo*u"D
0ri/ate /oid o04A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
lbl-"etTetEnter te *u"tomer nameD
t4-"etTetD
t4-re!ue"tFo*u"D
0ri/ate /oid EITA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
ti"-ideD
0ri/ate /oid "ear*A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O adde 'our andlin$ *ode ere(
.efaultTableModel mV.efaultTableModelD tb9-$etModelD
tr'
100
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
101/146
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
102/146
#ilere"-netDD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$*u"tidD1re"-$etStrin$nameD1re"-$etStrin$addre""D1re"-$etStr
in$0onenoDD
*at*E*e0tion eD
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Sear*Cu"tomerformD-"etKi"ibletrueD
D
A.. SA&E PRO.UCT FORM
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
102
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
103/146
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
im0ort )a/a-tet-
im0ort )a/a-util-
im0ort )a/a-util-.ate
im0ort )a/a-tet-Sim0le.ateFormat
0ubli* *la"" Sale0rodu*tform4 etend" )a/a-"#in$-JFrame
Statement "tmt
> Create" ne# form Sale0rodu*tform4 >
0ubli* Sale0rodu*tform4D
initCom0onent"D
0ri/ate /oid "a/eA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ 0name1#name1*name1"aledate101*1#1*addre""1#0one1*0one
int
0rodu*tid1*u"tid1#or=erid1totalamount1!t'1"aleno1ad/an*e1balan*e1"ale0ri*e
0nameVtt0name-$etTetD
"ale0ri*eVInte$er-0ar"eInttt"ale0ri*e-$etTetDD
!t'VInte$er-0ar"eInttt!t'-$etTetDD
#nameVtt#name-$etTetD
*nameVtt*name-$etTetD
#0oneVtt#0one-$etTetD
*0oneVtt*0one-$etTetD
*addre""Vtt*addre""-$etTetD
totalamountVInte$er-0ar"eInttttm-$etTetDD
ad/an*eVInte$er-0ar"eIntttad/an*e-$etTetDD
balan*eVInte$er-0ar"eIntttbalan*e-$etTetDD
"alenoVInte$er-0ar"eInt"n-$etTetDD
"aledateVtt"aledate-$etTetD
0VStrin$-/alueOf0*ombo-$etSele*tedItemDD
103
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
104/146
0rodu*tidVInte$er-0ar"eInt0D
*VStrin$-/alueOf**ombo-$etSele*tedItemDD
*u"tidVInte$er-0ar"eInt*D
#VStrin$-/alueOf#*ombo-$etSele*tedItemDD
#or=eridVInte$er-0ar"eInt#D
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Strin$ !uer'
!uer'Vin"ert into "ale0rodu*ttable
/alue"X"alenoX1X"aledateX1X0rodu*tidX1X0nameX1X"ale0ri*eX1X
!t'X1X#or=eridX1X#nameX1X#0oneX1X*u"tidX1X*nameX1X*0
oneX1X*addre""X1XtotalamountX1Xad/an*eX1Xbalan*eXD
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""ful "a/edD
#*ombo-remo/eAllItem"D
**ombo-remo/eAllItem"D
0*ombo-remo/eAllItem"D
*at*E*e0tion eD
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from 0rodu*ttableD
104
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
105/146
#ilere"-netDD
0*ombo-addItemre"-$etStrin$0rodu*tidDD
*at*E*e0tion eD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from *u"tomertableD
#ilere"-netDD
**ombo-addItemre"-$etStrin$*u"tidDD
*at*E*e0tion eD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from #or=ertableD
#ilere"-netDD
#*ombo-addItemre"-$etStrin$#or=eridDD
105
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
106/146
*at*E*e0tion eD
0ri/ate /oid 0*omboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ 0id
int 0no1tm1"1!
0idVStrin$-/alueOf0*ombo-$etSele*tedItemDD
0noVInte$er-0ar"eInt0idD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from 0rodu*ttable #ere
0rodu*tidVX0idXD
ifre"-netDD
tt0name-"etTetre"-$etStrin$0nameDD
tt"ale0ri*e-"etTetre"-$etStrin$"ale0ri*eDD
tt!t'-"etTetre"-$etStrin$!uantit'DD
tt0name-"etEditablefal"eD
tt"ale0ri*e-"etEditablefal"eD
"VInte$er-0ar"eInttt"ale0ri*e-$etTetDD
!VInte$er-0ar"eInttt!t'-$etTetDD
tmV"!
tttm-"etTetStrin$-/alueOftmDD
tttm-"etEditablefal"eD
106
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
107/146
*at*E*e0tion e4D
0ri/ate /oid **omboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ *id
int *no
*idVStrin$-/alueOf**ombo-$etSele*tedItemDD
*noVInte$er-0ar"eInt*idD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from *u"tomertable #ere
*u"tidVX*noXD
ifre"-netDD
tt*name-"etTetre"-$etStrin$nameDD
tt*addre""-"etTetre"-$etStrin$addre""DD
tt*0one-"etTetre"-$etStrin$0onenoDD
*at*E*e0tion e4D
107
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
108/146
0ri/ate /oid eitA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
ti"-ideD
0ri/ate /oid #*omboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ #id
int #no
#idVStrin$-/alueOf#*ombo-$etSele*tedItemDD
#noVInte$er-0ar"eInt#idD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from #or=ertable #ere
#or=eridVX#noXD
ifre"-netDD
tt#name-"etTetre"-$etStrin$#or=ernameDD
tt#0one-"etTetre"-$etStrin$0onenoDD
*at*E*e0tion e4D
108
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
109/146
0ri/ate /oid *al*ulationA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int tm1b1ad
tmVInte$er-0ar"eInttttm-$etTetDD
adVInte$er-0ar"eIntttad/an*e-$etTetDD
ifad[tmD
JO0tionPane-"o#Me""a$e.ialo$null1 total amount i" "ortD
return
bVtm:ad
ttbalan*e-"etTetStrin$-/alueOfbDD
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Sale0rodu*tform4D-"etKi"ibletrueD
D
.E&ETE PRO.UCT FORM
0a*=a$e furniture0ro)e*t
109
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
110/146
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
0ubli* *la"" .elete0rodu*tform etend" )a/a-"#in$-JFrame
Strin$ 0id
Statement "tmt
> Create" ne# form .elete0rodu*tform >
0ubli* .elete0rodu*tformD
initCom0onent"D
0ri/ate /oid deleteA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int *oi*e
*oi*eVJO0tionPane-"o#Confirm.ialo$null1 Are 'ou "ure to deleteD
if*oi*eVVJO0tionPane-YESOPTIOND
tr'
Strin$ !uer'
!uer'Vdelete from 0rodu*ttable #ere 0rodu*tidVX0idX
tt0id-"etTetD
tt0name-"etTetD
tt*o"t-"etTetD
tt"ale-"etTetD
tt!t'-"etTetD
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' deletedD
*at*E*e0tion eD
110
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
111/146
0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid o=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0idVtt0id-$etTetD
Strin$ !uer'
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
!uer'V"ele*t from 0rodu*ttable #ere 0rodu*tidVX0idX
Re"ultSet re"V"tmt-ee*uteuer'!uer'D
ifre"-netDD
tt0name-"etTetre"-$etStrin$0nameDD
tt*o"t-"etTetre"-$etStrin$0ri*eDD
tt"ale-"etTetre"-$etStrin$"ale0ri*eDD
tt!t'-"etTetre"-$etStrin$!uantit'DD
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 Not foundD
111
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
112/146
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
113/146
im0ort )a/a-"#in$-
im0ort )a/a-"#in$-table-
im0ort )a/a-"!l-
0ubli* *la"" Sear*Produ*tform etend" )a/a-"#in$-JFrame
> Create" ne# form Sear*Produ*tform >
0ubli* Sear*Produ*tformD
initCom0onent"D
0ri/ate /oid rb9A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
lbl9-"etTetEnter te 0rodu*tid I.D
t?-"etTetD
t?-re!ue"tFo*u"D
0ri/ate /oid rb4A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
lbl9-"etTetEnter te 0rodu*t nameD
t?-"etTetD
t?-re!ue"tFo*u"D
0ri/ate /oid EITA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid "ear*A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
.efaultTableModel mV.efaultTableModelD tbl-$etModelD
113
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
114/146
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"
int ro#
ro#Vm-$etRo#CountD
forint iV6i\ro#iXXD
m-remo/eRo#6D
ifrb9-i"Sele*tedDD
Strin$ "
"Vt?-$etTetD
Strin$ !uer'VSele*t from Produ*ttable #ere 0rodu*tidVX"X
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netDD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$0rodu*tidD1re"-$etStrin$0nameD1re"-$etStrin$0ri*eD1re"-$et
Strin$"ale0ri*eD1re"-$etStrin$!uantit'DD
el"e ifrb4-i"Sele*tedDD
Strin$ "
114
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
115/146
"Vt?-$etTetD
Strin$ !uer'VSele*t from Produ*ttable #ere 0nameVX"X
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netDD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$0rodu*tidD1re"-$etStrin$0nameD1re"-$etStrin$0ri*eD1re"-$et
Strin$"ale0ri*eD1re"-$etStrin$!uantit'DD
*at*E*e0tion eD
0ri/ate /oid t?A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
115
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
116/146
ne# Sear*Produ*tformD-"etKi"ibletrueD
D
MO.IFY PRO.UCT FORM
0a*=a$e furniture0ro)e*t
116
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
117/146
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
0ubli* *la"" Modif'0rodu*tform etend" )a/a-"#in$-JFrame
Strin$ 0id
Statement "tmt
> Create" ne# form Modif'0rodu*tform >
0ubli* Modif'0rodu*tformD
initCom0onent"D
0ri/ate /oid u0dateA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int *o"t1"ale1!t'
Strin$ 0name10id
0idVtt0id-$etTetD
0nameVtt0name-$etTetD
*o"tVInte$er-0ar"eInttt*o"t-$etTetDD
"aleVInte$er-0ar"eInttt"ale-$etTetDD
!t'VInte$er-0ar"eInttt!t'-$etTetDD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Strin$ !uer'Vu0date 0rodu*ttable "et
0nameVX0nameX10ri*eVX*o"tX1"ale0ri*eVX"aleX1!uantit'VX!t'X
#ere 0rodu*tidVX0idX
"tmt-ee*uteU0date!uer'D
117
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
118/146
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' u0dateD
tt0id-"etTetD
tt0name-"etTetD
tt*o"t-"etTetD
tt"ale-"etTetD
tt!t'-"etTetD
tt0id-re!ue"tFo*u"D
*at*E*e0tion eD
0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid o=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0idVtt0id-$etTetD
Strin$ !uer'
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
!uer'V"ele*t from 0rodu*ttable #ere 0rodu*tidVX0idX
Re"ultSet re"V"tmt-ee*uteuer'!uer'D
ifre"-netDD
tt0name-"etTetre"-$etStrin$0nameDD
tt*o"t-"etTetre"-$etStrin$0ri*eDD
118
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
119/146
tt"ale-"etTetre"-$etStrin$"ale0ri*eDD
tt!t'-"etTetre"-$etStrin$!uantit'DD
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 Not foundD
*at*E*e0tion eD
0ri/ate /oid tt0name,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[VA *\V8]]*[Va *\V]]*VV,e'E/ent-K,ENTER]]
*VV,e'E/ent-K,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 In/alid nameD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
tt*o"t-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid tt*o"t,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
119
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
120/146
ifZ*[V6 *\V5]]*VV,e'E/ent-K,ENTER ]]
*VV,e'E/ent-K,%AC,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 in/alid noD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
tt"ale-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid tt*o"tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
0ri/ate /oid tt"ale,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *
*Ve/t-$et,e'CarD
ifZ*[V6 *\V5]]*VV,e'E/ent-K,ENTER ]]
*VV,e'E/ent-K,%AC,SPACEDD
JO0tionPane-"o#Me""a$e.ialo$null1 in/alid noD
e/t-*on"umeD
if*VV,e'E/ent-K,ENTERD
120
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
121/146
tt!t'-re!ue"tFo*u"D
e/t-*on"umeD
0ri/ate /oid tt0nameA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Modif'0rodu*tformD-"etKi"ibletrueD
D
.E&ETE SA&E PRO.UCT FORM
121
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
122/146
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
0ubli* *la"" Modif'"ale0rodu*ttable etend" )a/a-"#in$-JFrame
Statement "tmt
> Create" ne# form Modif'"ale0rodu*ttable >
0ubli* Modif'"ale0rodu*ttableD
initCom0onent"D
0ri/ate /oid modif'A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int "a101"1!1#1* 1t1a1b1"no
Strin$ "al10n1#n1#0o1*n1*01*a1"id
"idVStrin$-/alueOf"ale*ombobo-$etSele*tedItemDD
"noVInte$er-0ar"eInt"idD
"alV"d-$etTetD
0nV0oname-$etTetD
#nV#or=ername-$etTetD
#0oV#0-$etTetD
*nV*u"tname-$etTetD
*0V*u"t0one-$etTetD
*aV*u"taddre""-$etTetD
0VInte$er-0ar"eInt0oid-$etTetDD
"VInte$er-0ar"eInt"0ri*e-$etTetDD
!VInte$er-0ar"eInt!uan-$etTetDD
#VInte$er-0ar"eInt#id-$etTetDD
*VInte$er-0ar"eInt*u"toid-$etTetDD
tVInte$er-0ar"eInttam-$etTetDD
aVInte$er-0ar"eIntad/an-$etTetDD
122
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
123/146
bVInte$er-0ar"eIntbal-$etTetDD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Strin$ !uer'
!uer'Vu0date "ale0rodu*ttable "et
"aledateVX"alX10rodu*tidVX0X10nameVX0nX1"ale0ri*eVX"X1!t'VX!X
1#or=eridVX#X1#nameVX#nX1#0oneVX#0oX1*u"tidVX*X1*nameV
X*nX1*0oneVX*0X1*addre""VX*aX1totalamountVXtX1ad/an*eVXaX
1balan*eVXbX #ere "alenoVX"noX
"tmt-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' u0dateD
"d-"etTetD
0oid-"etTetD
0oname-"etTetD
"0ri*e-"etTetD
!uan-"etTetD
#id-"etTetD
#or=ername-"etTetD
#0-"etTetD
*u"toid-"etTetD
*u"tname-"etTetD
*u"t0one-"etTetD
*u"taddre""-"etTetD
tam-"etTetD
ad/an-"etTetD
bal-"etTetD
*at*E*e0tion eD
123
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
124/146
0ri/ate /oid *ann*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid "ale*omboboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ 0id
int !1"1amt
0idVStrin$-/alueOf"ale*ombobo-$etSele*tedItemDD
"VInte$er-0ar"eInt0idD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *V.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'Sele*t from "ale0rodu*ttable #ere
"alenoVX"XD
ifre"-netDD
"no-"etTetre"-$etStrin$"alenoDD
"d-"etTetre"-$etStrin$"aledateDD
0oid-"etTetre"-$etStrin$0rodu*tidDD
0oname-"etTetre"-$etStrin$0nameDD
"0ri*e-"etTetre"-$etStrin$"ale0ri*eDD
!uan-"etTetre"-$etStrin$!t'DD
#id-"etTetre"-$etStrin$#or=eridDD
124
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
125/146
#or=ername-"etTetre"-$etStrin$#nameDD
#0-"etTetre"-$etStrin$#0oneDD
*u"toid-"etTetre"-$etStrin$*u"tidDD
*u"tname-"etTetre"-$etStrin$*nameDD
*u"t0one-"etTetre"-$etStrin$*0oneDD
*u"taddre""-"etTetre"-$etStrin$*addre""DD
tam-"etTetre"-$etStrin$totalamountDD
ad/an-"etTetre"-$etStrin$ad/an*eDD
bal-"etTetre"-$etStrin$balan*eDD
*at*E*e0tion eD
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
int "V6
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from "ale0rodu*ttableD
#ilere"-netDD
"ale*ombobo-addItemre"-$etStrin$"alenoDD
*at*E*e0tion eD
125
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
126/146
>> Add 0rodut*t I. into 0rodu*t *ombo
>>::::::::::::::::::::::::::::::::::
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from 0rodu*ttableD
#ilere"-netDD
"ale*ombobo-addItemre"-$etStrin$"alenoDD
*at*E*e0tion eD
>> Add Wor=er I. into *ombo #or=er
>>::::::::::::::::::::::::::::::::
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from #or=ertableD
#ilere"-netDD
"ale*ombobo-addItemre"-$etStrin$"alenoDD
*at*E*e0tion eD
>>Add Cu"tomer I. into *u"tomer *ombo
>>:::::::::::::::::::::::::::::::::::
126
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
127/146
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
"tmtV*on-*reateStatementD
Re"ultSet re"V"tmt-ee*uteuer'"ele*t from *u"tomertableD
#ilere"-netDD
"ale*ombobo-addItemre"-$etStrin$"alenoDD
*at*E*e0tion eD
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Modif'"ale0rodu*ttableD-"etKi"ibletrueD
D
STOC, OF PRO.UCT FORM
0a*=a$e furniture0ro)e*t
127
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
128/146
im0ort )a/a-"#in$-
im0ort )a/a-"#in$-table-
im0ort )a/a-"!l-
0ubli* *la"" Sto*=0rodu*t etend" )a/a-"#in$-JFrame
> Create" ne# form Sto*=0rodu*t >
0ubli* Sto*=0rodu*tD
initCom0onent"D
0ri/ate /oid )%utton9A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
ti"-ideD
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
.efaultTableModel mV.efaultTableModelD tbl-$etModelD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"
int ro#
ro#Vm-$etRo#CountD
forint iV6i\ro#iXXD
m-remo/eRo#6D
128
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
129/146
Strin$ !uer'VSele*t from "to*=table
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$0rodu*tidD1re"-$etStrin$0nameD1re"-$etStrin$"ale0ri*eD1re"-
$etStrin$*o"tD1re"-$etStrin$!t'DD
*at*E*e0tion eD
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Sto*=0rodu*tD-"etKi"ibletrueD
D
&IST OF CUSTOMERS
0a*=a$e furniture0ro)e*t
129
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
130/146
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-tet-
im0ort )a/a-"#in$-table-
0ubli* *la"" &i"tof*u"tomerform etend" )a/a-"#in$-JFrame
0ubli* &i"tof*u"tomerformD
initCom0onent"D
0ri/ate /oid )%utton9A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
di"0o"eD
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
.efaultTableModel mV.efaultTableModelD tbl-$etModelD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"
int ro#
ro#Vm-$etRo#CountD
forint iV6i\ro#iXXD
m-remo/eRo#6D
Strin$ !uer'VSele*t from &i"tofCu"tomer
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netDD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$*u"tidD1re"-$etStrin$*nameD1re"-$etStrin$addre""D1re"-$etSt
130
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
131/146
rin$PonenoDD
*at*E*e0tion eD
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# &i"tof*u"tomerformD-"etKi"ibletrueD
D
&IST OF WOR,ER
131
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
132/146
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
im0ort )a/a-"#in$-table-
im0ort )a/a-"!l-
0ubli* *la"" &i"tOfWor=erform etend" )a/a-"#in$-JFrame
> Create" ne# form &i"tOfWor=erform >
0ubli* &i"tOfWor=erformD
initCom0onent"D
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
.efaultTableModel mV.efaultTableModelD t9-$etModelD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"
int ro#
ro#Vm-$etRo#CountD
forint iV6i\ro#iXXD
m-remo/eRo#6D
Strin$ !uer'VSele*t from &i"tofWor=er
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netDD
132
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
133/146
m-addRo#ne# Ob)e*t@B
re"-$etStrin$#idD1re"-$etStrin$#nameD1re"-$etStrin$addre""D1re"-$etStri
n$do)D1re"-$etStrin$PonenoDD
*at*E*e0tion eD
0ri/ate /oid )%utton9A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# &i"tOfWor=erformD-"etKi"ibletrueD
D
&IST OF SA&E FORM
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
133
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
134/146
im0ort )a/a-"!l-
im0ort )a/a-tet-
im0ort )a/a-"#in$-table-
0ubli* *la"" &i"tof"aleform etend" )a/a-"#in$-JFrame
> Create" ne# form &i"tof"aleform >
0ubli* &i"tof"aleformD
initCom0onent"D
0ri/ate /oid )%utton9A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
di"0o"eD
0ri/ate /oid formWindo#A*ti/ated)a/a-a#t-e/ent-Windo#E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
.efaultTableModel mV.efaultTableModelD t4-$etModelD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tmtV*on-*reateStatementD
Re"ultSet re"
int ro#
ro#Vm-$etRo#CountD
forint iV6i\ro#iXXD
m-remo/eRo#6D
134
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
135/146
Strin$ !uer'VSele*t from &i"tof"ale
re"V"tmt-ee*uteuer'!uer'D
#ilere"-netDD
m-addRo#ne# Ob)e*t@B
re"-$etStrin$"alenoD1re"-$etStrin$"aledateD1re"-$etStrin$0rodu*tidD1re"-$
etStrin$0nameD1re"-$etStrin$"ale0ri*eD1re"-$etStrin$!uantit'D1re"-$etStri
n$#idD1re"-$etStrin$#nameD1re"-$etStrin$#0oneD1re"-$etStrin$*u"tid
D1re"-$etStrin$*nameD1re"-$etStrin$*addre""D1re"-$etStrin$*0oneD1re"-$
etStrin$totalamountD1re"-$etStrin$ad/an*eD1re"-$etStrin$balan*eDD
*at*E*e0tion eD
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# &i"tof"aleformD-"etKi"ibletrueD
D
135
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
136/146
CHAN+E PASSWOR. FORM
0a*=a$e furniture0ro)e*t
im0ort )a/a-"#in$-
im0ort )a/a-"!l-
im0ort )a/a-a#t-e/ent-
0ubli* *la"" Can$ePa""#ordform etend" )a/a-"#in$-JFrame
> Create" ne# form Can$ePa""#ordform >
0ubli* Can$ePa""#ordformD
initCom0onent"D
0ri/ate /oid EitA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
ti"-ideD
0ri/ate /oid o=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ 091041!uer'
09Vne#0a""-$etTetD
04V*on0a""-$etTetD
if09-e!ual"04DD
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tateV*on-*reateStatementD
!uer'Vu0date lo$intable "et 0a""#ordVX09X
"tate-ee*uteU0date!uer'D
JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' *an$edD
*at*E*e0tion eD
136
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
137/146
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 No mat*D
0ri/ate /oid /erif'A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
Strin$ u"er91u"er410a""910a""4
tr'
Cla""-forName"un-)db*-odb*-Jdb*Odb*.ri/erD
Conne*tion *onV.ri/erMana$er-$etConne*tion)db*(odb*(furnitureD
Statement "tateV*on-*reateStatementD
Re"ultSet re"V"tate-ee*uteuer'"ele*t from lo$intableD
u"er9Vuname-$etTetD
0a""9Vold0a""-$etTetD
re"-netD
u"er4Vre"-$etStrin$9D
0a""4Vre"-$etStrin$4D
ifu"er9-e!ual"u"er4D 0a""9-e!ual"0a""4DD
JO0tionPane-"o#Me""a$e.ialo$null1 Corre*tD
ne#0a""-"etEditabletrueD
*on0a""-"etEditabletrueD
el"e
JO0tionPane-"o#Me""a$e.ialo$null1 In*orre*tD
*at*E*e0tion eD
0ri/ate /oid old0a""A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
137
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
138/146
0ri/ate /oid *on0a"",e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD
>> TO.O add 'our andlin$ *ode ere(
*ar *Ve/t-$et,e'CarD
if*VV,e'E/ent-K,ENTER]]*VV,e'E/ent-K,%AC,SPACED
o=-"etEnabledtrueD
e/t-*on"umeD
>
0aram ar$" te *ommand line ar$ument"
>
0ubli* "tati* /oid mainStrin$ ar$"@BD
)a/a-a#t-E/entueue-in/o=e&aterne# RunnableD
0ubli* /oid runD
ne# Can$ePa""#ordformD-"etKi"ibletrueD
D
138
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
139/146
CHAPTER:3
CONC&USION
Te 0ro)e*t made me realie te "i$nifi*an*e of de/elo0in$ "oft#are for
*lient1 #ere all te e/entualitie" a/e to be ta=en *are of1 unli=e at edu*ational
in"titution1 #ere te "ole aim i" to learn- Wat ma' be "een to te de/elo0ed to be
a "oft#are *om0lete in all re"0e*t"1 I #a" re!uired to meet te "trin$ent demand"
of te in:ou"e *lient in te material" de0artment- Trou$ ti" "eemed tou$ at
fir"t1 I realied tat 0re""ure $oaded u" on to de/elo0 better and better
a00li*ation"-
.urin$ te 0ro)e*t1 te real im0ortan*e for follo#in$ all te 0rin*i0le of
S'"tem Anal'"i" and .e"i$n dra#led on me- I felt te ne*e""it' of $oin$ trou$
te "e/eral "ta$e"1 be*au"e onl' "u* a 0ro*e"" *ould ma=e one under"tand te
0roblem" at and1 more "o due to te enormou" "ie of data "tore" in/ol/ed and
teir mani0ulation
In retro"0e*t1 I #ould li=e to "a' tat te in"titute 0ro/ided u" #it "am0le
o00ortunitie" to learn Ora*le 2 and it" tool"- I "0e*ifi*all' #a" able to learn MS:
139
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
140/146
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
141/146
We a/e learned to 0re0are te re!uirement *atalo$ue1 fun*tional
"0e*ifi*ation1 de"i$n "0e*ifi*ation1 "'"tem de/elo0ment life *'*le in
0ra*ti*al de/elo0ment and al"o learned "oft#are de/elo0ment #it
tool" a/in$ intera*ti/e feature"-
We a/e al"o under"tood te im0ortan*e of namin$ *on/ention" and
*odin$ *on/ention" in de/elo0ment 0ro*e""-
Tou$ te 0ro)e*t #a" ta=in$ too lon$ and #e fa*ed man' diffi*ultie"
#i* ad been re"ol/ed effe*ti/e $uidan*e of 0rofe""or"-We are "ure
tat #e *an 0erform better and better a" #e "te0 u0 on ladder" of
e0erien*e-
CHAPTER:G
FUTURE INHANCEMENT
Ti" 0ro)e*t #a" de/elo0ed to fulfill u"er re!uirement o#e/er tere are lot" of
"*o0e to im0ro/e te 0erforman*e of te 0ur*a"in$ "ellin$ 0rodu*t" in te area
of u"er interfa*e1 databa"e 0erforman*e1 and !uer' 0ro*e""in$ time- Et*-
So tere are man' tin$" for future enan*ement of ti" 0ro)e*t- Te future
enan*ement" tat are 0o""ible in te 0ro)e*t are a" follo#"-
Admini"traterD add or modif' 0rodu*t"1#or=er #i* 0re"entl' done from
ba*= end-
In te area of data "e*urit' and "'"tem "e*urit'-
Pro/ide more furniture ti0" and el0-
To o0timie te !uer' #i* i" embedded in te "'"tem-
141
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
142/146
MO.U&E
Module 9( Pa""#ord Module(
In ti" module1 re$i"tered u"er enter" a 0a""#ord and te "oft#are *e*=" it"
/alidit'- If te 0a""#ord i" /alid ten e i" allo#ed to enter1 oter#i"e ;In/alid
U"er>Pa""#ord< me""a$e i" di"0la'ed-
Module 4(Produ*t .etail"(
In ti" module1 a uni!ue no- to ea* 0rodu*t in te "o#room and re*ord are
"tored-We al"o mention te o# man' 0rodu*t are in te librar' -
Module ?(Wor=er .etail"(
In ti" "a/e" te re*ord" of to"e #or=er" #o are te member" of "o#room1 #o
a/e autorit' to "ale from te "o#room-
Module 7(Cu"tomer .etail"(
Ti" module a" all te detail" of *u"tomer -
Module 3(Sale .etail"(
In ti" module1 #e entered te detail" of "ale 0rodu*t #i* are 0ur*a"ed b'
*u"tomer-
142
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
143/146
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
144/146
7 .. .ata .i*tionar'1 #i* i" a data ba"e tat
Contain" ;data about data< i-e- de"*ri0tion of
oter in te "'"tem
3 F&OW CHART F&OW CHART #i*
de0i*t" relation bet#een different entitie" in
te "'"tem-
G HAR.WARE Te 0'"i*al e!ui0ment in a "'"tem
*om0ri"in$ of *om0uter"1 terminal"1
,e'board" Oter an*illar' item"-
IT. Information Te*nolo$' .i/i"ion-
2 MENU A $rou0 of o0tion" from #i* Sele*tion i" to
be made-
5 MO.U&E A "mall *om0onent" of a lar$er "'"tem
96 OFF:&INE A term de"*ribin$ 0eo0le1 e!ui0ment or
.e/i*e" tat are in dire*t *ommuni*ation #it
te *om0uter
99 PI Preliminar' In/e"ti$ation
94 PRO+RAM A "e!uen*e of in"tru*tion $i/en to te
Com0uter to "ol/e a 0arti*ular 0roblem-
144
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
145/146
9? PROTOTYPE A de/elo0ment model of te "'"tem for te"t
Pur0o"e
97 R.%MS A data %a"e> Mana$ement S'"tem in #i*
Relation"i0" are defined b' table"-
93 RS. Re!uirement S0e*ifi*ation .o*ument-
9G SCA&A%I&ITY Te abilit' to in*rea"e te 0erforman*e Wit
te $ro#t in Hard#are-
9 SOFTWARE Com0uter 0ro$ram1 0ro*edure A""o*iated
do*umentation *on*erned #it te o0erator of
a "'"tem-
145
-
8/12/2019 Furniture Report Sh - Copy (2)SUNIL
146/146
%I%&IO+RAPHY
Com0lete Ref-
Autor Harbert Seil
Publi"er TataM*+ra#:Hil
%la*= %oo= of )a/a