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


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


3/146

FORWAR.IN+ &ETTER

Ti" i" to *ertif' tat te 0ro)e*t entitled ;FURNITURE SHOWROOM

SYSTEM


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


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


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


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/146

CHAPTER:9CHAPTER:9

INTRO.UCTIONINTRO.UCTION

8


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


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


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


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


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


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


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


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


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


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* /oid runD

ne# S0la"formD-"etKi"ibletrueD

D

66


67/146

MAINFORM


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


.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


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


68/146


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


0ri/ate /oid Modif'Cu"tomerA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


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


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


Add#or=erform #Vne# Add#or=erformD

#-"o#D

68


69/146

0ri/ate /oid .eleteSu00lierA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


.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


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


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


.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


Modif'"ale0rodu*ttable m"0Vne# Modif'"ale0rodu*ttableD

69


70/146

m"0-"o#D

0ri/ate /oid Sear*SaleProdu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent

e/tD


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


&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


&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


&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


&i"tof"aleform l"fVne# &i"tof"aleformD

70


71/146

l"f-"o#D

0ri/ate /oid *an$e0a""#ordA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


0ri/ate /oid Sto*=A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


0ri/ate /oid )MenuItem9A*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


S'"tem-eit6D



Can$ePa""#ordform *0fVne# Can$ePa""#ordformD

*0f-"o#D



Sto*=0rodu*t "0Vne# Sto*=0rodu*tD

"0-"o#D

71


72/146

0ri/ate /oid Sear*0rodu*tA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


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


.elete*u"tomerform d*Vne# .elete*u"tomerformD

d*-"o#D



Sale0rodu*tform4 "0Vne# Sale0rodu*tform4D

"0-"o#D



0ubli* /oid runD

ne# MainformD-"etKi"ibletrueD

D

72


73/146

A.. WOR,ER FORM


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


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


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'




Strin$ !uer'Vin"ert into &i"tOfWor=er

/alue"X#or=eridX1X#or=ernameX1X#addre""X1X#or=erdateX1X#

or=er0oneXD


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


0ri/ate /oid NetA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


#id-"etTetD

#name-"etTetD

addre""-"etTetD

#date-"etTetD

74


75/146

#0one-"etTetD

int 0V6

tr'




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


int 0V6

tr'





#ilere"-netDD

0VInte$er-0ar"eIntre"-$etStrin$#or=erI.DD

75


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* /oid runD

ne# Add#or=erformD-"etKi"ibletrueD

D}

76


77/146

.E&ETE WOR,ER FORM


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


*idVtt#id-$etTetD

Strin$ !uer'

tr'



"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


78/146

*at*E*e0tion eD

0ri/ate /oid *an*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


di"0o"eD

0ri/ate /oid .eleteA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


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


JO0tionPane-"o#Me""a$e.ialo$null1 "u**e""full' deletedD

78


79/146

*at*E*e0tion eD



0ubli* /oid runD

ne# .elete#or=erformD-"etKi"ibletrueD

D

79


80/146

MO.IFY WOR,ER FORM


im0ort )a/a-"#in$-

im0ort )a/a-"!l-


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


*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


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


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


0ri/ate /oid #name,e'Pre""ed)a/a-a#t-e/ent-,e'E/ent e/tD


*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


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


82/146


Strin$ name1add1d10

*idVInte$er-0ar"eInt#id-$etTetDD

nameV#name-$etTetD

addVaddre""-$etTetDD

dVdo)-$etTetD

0V0one-$etTetD

tr'




Strin$ !uer'Vu0date #or=ertable "et

#or=ernameVXnameX1addre""VXaddre""X1do)VXdo)X10onenoVX0o

neX #ere #or=eridVX*idX


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



di"0o"eD

82


83/146



*idVInte$er-0ar"eInt#id-$etTetDD

Strin$ !uer'

tr'




!uer'V"ele*t from #or=ertable #ere #or=eridVX*idX


ifre"-netDD

#name-"etTetre"-$etStrin$#or=ernameDD

addre""-"etTetre"-$etStrin$addre""DD

0one-"etTetre"-$etStrin$do)DD

do)-"etTetre"-$etStrin$0onenoDD

el"e


*at*E*e0tion eD

SEARCH WOR,ER FORM

83


84/146


im0ort )a/a-"#in$-

im0ort )a/a-"!l-


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


lbl-"etTetEnter te Wor=er I.D

t4-"etTetD

t4-re!ue"tFo*u"D



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'



84


85/146


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


#ilere"-netDD


re"-$etStrin$#or=eridD1re"-$etStrin$#or=ernameD1re"-$etStrin$addre""D

1re"-$etStrin$do)D1re"-$etStrin$0onenoDD

85


86/146

*at*E*e0tion eD

0ri/ate /oid EITA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


di"0o"eD

>> 0aram ar$" te *ommand line ar$ument"



0ubli* /oid runD

ne# Sear*#or=erformD-"etKi"ibletrueD

D

A.. CUSTOMER

86


87/146


im0ort )a/a-"#in$-

im0ort )a/a-"!l-


0ubli* *la"" Add*u"tomerform etend" )a/a-"#in$-JFrame

> Create" ne# form Add*u"tomer >

0ubli* Add*u"tomerformD

initCom0onent"D



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'




Strin$ !uer'Vin"ert into *u"tomertable

/alue"X*u"tidX1X*u"tnameX1Xaddre""X1X0oneXD



*at*E*e0tion eD

>>add item into li"t of *u"tomer form

>>::::::::::::::::::::::::::::::::::::

87


88/146

tr'




Strin$ !uer'Vin"ert into &i"tof*u"tomer

/alue"X*u"tidX1X*u"tnameX1Xaddre""X1X0oneXD



*at*E*e0tion eD

0ri/ate /oid netA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


tt*u"tid-"etTetD

tt*u"tname-"etTetD

tt*u"tadd-"etTetD

tt*u"t0one-"etTetD

int 0V6

tr'




Re"ultSet re"V"tmt-ee*uteuer'"ele*t from *u"tomertableD

#ilere"-netDD

0VInte$er-0ar"eIntre"-$etStrin$*u"tidDD

88


89/146

tt*u"tid-"etTetStrin$-/alueOf0X9DD

tt*u"tname-re!ue"tFo*u"D

tt*u"tid-enablefal"eD

*at*E*e0tion eD



di"0o"eD



int 0V6

tr'





#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


90/146

0ri/ate /oid tt*u"tname,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD


*ar *

*Ve/t-$et,e'CarD




e/t-*on"umeD


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


0ri/ate /oid tt*u"tadd,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD


*ar *

*Ve/t-$et,e'CarD


90


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


*ar *

*Ve/t-$et,e'CarD




e/t-*on"umeD


Strin$ "Vtt*u"t0one-$etTetD

if"-len$tDZV96D


tan96D

e/t-*on"umeD

0ri/ate /oid tt*u"tnameA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


0ri/ate /oid tt*u"t0oneA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD

91


92/146


>


>



0ubli* /oid runD

ne# Add*u"tomerformD-"etKi"ibletrueD

D

.E&ETE CUSTOMER


92


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


int *oi*e

Strin$ !uer'



tr'

!uer'Vdelete from *u"tomertable #ere *u"tidVX*idX

tt*id-"etTetD

#name-"etTetD

Addre""-"etTetD

Poneno-"etTetD



93


94/146

*at*E*e0tion eD



di"0o"eD



*idVInte$er-0ar"eInttt*id-$etTetDD

Strin$ !uer'

tr'




!uer'V"ele*t from *u"tomertable #ere *u"tidVX*idX


ifre"-netDD

#name-"etTetre"-$etStrin$nameDD

Addre""-"etTetre"-$etStrin$addre""DD

Poneno-"etTetre"-$etStrin$0onenoDD

el"e


*at*E*e0tion eD

94


95/146

MO.IFY CUSTOMER


95


96/146

im0ort )a/a-"#in$-

im0ort )a/a-"!l-


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



Strin$ name1addre""10one


nameVttname-$etTetD

addre""Vttaddre""-$etTetDD

0oneVtt0one-$etTetD

tr'




Strin$ !uer'Vu0date *u"tomertable "et

nameVXnameX1addre""VXaddre""X10onenoVX0oneX #ere

*u"tidVX*idX



tt*id-"etTetD

ttname-"etTetD

ttaddre""-"etTetD

tt0one-"etTetD

96


97/146

tt*id-re!ue"tFo*u"D

*at*E*e0tion eD



di"0o"eD




Strin$ !uer'

tr'




!uer'V"ele*t from *u"tomertable #ere *u"tidVX*idX


ifre"-netDD

ttname-"etTetre"-$etStrin$nameDD

ttaddre""-"etTetre"-$etStrin$addre""DD

tt0one-"etTetre"-$etStrin$0onenoDD

el"e


*at*E*e0tion eD

97


98/146

0ri/ate /oid ttname,e'Pre""ed)a/a-a#t-e/ent-,e'E/ent e/tD


*ar *

*Ve/t-$et,e'CarD




e/t-*on"umeD


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


*ar *

*Ve/t-$et,e'CarD




e/t-*on"umeD


98


99/146

Strin$ "Vtt0one-$etTetD

if"-len$tDZV96D


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


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




0ubli* /oid runD

ne# Modif'*u"tomerformD-"etKi"ibletrueD

D

SEARCH CUSTOMER FORM


im0ort )a/a-"#in$-

99


100/146


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



lbl-"etTetEnter te *u"tomer I.D

t4-"etTetD

t4-re!ue"tFo*u"D



lbl-"etTetEnter te *u"tomer nameD

t4-"etTetD

t4-re!ue"tFo*u"D



ti"-ideD


>> TO.O adde 'our andlin$ *ode ere(

.efaultTableModel mV.efaultTableModelD tb9-$etModelD

tr'

100


101/146


102/146

#ilere"-netDD


re"-$etStrin$*u"tidD1re"-$etStrin$nameD1re"-$etStrin$addre""D1re"-$etStr

in$0onenoDD

*at*E*e0tion eD

>


>



0ubli* /oid runD

ne# Sear*Cu"tomerformD-"etKi"ibletrueD

D

A.. SA&E PRO.UCT FORM


im0ort )a/a-"#in$-

102


103/146

im0ort )a/a-"!l-


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



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


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'




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


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



tr'




Re"ultSet re"V"tmt-ee*uteuer'"ele*t from 0rodu*ttableD

104


105/146

#ilere"-netDD

0*ombo-addItemre"-$etStrin$0rodu*tidDD

*at*E*e0tion eD

tr'





#ilere"-netDD

**ombo-addItemre"-$etStrin$*u"tidDD

*at*E*e0tion eD

tr'





#ilere"-netDD

#*ombo-addItemre"-$etStrin$#or=eridDD

105


106/146

*at*E*e0tion eD

0ri/ate /oid 0*omboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


Strin$ 0id

int 0no1tm1"1!

0idVStrin$-/alueOf0*ombo-$etSele*tedItemDD

0noVInte$er-0ar"eInt0idD

tr'




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


107/146

*at*E*e0tion e4D

0ri/ate /oid **omboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


Strin$ *id

int *no

*idVStrin$-/alueOf**ombo-$etSele*tedItemDD

*noVInte$er-0ar"eInt*idD

tr'




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


108/146

0ri/ate /oid eitA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


ti"-ideD

0ri/ate /oid #*omboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


Strin$ #id

int #no

#idVStrin$-/alueOf#*ombo-$etSele*tedItemDD

#noVInte$er-0ar"eInt#idD

tr'




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


109/146

0ri/ate /oid *al*ulationA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


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

>


>



0ubli* /oid runD

ne# Sale0rodu*tform4D-"etKi"ibletrueD

D

.E&ETE PRO.UCT FORM


109


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


int *oi*e



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



*at*E*e0tion eD

110


111/146



di"0o"eD



0idVtt0id-$etTetD

Strin$ !uer'

tr'




!uer'V"ele*t from 0rodu*ttable #ere 0rodu*tidVX0idX


ifre"-netDD


tt*o"t-"etTetre"-$etStrin$0ri*eDD

tt"ale-"etTetre"-$etStrin$"ale0ri*eDD


el"e


111


112/146


113/146

im0ort )a/a-"#in$-


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


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


lbl9-"etTetEnter te 0rodu*t nameD

t?-"etTetD

t?-re!ue"tFo*u"D



di"0o"eD



.efaultTableModel mV.efaultTableModelD tbl-$etModelD

113


114/146

tr'




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


#ilere"-netDD


re"-$etStrin$0rodu*tidD1re"-$etStrin$0nameD1re"-$etStrin$0ri*eD1re"-$et

Strin$"ale0ri*eD1re"-$etStrin$!uantit'DD

el"e ifrb4-i"Sele*tedDD

Strin$ "

114


115/146

"Vt?-$etTetD

Strin$ !uer'VSele*t from Produ*ttable #ere 0nameVX"X


#ilere"-netDD


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




>


>



0ubli* /oid runD

115


116/146

ne# Sear*Produ*tformD-"etKi"ibletrueD

D

MO.IFY PRO.UCT FORM


116


117/146

im0ort )a/a-"#in$-

im0ort )a/a-"!l-


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



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'




Strin$ !uer'Vu0date 0rodu*ttable "et

0nameVX0nameX10ri*eVX*o"tX1"ale0ri*eVX"aleX1!uantit'VX!t'X

#ere 0rodu*tidVX0idX


117


118/146


tt0id-"etTetD

tt0name-"etTetD

tt*o"t-"etTetD

tt"ale-"etTetD

tt!t'-"etTetD

tt0id-re!ue"tFo*u"D

*at*E*e0tion eD



di"0o"eD



0idVtt0id-$etTetD

Strin$ !uer'

tr'




!uer'V"ele*t from 0rodu*ttable #ere 0rodu*tidVX0idX


ifre"-netDD


tt*o"t-"etTetre"-$etStrin$0ri*eDD

118


119/146

tt"ale-"etTetre"-$etStrin$"ale0ri*eDD


el"e


*at*E*e0tion eD

0ri/ate /oid tt0name,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD


*ar *

*Ve/t-$et,e'CarD


*VV,e'E/ent-K,SPACEDD


e/t-*on"umeD


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


*ar *

*Ve/t-$et,e'CarD

119


120/146



JO0tionPane-"o#Me""a$e.ialo$null1 in/alid noD

e/t-*on"umeD


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


0ri/ate /oid tt"ale,e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD


*ar *

*Ve/t-$et,e'CarD



JO0tionPane-"o#Me""a$e.ialo$null1 in/alid noD

e/t-*on"umeD


120


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* /oid runD

ne# Modif'0rodu*tformD-"etKi"ibletrueD

D

.E&ETE SA&E PRO.UCT FORM

121


122/146


im0ort )a/a-"#in$-

im0ort )a/a-"!l-


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


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


123/146

bVInte$er-0ar"eIntbal-$etTetDD

tr'




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



"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


124/146

0ri/ate /oid *ann*elA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


di"0o"eD

0ri/ate /oid "ale*omboboA*tionPerformed)a/a-a#t-e/ent-A*tionE/ent e/tD


Strin$ 0id

int !1"1amt

0idVStrin$-/alueOf"ale*ombobo-$etSele*tedItemDD

"VInte$er-0ar"eInt0idD

tr'


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


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



int "V6

tr'




Re"ultSet re"V"tmt-ee*uteuer'"ele*t from "ale0rodu*ttableD

#ilere"-netDD

"ale*ombobo-addItemre"-$etStrin$"alenoDD

*at*E*e0tion eD

125


126/146

>> Add 0rodut*t I. into 0rodu*t *ombo

>>::::::::::::::::::::::::::::::::::

tr'




Re"ultSet re"V"tmt-ee*uteuer'"ele*t from 0rodu*ttableD

#ilere"-netDD


*at*E*e0tion eD

>> Add Wor=er I. into *ombo #or=er

>>::::::::::::::::::::::::::::::::

tr'





#ilere"-netDD


*at*E*e0tion eD

>>Add Cu"tomer I. into *u"tomer *ombo

>>:::::::::::::::::::::::::::::::::::

126


127/146

tr'





#ilere"-netDD


*at*E*e0tion eD

>


>



0ubli* /oid runD

ne# Modif'"ale0rodu*ttableD-"etKi"ibletrueD

D

STOC, OF PRO.UCT FORM


127


128/146

im0ort )a/a-"#in$-


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


ti"-ideD




tr'




Re"ultSet re"

int ro#

ro#Vm-$etRo#CountD

forint iV6i\ro#iXXD

m-remo/eRo#6D

128


129/146

Strin$ !uer'VSele*t from "to*=table


#ilere"-netD


re"-$etStrin$0rodu*tidD1re"-$etStrin$0nameD1re"-$etStrin$"ale0ri*eD1re"-

$etStrin$*o"tD1re"-$etStrin$!t'DD

*at*E*e0tion eD



0ubli* /oid runD

ne# Sto*=0rodu*tD-"etKi"ibletrueD

D

&IST OF CUSTOMERS


129


130/146

im0ort )a/a-"#in$-

im0ort )a/a-"!l-

im0ort )a/a-tet-


0ubli* *la"" &i"tof*u"tomerform etend" )a/a-"#in$-JFrame

0ubli* &i"tof*u"tomerformD

initCom0onent"D


di"0o"eD



tr'




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


#ilere"-netDD


re"-$etStrin$*u"tidD1re"-$etStrin$*nameD1re"-$etStrin$addre""D1re"-$etSt

130


131/146

rin$PonenoDD

*at*E*e0tion eD



0ubli* /oid runD

ne# &i"tof*u"tomerformD-"etKi"ibletrueD

D

&IST OF WOR,ER

131


132/146


im0ort )a/a-"#in$-


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



.efaultTableModel mV.efaultTableModelD t9-$etModelD

tr'




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


#ilere"-netDD

132


133/146


re"-$etStrin$#idD1re"-$etStrin$#nameD1re"-$etStrin$addre""D1re"-$etStri

n$do)D1re"-$etStrin$PonenoDD

*at*E*e0tion eD



di"0o"eD

>


>



0ubli* /oid runD

ne# &i"tOfWor=erformD-"etKi"ibletrueD

D

&IST OF SA&E FORM


im0ort )a/a-"#in$-

133


134/146

im0ort )a/a-"!l-

im0ort )a/a-tet-


0ubli* *la"" &i"tof"aleform etend" )a/a-"#in$-JFrame

> Create" ne# form &i"tof"aleform >

0ubli* &i"tof"aleformD

initCom0onent"D



di"0o"eD



.efaultTableModel mV.efaultTableModelD t4-$etModelD

tr'




Re"ultSet re"

int ro#

ro#Vm-$etRo#CountD

forint iV6i\ro#iXXD

m-remo/eRo#6D

134


135/146

Strin$ !uer'VSele*t from &i"tof"ale


#ilere"-netDD


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

>


>



0ubli* /oid runD

ne# &i"tof"aleformD-"etKi"ibletrueD

D

135


136/146

CHAN+E PASSWOR. FORM


im0ort )a/a-"#in$-

im0ort )a/a-"!l-


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


ti"-ideD



Strin$ 091041!uer'

09Vne#0a""-$etTetD

04V*on0a""-$etTetD

if09-e!ual"04DD

tr'



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


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


Strin$ u"er91u"er410a""910a""4

tr'



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


137


138/146

0ri/ate /oid *on0a"",e'T'0ed)a/a-a#t-e/ent-,e'E/ent e/tD


*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

>


>



0ubli* /oid runD

ne# Can$ePa""#ordformD-"etKi"ibletrueD

D

138


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


140/146


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


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


143/146


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


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


146/146

%I%&IO+RAPHY

Com0lete Ref-

Autor Harbert Seil

Publi"er TataM*+ra#:Hil

%la*= %oo= of )a/a

furniture report sh - copy (2)sunil

Documents