prokom kom 3

7/26/2019 Prokom Kom 3

1/26

LAPORAN PRATIKUM

PEMROGRAMANKOMPUTER II

disusun oleh:

RAMADHAN FEBRIANTO (03!"#

KELA$ %!

KOMPUTER 3

DEPARTEMEN TEKNIK ME$IN $EKOLAH &OKA$I

UNI&ER$ITA$ GA'AH MADA OGAKARTA

)0!*

DAFTAR I$I


2/26

A. LATIHAN TUGAS

Load Data Produk..................................................................................................... 4

Manage Data Produk................................................................................................ 9

B. LATIHAN PR

Menghitung Vou!e Tangki Ta"e A#....................................................................$%

Menghitung Vou!e dan &nergi Daa! Ta"e A'..................................................($

LATIHAN $ )L*AD DATA+

DEPARTEMEN TEKNIK MESIN SV UGM | PEMROGRAMAN KOMPUTER II 2


3/26

Data"a,e Latihan (

-oata"/dr-0tota1



4/26

u,ingna!e,2a/eS3,te!1

u,ingna!e,2a/eS3,te!5o!2onentMode1

u,ingna!e,2a/eS3,te!5oe/tion,1

u,ingna!e,2a/eS3,te!6indo0,7or!,1u,ingna!e,2a/eS3,te!Data1

u,ingna!e,2a/eS3,te!Dra0ing1

u,ingna!e,2a/eM3S8DataM3S85ient1

2riate S3,te!Void "utton#:5i/k)S3,te!*";e/t< ,ender

S3,te!&entArg,< e+ =

String< >>>?L@data"a,e?"ngke1data,our/e?o/aho,t12ort?C1u,erna!e?root12a,,0ord

?@1

M3S85onne/tion< 333? g/ne0M3S85onne/tion)>>>+1

M3S85o!!and< nnn ? g/ne0M3S85o!!and)@,ee/t

-ro! t":"an@333+1 M3S8DataReader< !3Reader1

tr3

= 333EF*2en)+1

!3Reader?nnnEF&>e/uteReader)+1

Me,,ageBo>Sho0)@onek,i Done @+1

0hie)!3ReaderEFRead)++ = 333EF5o,e)+1

/at/h)&>/e2tion< e>+ = Me,,ageBo>Sho0)e>EFMe,,age+1

2riate S3,te!Void "utton$:5i/k)S3,te!*";e/t< ,ender


/o!"oBo>$EFIte!,EF5ear)+1

/o!"oBo>$EFTe>t?@@1

te>tBo>$EFTe>t?@@1te>tBo>(EFTe>t?@@1

String< >>>

?L@data"a,e?"ngke1data,our/e?o/aho,t12ort?C1

u,erna!e?root12a,,0ord?@1



-ro! t":,eri,@333+1

M3S8DataReader< !3Reader1

tr3=



5/26

333EF*2en)+1


Me,,ageBo>Sho0)@Load Data Seri,@+1

0hie)!3ReaderEFRead)++

= /o!"oBo>$EFIte!,EFAdd)!3ReaderEFGetString)@na!a@++1

333EF5o,e)+1

/at/h)&>/e2tion< e>+

= Me,,ageBo>Sho0)e>EFMe,,age+1

2riate S3,te!Void /o!"oBo>$:See/tedInde>5hanged)S3,te!*";e/t>> ? L@data"a,e?"ngke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":,eri,

0here na!a ? J@K /o!"oBo>$EFTe>t K @J1@333+1

M3S8DataReader< !3Reader1 tr3= 333EF*2en)+1 !3Reader?nnnE

F&>e/uteReader)+1


= te>tBo>$EFTe>t ? )!3ReaderEFGetString)@na!a@++ 1

te>tBo>(EFTe>t ? )!3ReaderEFGetInt()@harga@+.ToString)++ 1

te>tBo>$EFTe>t ? )!3ReaderEFGetInt()@harga@+.ToString)++1

333EF5o,e)+1



2riate S3,te!Void "utton(:5i/k)S3,te!*";e/t< ,ender


/o!"oBo>(EFIte!,EF5ear)+1

/o!"oBo>(EFTe>t?@@1

String< >>> ? L@data"a,e?"ngke1data,our/e?o/aho,t12ort?C1u,erna!e?root12a,,0ord?@1



6/26


M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":2art

0here na!a:2art ike J@K /o!"oBo>(EFTe>t K @J1@333+1


tr3=

333EF*2en)+1


Me,,ageBo>Sho0)@Load Data Part@+1


=

/o!"oBo>(EFIte!,EFAdd)!3ReaderEFGetString)@na!a:2art@++1

333EF5o,e)+1 /at/h)&>/e2tion< e>+


2riate S3,te!Void /o!"oBo>(:See/tedInde>5hanged)S3,te!*";e/t>> ? L@data"a,e?"ngke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":2art

0here na!a:2art ? J@K /o!"oBo>(EFTe>t K @J1@333+1


F&>e/uteReader)+1


= te>tBo>EFTe>t ? )!3ReaderEFGetString)@na!a:2art@++ 1

te>tBo>4EFTe>t ? )!3ReaderEFGetInt()@harga@+.ToString)++1

te>tBo>$EFTe>t ? )!3ReaderEFGetInt()@,to/k@+.ToString)++1

333EF5o,e)+1



2riate S3,te!Void "utton:5i/k)S3,te!*";e/t< ,ender




7/26

String< >>> ?

L@data"a,e?"ngke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":oi0here na!a ike J@K i,tBo>$EFTe>t K @J1@333+1


tr3

=

333EF*2en)+1


Me,,ageBo>Sho0)@Load Data *i@+1


=i,tBo>$EFIte!,EFAdd)!3ReaderEFGetString)@na!a@++1

333EF5o,e)+1 /at/h)&>/e2tion< e>+


2riate S3,te!Void i,tBo>$:See/tedInde>5hanged)S3,te!*";e/t>> ?

L@data"a,e?"ngke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":oi 0here

na!a ? J@K i,tBo>$EFTe>t K @J1@333+1


tr3

= 333EF*2en)+1 !3Reader?nnnEF&>e/uteReader)+1


= te>tBo>#EFTe>t ? )!3ReaderEFGetString)@na!a@++ 1

te>tBo>CEFTe>t ? )!3ReaderEFGetInt()@harga@+.ToString)++1

te>tBo>'EFTe>t ? )!3ReaderEFGetInt()@,to/k@+.ToString)++1

333EF5o,e)+1





8/26

2riate S3,te!Void "utton4:5i/k)S3,te!*";e/t< ,ender


-oata"/dr-0tota1

a?5onertToDou"e)te>tBo>4EFTe>t+1 "?5onertToDou"e)te>tBo>%EFTe>t+1

/?a"1

te>tBo>$$EFTe>t ? 5onertToString)/+1

d?5onertToDou"e)te>tBo>CEFTe>t+1

r?5onertToDou"e)te>tBo>9EFTe>t+1

-?dr1

te>tBo>$(EFTe>t ? 5onertToString)-+1

0?5onertToDou"e)te>tBo>$EFTe>t+1

tota?-K/K01

a"e$$EFTe>t ? 5onertToString)tota+1

1



9/26

Latihan ( )Manage Data+

Data"a,e Manage Data



10/26

intkode1


u,ingna!e,2a/eS3,te!5o!2onentMode1

u,ingna!e,2a/eS3,te!5oe/tion,1u,ingna!e,2a/eS3,te!6indo0,7or!,1

u,ingna!e,2a/eS3,te!Data1




S3,te!&entArg,< e+

=String< >>> ? L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":,eri/e

0here ;a,a ike J@K te>tBo>$EFTe>t K @J1@333+1


tr3

=

333EF*2en)+1


0hie)!3ReaderEFRead)++ =

/o!"oBo>$EFIte!,EFAdd)!3ReaderEFGetString)@;a,a@++1

333EF5o,e)+1 /at/h)&>/e2tion< e>+




String< >>>?L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1u,erna!e?root1

2a,,0ord?@1



-ro! t":,eri/e@333+1


tr3=

333EF*2en)+1 !3Reader?nnnEF&>e/uteReader)+1

Me,,ageBo>Sho0)@onek,i Suk,e, Bro @+10hie)!3ReaderEFRead)++ = 333EF5o,e)+1



11/26



2riate S3,te!Void /o!"oBo>$:See/tedInde>5hanged)S3,te!*";e/t>> ? L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":,eri/e

0here ;a,a ? J@K /o!"oBo>$EFTe>t K @J1@333+1


tr3=



= kode ? )!3ReaderEFGetInt()@id@++1

te>tBo>(EFTe>t ? )!3ReaderEFGetString)@;a,a@++ 1

te>tBo>EFTe>t ? )!3ReaderEFGetInt()@Harga@+.ToString)++ 1

333EF5o,e)+1





String< >>> ?

L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and)@in,ert into t":,eri/e)a,aharga+ aue,)J@K thi,EFte>tBo>(EFTe>t K @JJ@K

thi,EFte>tBo>EFTe>t K@J+ 1@333+1


tr3

=

333EF*2en)+1


Me,,ageBo>Sho0)@Data Di,i!2an@+1

0hie)!3ReaderEFRead)++= 333EF5o,e)+1



12/26



S3,te!&entArg,< e+

=String< >>> ? L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and

)@u2date t":,eri/e ,et a,a ?J@K thi,EFte>tBo>(EFTe>t K @J harga ? J@K thi,E

Fte>tBo>EFTe>t K@J 0here id ? @K kode K @ 1 @333+1


tr3= 333EF*2en)+1


Me,,ageBo>Sho0)@Data Diu2date@+1


= 333EF5o,e)+1 /at/h)&>/e2tion< e>+



S3,te!&entArg,< e+

=

String< >>> ? L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1




)@deete -ro! t":,eri/e 0here a,a ? J@K thi,EFte>tBo>(EFTe>t K @J and harga

? J@K thi,EFte>tBo>EFTe>t K@J 1 @333+1


tr3

= 333EF*2en)+1


Me,,ageBo>Sho0)@Data Diha2u,@+1


=

333EF5o,e)+1

/at/h)&>/e2tion< e>+= Me,,ageBo>Sho0)e>EFMe,,age+1



13/26



String< >>> ?

L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1u,erna!e?root12a,,0ord?@1

M3S85onne/tion< 333? g/ne0

M3S85onne/tion)>>>+1 M3S85o!!and< nnn ? g/ne0M3S85o!!and

)@,ee/t -ro! t":oi 0here na!a ike J@K te>tBo>CEFTe>t K @J1@333+1


tr3

=

333EF*2en)+1

!3Reader?nnnEF&>e/uteReader)+10hie)!3ReaderEFRead)++

=i,tBo>$EFIte!,EFAdd)!3ReaderEFGetString)@na!a@++1

333EF5o,e)+1 /at/h)&>/e2tion< e>+


2riate S3,te!Void i,tBo>$:See/tedInde>5hanged)S3,te!*";e/t>> ?




M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro!

t":oi 0here Na!a ? J@K i,tBo>$EFTe>t K @J1@333+1


tr3

=


0hie)!3ReaderEFRead)++= kode ? )!3ReaderEFGetInt()@id@++1

te>tBo>#EFTe>t ? )!3ReaderEFGetString)@na!a@++ 1

te>tBo>4EFTe>t ? )!3ReaderEFGetInt()@Harga@+.ToString)++ 1

te>tBo>'EFTe>t ? )!3ReaderEFGetInt()@Sto/k@+.ToString)++ 1

333EF5o,e)+1





14/26

2riate S3,te!Void "utton%:5i/k)S3,te!*";e/t< ,ender


2riate S3,te!Void "utton':5i/k)S3,te!*";e/t< ,enderS3,te!&entArg,< e+ =




M3S85o!!and< nnn ? g/ne0M3S85o!!and )@u2date

t":oi ,et na!a ?J@K thi,EFte>tBo>#EFTe>t K @J harga ? J@K thi,EFte>tBo>4E

FTe>t K@Jharga ? J@K thi,EFte>tBo>'EFTe>t K@J 0here id ? @K kode K @ 1 @333+1


tr3= 333EF*2en)+1






2riate S3,te!Void "uttonC:5i/k)S3,te!*";e/t< ,ender

S3,te!&entArg,< e+ = String< >>> ?




M3S85o!!and< nnn ? g/ne0M3S85o!!and )@deete

-ro! t":oi 0here na!a ? J@K thi,EFte>tBo>#EFTe>t K @J and harga ? J@K thi,E

Fte>tBo>4EFTe>t K@Jand ,to/k ? J@K thi,EFte>tBo>'EFTe>tK@J 1 @333+1

M3S8DataReader< !3Reader1 tr3= 333EF*2en)+1



0hie)!3ReaderEFRead)++ = 333EF5o,e)+1 /at/h)&>/e2tion< e>+



S3,te!&entArg,< e+

=





15/26


M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":2art 0here

na!a ike J@K te>tBo>$EFTe>t K @J1@333+1


tr3

= 333EF*2en)+1

!3Reader?nnnEF&>e/uteReader)+1 0hie)!3ReaderEFRead)++

= /o!"oBo>(EFIte!,EFAdd)!3ReaderEFGetString)@na!a@++1

333EF5o,e)+1


2riate S3,te!Void /o!"oBo>(:See/tedInde>5hanged)S3,te!*";e/t>> ? L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1

u,erna!e?root12a,,0ord?@1 M3S85onne/tion< 333? g/ne0

M3S85onne/tion)>>>+1


)@,ee/t -ro! t":2art 0here na!a ? J@K /o!"oBo>(EFTe>t K @J1@333+1


tr3

=333EF*2en)+1



= kode ? )!3ReaderEFGetInt()@id@++1

te>tBo>9EFTe>t ? )!3ReaderEFGetString)@na!a@++ 1

te>tBo>%EFTe>t ? )!3ReaderEFGetInt()@Harga@+.ToString)++ 1 te>tBo>$$EFTe>t ? )!3ReaderEFGetInt()@Sto/k@+.ToString)++1

333EF5o,e)+1 /at/h)&>/e2tion< e>+ = Me,,ageBo>Sho0)e>E

FMe,,age+1



16/26

2riate S3,te!Void "utton$(:5i/k)S3,te!*";e/t< ,ender




M3S85onne/tion< 333? g/ne0M3S85onne/tion)>>>+1M3S85o!!and< nnn ? g/ne0M3S85o!!and )@in,ert

into t":2art)a,aharga,to/k+ aue,)J@K thi,EFte>tBo>9EFTe>t K @JJ@K thi,E

Fte>tBo>%EFTe>t K@JJ@K thi,EFte>tBo>$$EFTe>t K@J+ 1 @333+1


tr3

= 333EF*2en)+1 !3Reader?nnnEF&>e/uteReader)+1

Me,,ageBo>Sho0)@Data Di,i!2an@+1

0hie)!3ReaderEFRead)++= 333EF5o,e)+1 /at/h)&>/e2tion< e>+ =

Me,,ageBo>Sho0)e>EFMe,,age+1

2riate S3,te!Void "utton$$:5i/k)S3,te!*";e/t< ,ender


String< >>> ?L@data"a,e?!anage:"engke1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@u2date

t":oi ,et na!a ?J@K thi,EFte>tBo>9EFTe>t K @J harga ? J@K thi,EFte>tBo>%E

FTe>t K@Jharga ? J@K thi,EFte>tBo>$$EFTe>t K@J 0here id ? @K kode K @ 1

@333+1


tr3=

333EF*2en)+1



0hie)!3ReaderEFRead)++ = 333EF5o,e)+1 /at/h)&>/e2tion< e>+



S3,te!&entArg,< e+

=






17/26

M3S85o!!and< nnn ? g/ne0M3S85o!!and )@deete

-ro! t":2art 0here na!a ? J@K thi,EFte>tBo>9EFTe>t K @J and harga ? J@K thi,E

Fte>tBo>%EFTe>t K@Jand ,to/k ? J@K thi,EFte>tBo>$$EFTe>tK@J 1 @333+1


tr3

= 333EF*2en)+1






2riate S3,te!Void "utton$4:5i/k)S3,te!*";e/t< ,enderS3,te!&entArg,< e+ =


/o!"oBo>$EFTe>t?@@1

/o!"oBo>(EFIte!,EF5ear)+1

/o!"oBo>(EFTe>t?@@1

te>tBo>$EFTe>t?@@1

te>tBo>(EFTe>t?@@1

te>tBo>EFTe>t?@@1

te>tBo>4EFTe>t?@@1

te>tBo>#EFTe>t?@@1

te>tBo>CEFTe>t?@@1

te>tBo>'EFTe>t?@@1

te>tBo>%EFTe>t?@@1

te>tBo>9EFTe>t?@@1

te>tBo>$EFTe>t?@@1

te>tBo>$$EFTe>t?@@1

i,tBo>$EFIte!,EF5ear)+1

i,tBo>$EFTe>t?@@1

2riate S3,te!Void "utton$#:5i/k)S3,te!*";e/t< ,ender

S3,te!&entArg,< e+ =5o,e)+1

1



18/26

Latihan PR $

Data"a,e PR $

2riate S3,te!Void 7or!$:Load)S3,te!*";e/t< ,ender



S3,te!&entArg,< e+

=

String>>?L@data"a,e?d":ther!o$1data,our/e?o/aho,t12ort?C1u,erna!e?root12

a,,0ord?@1



19/26


M3S85o!!and< nnn ? g/ne0M3S85o!!and)@,ee/t -ro!

t":a#@333+1 M3S8DataReader< !3Reader1

tr3=


Me,,ageBo>Sho0)@onek,i Suk,e, Bro @+1






/o!"oBo>$EFTe>t?@@1

String< >>> ?L@data"a,e?d":ther!o$1data,our/e?o/aho,t12ort?C1




-ro! t":a#@333+1


tr3= 333EF*2en)+1


Me,,ageBo>Sho0)@Load Data A#@+1


= /o!"oBo>$EFIte!,EFAdd)!3ReaderEFGetString)@T@++1

333EF5o,e)+1 /at/h)&>/e2tion< e>+= Me,,ageBo>Sho0)e>EFMe,,age+1



-oatT2-gV!a,,a1

!a,,a?5onertToDou"e)te>tBo>$EFTe>t+1



20/26

i-)/o!"oBo>$EFSee/tedInde> ?? + V?!a,,a.$1

i-)/o!"oBo>$EFSee/tedInde> ?? $+ V?!a,,a.$C1

i-)/he/kBo>$EF5he/ked+

a"e'EFTe>t ? 5onertToString)V+1

2riate S3,te!Void te>tBo>$:Te>t5hanged)S3,te!*";e/t< ,ender


2riate S3,te!Void /o!"oBo>$:See/tedInde>5hanged)S3,te!*";e/t>> ?

L@data"a,e?d":ther!o$1data,our/e?o/aho,t12ort?C1u,erna!e?root12a,,0ord?@1


M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":a#

0here T ike J@K /o!"oBo>$EFTe>t K @J1@333+1


tr3

=

333EF*2en)+1



=

te>tBo>(EFTe>t ? )!3ReaderEFGetDou"e)@2@+.ToString)++ 1

te>tBo>EFTe>t ? )!3ReaderEFGetDou"e)@g@+.ToString)++ 1

te>tBo>4EFTe>t ? )!3ReaderEFGetDou"e)@-@+.ToString)++ 1

333EF5o,e)+1 /at/h)&>/e2tion< e>+


1



21/26

Latihan PR (

Data"a,e PR (

intkode1


u,ingna!e,2a/eS3,te!5o!2onentMode1u,ingna!e,2a/eS3,te!5oe/tion,1

u,ingna!e,2a/eS3,te!6indo0,7or!,1

u,ingna!e,2a/eS3,te!Data1





22/26


S3,te!&entArg,< e+

=

String< >>>?L@data"a,e?2r(1data,our/e?o/aho,t12ort?C1u,erna!e?root12a,,0ord?@1


M3S85o!!and< nnn ? g/ne0M3S85o!!and)@,ee/t -ro!

t":a#@333+1


tr3=


Me,,ageBo>Sho0)@onek,i Suk,e,@+10hie)!3ReaderEFRead)++ = 333EF5o,e)+1






/o!"oBo>$EFTe>t?@@1

String< >>> ? L@data"a,e?2r(1data,our/e?o/aho,t12ort?C1



M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":a#

0here ,uhu ike J@K /o!"oBo>$EFTe>t K @J1@333+1


tr3

=

333EF*2en)+1!3Reader?nnnEF&>e/uteReader)+1

Me,,ageBo>Sho0)@Load Data Suhu@+1


=

/o!"oBo>$EFIte!,EFAdd)!3ReaderEFGetString)@,uhu@++1

333EF5o,e)+1 /at/h)&>/e2tion< e>+




23/26

2riate S3,te!Void /o!"oBo>$:See/tedInde>5hanged)S3,te!*";e/t>> ? L@data"a,e?2r(1data,our/e?o/aho,t12ort?C1

u,erna!e?root12a,,0ord?@1M3S85onne/tion< 333? g/ne0M3S85onne/tion)>>>+1

M3S85o!!and< nnn ? g/ne0M3S85o!!and )@,ee/t -ro! t":a# 0here

,uhu ? J@K /o!"oBo>$EFTe>t K @J1@333+1


F&>e/uteReader)+1


= te>tBo>$EFTe>t ? )!3ReaderEFGetDou"e)@-@+.ToString)++ 1

te>tBo>(EFTe>t ? )!3ReaderEFGetDou"e)@g@+.ToString)++ 1te>tBo>EFTe>t ? )!3ReaderEFGetDou"e)@u-@+.ToString)++ 1

te>tBo>4EFTe>t ? )!3ReaderEFGetDou"e)@ug@+.ToString)++ 1

333EF5o,e)+1





dou"e!Vu-ug-g>$u1

u-?5onertToDou"e)te>tBo>EFTe>t+1

ug?5onertToDou"e)te>tBo>4EFTe>t+1

>?5onertToDou"e)te>tBo>%EFTe>t+1

u?u-K>)ugEu-+1

a"e9EFTe>t ? 5onertToString)u+1



dou"e!Vu-ug-g>$u1

-?5onertToDou"e)te>tBo>$EFTe>t+1

g?5onertToDou"e)te>tBo>(EFTe>t+1

>?5onertToDou"e)te>tBo>%EFTe>t+1

$?-K>)gE-+1a"e$EFTe>t ? 5onertToString)$+1



24/26


S3,te!&entArg,< e+ =dou"e!u$1

!?5onertToDou"e)te>tBo>CEFTe>t+1

u?5onertToDou"e)a"e9EFTe>t+1

$?5onertToDou"e)a"e$EFTe>t+1

?!)uE$+1

a"e'EFTe>t ? 5onertToString)+1

2riate S3,te!Void "utton':5i/k)S3,te!*";e/t< ,enderS3,te!&entArg,< e+ =

5o,e)+1

2riate S3,te!Void "uttonC:5i/k)S3,te!*";e/t< ,ender



/o!"oBo>$EFTe>t?@@1

te>tBo>$EFTe>t?@@1

te>tBo>(EFTe>t?@@1

te>tBo>EFTe>t?@@1

te>tBo>4EFTe>t?@@1

te>tBo>CEFTe>t?@@1

te>tBo>%EFTe>t?@@1

a"e9EFTe>t?@@1

a"e'EFTe>t?@@1

a"e$EFTe>t?@@1

2riate S3,te!Void "utton%:5i/k)S3,te!*";e/t< ,ender

S3,te!&entArg,< e+

=


u,erna!e?root12a,,0ord?@1M3S85onne/tion< 333? g/ne0

M3S85onne/tion)>>>+1


)@in,ert into t":a#)-gu-ug+ aue,)J@K thi,EFte>tBo>$EFTe>t K @JJ@K thi,E

Fte>tBo>(EFTe>t K@JJ@K thi,EFte>tBo>EFTe>t K@JJ@K thi,EFte>tBo>4EFTe>t K@J+1@333+1M3S8DataReader< !3Reader1



25/26

tr3

=

333EF*2en)+1


Me,,ageBo>Sho0)@Data Di,i!2an@+10hie)!3ReaderEFRead)++

= 333EF5o,e)+1



S3,te!&entArg,< e+

=


u,erna!e?root12a,,0ord?@1M3S85onne/tion< 333? g/ne0M3S85onne/tion)>>>+1


)@u2date t":a# ,et - ?J@K thi,EFte>tBo>$EFTe>t K @J g ? J@K thi,EFte>tBo>(E

FTe>t K@J u- ? J@K thi,EFte>tBo>EFTe>t K@J ug ? J@K thi,EFte>tBo>4EFTe>t K@J

0here id ? @K kode K @ 1 @333+1


tr3

= 333EF*2en)+1




= 333EF5o,e)+1 /at/h)&>/e2tion< e>+



S3,te!&entArg,< e+

=String< >>> ? L@data"a,e?2r(1data,our/e?o/aho,t12ort?C1




)@deete -ro! t":a# 0here - ? J@K thi,EFte>tBo>$EFTe>t K @J and g ? J@K thi,E

Fte>tBo>(EFTe>t K@Jand u- ?J@K thi,EFte>tBo>EFTe>t K@J and ug ? J@K thi,E

Fte>tBo>4EFTe>t K@J 1 @333+1




26/26

tr3

= 333EF*2en)+1



0hie)!3ReaderEFRead)++=

333EF5o,e)+1



1

prokom kom 3

Documents