Oracle_Datab-_11g_Release_2PKPPKRBOOKMOBID p-3R8=C) H NU\dksz_ S"p$&}(*j,.N0 24y68:<>,@B DGFbHJ$L+N2`P8R?TTFVMXTZ\N\b^j`pbx0d~fhjolTn'prFtvx3zl|~Ws Ba$_*1;8>tEdL%SuY`#fmt|^"yLN̬ٴ2#T WE%N*075;@DLp Lpt4  B ah  =l  0?x$d;O(GhP "$ &nP(.0*,:.T0d 2(46.|8:2<>,@tBDF%H\LJLNPR@T8 X8 Z8/\86_^8;`8ASb8Fd8Kf8Qh8W'j8]rl8cn8jp8rr8yt8Hv8x8z8|8 ~8+888888o8s8=88+889^99 9 9&9 9'e9/959<|9D9Kc9R9Y9`9g9n9v9}9^9g9a9999}9-99ƅ99g999?99l:A:j:::::$:+:2:9:A}:H:N:U:\:c:j:q:x: :: : :C::.::::Y:::X :":q$::&:(;*;,;$.;0;2;$4;+6;28;8:;?<;Gw>;M@;UB;]D;dF;kH;sJ;{OL;N;P;R;T;oV;&X;Z;a\;^;z`;b;d;>f;h;Hj;l;'n;?p;7r; t;v;x;oz;W|;?~;g;;;< y`xMOBI(= yXEXTHhE12137-02dOracle CorporationeOracle CorporationiEOracle Database 2 Day + Java Developer's Guide, 11g Release 2gfGuides application developers on how to use Java to access and modify data in Oracle Database. en-us horizontal-lrkindle:embed:001F .t ,4 @  0626-3a91e28 } /y Oracle Database 2 Day + Java Developer's Guide, 11g Release 2
OracxDatabase 2Xy +avaeveloper'sNjy, 11gelebList9ExampleHLaxLjw02569wwwFiguroooWWߗ30220߆߆ޚZφφϒ?g08H??Tndpyrightnformation'N5O'!Paceߍߍulli߂593ߐ>AudiG/@624">DocumRccessibilitywߕ8674> ated g97xpvpW/*4126Ǜspan >1sing[with oj347_.tonectYW㒏g6379gg׃mJDBChinriver?&781'X_]OCIWs86521.3Packϒ5180׭$^JtApplicb?ǃ291DZ.2זxI/X454ohN?oolWߧ05657oOxview1S*cW.6@W/.4Advadϩ؎aFrameworkǥǽ2525'ƚGettStar)theoϿ%88G'WhatoueHInstall66?7 O׬ӐХgG67515ϰModifyъHRchemao('7׿7030׏WCliV1@2SE 0JDKN440ޤgrdpEnviron׳92O@5>ebO?gM61߾gger羯a7wheckdYirectoriesndƾ@7768024777wQtariab08138GDeminDris/ 2.3nstallingracleDeveloper
4.2.1rengxMethodnDeveloperoueryata(01622952.2 TestheonnecYnds/:god9577ooo3_\JSPage718163Overviewf*resent342'Tag4828Scriptlet595HTMLq6444Form__177610___3W_impleNϚǞϓF868GϞϓ@vAddSct(y806833tySheeo//260DynamǦ9 :zbas Resul8318.4useBe(xInitialize!HlClas50?et߮ײߐ^916ײ߲߇Ȕ]TabhòDisplayg?779241.5Filter7r443.54for_t69315m|25O܃Drols'o29inedRnW_//5H///6߫LogFuncٟ0tPCApplic 6W}Aunhateser1ط//׽׽׃H2854׽׽6PrepaBErrhRrtsa0d _75672___67^CIrfacooo90ooXcLA:233207oo qJDeveloper߼߼߭30ߊ?DefinNPrties ȵT2347g:fromMClas677dfymployeecor4031?G ? employeeata <(5.2.3ddinginkoavigateapUpdiPage48782.4Creat JSP:)EditŇ607512.5andlection/ul1WWs4084WWWFInserSnRecordǏǏ65637ǏǏ3.1ϋMethod+gggg9639ggg3.2ggggg___0270732___3_gganterew''''748/''`///GΓG7G886Dele????28228o.4?=for/ 52934Wooo7580ooo4owwa5w׮׏D982'׮צExcep{ 79245G.57omQJavsߵߵ߃582ߵ߃~rAnyQLNWW9847WW.6EinheapplicҾG30060.6Gta2Aplh2size="+1b/&355׿/.Enhancon:xvedDBCƼ`ureWIؿńзω431τUsynamic׻w566w.1+OraclePreparedtementマN83851leCallablewww11271ww/1;Bindari?3120ϟStopro𑧵׽614.2׽L/HIJDeveloper?_2012_τ XUs72G726׈(AllowrsIChoo?OOO3X8OOߌ04rom'gCursPW׽605.3סEFURSORypetegoryoof74ooAcces⃷ata43+g1236ggǹǹxckćbas/w293/wW¦'MuncXi>6.3allingheEFURSORromethod <(׃9599׃׃׃4Displayaynamichyeneratedist/ul1gDŽh2size="+1bGE5310GGF7reat3Master-Detailppltions)JPAndracleDF߉8U0 unn-zSXoutsidEEnث7475ϳϪߪeNor2UsernHf緷~6707w.5Wagelow''905w.6DZDZDZ 8**''8525.ǵQueryEdit81777.8//߳GGGG95GGGet:Un0n8edromubas90969FethodolosllpenbQ3xO@7tsn597/.9Globalon__[777wDevelopLocawarenes40762O.1MapbBetwe1۵„#40920'_8ermijwww1113ww.2wQߏ?o(272wGE HTML߽W398'xSpecifyϱȃ޵NȹLJ֋leSPwgggg$940ggOrganizCe(ofsTransl߾2ɾG4Strgg׿??2284??Ќt@cƽH??3330??4ɶSٶ?font> 9.5resentingatayserocaleonvon2-1eterminIthehBCriv`VersO119050>38Specify5urltyP٧AS Objectߣ21602faulterviةfigur@lener.orag/?U3054g?Q3mpPack%aavapplicǪfЧG4clar!nVabPndϮoC84G5ddMethoHo-YbasG߸?487tm7׻55471Mcroll-Sensit@,ad-OnlyhSe縷ǿǘ61ǿdž3G,7,uery,r2106294lUsɲd731>5keletCoderaas0Bewithcc’474942!UpRݵcordW56838W13OrNewŭoye_3o4rػnWo9647oٟ//ȢAnyQLExcep]DZǴ3073_6ǣAPrepared/Ǿ105822aall߷Ǻ3283Stoطcedur944׽4Fun*925ނ칱q916ǏL/WTInt_ѽggg2571Og7܃ύGWWWC3672WA8WREFURSORypoo788oo99Լur1gc4262gb0/hackage____<499_g___Z40839_">9pMappIfrompLocaXOracLanguTerriy>
  • 9-2eterminingserocalenavatheccept-Languageeader5593??85ǃonnMLz80906'ServletssetCentTypg263177ifferenceetweenateormaby(Unitedts0dǔXany)τN973ϖϖ8OONumb_____' 3276'!9ariRsLXuisticort(Binary"Spanish'Ϟh0Ϟ10reaesourundClass/ul1divXmbp:p`b8k/ڟR < `br/h1size="+2">L figureXb0l탂ǥ05393/">1-1DevelopI0rfac8262ebꍂSampApIǧǫ9702_">3 o 0necqailߪϮ91282s abasebj@΀Navigato945Dz3iewTabxStruct@Bqϱϵ105`el odocj4615Display0125106a;wgg77׿7SSEdi12941Q8mp\Librxggg3742?g 9odesight___684_X4TeOutputorueMethodogindowϿϿϕ7934Wσqd:4JSP2_Visual018175435Yo3N4O4seBeanppª=e0oyees.jsplwWW6565WW5criptletOOO;744ǾO6Error摿׽׽׍825ו)7@ck]Ϸ79216I8ԉ/׼20267כ9TMLormn__///C4620//A0%PrtalXBoxggg8߽g1G߿߿߿413Wߤ*2e*SaepplicBrowsײ733n(teredŜ\b ټo78:4____www3гw">5Generatccessُ54582hinkٹ֮ϿϿ26044oφa3ϥ׃׍etail>
  • 5-4ditingmployeeata6-1ddJ댸Providehetoredcedureption77265?2s sEnterecords_%52198__ 38ructViofropdownstBox̃wσw5ϙϊ4ynamicallyenerat InrowOO6372>7MasIDetailpplageםg/6699//2ersenceodelד729ׅ3re8JavaerviFacade׃890ǥ׈4SFavigjg-8896gQ5T-WVaߩ''931߫6)??;Cent/ul1divmbp:pbk/: < br/Hh1Tsize="+2">Tablbz07786">2Direciandƴs)ORACLE_HOMENy϶10911">3St`ardour觰p46 >4KeyueryxecuMethodsj.sql.`tem'Ͻ43Ͻ">9XLoepHcA,QL,:PL/`Igramm*nvironQxOracle®bas 11J>g

    E12137-0xFua201d?h~ , ߆߆߆ډW?>Copyright &cX;07,, Ԟ/it0fis.ll s rved.׏>Prim1Au`rs:epaswani,osslynneeffn,(itreyeeh0hantribFKathleenapXim0LawoWWo+uassiHnsah,risckttiBauwrkownhd,ul ,enksubamyϙThpsoftwarldocu!provXdnda Xgrein9pcis uIxdisclosu|tbytellual yawExceptsxy mitxyallo`,Qnot,py,0ductPsa,roadcx,odifH<,ё+xexhibmHublisP plpanari[`Hme .verengineerzemblecompiɼtrun`quUҋZabHt@ x"߫ߒ+e94(hereГ!ubjo nge@ut@ZЌ`0)pbrror-f(.ffi☸por0hemYusQwriɢG">؉eјnat1delic.S.oʓnyo{inУfSǁĔfoa4appable:>[OVERNMENTIGHTSs,oftware,atabases,ndelatedocumentationtechnicaleliverXto.S.onustomers "comhciXputer"rG"ursua@theppl8bleederAcquisiZReguagency-specificuelhes.sch,*usuR@isclosumodiԃ:dapdshalleXbjecrestricrZ0ensermetorthnGC׊ntractr`extyjofҍ?ddꈙightwrFAR 52.227-19,ÎwXsS̆(DecembH2007).υA(,nc., 500Parkway,dwooditpCA 94065.

    Thi=harddevelop (iaarietyAin(mman\Itnotϖ1in0d,nyhHntlypngerouȂincludingW9that8yreXriskp荊injuryfout__[nnpiQak؜roprifail-safHbackup,dun@cXoreaᆘo 8A؛iCorpor)affilyH1aim€bȍȎQdamsad)!?>JavaRisrademo/InamqirwISXea񅷅n0SPARC+Ȯئͬww''frnal;MD,pQ)ogo҇GGAdvMicroevذUNIXώΪTOpGp'''''%ٻy @vidcxڣ2ذ@,iductDser*romrdartigggd٧!GJdpsrX(ki(wi;x-yІϠϠϠwiυaos8cos Uurdu2 XKS/divmbp:p8bk/>Prefaceu!/zoo"0ojǣSuptOtXhav^elic supporthroughyracleӀ.ornformation,isit } X M
    _/* 's 9Reference, /e 2*2G׆EV??ІBϽConvQwϢϼexق~ Yd{ div itl sԶy"`mmary="T!s8sXwwt."ixltr"xe u00%"ramhs8s"ules="groupxcellpadI="3Q03"headr_X̘;W="bottom"@onthςǁρMeanXr2body///bd y ="p@r1c1-t2>b>bold,t"d2 82:BypAdicsraph`lIrterB[associwincxmefC)ɷglossмJwwwiicg_]3gIWSb+s,mphasiPplhXvyswhou pplyarticulaQlues߇ߕwwOOOJ">monospace M=ypendicatesommandsithinaragraph,RLs,dxampletexthatppearsnecreen,r'ounter./tr2bodyyablebr/8divY;mbp:pagebreaka Pa8Xς2

    1singava:racleaas؁pdth="1"lign="left">srelational͉cuotore,q, odify.ԋ(.Connectivity (JDBC)`arddy;lsacces0anipu`eBх߅shp''%7Pnustry-ƄGnrommaiQ (API)evelopSunicrosystemYletscmbPSQLs. d풶X/OpenCall̃ɄCL)8w En$of:-92.achendor,uhas4Yik9ÎAI؃^<9ҡ="F>j.sqlߣޡ0ck41cZ"ޜCУhry=""orښ,80%"@hsides"u="groupxcellpaddp="3适0؟_٣jb>Seelso:ulli>http://un.jse/technologH/%/`ex.jspc#039">}熰X  Thgu(howÀH9aao-cKaOK_ߥ81.uritQeAĢYƔworkDF)mar-detail7displayployhGgg[chaprodupTUstools׆>7ceollow:opics`Gfilepos=0 43471pߕݺOWW051800W/U4@S_nswdž56572ǜ>OverviewqSa?n熞Sݾ&<

    1.1 癒ߋ,D0topen!Jr߼ںquer\TcorTclalibrazv)2RPIs,׶׶վy''' x.owxXh蝐 lo0riȥhoff9PXxpeci0zfor@particularNote11>goracle.jdbc foingecsescribe suppor`x:kullifilepos=0 46379zcolor="#039"ThDrivera(/ς047816ςςύPOCIǂǂDž8652PLwv/jdivce">
    Seelso8bP_[hrefttp://www.com/pls/topic/lookup?ctx=E11882-01&id=Jaߐ1.i]ggbremsVϦЧmostxquiretP-Aisnlyeeded-specificur a,7TV.ɚxs< >TM@ 2latӱLdi 5.0,sonowsזit (JDK)pyzinclu K 6p-indepado noƷqalsoftwacli-dG#4QunaеҹserSQL*NetwEǸȼ21dcinn뼹:byrovi8impl‡sofnetworktos (Wwo-TaskØonߏۺyTTCnئPD)S a7CP/IPYou`ڡ=-֑Gjdbcdz pkag2?2ushJ"wnp?nw; l|adapters,ԱinȡG(IPC),ampipeȘI!,PФ8Exchange/ϴenc(o>IPXSPXgg`cAPI+enAs crXϋYk` t( Jfun[c8,rit``biaCpC,ѿ0ʂMhBthmethop-`ro 8ӱe^''''' 3''&q@s??"rbټ:througk*sql^nɸDit`DK)leHsrom 1.51.6ߤWz0Ӫsiz+1Pк̫1le.sql
    The oracl̂i/ kageupportsirectccessoatanQLormat.hisconsisprimarilyflassehatovideavaappingꂩ typhandeir=.łpntially,!aqswrersIy0haHtarverteoOOOHs''noyt)UCS-2/et.EachYOHH.*~extendso!Datumב,ᑩerJ;includfunctife r`comȒ8*.ome}XaJDBC 2.0-pliaH.nddies________in؛usetbjxcoll.Ӑ
    See@!gihrefttp://www.|/pls/topic/lookup?ctx=E11882-01&id=JAuxo#039n>Develoh'suJRefere1.2Us JCrApcsЃ﷿J7utorial+8gs 10gG>le10.1.3grdJenviron(IDE)*OLYWebhgrview@հϓWWxthmlH,/bbuggoptimizdeployٌvi"orůůyouwri0testKHm$}ecimbedd`?8.ƳXse,unco.dorfollowظdanporow޺,dit81leh#L/q,Acedɏ{kjg7o43.1ǡOMU ɴrѭs'' 'OI.dvarioutoolYHcdisplayyh`f:3Ɂock)m u}kx8byourethodforking.

    IndditionoheseHols,Developerrovidesange
    navigatorshelpourganizendiewontents!0jects.pplicabSystem howQfilin?9,zatructurendss`iual郐s">Ycarkv{PkchooseclxȋhfromV1menu.pos=0 53930f0lor="#039">FigA1-1Seelso:7nW{8thטIDEہj,բnlineȡ1.2.2ĦԨQȂ%wwrFortYaʚᦷfolloHgYsimxfycessȮqulliЧwr;whicharHHalleleߥurrlyeIeedhJ,ML,SP/HTML(/2_iՉ9VisE`orbIassemaDzaquick1ilyNJb>WWOWUvʈ (ge7!SHexsiv0srhwrhAcodsudiscthighhr9syntaxanticrrBan+[orPa,vCps%ѿplNoteTGGe鹘ilitat7c-spfic9txighpwheHe7.gu`, wihs0yhow' wueOOOOOwCopnPalett觗0omǖhlec`c=button@ᮐ2Э`hy񮐟Prя8hhPbift i xmsF/GB/2{Hfilepos=0 53930zcoloH#039ig1-1FmѭgeHXdeaᕈac!"AUIи)]2O`+1 >1.3lverյVSazA+ezT~sɿx8paJDBC2OracADF/_n[buildMfollow:u-olialu ɺoo*a(idn8:pw`O2(E@blisnaiabase7QuerOretripf$arBeanV4DtNjSPy ()Hchn(gy5ωͨ,p, recnj6modifmBapster-detailpplication.

  • andlexcep9sF/olpdivlign="center>
    Note:

    heononnectsoHRFigure 1-2ކshowrekahgbpdevelopedor iߊ9ϕ׉includ a Hs___ggφϣ_ǣmaף ~ai` }HRGGschemaAnyCoorpor̝pwotusznyrتlsollinkadtdelepʞabss,wrXȚ#dyYSPě"Ѣ#dphf7achԃtasksGtǴǴǺǺǩѲ#. WWjirOKt!AmpȔepewσݧHeX`ʰ!proَc{σoOOOOOi#\琮2芇OOǩ''/oʘ׾gg׳׽ôcurrP ȝfexhield)candithisnformation.

    Theubm t___Xpageirectsr aononviewableR,hichseredin҂3baseljljljljljNJ deleljljljljljljlink[0mployee ordg>shandlby___\* warduacZה//wwul@
    Notes@velopahggulrmIutorPsmded,rePJyouaesehapقsequenc://η91.4dvadĈUFworkϾooo prisolu2search,isplayЊXtx먛NJuweb,8reXktop, Pآrviиx@QQneؐr :ysَrob_Ǿ‰/hwri@a All-defin(?.0largeime-savIbent,8imaksehqEvironbeca凯rovQ1ȭstructup9wOJn d(GAZ෹sprսxatHmOracWWQ (UDF)ysu(`-to-fkbuiqPstaPn-sHcechnologixO!PAe\-)o1׾OO*illu(how̟ҕ9bePeasyDa月-ri٧hilitp@xnclumHerl nfilepos=0353108c#039">C 7a>׿mbp:pagebkg2UGetStarwithjn1wwW!pȞȧ D `ernon@inXll!quxd:eroversheollowingopics:

    Whatoueedxnstall
    Verify*Oracleatabaselie`tationoo83657oo>ɃJDeveloper/`:N
    2.1 WWSpuhpidth="1"lign="left">Toebxd samp(applic,ni'"productsnd0mponؑ667">okSeroo7030ooǑ/)__//71//>J2SErpKǖǙ74402(tegratxmQEnvirona眷7492'ebGsubsecsXscri requiresؓPtail.c371G7AyGGGCXavaߗߥaorkfW0thRHRV)/chema,hichesd$.fchoo*c,n2must?;Fbeforr7GGon. WPcre#nce pviPddiaoolsranagiVs(p8m-specific.Ƃ!inѧref `h="http://www.oj.`/pls/*/lookup?ctx=E11882-01&id=GINST">̋˦SQL*Plu8/IDBAs,Jexb:height="0@/@>j"GGC>1PLUS /BErassd ?򾭈E2@Ruyg'''߇'gg' PASSWORDChanjNew߾RetypeȁWWWWWW3Tennec_''CONNECT/򫏫YshouldXhessagYdathax l˙/"c0erڲԽsury=""eh80%"ramhs"ules="groupxcellpyng )siztbodyr!d77b>Notepwn cresisecuh]ssGB,efx hhttp://www.o./pls/topic/lookup?ctx=E11882-01&id=DBSEG3322coloP#039USIityǶ)aY*//(e>
    Inddition,omefheonstraintsndriggersresentnBHRN

    2.1.2OracleatabaClixojdbc5.jargg)J9bc67ĉ5.nk6n>,eѿ@ely.>@gWW.drprOO>8J,OH4OknjSConnonCacheImplאב noongHH8il)0(sconvpchaXdomo81OO`!7>.fSunsit{ollowalo:moin齺:GGMzohj.sunZj2se/1.5.0/docs/relPes/<-.htmloo>ǻ(KϽ(//UToooooo="80%"rame="hsides"ules="groupxcellpadding="3spac0"> Seelso:ρρρ2.1.4ntegratedevelopmePEnvironamOOJF(exPkapplic,ouPchooptourg* iw rew (nIDE).hisusesgOraclerIcre`Jfitn. QmorQ, Ipos=0 83657IWTo>.sGGGGGC5EWeberv鏇ϤTxsamp0ޒ@_agȍJSP) y isplay' andcceptpurom)rsplohep!nehaفQwitha>letZntainsucXsA Tom` t__oiembedd$cpǖg(LcTA".fnotXyʉthllows"lhoulufficeϸ''*supportsrectoiproduc_s1'NJǭ݁_ߢAߑ߃IBMSpheϰG7Bos_.boК#t, 9vendor-specipocu9sǵ2siz+1.2VerifDlix/74c3, spat1.٤=Y77wHcessfuleeBcL笷KsH#scribstep[k7ǴavolvtaskGG77006>CheckĴDori8aFߺ?Ͻ024ϽσWEnvironVariab''w!1382ww>DeterminNDBCriqsO窟ߛ3_Y.1m'&ŊiЛ7avas,Zgg code>ORACLE_HOME/jdbcρβo'WWWWWWWWYlib'_ fŒTd869>TY 2-haveenldpopuB_______[/code>irectory.

    Table 2-1ĂiesndilPinhe ORACLE_HOMEyljthǂǁescriptionׂr2bodyGGGzd ergetstartr1c1-t5yJ/I/libTooo">???ry8ains3">o)5.jar6requdavalasses. `seeJDBCriver=or@wi0JDK 5JQ6ۑWWWϑRme.txtOOOOWtr3OOIipolate-breakrrelease-specificȊxmaiboutBs,hichayotaveeencludorocume0Zpproductǝǝǯǝǝǝǝ/j4ﳧ\gϢϛrai18n߸ُQoԘrlob0zķ8multibytharacts0ppor/%)pbr/@Իcer){9=f??8773groupGGGGG__[b>Note:ޤ;Yalsob!fromSunicrosystemsebptHowe,t ȿomtoq+!lixbyόle՛ted)CU׍׍׍Հ?Aa /a>N4s 2.hecڂEEnvironaris{Xoscrib؃Xeatpstz^(nIJ.ouS9ɴJpa!yourllYFH,a_ollowuggd^CLASSPATH߾߇cǾǾǵORACLE_HOMES)ڪDaaX11g>ele agdexlsbouˣTdsslheightZWƢ!GGD9>ava - nbsp;311.1.04.0 p`䧈6Dܲ˻OOJIXhversionfheDBCriveratounstalledyPingrgetDjV;OracleDatabaseMetaaclass.


    Note:Examp2-1fa>llustrathowdemin\qؐe΋ߍPߋ2.3ɷ{)ﳷ JDeveloper3uIgu,egdmnvironb(IDE񼘬push8csJhpphPusq®8@le!11.!sW9supHMicrosoftindV8a,~XPg2003׀p0,inux,ndacS 0szs.`cribHPailQ*ٯwHGorONROY0.0ˑ,ichQpil1В(9 Techngyetworktcode~aref="http://Hnload.,耠cs/cd/E12839_01/.1/e13666/toc.htmtmן ;g羠D񲪕ټVquires{h⑃b>wGpXYouhoulsoadߡ`g~NotesWWWWWWWWWWWWWQwww/m/t/products/j/htH8ex!l//-ǂǂǂǂǂǒc'"m3.1F'tudiodiA:©WإFuOon+ϬKxTincluHmADFd2tYAmar-IJ7nL.WW>cDihrb\fـϞOwrd츨󂟱鈎vers0speciz}}Virtualh1G (JVM)K4u, L8larger.ƵHhck@p,׋ҨWllation.

    2.3.2
    tepsonstallDeveloperIfoure;ingheas,Rneedhave2EEers 1.6.0_05 `rachine. //+fu/)niscluded.OInut8eb!processsollows:ollialueQ>ownloadr1.0udiodi fromOracleechnologyetworktNoteHWchoosMiddleomeitorysHe'doesontain s.Ɲexampldo"uHǪǪǪC:\Progip_//e^|价changJDKocpreviouslyecified3modifײש nf7Wf.evariRxJAп:w߷߷ڸn><_>ڿ 3binzڬ9ofr qߴ.erhhbe0resdye>.G@aNIXvironPtfcdGGZusr/l/y8ntx߾߾ߕו׾>oulx(sLsǵ777񆇆?7O(askmust pmxcludett-Pmiss*xX-poagivIrsritxcu`+rr('iȼS/lililuI quba׻ш1Psalup ,xHg///ˣMfigur˧,pdOJVMdownloaɾonocu#sѶisڂ(il.=/ol8elsotmaOGZOZIonu //A</tbody> 2.3.3StartingDeveloperTornindows,lickaz J,electAllrogramsOHthenwOracleusiMiddleware>nd7Dwtudio 11.0.0>.oualsoun9 <in(ll_diiՏ?a">>\jdMZ\binw.exile. `useonsow2orisplay9internalagtic(mat,''''">AOXjsamer0orysteadf???o.ǒnj&/R100454>SetUpsjs05735ߙߐǕHχ_/G ~2y1x.1מטW/XWMsetȽman@חČB߾!Pen(rGApommunɷthx-s8,1offlinOsإ)@do+nNavigaYnalsdKsߥneedsu`a8oAvsubթ&Yi__viep稻i۩:a§seנננ3246נ>WWϣ944ϣɱa˯ǣWWϦ9796W">BrowYUן3wݪO"xט/ƿPlurrently(fd7nٓ7ເQҦǐ/i{'elQtop -h1sidXf"fed, V!menu.Ɵhill(ṙault outIDEi053930>Figure 1-X~www?צ/ײb!rough7tv.n@rticulafyschema,ި.Z׫,ilѤQzheits"g s8ndhnodey쵵,pʶn.ŀˇemaisplaysodesorhebjectypinatchema.xpandingZɁanpeitdividuals.henou傂abl,cviewstructurf"sхdataithr.

    N < br/8h3>3.1.2
    CreataăbaseonnhionYcoy*Awhich have]8etailPhcmuspecifyXuseram aassword.„8efault,ZdžlowsbrhXnly ͌gOOJTo,Haasteps:collialue>tartDeveloper.li?828FromYV;menXelْwuNavigator>.Ԛs%ed,howɘaipavx/7l3hRight-clickOIDE?<,fՃrtcutRp\NXw׆/nrepoeP7l4hO,o(thang🡕CcWQ, g1ieldHDeaӰRRolPWdeploy O rproembompuAwheHrloc`dminruldVq! nggbsɅnuòpDriveon>:OOOIAֵHo N?gi'"Զ֊"steiEט׷__[IfhrِJn/parQlhoAШȰ___[152'''SIDGlRCLWW/C?TeGߵ8׮successful Ӏ!߶ؿռ`tuXٿ">Figu3–1s߲آ6DHXdets4divξ"09iN-1pecify!ă;#imgpndexЀ4t="DeipҾs"/r/$z""Cqo clo¿J/oO_{siz+1}isPReromWnDevelopU߰Toӻ?1$NavigA,ight-cG/OTÃwonlyמGon,pl(+)ymbolexd2Є(o̐sewwwwwyĺ?敳h3 >3.1.3NBrE1Հ~wӃgg`Afi)hav(ablhaGx)c0by0tstproughGG@vDsnble, hierarchicalreetructureorheatabase,tsbjects,irnstanceandcontenYfach.oiewatevelaay킱nionyoureated,oRfollowing:

    ԆIDEÂ~sodeHjDNavigat nowhow[withname1`rn.lickplusymbol (+)SleftׂexpunCjdisplaylisF^anTyp؎iexampleabl7geEPoyees
    Figi3-2c@s7Oszhortcmenu.alogox!9makhang$ʱn/ Cs

    3.2SetzUpAppZXProJDevpeqȄ%GBIe@Zxtework,thpwhiorgan߽aumberap.rviQW(e0helpl9ܼ?@tarHȸOniyu@easily{tim߈؈n'7choowmatchɝ1wibeuild lWSa>ϊO⢌ermin$Jal(m8edersWR)mchnoXi@dOddyxtraibrarg@ne(particula9<ʇb0mo7L3Ϟ.1~Us՝ n󂘞oGgWfirsy(lr_Ybyault 90d/IDECwy@noЄe&nsgcnVeltop-ІϬ,yߏ׏׶wuVqR߮ڱoPhcg8pli0zۭN0se߭ Pidux׽4/Swow">F5ǙDcanisplaytemsn appropriateefaultditor.orxample,fououble-clickavai theRpen Sourceł,d|Serverages (JSP) it߂SP/HTMLisual.

    3.2.2
    reating)>Appo1dPProjectToettarted0thDevel0qmustQelteaone @ whichoorerorksollows:Colhlialue)>ɍӇnavigaӇNewoon*.@li2TPeenericowizarsed.ntHR
    enuϗAllww/3V =docڪtCXvailaYcYɛЊHnyeclass '/technology"7.iadH7detsallmethods׫׫Ҷǵ0ee/mːأ">Connߣ݉B,)Ȭ WY/Ȗo˖OMo{C70alsސspecifڿǢ9 xahoxO>Ѵ߳߶ٲ;WswaȘBO>Br/(`fi. 1ϒstarҰOOwu3&)'$ (j@.sql)71ߨY0igure 3-4ӻҨ)TsDdbes&݇5^ubsupos=107091pjcolor="#039">OverʳF_^16327__>Syy[seRLs CreatingavalassnDeveloper////26025//>Librarie128297>AddJDBCndSP26>ImporPackagNjooo0130871oo>DeclpConnection-Relatedֈabl@49ghe_nethod/ulZN
    3.3.1Overviewf·oracleatabaseseci://NAxxxT3-Pox0-tandard Gs̤ltitlSׁט """iltr''10////////heatrtop;="bottom"Y>N thTyp7/75DescripCnuެGd H@etYr1c1-t {>]ŷ hgd2b 2Strؿ///c3ϷGG"(ticular!ser(.lsonowninI(SID)Oracermin`gy.ƭī,xORCLbyfault츯????߷'ے_3??ooǖǛ'/underlyingataourcelass.

    descriptionDwfhe7cenetworkProtocol'''r5'''OבO/'Norommunicatwithserver.ƁOracle,isppliesnlyoRJDBC4allnter (OCI)ripndefaultswwwptcp}p8dgggr6g7gg/g''"P\Qec uȬwwwwwwwwwwwwwwortNumberooor7o?intׄWO22-hereristens requests+Nameor8????/??8tabas=Gw77AGr9WWWWWWǽǽǽDŽ/ǽǽU@ѷXbelogin?Ǵ????׽״?GG? able(br/pdivpidth="1"lign="left">Ifouhooseoethe url rofDataSourceobjectthXlecessaryarameters,nanon0odbax!outtingnpriesrpecifyadditionals҉">getDBC낀7hod.Ƅ8morenforma ݆ǎ8URL,efHqfilepos=0116327color="#039">SoIsa>(tcen">" Note:Oevel1'suRenix7Yư d 3.3.2$ ױeThisle9JVM8pportsɣYnxProto ֯ب6 (IPv6)Qr0DКmachineJava`8M,hichsolv:772OH8strthat$ valuڲ''''''Ggg߻߾߻.plhNJsyntax 这followЪMheightnqjdbc:+:.driH_typn>:[6us>/passwȚ>]@_]rC&4 irstYt=BsԠzoe pdk߉wpscliX-QonǸǸǸtoci_^bkeind` iែm(iop!al׾׾׉wnt[ connHǶ -$In-styervicݥbyZn"wqGEg߂OGGGW'ϮǮǮǤ𮷈woooצW70/Gi>host_ǣ?77'߸߸ߧG>_numbߧGwwGg'4SIDign="left">Forheamplepplicationreatednisuide,foucludeuseramndassword,rxdatabase Hhoslocally,/onnec2URLashownqEx3-1.

    height>t!2face="monospXr/>jdbc:oracle:n:hr/hr@R:1521:UORCL+B_i 3.3.2.8y>s]DefaulterviFHurecORClienу=~1mesthewGn#.ɗstGB̘ine@not{details#7Dipart͗.ndcha(disadaptrequironlyB[mpuawhegc:[OO77O>/u]@[//]Ϥψ>_1פooWWP[i>por ggm[:_7>IdulPli> //ᖝ. :זo972gbԩPmNetini(A)a 2(qbT?Or^pDso.πo)shtW??8 WWWPE.pfileg ۿpos=0121605Jcolor="#039">Exampx3-2&a>howsicfigura,Hin>div"0#b'2Ę4SDC߾gaq heightIЄ>br/>MYLISTENER = (ADDRESS_=  =(PROTOCOL=tcp)(HOHtest555)(PORT=)jdbc::n:@/Hoom:ow(yRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test555.Aserver.com)(PORT=1521)))
    jdbc:oracle:thin:@(DESCRIPT/////+ׂׂׂׅ))(CONNECT_DATA=(SERVICE_NAME= <0lign="center"> Note:efaulxxiceseweaturnϏJaase 11gN

    3.Crp~Javaass!JDeveloperۂoojT(firQtepQbuil applic؋ЊلQc. Jollow!instrucs cribeowalled Hl ViewۗprojH,fromsh(cutnu,li.N'(.li2Gary7GeneralO>8tegoryЂφItems>isӕOቋnOK_8qBedialogHxdisplayedY??=, ڔYx(3ȐėhPackagDoothangekjsfp!alttxuPwithjPropriܫi𱨗w nzfilepos=0125101colo#039">Fig3-6a0hKOazφ׆׆ԯeadyZIhaddrl:GMߔߔ01ߔ߂ߔߔߔ߄'ߎ۔ǔǔ/2\杪

    3.3.4GALibrarie ^1_ZOraclDevelopPcomHRstHard(̎9help0gramm0seHcludзAPIuppБAW \ptƂework (ADF), JDBC,SPson.ϧ'"To ٫A¬j,imz-`[yف.imilySPechn8g{Runtimey'ﭣ4.1Overvieweֆ7CTyD4GGIraХlg+:Kuɬⴞ7{o.jdbc߬:XerageefineheraclextensionsointerfacesXZjava.sql <*a xa>Vo‡ww :1'upportsirectGH KicisprimarilyflassthЋJapp"typ 鑀ir=OOOggOO.jdbc.pooy$ DSourceuse`oeh!nؘՔibascverloadC~77methodexXahysical??>T/ul1div耇br/h4>3.3.4.2φviewiʘJSPuntimeibraryl'!"ag,irequzpؠJrun yfilOaebLogScomwithDevelo .oub`click;*VD}AppaNavigatoisplayߊ'P4@t1dialogox&2 CΊCypathg>,np痐Е߆[yxa@stila(Ϭy2latQ,t0arddi(J2SE) (g`3IOx,crؾrough"mǾEyd0Hl!G(]/OK>ai sjhcSimrly௡ܚx ipos=0129419Jcolor="#039">Figure 3-8Hshow׾׾ԩ񾧾{0yi8mAA/iqimgXcindext="De8ip(s"/Jz"/";iף4בϣͥϬϬ6zPackag74usĨ,W,録'"؃ggcI">DHplj__nolready X ӲcHpor߮߮,xP///iG|̭WD (hr>)d߲+eExamp3-3OO?OOOK3Waonheigh0:ʦǦ9__[:hr;,.sql.Conn(oJ.jdbc.pool.ә˂sW~Zţϭgϣϣϣ7UDBIG-ReljVaGGGWPwHmS`p?cGmethodysingheollowqconnectionariables:"RL,seramehnd,rrespondpassword.

    Use:JavaourceditorfDevelophtoDataHler.jft σσσσ̃struc, @aewin@dersthree /(Rwws
    StrjdbcUrl =ull;gidׁm քoolThexgwilleqdnapplica:ta؍zsupbyBatogountˁ!hrea_"9dbase. ( <Ǔǚs˖hol+you{4_ggfњ___XMɆmidfschemafess0ܖw"cerʕ <Ȋpsummary=""erb80%"r="hs8s"u="groupxcellpad="3qRsizP3tbodyr!d//b>Noteb !havehen secuėn.i(poi gu(7funtyy3buil \(reȯHQes7nxl77,catWױױS1ooogg'g3(r//":oracle:n:@localhost:1521:ORCL"Ӷǫooogg'!ggg`hWǽŸ______ "hr翇Makrꯙǽso0finishҿFmpppm;P"fpp0Xes,fPn>OĶ=SGɲ[=lihli="28O0ewindeclIa-instancॷϡ߽ߡCgϾϴ''#YAJavlhouldowtaɲaExamp3-4&a>HhNool4ċ¬gֱObj8#gookager;import.sql...pool.S0ce pubQHlH{W; gr()ww+}?񴿴qwo'%✫>˾Qol7ON 3.3.8-CrнY_Metho9M ToYd,:musiImwuo1hAd3 쥻[aft9heonnectioneclaraa: align="lefttt#fontace="monospXbr/>publicoidetDBC()hrowsQLExcepYtatemePi@ddedylistfts.

    CendsamIne,npenr (gg`{6)0 h8pƉ.Devel8rutomcallyreCclos)Jp urs`innewmptyRetwe(Js.}3xO ke)W//(OleDataSourceגwinn@asoll///////-/+s;GGE4s#ٚkϡOobj???????=ds =()WW5StaIoe;URLwwp߭߭߭߭߭߭߈.P((jdbcUrl_LϬpro@sbyyvinwithPilabldzwwwthocrh"ughWlȰg??=$Strh)װwWH`rdIpns0fun,TǼLlca file=0137421 color="#039">Fig3-9>ahQ(__[Hϧlp3Pert IJNb>;,'ݾ70dTneMsemin (;)Ogw">Yݟuldookim `ozP8448>Examp 3-55d aͱ basﻗPkagerSimport.sql.?l.SQLExcezc oho..pool.ρpublicl"HHl{;K gr()ww}W? hnullǃwgoޥ5Snׇ׉`voDB׈thr)?on''_/+/f8ew GC();
     3 ?wds.setURL(jdbcUrlρς?conn=getCXection(userid,password77ogg}*3ompileourlonsurehat(eXaxnoyntaxrrors.oo8is,ight-clicknavaӂceditor,ndelh Make<YacHmono`ce">Successfulaψ"ssagesisplayedLogindowel0wwor$./ol9t?mbp:pxbreakPa xaXϔ 4Querying愰DData􂘂p8dth="1"lign="left">Thapteddsun sAQ9Hler.jGf1q]dbaseXra8folss:Overviewf OracXv1僗56368>aAppH??φ69577φ>CtJSPЗsߠoo82606oo>Addynamic8nteM:nesultߍoo192415oo>FilЗa߂etϧ_^20501_8PF̙tyGד223320ד>Tesg/W21.1-e/Inutline,1.aretriev,ust;gD` rys''' Cggcthod,o`{ 091271>C|3, "Aoשs">Dzef8SQLt0tsthva@bɉbj`OcSe[usd[@[v&3 Un''#,unSies.ْexecute"߶߆H$ producsetArowQatatcsdirr ta@aé߼؏O|4xU/Ǚǃ///isplaPٿia1/:٠ΊЮrsscribemportaⵞv(JDBC)cep0rel8 aon̮ZGG14315G">A''''14552'">M4Ϟڽgggg4995wgѿϿ϶0summary=""ordeز80%"amhsiX"0les="groupxcellpaJ 0/4.1.1 ωp͝ϝϝO`\Y,cess, +OOHe">Connection
    bj,heexttepsoreate <<Yace="monospX">Stmentggc.ԃ`WWWP낇methodfJDBC wwwseturnsn''////type.filepos=0143935(color="#039">Example 4-1a>hows (WQo

    ѓ
    Seelso:Oulli305668>UsO/҂30838WWGhrefttp://www.o.com/pls/topic/lookup?ctx=E11882-01&id=Jy 4.1.2GQ yͿBsQ_]93aymbedǾǾǾǾǹ8vant fo׼׼executǼm .mport( pist'#146010''>T>g؎>0?%Hey ErȎjava.sql.ߕtitlȂoo_oo"_OKDݽtdiltr10heatr𼑿b;="bottom")>ίthׂρׁReturnyp׃DescripV''d qerydr1c1-t4idzdzü\(StrQ)ө2 (2//ggbBoolea8W???'?3g''">RunsgivenQL,hichzssponse:rue s0ccessfullyfalHitoesotwׯׯׯН Batch(ǯߏǏǔ3ǔ''"voidoPquerdatar3c1-t41c3@"> AddsetfarametersoPreedStatement
    OOOH2???OOJint[]///gggbSubmity_\ythe baseorunning, heturn`nrrayyupxeunifluccessfullyǖǖǐzQ y(Strqlϗϕ5ϝϜResultSeככׄOOOOKRugivenQL,hi&leǡơ77777777oo7772URǐǨOO6ǭǭǦ׬סgg߱߱ߐHbe___XINSERT,???9UPDATE @7770DELE>Aathatnothjhẩ!DDG_/tbody1abl
    :hry=""or(z80%"="hsides"leHgroupxcellpadd="3A0(siz3z۾1 b>Seelso:?????氠??0@ߏ?qߴ$d 4.1.3
    c hs#XAoo}pntai2of presxabaseseFisenerdy ほieӂcurspo0oʀrQrowinh''''''6nitially,tposon!eforefirs".ou׍o>nexethodʽmov 䊬)Pao׻׻׻falsewh0anQX(sTypicrHsי׼׆rus1WWG__Ewiɵloopl ׼ǼǼNj׼Z7">T￯ǻerarovccesٖ+s (۪getBooleanWV,7''OKLong7gWW{InOg,ndon) ) v(umnalufromntow.aluesaneetrievedysingither (ndexumbofcolumnname׀.

    Byefault,nly(e ResSet

    Seelso:aߠݝ@`Xon QLypandʆ|OĢHbaXĬl0r'sNJ*Ref4..1ƄU@vϨKUcroll,ability#ers 1moPbackwardsA@thpghȋG.٭Ia#anyicularosiikGrelhꋿOgXstg. Y pecifinumbhrow/&rcurpowOGG_ |,untZbeginyehȋoojWc""ȎEo3+ygsensiך+ThPy)יdet馹r@alhangPmaP$unlyYdoutyAЅ򢟗2sP''whi(/Z0provi1dynamiciewM_Z.ÆHumnalub7eavisi`.Upda!u߃opA􉯰Rinclud8insen؆de!exisi_@y[Ud-only2SummarB Լ"̬bdedpr,孑ĸwo8ncҿ`bin$fowIsixategories:Fs/> -6GG76wewG/2ǼǼüHfx=0155477fo`or="#039">Examp4-sdemonstrs诸8dech23fcode>a/L0+i-2ą²S,PO
    stmt =onn.createSt(ment(ResultSet.TYPE_SCROLL_SENSITIVE, CONCUR_READ_ONLY);Note:orward-onlypda3retasorovisionosith0tarticularowthinhe N 4.2ueryDomJavapplica){DuGGBThisciscussesȋaBseDevelopero Xclassqhi OracHba8Dfollows@ CI͎Ʌ" &/R162295>TesrCHand[Kswv/3oi.1}wwwth?:tep-iPsimpQyrOxiHler.j 砇.fǰuǂǮCnot hntegd䗣nvironb(IDE),ou0-ckwnavigat0play_Scedi@AoCalu@ɫO׊׶/j,bW٭orϭϑx,sfbexiK߾߂ϻςϣA7774S7IGGGGGG>`BCes:heightb׸ז .sql.N;.v΄Z=u2pAFc.dexjeriAsP,oor//objȆa珟''fmDsql/O//3Ҿ9ype: align="lefttt#fontace="monospXbr/>stmt =onn.createSt(ment(ResultSet.TYPE_SCROLL_SENSITIVE, CONCUR_READ_ONLY);efin1eueryndriaressage. followingusesHsimpl:tenllrow@columin<1775Eoyeesgab dataorderedy‚D剃= "SELECT *ROMsRDERY,_id"Sys0.out.jln("\nExecutT" +׎8RurievsrOO">vOinn`assGGGGGGGErseAy.e2eQy( ϗ9/__瞏,obj~뇱WWϞ1a rork.romsn>File.5/olGGGpforO}getXߟ~methodhoulrhwnqfpos=0161396:or="#03(Exa4-3^a>t1>ރ&೏i-3sQCPion, , *,~ϒi)}> 3 kpublic ()H*SQLExcepY{DB(}GτWWO7׾Ͼϊ׊oб-///g;쓇}P;⯣ 4.2.2TesRuaͣB MwwISӽps,! ibJavalassoȽ2">DataHler.j2.ԃuseridϿϿϿp8 džVCrequireocceIϿϿHR/schema ("hr"eachse)ܽli>pe׽OOדד׽WזeVisualditfromAaviga.li2ChangȘGGe>,//''ta1O7ass:height="0"eYohϣϣ˿S[DA>-s where <@n>connect-stringSeelsoba filepos=0130871colo#039">Decla9Îion-RelatedրЈsan0912Chapter 3ن//m拡x+/lilialu4Cre(ewava PssthzhrXkage.ΑtClient,akBaublic3,ndener+defaulnuctaǜǜǜmainכmethod.Ԉpskeleto؟777nt.jDs(`display Sourcedi.ϨϚjinmai B!aOs______[4Import775Res@Sewo:߮ iq.sql.;O5I__ohHddceprhlZollowswO}4stcoidin(Sj[]rgs)rń{g60Reo//'$objР~by~with'WWSDataHe .ocɌx\=V{()?ߪ(ؽ϶ϹҊr¼@+r7o??7Def//wwgooldrsf///-getAllEmployeesqueryihgh9|et,zirsxumn׼׼׼Єd߾߾FNoooiLa?"ailf.oo"+YAٳ}Hr.wh (.nex) System.out.p0tln3I@1) + "+R 3=(2V__\3_g(4)T}8Compww/,.iϻfjoheckqbrrorsגr-ckiӜXEditorsel9<(nh>Makbromzshortcutnu.OOI:rX no An,ouu(spmessageLogndow77S">Succful7on: 0rrors, 0arnings unhe JavaClient.jX/.ile.ooiright-clickKAourceditorindowndelect Ntr@(ssage,ollowedyf@olumnsggg`Employee__ables!wn)pos=0168499@or="#03Figure 4-1~a>HdivG DataHlerߠbatonul/ol( cher(summary=""Xe1"80%"`am(hsides"u="groupxcellpadd="@Q3siz@3tbodyr!dʚSeelso:30871cl8Conn-RelatV ǰY//U>73?wz 4.35CrexJSPЫi݊gTHRAppn sServer ()chngisplay. rov@aw0c"-apetmϼXdyn@ceb`p`.js7xs轸fihфþaC hulxroc` aڅa0r i pretZag8l,eK,hquired,@KresulՁli*TML X8. +evelopPomeqall񰡵uѲʾ]besĂyd2V>StardW7-baڶhrHmponȒ(ՄP x.OfromNcustȏibrؓZ7OviewQЦpUq76107>aӴٌ߅7868ߐ">A tpC,K/80683?-tyXShee'O/$䒓 4.3.1 >y0׻Qd,reqd2wingasks:

    isplayata. BecaSPagqrees sTMLrML,ouanpntrolҁon!sameHwou@fxscY[.ك,8ndard;tago matqr,cluititle
    Styshee*defin.fDevelopdkapplicrsct(rom oWW">Tfollows(Zdescrima8N`ms˘ O(p@on_[filepos=0173426hcolor="#039">9TؑaWU4828WW>Sptgg17595">ʄ 644\FcE
    <n >4.3.1.1SPAȬhi>Xhrefttp://j.sun.com/pductsbs/m_XW蘧ymoHinmLnnPߚp//Vq4ضbpٸ ·qaarietyj.xr,h7PwwwrDHlerwwretur9'''!ResultSetobjec ͺظooohE__,hichAAy2M$N|qǔ8thghwwwWWgVaXpmaowa[ܣGGGGGE3G,HTMLԹ???ڢtypllyk!outndresentationfheondynamicorsusernterface,orxampleeadingsndables.nDeveloper,ouanragBdropԁyomponxrombCPalettentoArage.قmustpecifyumbProwcolumP1,jall؆!reutomcyreated.

    N < br/8h4>4.3.1.4HTMLormsFORMߗww">!hy,f 9famptу#utsidƥ@thatonoڅ̒Zxps=iMWWWW3WRG*C aiP03ǤǤǤfollowQstepsscriBPRs7a:ollialux1">1Awavioright-cHkCViewjIzhoofN_shcutPnu.lip2Dz`er@A@Techng>3Ex𺐼ЭTinȹ/CgorliP:f_>OF4GIh[FGG)ҋҋOKHIңDiaox ׏5O˦F Heeaamg_/wm6__\n(penL/RVisupE0hdyʡ$rxtexeڦr/򡧡3AۣStcp{vp#/-Prytysp P1ZOO . lsعHS8ce@B½y pDes(9bottв$ә ?!Ȏn__'e{qd.lankwPnϿ179341ϿϿ4ϿϵRF0GBai2/eoyees.jspF/ڗy6"oodifyͲǔlikHYSIWYG婏51ibc󓤨JG1@With ''''''#љ߮r,}topPnBAnyCorporon:RppFrȽystylԃh@theeft-handide,elect Heading 2 ithcursortillnhDyoudded,romnDesignW>enuAl79, nCenter3Inmilaray,aewinBEmployeeata$formattmWT3W> yle.ositiXЉόfpagx/ol1div`a a>N < 0br/`h3y >4.3.4%Ada'nSheetoPJSPЄ spdth="1"="">YcQsreferenceِro00s,extSo(r Htsreted鎉consist opresabfeatuuchsfocolorssWebs. dždžÉH]follows:<acmonoPce">es.jspFigP 4-ԝsh [(viouP $appli%ؠ0i'3SIc[ġiimgcindexp5It="crip0_"/H"!z"߄"*Ѫicⶐd tabummary=""orde80%"amhs"uh="groupxcellp 0`sizNoteP'ers!10.1.3,ZssociatpǶhprYCpWizard.ԿonlyifMݻ[bhsCloc9檆bP?yinHafu!gdropplʺ.i//5Əi=׼2+輟4Dynam:aaQueryesults۱ThТeincluȸdٟYsubtMuK?93189??>aBeTInitizHhlPClό&/185056//>[et89165熯T 7hDisplay҃װWߒ??83.1ϋi?xAwjsp:Lx8ntifiaiFc顳hold+methobhruoIp,490Xplialuppenemployees.LVisualditorЗ2Compon1Palettsel9༛Ks8cs.crHgli肌nUłn,޳rǮȃInsert alog(x, woosbWWPaVIDO>,forwiǁ=g777">hr.r/O2yb>Sc؎osessP,ndeaveheypeBeanNameieldslank. lick OKFigure 4-4howsrepresentationfuse???:employees.jspoo4.4.2EC)ingpsultetKT!steps2be ouXaddxelempArallߔߔߔݑgetAllEggmethoholdzsetata@atsPturned.hxquerydefiߙߙߖfD8HlerclassinitiXz byq`:'21OpegVisualditor.ɨJSPrtComponPalette,8lectwSJ諯>dr`Kop邠n`78nexʨǨǨUϯ2ȅInseV䍘ogox, Perlsٴ!,hichؗ"ooolproducدWWWQeobj:heighp0:ϵɻYܩ! ;€Q =sb߱();{WWRgge.ιe iisplay&asz 65655>縟7a POOO017OOO@OOOODŽǽoDŽ÷3SS"vc8_tab qbottomseȼ+hbec鰘fQ%so`Aavyr''' 8icxsS xaerrorsŹǮ4iStrucendܾy-h si@al8any?~.et컉exE>ۙ74466>s@w: QPe;gW@DŽǑÛ5xYouus(GGGXkTois,8qO OJgp iPypoP?<68Ș]r ߇P|.llips1ymbol (..))݋dialogj'ed,hich8825_-7д߹ߴ߼_߂ɑaPæbJDevel019-7 follows"/>
    Descriptionf "Figure 4-7mportingackagesnDeveloper"nhe邚ist,electHierarchyode,Issql=tnE&ResultSet'>.lickOOK8OSource5aminhhcpo@fC> 4.4.3}AddaablJSP@Displays ~p8dth="1"lX="left">stepsiHbeow!Ȏ@GA2ЍxFrsMWWWPgetAllEmployeesquery:ĥN2OInseHdialogoxpecifyWWWQ1//r1GGG@6columns.eavelaxtrtidefaaV3W,PܩᴀnexslAshea)each $:FirNamGn>,LaEmai׺hJob?b>Phػwb>SalarUs>H 4omak;`׸4ЫڵputhtimWsd8`xQi8W.Н?>top0rdڣwhȟmchangp}.ƻE=/P(Ynep!draâinҲj;9auto@lly.)篍5VlinȿмAheight="0"X70 B 3 kwhA(rset.n())gg{//.prln("<tr>");;td + WW;RxStg("f_")/s ψςς"lPǂǂǂNJߊ߅eggg//.job_idϊϐWϊp_numberߊߍ'Dou("s|7ϖp;}KǺws6p/ol0pidth="1"?9T췹reashown).aNס` `i8ԪnyPHz"τ//"؀?ć߇ڈ 4.5u&Filhqaueryesultet

    Youanilterhersfuebyertainarame`ronditions. ]also(lowsBfapplicaqoustomizedata,.ɁHsamplǁcreated Hthisuide,procedureɆ{ing+ÅsisyfoYZasks:ćminwhatpset hrequi{UspecifyKpexoyecordsp0yanPoiewqeni(field,vcasha!qnpONsearchxTs.jsp/ڑg ccepinpurougZmtrols0ndsseXt./liό2CkhodreturW#1lstЗ؄BSQLst0m(8Xlecsxos[cludsencchcʑńӑb9ꊸCnothirst:lah O3isplayO7__^soneadd ɡٔ7777777Чjruņٞהʪ's)desbA~r"gŤu a epos=0194436 Tcolor="#039">_ava͘AF{sFaǃww96931ww>Tes±QJ+φ~283>ACuJSPТOG02965>ω<D'W:JN
    <Щ`n >4.5.1f1/__GAll^ooC,prG:cght="0x/>oh4apub`$x (S3)rExcep{}[Յ77WibodyǬ´converӼaBppercaqoPablo#it=toUC();WWW4C7H"nIb'''7'%HDBpQH߽//5Specifϥϥϥɓntype _e×ǗǗǿǩǩǗstmt.Stment(n.TYPE_SCROLL_SENSITIVE,3 3 ?wWǁooCONCUR_READ_ONLY ="SELECT *ROM HEREPPER(_sLIKE'%" +#+ "%\'xR `DERYN_id"?נ߲C6@P ttrssXgSy m.out.pqln("\nExecu꓌ovalue="7">unheueryndeturnHsultetsefore: align="lefttt#fontacmonospXbr/>r=tmt.executeQA(r);+a; N 4.5.2esting҂>ilterethod_eonnec“QssΊXt0owwugetEmployeesByName'?m. amuad+oww?displayךlsQdescribSollowsteps:4.5.3MA2ƃCXtrolRSPлk0@accepcri9qд0displammodifOOOHe.jspp0follogtep!m xt܈WǾDŽ__YaR)pQJԆΑinȲ<1HWithhe employees.jsp ɄHTMLormsofjCompone8Pa te,elect 3?InsertJalogox, hdownrrow戈Ac:field Weavor#s ty click_OKOIpidth="1"lign="left">T@msO l,epresxbd-linectangle.O? !tYӔ8wwith܏YpSubmButto___776righ7|Ǥlo777wwvVѫ|,wϦwwww>4.5.4UDӣi# Data@ǹǹµ(viousX,oueaathaXccepQputsЮ,\c spfstrIIhich9,UZYalsoI"sbggǭgepsѸѰ-;ǹǹǙ.javaCabP 𜷼ǼǼgetsBy/-metho:k dlyf؍JsPʮqesulbqºr`nottiegAll~tO1HOpegg,Visualditor2Dou@-Ga>ag(Ѿw)oPiesx.od!ⵠ<:he!䭂 jRBShrset; Squery =xPst.0Par("")({!=ull &*D)&nbs20sbean9ojۃ\else'''#/es(<׽׽׽׽4620׽׽10߽ݾ V''oxam7ѼϼϽϼϼϼυsU?_ДZBox022a/>
    Descriptionf "Figure 4-10singheӁ"letropertiesialogox"lick OK4.6DddقσLoginuncalityojApp aパEpidth="1" gn="left">Thf߂used isample?sᆠexpn-manag(securp.tnotfullavaE mentj,uуan2.CreؗaethodAu0nteers!EON11751OOOa kP12854>PreparError҇rtsrad{__215672___IntacOOO219015OOOaSPHandAg/ڠx3.1 7͢~)I+stepscӟDatar.j(/lasshaxw8rsyheck(eyuy:idWWppwor_atchoseequirQdXbasxmaܱZGpe Sourceditor>29_*calُ___XteI__*rfϓ,ggw Xt i+arid:height="0/>ʺ //+pubooleؙWs(StjdbcUrl, k~,z 3HttpSesssC)rowsQLExcep{;r}מj3JDevelo8romp(withwav0nderlinxssB9Ine80;ig. Pelt+Eey(x.vlet.h.?gcϠ4Wbody xgϑ3wWgfAatbuчcurrpbjecsߛߛ߷߶݋s.=ڲ =l.e౽Gww5Atte connQusΤŧ3Xsuccfuretur3AGGG@true_nclq!1acyblock'''ryקOracle9dsp;dsnew wC()ootURL(T'^1pXgetC(e6܌yR  <`lemmary=""`r(="1"dth="80%"amhsides"ules="groupxcellpaddhiQ!2sizdSeelso:

    ornformationboutsing tryExcepBH(l(a>@ge26107gg>Chapt5>.@d> pr2bodyy%abl
    oeheaseher{logHcredentialsoot ch,fɍkHdd///O?OI.ԆHthis rints qaessageseupPrrqc0beisplayedusifattemp9ilsÖjdbcUrl76, idpassworhriisᐸxaq">nulȜmethodturns⟇fpe(o1, followYQ: qzNǒOJ0i-4Ʌ)mѷUV 4.6.2rePa7BagТMﵸps񡀂ѽ???">.jsp_^0ge, `whis zetailsKschemayreoto `kh: *li u1">ɗxViproj,_iJSP.hange:NamHogggg`andcxl﫸rfaultsصypensq1/HTMLsualditXȏ(dyyou1starddexxиonXsQXrebdĉo2hApply Develrysheet)3GivYh`arlier, AnyCoorporJ:Rjʸ,.H@Nđ iRрp5cof%4 O#nl,_#withg 3υied.r-XdidȆ/R{{PrepaEqex7}Fe,sgfwidth="1"lign="left">Theollowingtepsddunctionso(login.jsp
    ithepdVisualditor,osiburs`aft`text n,romJSP$ComponatXdragdropn>Sz
     3 kStrq2msg =ull; ok(+)getAtbute("")_•(GA!K)wbc3`Aanoiexactly{ameay㒒tison8apclbrp (''' })ggd/4Pletwe8w𧿧ŒoreaxaewX.ppHyۮف_5stillsЬ#OOOJclickEn>v6כǛƵש7Tdatas ddyou@be誟sctOJce7>abjshouappeasslt;% _OO7%>h4;z=G /'/_A/*pidth!Beforntinuw7sȼhs,eturdesiLbyt׺DN 4.6.PC EL踑(߈ߺrstepield0/ŝowhichsԵidetailsDW1A봏gτdpLGBdouble-iAYicPNaviga[tche`"{ɥed~2fd!oGx6HTMLƭѳooo6~W@QQdisplayмyada@d-Ictangl3G????z׸ц_a򴿸XѼsvAҾW>!XfilellpZproc8ҙ@puFǶ. (YXcanQХfromlis scpyet.)eavoremptY ^OK?8=ߢ4Aa7Table
    oheage.ositiontnsideForm.pecify 3-rownd 2-columnayout,acceptrefaults. n2first ofthree s,ntRollowings;extidisphrsers: <"UPD:׉p8߁߁߁Password烿b>Host 6FromJHTMLrComponalette,ra TField>tableellurigh .]Int ߋalogoxM i񔐁I/UvNam' prophy.eavfsmptȕclickOKg>7say d ǚƊ獘߉߉߉pSimilarlߑ"אאאhАǐǐǐǐǐǐǐ£8D?*Submibuttp$9e.ŗ___]_]QhV'^/olW/-You___Zin.jspwwshou8nppearـwxn Figure 4-11a>.divhN/"0/+hi11̆axgPiPqiimg(ndex@(3t="Descrip1Ts"/@r/Є၇B"ge"4.6.5CreatJSPH஘CAcestepɫ _aϯ?,hichsnonview2that cesse[Z (@S*1:ePṢaHitGF.ceptlefault0sփ2Withggg8jVisualditor,romoComponhlЌd˒rDiticN䆛In`!PdiaoxG;IrHz,rJijava.sql.ResXSeC3/sp:usebea|X@ϯϽOOO>empssOO爒D׾8x_selHGhr.Data[rClass׷cP''' sҽ?<,Kwww4Posi*)cursaf BjQad S Jgcɶ$<^x_heigh0دggcJboolihrIsVd =lse;RStrhostrequest.getParame("")Z(""pworGC gjdbcUrl"Y:oracle:thin:@" ++ ":1521:ORCL"뇷%.auntic0U(,,^,8⬏5Ano0C9t:wwif (d){߆߆߳g6theSPagefComponentalette,ind Forward. norcript,jˈyfollowingode: align="lefttt#facmono0cebr/>}lsejr8closibr (׊GG@})1Xayourork/olpidthX"WQToeP`(ataseene//(_actiogg,PlectJceib.Ԅdisplay8simila+:N˼ R >4.7NTм1JSPУ0__]tʶk`ilaof,gg <φnBAppl Pavigator,-ckzviewprojܰFRun׵׵YouaX mptcspecifyDefa arرh.ƀnowѳ(׼׷G. cl0rhantypertiesddr`tcbanyۍ"choice.þ_s Rbrowxhowxnepos=0224136color="#039">Figure 4-12a>Ԙ607Hi12̖bSaȔ71XBS


    "3nfilteredmployeeatan倌.jsp"ntringlet syhichouanto v.oxae,傒pFhNameہ*eld,ndlickg>. listsisplaye shown: < >⊺M 5UpЕCd]1 I)chap,ill󚘏ؗcmodifyspp(螈addunc0tiatsYedit, adeP Oracbase.ԅrcludeX˝yses:;uA*X`epos=p022708dcolor="#039">CRaavaBeanƗ134717>fromlass6408ȅnoRecord86((狏9823>ExceHlG//9847/">Navig SsAwϑߝ'21.1E&g/Нggocout8tcqhasropes8vHHmethodsDaPi聇,alsoaccessor߶߶߶get߶ߵ s縿>AnybjCconform"caicul)bҢطnopal/+0exted¡&ptepsxrw2gfʬi)HbholnghI.hea Aexs paew @exHݰQnghpvaluЇar a pprepa8Yu9ó: G''>Ps$dJfiepo93nDpldC ()wPseOY㕗R77subϺϺϺ228549ϺϺϺϿAg??3019_AfinvPGM󾯯3yYPxm.j??pRodifyٳ,oToSq>ight-c@kںһView ɝfromShortcut8nu,A&N .O2`alleryogox,l>ATechngG>O^3XEx0+GegoQT>TW>=Item8l.ɋCϘOK</b>. nhe
    OCreateeanialogox,nter EmployeeExtends:1cbЌ5Sav#file.ԍWP׋׋׋.hounowaifollowingde: align="leftQwws
    dr; [publass ?;kD()}b3/ol1Oۙȅ 5.1.2M'mDefin!J*PropertiesjMethodsMpidth="1",ouustonforachlumn wtablaccessm (ge">Ϣσ)2..ŏ!xpriv7w1َ @8{ߩGGGGFýtegeId'gcStr firstN wWXOemail/ϱphPNumbeOireϯOdždjobnoalary/?commissionPct_departײ_3XR-ckSourcedit@pselect aGenerAdfromHrtcutnu.HBialogox,etop-levelמn.hePmarkdisplayethatJ )alls.ÈBOK>.*filepos=0232259*`or="#039">Figu5-1&`wkthed8ʾ笒(i1DBoxExaȌSk`txCiJasicʾean#ethod׽|kIhpSp/, d{()__}O'oGǹ'//W/gg_7׵׾nj׎GG+nbsp; &n9privatentegerepartmentId;
    *kublicoidetEmployeeId(ee)??G}this. =/|W&}'wwc>g7w;returnτFirstName(String怍7w?_/]_בדO݄ǒǎw...G//ԑ`istaseenhortenednd notomprehensive.ectualdentains accessorethods`allfieldeclarinbeancWWWVDgǙwwu癗υɞמϞWWN < y

    5.2pdatADataromavalassaowAa Xabase 8l`/ppHXonequiresouooollowtasks:<facmono`ce">.jsp_8with6Ked,adyYO4SPwwwwww,Kaț0(a"aPngʌ{chanx_&5'3pro锌GGGGGGB{wri]̐ggggEjȩ琏&ݬ?KקקYwish{_secuus pos=0236772color="#039">zSModif@n ecord=40310oSeoA__51345>Add+Loavigȶ`PdžNJWW54878WWW˂EdžNJ60751_YHІA/Z
    align="lefttt#fontace="monospXbr/>publicmployeeindmById(iid)hrowsQLException r} ithineodyfPisethod,reewnstance3e (.TYPE_SCROLL_SENSITIVE,4 ?wWǁCONCUR_READ_ONLYD2 "SELECT *ROMsHERE4_idi +УSysX.out.prln("\nExecut:jbץ'''$6 Ru 3!uslًtarקּrsx= .eeQ(="7UXotturnȫ7708popOfieldsՎU3usOwo|ᬯGGGGGGEwhile (.next())?p.H8Integer+P("d"))ĞWFirstName>Stg("f_n؂HG(La??8lȂ7ailWTe/ PhoneNumb~p_nꆏokHireDЊj"h_h?Sala`YDoubl/|"sWJobȍ73job[}GGGGB8q" dtggggggg^Kpoook/ol1 Nۿ 5.2.2õ٠a͞yUpI xa onnectoheatabase. sPlogic`maggg`em_Z_GG@ph@_numb__>.cen@諊C <0su@ry=""erʢ80%"0="hsides"ules="groupxcellp="3zsizx3tbodyr!db>NotbhOnlifict`incluwithisocedurExH5-2Na>nnJmodp*//9OOOWWWPsalؽ''field,b1valu(Q//W/ssooooo׶׫on;WWW;! = GBS().toOgϫp;  columns.append( "salary = '" + t+ "x);
    henheholeetfhangesaseassembled,ecko`erre inactny=,atHe <)monospX">StringBufferɁ0ainsathX.fo onstru9QL___YUPDATEσ/statemeuspbinformationooooonandxecut tR'0donotՋ/)outpumessaghayso: <eight="0"align="leftÔif (@length() > 0 )|{ 4sqls"updmploye8SET ietoۃX+ ׀wp;"HERE_idɚdkwnSys..ptln("\nEꕈ:btmt.(Nj5}Njelseo@NoQdodSߋ'/gRWצ9Returorducc"./////,r;׫׫׫׫1aveourIk makerfih lnyxrrors/olpidth"Ǟa pos=0247494 Գ or="#03Exae 5-2NaojcoP histhod.public(ifirst_name,woGO/ϩקvlaemailgϬ窇/7׮\phone_numbersalaryO'/gWjob1rowQLExcep:׶ݷgdold.=Xn~ById(getDBConnec(@(n.cre`Stment(ResultSet.TYPE_SCROLL_SENSITIVE,O/ϼ׺wㄧCONCUR_READ_ONLY犿tBufferhnewԀ( 255 o~if (e !ull &8;*O!w.equals(ee.hFNx() gp;\.appendב'ѡg8"燏(G;!.L0W獥.length8> 0Ǿ ", 'ǩň___ "TOOթ/;!’EGGOOOI$/ߟ߹ߺ!er׬ǝPNGGGGWW__GϞoend( "phone_number = '" + + ");
     3}if (alary !=ull &am)  ?!.equals(ldEmployee.getS().toString() {ςvcolumns.length> 0dž*appeR, ??-wGG " d|777Nj5job_id77G7o;!Ӌ771JobId׏׊׊׌_O׊׊דG׍a4_%sqlkؚq"UPDATE msET`+G7o;"HERE܈do_System.out.p tln("\nExecut:tmt.ee(//elsegף煏Nothtoo1updatedSϥwWRreturnuccess";N <0 

    5.2.3dd1ainkNavig(pUPageInheollow)ps,ouddplteachowfsableS.jspɁ,atsersص(clicCdith.ϰoooooliVisŃor.hli29extradisplaysetails.Ԙchipositicursorelastd,ight-Sandelect jTI㒛fromshortenuInptowsrý>. tWs Talogox,߄܂wAfterӆ/CNOK7 3T@oiC aUJZeadsXrf.Řssjparher9ed7recorHb(eddou@criptle|xinsidGGG@fǜ'񕃡2SProphiPǜV4PModif inclupߡߡݚ@mi/ ulX@de:[he9="0" ߽߿whiH(rset.n@ ())??ǽƿϿ<tr>"WWρtdʻ//getStg("first_name")2/sǽς("قǂǂǂǽ_ׅemggg//.job_idϊϐWϊphone_numberߊߍˮ֓oD("salary°Wwߒ'z__X9aref=\" ?Pid= Int(1'׆G;"\"9zau̘ל }K'M edit.jsp avWWWSs(. Figure 5-2a>howsWWύwhent run isplayedarPer, ustratinglinkrsanlickqIdivN 5.2.4rea7JSPЙ7DD؃51ߌIpsec,oucâꝋabD`PϢ˝:1ew !ʗanamtpAccepRXrefault 7420Gi0 sAheads liYAnyCoorpoon:Rpp*,y H8Nty1ocent򅃆3O#nextɰptyp>RZwithg 3߅ied؅ډ)DžǮ"4AddGJDeveloperMsheeވo?<">h:bea𺯺tag.ŌﳛsG钀WIDgahr.Hмo7ClassSᔟb>Sc8LJosessz;OKϻɾ6Posi:ursorf9BynKTYtiPkؾooξs1sel_cqleayC׋׋רW7OletoTi5 hsID 7770findByIwumethod`triXa@si@A foپaBiInPt-dialogox: ׼׼
    F*N WϾ___YLaOail綟׿׿׿PhonWpace">Job, rag <@n>HiddenieldXy<%= .getE4Id() %>DŽooVɌw2Textisߌߌߌߌߌރόϖf_nő܌njǕf`oooet?'/+.lickOKOGG13G܍oogg La___OOl؍??w﩯ߩߩ"]wwww4x`imipay)dJseachremains,s___ ail77777ph_numberGGGGG job϶'!߶GGDs'eC 1 (Icorresa ImethodorTheser0pecidfollowtabl5AP>Submit_>uttonrm,eعEwǾǾUpdatIitsϰO6Sav(app@ationpidth"lign="left">sultadit.jsppaghoulooḱw
    Figu5-3a>.5.2.5]@Hl؎Ӎc)sh,oullHIo㍩S___Xuz_a?àTprocess ''ϔÙghatȐѰHerpo {qorC Anoisuallems,_ dlyɆԺG??ן׼g\ireturnsntrolս///sw21ew"ZcHߐ߻.XcepJxrefasJ.q뱀Wizaѳ2Dra"DitivcomP8rom>H!CPalqț e8H)gdialogoxrPji`java.sql.RSeCk/OK׻3ǃsp:HbeaԻtagsۿ=ID>,bhr.Datar//7an>Class.ethe <Scope>o session ddᄿScriptletڅpage.nterbfollowing nDInsert ^ialogox: align="left1WWS
    IXghemployee_id =ew(request.getParame("d"));bStrQfirst_nPP(""1߃σ"׃email|gBphone_numbhWGA/ergBsalary'job("sbean.updateE(gd.VQ(),e,O,,x,,ޒڗ5Dragb>jsp:forward0H.'tƁx ggg`s.螗;P>rrtyמ6Saveourork7Ru`ject2ther andifcord.ãE@׆3anyo gggy!shouldepte@wn
    Figure 5-4aXModifyofdetHsche`=chanXreflXsqWWWWʆɅE/olpy>/z"'??ta"+yX?ԇ" 5.3%&٘؈RýЃ-1ZTstepsi߶Zms(blePsimiroces2:r7reة@hoߠdow׽ޭr2Addlinknpp ؠъu@Qc:ﴹ. )akݧwwwp__YwithtymXadZ_@=9Gf37aSPkɃO#4o?jcromټ҇Ѧ//isIcov"!JavawBdH={AsubLsu#5637>;Më 963">x;LNaviglP@oo77488ooC HvA70732E N'b3 .1HI i,ou ll#G???;.Ope''"r.j__̚Sourc orxDec𲇪⮚Gheight="0ڽʹRwwspubtrdd(first_nam 3laLel&nbsp;Stringhone_number, job_id,ntalary)hrowsQLException
    &Z} ddineoonnectYtheatabase. <eight="0"align="leftac8monospXgetDBCS0()ㅷ4CreateManagerIdDepart7>)!tainard-dsasapplicaQ.`/r/FرÀ=5tressknngg6Return<0ays "succ"fjinserw ful߶7Makfiheck"syxrrors/ol//a Zpos=02683860Ro#039">Ex 5-3^a>h vu()?method ؝܅hN5.3.2ield,nd InsertmployeeText|.ouannotrowseoX///+i*.jspashave yetreatedt.lickOKg>. ӂaes׈׊/ol1divPa Pa>N < br/Ph3)r >5.3.3Cing'aJSPagEnterewataۂpidth="1"lign="leftiQsteps,SoooGGG>,hichlsAedetailsfecord.Thiscedusffere . mp romHTMLym(ageTPalett?88߼ì_1`|Insertelectialogox,nter job_idValue HRQ/td2 (2*HRolↃPr3"P">MK_MANߎ4MarketManagerﯟ5kߑϜǜǜǗǗǗǵwwwpFI׵wǗǚ6ǚFinanceǗ__YIT_PROGg7oftwareevelopϝAD_VIϿ/8ViPpntJֵܾ br/@qliliCp2DragSubmibuFbw"".ɼInsert #dialog x,'''qXEmploye(WT"prtypaSaverork6/olp6"OH>
    howsۂXi.jsp_pVisualditor.5.3.4%Cre@PJSPЋHandle AcY;גגҚ seteps,ラIǺǺǑ-_age.his athatycess!mpurom׾,hich usaewHordenoelem sIt9,d ȇonlydW?ק9returnntrol7770soڢܤb18B@ asp(Callwwwp摷 α>:`beatag.1s[凈ߵIDo`wwwphr.DataHandlershe Classo session, lick?OK' osit cursorfteruseBeaag ad GScriptletgJipage.n]following nDInsert ^ialogox: align="leftiljlj
    Strfirst_name =equest.getPar("");g ߁߁"׃emailgBphone_numb`WWQ/ergBjob_id''"I8gsalarynewЀ(//("[") kempsb.pEmployee(,?,,oh,,t.XV(eF4Drٜjsp:forward.ȕtƁxꝷ"s.ל5Saveourork6RuӣView>rojec蜰PheXriaUcord/olpidth="1"To>n&,u" UAa ahow filepos=0280104X:color="#039">Figure 5-6Na>.z"oom"3ɑ''5877>j;@87*' dthohz(led蹃li@se oelaa3ȎOOGߎߎڀ?I76{ 5.4D anRBKȃ%(stepsrsimihhoseZedil)]:;j7ՂѾhodreatBߢ36772ߢ>CCMCId0ifyوiV cuow.his 9b،e2Betthats6romœbas_\3XAdМnkxaappHа0Jach@˾hCޯx ak-aϾϾϾɉ;_aca,!IDo@wҔ؋="4pǽ74MJSP鉈s땟S 2s@discuss\itaskslշ9 u Ǽ2286ǼǙ٢ w΃/5293>CL,X絟/W87580?PHlA/3.1?7`?7'z8yhwwsOpeȝȾ5r.javG7nheavaourceditor. eclareewethodatdentifiesemployeeecor oeeleted: align="lefttt#fontac@monospXbr/>publictringEById(iid)ProwsQLException r}Exae 5-4a>h Air'&).}WWWӮ/olak 5.4.2irink9 eeeuߤ߿"Ifollowinstruyoudda샴each s8abH߳߳܁.jsppage.ÞkatCwilllata<` 1Open??ϪiVisualditorgc2[umn"Cdqtal1,2anor!ٻy)ooido0e-cѼscriptisqigDz,qdisplaySPropertidialogox3Modif @inclu'aOOJE[_ajgGgT@m)i(uldǶ:''''$whi(rsnext ())ooѶ77ϩ<tr>"Ƿρtdʭx;("first_name")h2/sǰB__ςlaǂǂǂǿ&nbsp; &:rset.getString("email") + "</td>YS "
    3ljob_idGG"phone_numberׅwwDouble("salaryB ave Hloyees!./ol1y
    N <@ 5.4.3reat(SPageoHandle#Z pidth="1"lign="left">InheollowAsteps,ouxLjLjLjWT߈,hichsatnlyrocessesperher` noisual mentsP).,Jhr.Datar/7Class7SetO)Sc(OWWW">8sZ$[click?OKW73ׄript'ڙ2ŌI XCInsert ^ialogox:+height="0ٝ/(ѱeg =p;newp*(reques"Param(r9(")U.+EById(/d.V1(ͫDragorwardromrCompPPa!oᙿЁɹ D]7־Ǟw5prork6Ru;jecttrynβxfilepos=0289356color="#039">Figu5-8^show#linksr_ecord0iO8̅+72iHimgindex0034Desf ߷s"༃z"_6"[A/:fk{>*anyپ?;,Aihзbd-cb 5.5źExcekjط<݈ߑߨA_a>SQL޽7obinstancvidesPmandHbasecchrrH8Pys(achϽϽϽɄ>mqtypؖxn,cludtrxba,hiisseJava mHpvailableia//-MG_ho}TxsaHppsxϏwQWW">chblock aNmechanism:XbWithf(øXrAe2neeиoet.enerallyce">catchlock eshexceptionndpecificoursefcinventn,hichlHimplyeoisplaymessage.

    EaXJDBCthod`rows SQLE''ixatabaaccrrorcc.ƀ`thiseasanyM appli8that@ecutsu(amustlPon">Allssacludq(f0zing熜ex,ʊGGG@getonne~Huse o c9J7so
    nsub8߬޷:777o777777n _; tryG'getDBConnec()wwp;stmt =ׄ c.createSt(ment(ResultSet.TYPE_SCROLL_SENSITIVE, ׆_?6wCONCUR_READ_ONLYWNJQqlString = "deleteROMŎ,shere厬_idY +p;Sys.out.p tln("\nExecut:: .eJe(77op;return "success"r}הratch (?8e)W7e ckTrace'_w> 5.5.2×IyaethodorHandlqAnyg`AsrefinZoeodebisaeppli`,ouㅀ[mthatbesedntighP<9挀="monoce">/ɋEK 5-5ddǏo regŊA GŶDatar.java_篟>l.@r2EzincluسtryﻈߵW߰s3ϸGϳ̇⼃,u????s4pF>=¸oooitg??teme,ssagedGduas:ߵߵ߹ߵߵߵܟ/°D| 5.6NavigUSampIk<ma^">web.xmlOfy ]deploy2descriptZ@7on.neecR___o9usdefina1rt𓙄Ѭp1ex:"monospace">
    <web-app>...nbsp;4Blcome-filen/p; myWSFH.jspww;/υi Ifouootefine Tagen!r <90=">@.xml7Y ,enerally)thheapindex/,Kextension___.htOOP777܋O'Ïq7if9rhsnX@usedsstarting.׉JDeveloper,*canwhichoe:aultun ge0licat,atXI,o 7(,isplayhfirst,ySi@Y`rYtiekject.inkhLmHTMLchagpl,uidentifyyaSPk`뎨Ȉ st . submbutton`aYFsuؔxernew1changdataa>___ਨ:ward{3execuXY]ɖ0`dPquؑY(oeXHjiagaiok/R5 < I

    5.6.1reȏyӟMPٜ鞰A[ehortcutenu.hepplicationunsndKindex.jspwardsouirectlyoRloginage,yjs splayed ؃rrowser.

    <n >6nhancingA:dv؅pJDBCeaturesThchapterscribehddialh[ithatcHusenJava!Somefف@fveotimpletÓ9saonsNare S#a@ropermَĈ߈߈߈incluJfollowss:#ulHlipHfpos=0304313color="#039">UsDynamicQL9/r312838>CallStorProH߂߅wu32950wwtCursVariablDž2?91?8.1M+wp/xWL, gener@QLtatЏrly, ahnne;a du`vironi.eryteespeciy=matupd o@a abasHiqu񥠚9knowXntilIimߟFscenoseXypmilari@withffx0Salu(mus1dw'q^@-OraclePrepXdS͵wobjex؃¸www">Ǹwǂ»)one@ubstituipb\.٩alsos])ǨǨǨxj sameϱCidalik۝Lheight="0/>»OH??derheollowingxamplefsOraclePreparedStatement
    E6-1 Creata iheight Ȅ@>jgaQwws
    ouanatchpdsy8m772|object 6.1.2
    զMCCallG 072eaccessxo cedur9n abas__.hXWextendggǰǰdžϋϱsistndardDBCscapyxcwu.maY!xwithrBoutular(X.owever,fdoʁ_]tubegheasUTWϼrߎb'J8ϽϽϽIN'&,߾͊both.3o夨 Щ HhoXinXitfrom7OOǽoo߯W?׎O7777`aXXXA///)ϰlsoIuriH'''!RRSo>bjects׹0exa,cre`WW''ͻ_[׻׻׻foo')follows:sdiv?"0?:ja //Tbr/77Qs = ('' )ڼ`n.p 9("{(?)}");zApas)yr9''' bar''пzinnӬJwoay/wwww׾׋ws.SJ(1,"X8 //DBCardҀor...ρAtN(X, "value@tensionו֖>

    6.1.3sing BindariablesnOraclePrepdS-.ɆNsety(򖗖">pOOOIXXXg7ןׇ,hpggggdieavaataypefʟۧA8depen؟hcolumnt1accesڪ(Ibase/div?= < h2dsiz`+1(.2myS#P%Lpۉ#DonnePvity (JDBC)rivsupport󊰥anonymous\TwckyxmostFscaЁCڧͨouwork#anyR3:ڧ0i>Examp6-3WWUA]height`i1//[s1 =qn.p  3 ?wWǁ( "{r (?,?)}" ) ; pOc:2׆'_υ?Ifunٝ3njoObeg; ;OJ4OOOO/gהn ? :=ߌܽ͛AA|ȹĤ,ೀa~pnippeacre׫ on Ђychaterequenc0cnuffixotﳏ_4Åa߳F?????>{r (l؈foo (1)returnzsz n1| '{';7777>You th0ߎc@agramsgg׳ggg`5fwwWYDataSourhodspnewԀ().setURL("jdbc:o:Pn:@<hstrh>"ǁser("hrzPass8d߲ȷe0Hτ (xoo(Fcs.registerOutParame`(1,Types.CHAR);
    cs.setString(2, "aa"executeUpdate(kesult = g1Theollow!sectionsescribeowouansetoredrocedun(samplepplica1isuide:CreaL/SQLӄ3P5)JDeveloperfa/j320122aethodoՇQ2726">ArsaChoog30483>CalloWromAW/J :N < a

    6.2.1 @/ݖGPsc9e=xabaroughDNaviga.ɘjBeps,ۃa畵thaXЛHds @alHn veayf(И#nPoyeecord.oalue>elXʌ9~N8Í Aview u2pEx Wennsode (byfa!c(C1) sYobj@<ɡfac0monoce">HR3Right-chks>,d؊vN(74˘e=dialog,n {_MXg.ÇwOK//.sktqrg@displaySourcedi s5pAf/സ:hey="0"ͥAWP //+PROCEDURE  <"INSERT_EMPLOYEE" (p_first_Ɂls.%typ8Bp_la_/.#emailWoZOgbphone_numb?er/GBjob_id;_.3Wojsalary/s.3);W6WBEGINϢst8mP,AdsNULLϥwit ////WW-Gp;NTOŖALUES (S_SEQ.next, '1}er,YSDATEkWQ,.30,100,80);//-YټೳH"彁eard-Ad3a(ʨrcolumn7777">addmethoָiHler.javac s7d/rENDǼǙ߭߭ߴ߸ww݃p׸7380Savkfilchewh#panyXmpilatierrors/olﺗ etQorϺshownIn 8steps,oudd0m6DataHandler.javapsatbesas xaltern vPu.ԉnew%hereakP@fWWWUχOJsp.electJApplicponKtabdisplayWnavigaH.pliW@2PIOOOOOOJfilesotxdypenؔJourcedi,ouble-ck釘ot3mporܓ">CallaStatementinɓfollows: height="0"ŜWPi.sql.ggg 4Afwwww,derfo'??SP'pic0r SP(WHCޱ߿΂\ځzs\ǿĒh )rXQLExcepz{ }嬿 spatisyBɬ??졧5nsidxtryblocknd1at,onnBsdhbase?Gp;getDBC();k߾c6ri,oojcѿDQLH1ǥǥǿǽǽǥť`= "beg8hr.O(?,(end;"gquesmarks (wwwp?'&)sᾰbivariss ceholder)ۼsfOϿΣP">ǁsnxped[sЀpprocedpWP7PCwwwϹϿ~'''''77%_cstmtA.prep(()߾ǹ߹߹8SeϽIN xsowwwwuGp;.set(1,oe߁(2,o//-3,4,GGE5,'tInt(6,e'#9 Atrssag ruӒ9nt. align="lefttt#fontace="monospXbr/> 3System.out.println("\nInsertingithtoredrocedure: " + gd ?wWǁsqlStXg);wtcallstmt.execute($ Example 5-5na>ǙǙǙǙǙǙǙň (QLx )ǚǚǚPossib(sourcef:akouave>")4Wp;on(/wtfailI}////+2(S!wxDataHandler.javaGަ؝3/ol`pdthX"ϦTco!tethoshowngg32571ggg6-7g>.Note:6.2.3ll[UHsohoosehų1dzT eptIsadiouttgroupټ䨛.jspopagwhiaa(cbetween`mecord/+,ryaaue@쿠d1ol> pen insert.jsp W"2PCteewinXfterImployeeecord肠ing.ith"cursorق\,rag UseBean, t?ScЋosessioד \tillLed,~stylĔ"GNǗǘtIHS 3>38D Routt7cnHTMLormsgeid`fbov{tabl`I܄dialog, SPϠϑoNam/aϣϣϣfals磧GVFÕvheckedǒPClickOK@_4ܧpositOrightbKtexoescribpur>hxaP'HhlyDBCɭS4r:'5PraeৼPr5c?6WsHbelow3irs ɔߔߔߔڪϵ/7ϰoϸtrygdzGsurĔbox}7GϔGGdi`t@?sxprocedAcallviaGE'ǩ8Sa/olpidth="1"lign="left">FigI6-1a>hȾc.(wrbvSopoЉ.6.2.4CоApp(ai772TstepsXHmodifXٻ%_aҔ_GAi,hichsspmgGGom,=ǗļSǾap@primethodC{YeoyeXB1Openװװם߉7ÿ?2ouble-cJleinvokƜp ad vafqalaryֳXs: heYy"StrIFl=8quest.getParx8(" ");Ot׶3Be,xillm///x,plexi觘xsbean.E\heצ۪s)GGGA__ľ@DeC׆w></tt>ethodonsertheecord. align="leftfontace="monospXbr/>if (seSPFlag.equalsIgnoreCase("true"))j 3empsbean.addEmploye((first_name,a^email, 74phone_number,ob_id,alary.intValue());//PrwiseureDBCDelsewwwwwwwww ave <ꍟk_action.jsp /ol8pidth="1"Youanowunapplicandadiouttons ypag(ohoohxywanewH[nIProw8,:willyearsn` Fig6-2Na>.aNojb>z"wׄׄׄs"ₛA?l/*k

    6.3Cursorariable8Oracldriver8uppopcv th"REFǬߪwwpCURSORgtypes,hich᥀notpaHѦsta G߭߅/ׅ///.$ږuletsAߎàldmemoryo (aueworka,X طcent[1.ec aoc@tioer*SQL,袨data﹇׮׭GGZx[{翭ex7Ͻϕߕi:f_CERENCE7wooodždžǴrepȎ*)pityerefn.b8 7Thn,dafijVi.ecamany mightxisҷr8'''1bIou)@eg8?sptdifࠒPoSO??OO窿esiallycapPaßҡL/do@1returnP Sԏccہbyu,ou YoooSooo4'OwwainemetaO(_߸ߺ>)GŝppaetweeRDBMS li,-PL/`Java MbasHalsofromaor@prouredivcer">
    Note:a 337468 >AccessingEFURSORata
    Uinheamplepplicationgf/ulkN
    6.3.1Toreursorariable,eg8bydentifyaYthatlongsoj^1/ǁǁǁ[߁ߋ.ƅexz:dept_cvĀ@C:... φhen,i declit9befҌ2_0ωXi>E 6-8DaOlhodmpiolass.li/2(TdnlI\ntlGGGW{ϋ3lwayᵌp;>Mmust@define醐d  GooGϿ翀4sun,ϸOOOWWWϘ5̻7WaЬ`׽׽׽ЦG'G@u쾗a>N׾כC, HchA`tensindardDBCpplicapgmerQ (API),߹̪oGospace">ResultSetbject. 0ol1divha ha>N < 8br/hh3><8n >6.3.3singEFURSORnheamplepplicationIfollowsȂs,ounhance:s;a?oisplayynamlly-generatedistfobDsndbtitlesJfieldheresertaewPoyeeecord.CreXPackagizDatabase΍K''342935'''aun 45458>CPrompMethod''GG49599GG>D4ǏLon/דדToi\c]f\, <<Rf="monotGET_JOBSon, atspaWWWšϞϗretrievQr"s󜩅sle.JavaZ777get*sz ϛ4.1WWWSz4gatepsϡ gegPhogg߮declaث0lialu1">elC⮐NavigatorNamԮvi@it~v_2XExHd_Conn;(nɬ囖s.crw*Right-cHk߀w>Bs;Nl>ϊ&3 ԭBeL/SQL^dialog,terbPKG__ae ؛CǼ)OK8defini*+xourEdiב/="4(Pos !cursor He(irHйpsŇ).ŀ,Ѫ???O[s:heq="0"0>70ǭǭá 3 kTYPE f_ISR;_/5a̠f/''~٣xshP2623>Example 6-10>:+__&0'iwwwti@GGGGG>PACKAGE "|"SENDWW;.2Ƹ꺨om???8GET_GthusesWWWWWW\ؿjobhrom#xoole??;,gaeﶈary:GH׾׸6//7774~rtcutenu񔝷ǸxǨ. 3F6,ubstituxGGGPkg.tt>sheeturnalue,nlacef VARCHAR2 fterASkeyword,nUfollowing: align="leftdždž
     jobs_cursorʀ`Pkg.ref;R& 5InߊߊBEGINǍblock orPxnt׏׉COPEN orOR?,SELECT9_iAtitleROM򊋂p;RETURߋ6Sav{function/olpidth="1"?9TfishowH`a filepos=0344992 color="#039">Examp6-11a>.qNGBb>FUNCTION <"GET_JOBS"zD'%jASWWT疯疿ENDקϟף;Z B 6.3allQREFURSORromMethod0setepsIe8JavaR,getA߱DZDZDataHandlerߴclasa;oooh}o_ƨtrieresultet$1Double-cliȸ.jи׭(ope0tSourEdifsotȞdy2Ef;e r@ooopXic҉Set |()rowsQLExcep:{W[}3WithĆbody,nectdbaseDBC()4Fff,qnewriaOOJqueryoooooooooS = "begX? :=_bnd;"{5xѧAStPmepusmOߴߴprep ?/'OO_OOOaStmtx.l(=Dzǟ6RЮtypef?OUTaxer,|Orac specifAעע׳ײ_U.rOutP(1,|Ths.w7hyou ywaбXuh(,D(l@risplaysmessagskLAlt+Lomportwwwqo.jdbc..жhs?,dnlY<n@>@b( (yϽ)romrlappears׺8usur˽OOOOO׮ד~executeݯp;r@().Obj`(19clo@dehedo r a?t>lockߺalue="10">ddatchlocko|anyxceptions,dHllourogEethoHsell. align="lefttt#fontacmonospXbr/>(QLex ) 3on(*;"}R N0

    <8n >6.34isplayiaynamiyenerd̍XuseBeantag֒̄_Y aHox,7770java//Langu8>,TImporCfield,!Bsel0!.sql.抯>.ÑOK3scripP׍nextwqSd“Юd,aȼћP`ainۤ_bتhe="0@oh773򳮯Pempsbپ=772J4HSBoxgHoHnɣ]*A$&_JSPÂVPa`t((Y`ne!d Ϟcase.)ԯO/ppearǨ5EGFi=// W????oo=p;while (.:())߿ǀ+out.prln("<opL +RSt8g("_id")">!缊/Q ",?}ǖǖDZ? 6Remo 7slpdthWqϳ/ϠPtillteuce8ndow9Hɶ&ϭ.xamin󢵆gseCSkeyworDЧeachsuatЦ(Q.Fig6-3:ctureiewfropdownistBoxptions
    z"truc"aveheage.%/olpidth="1iign="left">Nowunapplica,Xkonsert8employe`ndslQdisplayXavailableobsfilepos=0352775 >4h@*dynamicʄi3brXer.{xRM"07ÂtingMaster-Det8sJPAJOrac ADFCݗThishapHbes 8caSdSOn(`JHersencXPI()9=?evelopFramework ()[sec:u9'$4774''>Overvɋz_569xGF JthOH 61286>BuildADatxodelKEJB 3.0DDiag9p7475">2NProjp@r UnfaceώGg76707ggk]PƳǰ'7905ǫ'ǜ_\SsG85252GauerP0Edit//8178>Runnw/ztcey0Ctsummary=""orde 880%"="hsi"les="groupxcellpadi="30bodyr!dwte(T@,צ׫#asd_,ouuhavyst ବJ11bgStudio/:/u⵿CN2OI1OH.1]/𳿳A''Tҋdfromed bstBspime.Աrecs}beHalorՁx)<.frovisȫo坡ŅbtnÄalsD_bo 1dtcommPcpsx`/middle-tizmponsxp!hg#inlayZL#HRchemaXacup`edAnH5cPm9?&.O>) (UI),YٕHfPset(JSF)s裑qXInlwill٥a!??GGBɣo7ϫϫʛggg_}ɐWWWgd`reaɮxEMa-V -Cror (VC)1 t`easilymplemhsܘ A56372>Figu7-shѾBpship8KitemQ3d|Xapplication.

    Figure 7-1asteretailppagesHR7.2singavaersincPI (JPA) ă(7ǖØ/w? Qnnd-to-8ǗframeworkatuildsEEtandar@ @n-sour@technologiopifyJleriQservice-ori0e(s.َFchprisolu† search,,,od,2vpXu:web,rssesktop,rقsٙHUsin0m, 11gۊaWive2Jvironcovful@ ecyaʘS)@drag-X-drbb,isualI 3teaofs2t-i7Ǥ4RIsubsecc0rodupsome᥹߄_wiؠ 7n:kullifilepos= 0359082Hc@r="#>y/567FƓ)ww60718ww>QIïXrol//:ɹc"v+ssummary=""orde80%"="hsi@"u="groupxlpad="30pbodyr!dWǿW>Selso-ǷǷǷ8hrefttp://www.ob.com/y/pts/adf/p _11_aview.]ׂׂׂׂׂׂ֓GOrrehXmS1iW Pex.htmlolψGBampil,f 2_/://V97.2.1GGAЂ-qpart>pecifbdealsobj/"`m2pbetweenbasǰىv'$cfGCIZqueryanguagOm"/////.2=''/ d 1'vaS@(JSF)SR 127߼.7 onse!draerYyJ?P/bGanyDESsupporȅggg">YatoerminookfeelZy8allowsqfocuacrarn?:!lia.׃isoulti–ޜQtrans\iem@aXȀAacsibility8a)߹߹ߡDevelo@ vrp8(ols,XzardH(ogСqС`editorXihelpZintɖG?ps. Forxample,heisualditletsouesignsernterfacesyraggingndhoppicomponenfromCate.fareamiliarithML JSP/HT`cod ,bcanlso(sourcefpagxiltoptDFƅags.

    N < br/8h3>7.2.3IDataxntrolsOracleZdcerm\applicationli:ocpxusinI8vi defdImodelbjectayer. bXny@ll`p,alu0aatrproʃs.tuntim)Mead(inform`crib_Y1ؐq܈riateӔqim*two-wann0tweeQezǑǑǑ2>CYzP///364021///Persihnr//67148///ǂυψ71562>RunnMJavaӟutsidEEba8ol/§略.1nBee:cexdK5mar@0l7musuGe>ƮYF8 ;pu,7New/ispa@ryHGea(7egoryWlnׂericׁǯ.Ծe _wizarHHed.2EɔWS_8_JPA_hafookoracyO?Packagixo>,kNpwL3H܆cEseס???">رW/>ߒ#on4Navigat e,ܚᡑgpab.? O7ID2|s t2draIoptIٟJ/+nmak ile Sn^/b Ynowav0XdOOϛϲol,hichMQm'ooo7_\/_____3.2_\Pers(ence mSwillUp/|YϽϽϽhr.Departts)׽׽ׂ;Employee/us 3.0qityansggcJDevelo0'О^nιϹ'$OO'#n>Fileenu,elect <0New/>oisplayhe allery.x@dBusinessierw>ategory, EJB>.nItems>ist>ntitiesromables.>lickoOK YS#(ersiondžB 3.0 --PA U>s"9v=nNext@skipPstencenitage4qTypefonn(hooseωZnlataba聧>p2acceptdefaultff/)name$c׈W5GODetails275HRwc_us'?6KQuH!retrievavДbjxorHRchema.ԐmoDEPARTMENTSG OMPLOYEE+/Pedw"7uis p,akeurpackQ oracAXI/ooon>gKFinish8Right_Mhl>ApppaNavigat8GG@9y_ߪwO߬ dou .Diagram (8/)ǩ??10CrePbUdialog,ant@ӄ?m1)G1/hifyߒߒߒߒߒޔɪoDZggg11hOssociAuWithִgropd (///(.jp(_\).Xemptyopensmedi琯2Ծg9epartment?LmployedragSnLL.eorganizklayoutHoabo&horizXligned.ӁI Hrork/ol@div >7.3.ing In1oj^3,A㢛a0ssbethat@eZmethodf"ords.{)Compon۔N letlibralɼMNPwSB>ブ+wp ЗgeTWizar#s1܅A!OpɿseHRFacamake»Ifollowqrer: ransab߾CxO߼Gewn tM3checkPťyɔڅ>#8/+w߇n/RǢ/*gBNext>\3Exnn|s׾AllByRangH?feacNextFinish>. hsabeaHsdepreeiles:HRFac(B> -oiʂǂcodeHdescrib臊apabilitip,"q\eY>ikc.

    oubl)Eoyees> itydiagramop0Rour az7370Addco@ Hie@t <>@NdQueryz
    )Þ;=8oMx>Bompӫ".j//$qz|MageLog(ndowo`(portyrr@Gv9pR-oWWWPn9App0aviga\ditӿʴHexhenu׻1xh[ߺ߾Zlog. new dTOOO?@pexposjhod. XAOK>I ºŅSsb /oloa /a>Nd 7.3.4Runn!Servic0ut;EE%er{Ǹǿ*A9stenuncbfig"runr͑E.ɔas,ouua8ܿe1etBartrec( 1ETA-INF>n򛇢e.xmlߐ`ģN272C `elchoowabol(u0"0)O-CaАՂConnP>,kheGe3m(()Dbox.0ǰľI )'$\ƄcJDBConn;ߣmilyseoHR)O4Ahould beelectedyefault.ellhe byRangeNext.
    nsoureditorndow,`lass,ddewinefte///(//ODOommenomand ؂follogtate:3heighX0Rߋّq2Employees=ꇟ.query.dByName("P%").get(0);ߔŒ 6Compileڊsaveorkx7R-cZҖ}>鏻AppH(onaviga Run>romx >TLogisplaysJresfexecuJkrunnoutsișZEEar,tur*Birs///">t77rievork?;88ExPdMETA-INFdoublepersistence.xmlW>ontsfؐ9Both eniadescribed. doQily-cIOK}SKtabrevide`l1ouwposSEJBQdataJrolOracADFH#Thisi8ifi8iwatasiɔPoGG__HRBea77777DećCsǛw1ChoiI alog,$Loca߸) WJOK?0S9ɥ_=/olԴ wv: : 7.4enuM߬olGryȃ4GeXegory4OItems7(ic=WWgd2d;ee0HGGGߐ߻oުlHݤϺnishO3׬0r9?G__tOJ4'GEYTagibrarD8ribuluZn+Add瑿?5!?ȹ Compon`s 11CϳϕϷ6̽TechnoyЌP'}vailablG5Fo@Notithaྡྷingutomy࿸requiassoci@脗Java0 Servlet؉__Z???5 Ư__^th="1"lign="left">YouowseDeveloper'sSFavigationodeleroiagrammcallylanndreateourpplppages,*thebetweenm.

    Ɂ or,xpUserInterfaceWEB_INFg>.ouble8k烙s-config.xml>`lȊt. brows񌨁I/3Fromdragdrop??nexo3revious x'''''>query4S/.a,wt.ÓBiohXshc(/////-)זwtdestinǏǏlj>㈘ximgecindex="00042t="ߤ"/r(5ifyfaultabel,gggasucPson,yingtypqvit.oȚa(iswarnabxZ'b.hxbecahapnotet4Ks.%dis#1respiﭭ6ߤߨߦOߗߗߗߗߤחכGחכoߗߗߗڪkߪߪߪߪߪSworkPdiv >
    Figu7-47.6Cqaaster-DetailavaSerFѹ-u1<2few ps,eWWes!ADFc=sDepartmEmploye832.7Ͼ˃Flow ouble-o HlaunchJSP@zard2TFilshould.jspxk1~asMLocuYpYVOKϽYn2emptyGGGoo בבadddata-bouȑ76ٽ)kڀ0playd'alowitÆhж3Fromϭp,library__b>Lah߰s9dra~PanStret 粅/?ge470σplirmidd@of7curs0߁quc tag5pء ntrolXexd/HR@adeLocalnZsFxAlӍopsg>xde"firstp`up u֟FormRead-only qiC6@4Edit eld@cheInclu 'ߣߣߣߣߪ/7w,}'''<span>employeesList,InADFead-only zW>. Ed؃olumnsialog8tllexcept:following:


    Youanetndanage]cLonsnrenabyourpplicaQcommuneithxternalces,cludA/+qofflinbjs.hisousJhavigatorYeamealsoed or߆needsuchsH/rverZollowysubsdescribeow1j__XviewRitsݎ2 rease: Caaa'on1G4P8G5">BrowyUwv/ulaget9CACGCEBD"me߀߀،6 /-TDPJD129/߀ގ73 3.1.1 8ǀtBω/19׊׀疭C /h3}D">Y~displaylurrentlyfd'nɞ'velȦjboldE">WK(Yy@el 0topeft-hsidffb;ed, EVmenu.ƪزxillustrc̈`ault 8out~IDE釰9 65F">Figure 1-a>.ۍGo_7!200穤HbAroughںWPt.nrticulaf)schema,¢g31'GI+j, laheitsKJasඨndн@node!M$,xpb'n.ŀssypat ?[_ividuaл.henbta{B7>@uctќsE1ithږ/> ACFEJFBW޿$K3߿LMANO{27I(?_DPCCre@ޔOO1GQoܡan)whichhav detailoȄ9DZmpecifyrJassword.³ʫiPǬaZX$onXZT уͲĶOR(oߦɃɦteps:3ol%S9lialuHTSt0r.liГUFromOOOGV">ݶ9WWS3W7#H0Ծ// 1//,'r?:ɰaiHav𣪳swg2Right-click3">;frtcHGj4">N`ψGX*nreedǒN45HO˴74,othang[Wo/, g1?X7">Orac0(JDBC)Hode>.nter HRnothhe Usernamend$A">P8wordfields.ootaalueorole,selectB">Deploy 7.ouustroviinmationboutbcompuwhereouratabassocateddministratshouldV(ijn. following7on:

    Driver:'!H">(n4 IfϒȔ0asI-,n*GGGONpar2ohP">YlhH.QR6SJDBCorxפT">1521גץUח7Vק1I0">SIDߩ1I1">ORCLߗ/ul1I2">Ck$3">Te@C p&#դsuccessfulz Ӏ!displayedStatusˏ4">Figu3–1ywsRcre>̱Hdetailsdivf⊆5TDPJD288߀ތ6dצצ҂77Ӭy
    3.1.3M#X徴OBr8Հ~7;3?PAfyhav06eslXa׾𓷓cb`tsIt`roughG6DsnblhierarchicaltructaiAobjs,ir8n ,SPeachviewAat)myOBd,䝻k:;RS9IDEns⨷xYѤ߼rn. K֤ left/)to expandheavigationree.oisplayistfRinstancesanbjectype,orxampleables,6gd TStructureindowel0tshowszdetailedƅry}selior.Ӏڇtr4(/e E@oyees)oecolumn2thaw} divEfigP&V">
    F 3-2c`singaaseϒsNU
    oj"" vcromȲD(:q.ه\nڽѯ9ǮwEˉrough.koFalzcGGnH糿2ǀG󃲌right슇ٌϽϸsHȖŎҘ2hortc@menu.alogoxٲ¿makhang "@B/ol1lnCACCIGDBo߀޾lIoo132gǀ޾\J]"sKkh21JL num.M">3.2SetUpϼ׀N׾//22-O AppaIHPronJDevperI7ete1rorkW,xthpwhi Eorgan߭a berp.rviWfXtem@tehelpmlQܰrarЭsςrei(yuX@ easily03tX߈܈ng7choỏwkmatchQ(qwibeuildQf3翤RW׼̸ermin"al(smf ers ߖ) chnohi:\d(@ddPyxtraibrarxg neIparticulaĂ転fg8mo/)wg߿\S//?T44UUd3W1JVggfK0b.1ϿϹϿπ傄1a>UsingheDeveloperpplicationavigator


    T
    σrisplaysllourndrojects.hen)irsttartr,brs]edyefault 0 lefidefIDE.abnn eltop-h)wp, Xsel8__6_fromzVmenuǒ7''how@oglroupitems:Pse@structur:individupׇd߁ّ_X$Swow[8">FHropriateedi.ƙ0example,fdouble-aava qQ h Sceł,ڂ{ServpPages (JSP) ߢSP/HTMLsA/> TDPJD134߀ޤ<9 <`s2A//*7/dB-#h3WW1KC`_Bnum^D">3.2.25CreP(h??;8?tE;wws9wW箬Fw=)aЫ;__1KG withǗmuce/)tHaone1whicho:work(soll:olH"lialu1IIoo8øJ">Nwn.li߷OKeenericwizard.ntHRhmmielI'neТlist,/M">õkNx0ooA3OOR򉝐spen,-P"> Xs,$//Qinish//R,nXSDz?o5TSavn2dois,OggcUleݽiV">All{/olXgܺkL0130o,2߄e3L43VdocJC Availac1L5">YcЗorfhany rtechnologyPЮ. `adX37detxsallmethods.s6@exape,beeLJ }cw1L7">C`R,ٲAhW8WWI9WA?_////JA(OH/B(ho"EalspeciffػɆǩ0϶ϜCσ˶@aoxǺǞDbՕ77SE">4FȺSOGswano3ooSG m6dc?77LH">Browsfi . OIOOLstaroJ e>,ndromheisplayedistelect Conn(ion (java.sql). F 3-4ӈingCoiewRJXdocnDeveloper
    oj""! ClickǓǓR">OK/// S//,3/ޗT/W/2377MU///V/-5.Dooooj8oe/jpgooohoo23`M0oo߆߆ߑ/ol DzעVCACGJJFEW߀ޅ\1W~136Wއ2DC 3.3 5π,6#-yoracleatabaseappaSoar,ouave@enoo Qh/ _.oitiate聼9vauabjDBCprogramm9interface (API).c9">Thiscdbes֊㇧͆W߰ 1subs:;ulUAYBya !&pos:fi2N:offy1E7Cverv@.D׃׃O׃^EpecifyURLsO1MFOICG8reۼ?:HPAI">LibrariexJ3AK">AddndSPwW'1ML'''oP5CKM">Impor:PackOg(Nggg6PVOr-Reld֊PabloOPQOQethoddzpuAϲCCIdzܸ$RϺ_37W޺LS<(ct2^T 31MUV.1ǿgN!f__\7炝/W8_wԽjx.sql.w]withoh{߄'tWo".jdbc.poolpkoload(W((_mmŠ turnphys8lalign="cer"inftblnotepПN ac_no_warn"ummary=""order`"dth="80%"rJhs"uroups"ellpadding="3spac0"> N@:

    ThesefX
    DriverManagerYouaniretroperties؊@prixE">,ׂFhnՉinlin@alic"G">xxxCHatccepthesnpu8arXtersXL">ImportantM2π瑤N!Pare (` x="kindle:pos:fid:000N:offI3PUO">T 3-18etblmalwide~PTDPJD294߀ޘQߟ24RWQg1073227/ߜS"titl@Tg1t׀砭UCandard sFjWj:="S//"ummaryhdir="ltr"ordehHthp00%"旡="hsprulegrouheatr 8gnxeft"ttop;="bottom"nnr1c1-t3Ȭ`h2Typ3Descrip{*ׇׇםr2 PӸ5渲+3넰ߋ WStr???>KY8ticularserX.lsonownia (0SID)aOracminology. ЀŲY,0HORCLbyfaultĉ{ǖǖǎ36W??O'unHlyc2ϡϡϙ4Ǽ7ǽיG//?_n-eooo5O587networktocolﲯ?NcommunicatwiФߢlappllyoJDBCCallnfa(OCI)riHnd@otcpOOOb6/}9_zpd_______?_PTjecru''750抛ortNumberϾint-t3">

    NumberfheortherezservlistensorequestsN03~1Udatabas%y9}2_zuOOOOOOOO?OUȏoe dloginߔߔߔߔߔߔ0ǀdriTyp皯癯Ԕ/'''SSpecifiesROracleDBC CH.taneir +oci 0thi".p>This -scropertyd$錄254πsrlWWߢ_oURLǢī1ect.YoužP unlacstandard̰+ ,networkProtocoMǁl>gggggGbodyable0br/`div> A1NV">IfhoootB5O0Է//+6/烔00D8SourcFobjw轀l (essaryarhtp,n`]hߵ؂!ouettОxoqyadditionals≯1OI7d5ӿ`mhod.ƱmorexHma 彧, !="kindle:pos:fid:000O:offI.6"ҍQsYhRܕ-cen0n7clas؆tblnote81PUN ac_no_warn"umm`=""orP"hdth="80%")="hsides"uleroupxcellp ng="spac ˿pͅp8:2TPLih(ouge8rΤG/Qeviously9applicr777= 9alsoFAǎǎA@See ُhttp://www.oZ.com/pls/ic/lookup?ctx=E11882-01&JJh @t@c">ρYevel'suRaen1Q벯~CACGDCFF߀ޱBܴTDPJD138߀޴y2Dh31OEǂ num&F">3.3.2 g߀Gh3-OH">ThishlepJVMppportsɩnProtocolַ86 (IPv6)rHܯ(machinex{JavaL,hichsolve|I+(strthat: "valurJ"xm_"1OK">DataSourcebject.heomplete URLyntaxsfollowing:

    jdbc:oracle:driver_typY>:[O">u(1/]P">pXword]@Q(base_specifier reMR">firstartfJځshichDBC {oe `dsupported60߀S<TO="inlineUuvaluforient-si!ppationsᑠߓpV">thinan1P0">ociSbketsndeat"Jiop1al@1P21熤3__hX[1 ۜ/nyѠБ\}4]T 2獔5-styl蠸iceYhAby TH$=61P7">?889GGgA"_.BCחD"fE???'Fǝ'G"x/WPHwI">host_ףPJЍ'ϣϠ=_numbGwPhgSIDߒš/F(a'cred𹰹gu0,foucluХwwS,*xwp Ilocally,)ashownѿa="kȻpos:fid:000O:offI2QNvEx#3-1ɢdivEe /-CACFEEAI'߀ޯWTTDPJD295O߀ޱ̶@titl1ӾyᲒrlropertyھ DSourObjH4xml:Xc8xшȺoac_no_warn~ We:i:hr/hr@J:1521:UORCL r> W6O޿Qo"s3ooj8oO,Bbr/Ph4WW1QB`^3.3.2. "s{4_Beca#troducs,0{JDBC73g 7o4AssyntaxepaalߠBȽ1QC">e'QD'''&QE">driver_type''F [wG///_H">/žLI">]@[//]JׇK">_L">[OgQMOJitalic"id="1QN">port
    <1O">][:ORCL]/p> InhisRL:ulQ"hliRx// hoptional. <lass="9inlineiU">:zV">Specify Anlyfxeefaultracleetistenerk(1521)anotsed.ㆇ2R018(orserviceameʉ/R2">Tconnec!daptf_X+'4">.orafileul1R5aref="kindles:fid:000O:offI5HIR6">Examp3-2hows picfiguraos7,hereMdive681geta.htmCACEA"߀߀ؒ9/-TDPJD297/߀ޔA+ytitlBĘSC xml:Pc؀xqoac_no_warn^CMYLISTENER = (ADDRESS_= =(PROTOCOL=tcp)(HOtest555)(PORT=r) DEFAULT_SERVICE_'=dbjf.regs.rdbms.dev.Yr.com SID*= ZDESC=NAME)(GLOBAL_DB)(ORACLE_HO8//P> RD">AfmaghangeW0E77youust taP~withfollowRommand1RF>snrctl my5gRGۄ7st268'H+ȧhouldorkopw____I@jdbc::n:@/Z  ___gom:1߂ނϖׂτ'O(RIPTION=TCPחWo)))YO%(CONNECT_DATA4Űalign="cer&Jȱ="inftblnotKbr/0pDN g`suPry=""order"dth="80%"rrhsides"ulegroupxcellpadd="3)0ItbodyIrqd="p1">cݹneweatuбOaase 11geleB.fbuanyr sgCliIecZ ,yn/specify"HPdonumb3.=wwsWuQsCrPqa70RJava0XJDeveloperHl,hich0lltamethodsrueryɘǛdod`tt0olUlialuȤ(TVPIAavigator,ight-ckxboldSViewproj,from Xrtcutnu,Xl' .li_S2_'#3zǍ ry,>4">General(egoryψ1S5">Itemsist,elect JavaÃ,ndick 8">OK.hereate ialogoxqsplayed. In􂏅x,nter DataHlersr2B">N/(C">h D">Packag.oothangedefault3sfOptionalttributesEwithJappropri\specifiedshownn ="ki:pos:fid:000O:offI9DMVF">Figure 3-6divfGǖCHEIECGG߀ޘHTDPJD298߀ޚI
    3.3.4$yW5_ǀ焔3cLibrarieh3Np4racl`Developerm:stardEhelp hgrammX2se0clu7ǰ6?t5CAPIupportJAG LmentƄework (ADF), t9JDBC,SP[son.V6">Toq񤒇jx,Zim`y`.imily؂SPechnologsRunt肽Lg11?ޖ$7770T87L9l4W1TAoooBl.1}OverviewAook8oO瞌CkC4y 4' D">IasmGGes:CulEli=F9_Z]GĺHoo8OIO28'MJߴ28g嬄Ko.jdbc:)erfacpL"ׁ֎efin˩extens0ʟу)|M">j .sqlviacڭtSQL-matat@or -specificeats,-`"nenhAs.j>
    :he w0R"?=ackageupportsirectccessoatnQLormat.isވsisprimarilyflassehatoviJavaappingꂩ typhandeir=. ODSourcePuseo ጁnionbaseeverloadwx1">Cmethodeturn hysicalWWU/ul1div> '&TDPJD142߀ވ|2 3.3.4.2ϋviewُJz8_7{JSPuntimeibraryl+eag,irequinterp8:run fil0a/.9/痔9+ebLogicӉer[comwithDeveloper.

    wCACJDCJC߀ޛAߞBCٓd31UDgggEc5UAdd90gF DBCQ 3'G 9/y1j, Qfollowsteps:Sol-HXvalu 1~IDouble-click="boldJ">VdɫApp aNavigatoisplay??9gG宄K29?簽LP@tqdialogox֪OMC'N">vCpath,m!gߋO">cyx̶ȟbastavailaإ_Heʀ2lat!,tarddi(J2SE) 0s!gedPXI|x,crxProughExtend 8lGGGQ"meWW1UR">OKŽai=sjаoOctim@rlypɭ³l.q)="kindle:pos:fid:000P:offI4RV~S">Figure 3-8how/.9CcoT">ǿdzj?ǀM2">oj"熏"ùާz4f3o'4>/olɃOACEFBDCގ5ߐ14pבܐ6"sV7h31V8_ num9">3.3.6uPackXh3^pA">Tos,?,Bp:olBѶVCߚDataHljȠ=Qnotready X(heavaourceditor,nhepplicationavigaexpandViewroject,F">ns , y8ackage (G">hr)double-ckH">DataHler.j. AteofgenerateddeX, aewinentercodeEJ">importtmpshowniExample 3-3Igetconn.htmCACDGBHI"am߀ߐM/-TDPJD301/߀ޓN+ 3.3.7DR!g-RelzVaxh3pV">`form+issstoDmethodys followQO:[URL@H!Crpond!word.200">UseڭJDevelopIop-1ۮBss:ol 2A]203 f04^onstruczWR3Ct?G:77777y5St*Url =ull;Qidku ԍW06">ThHoilled aPtauyatog ou0nthrea'"dbase. (7">d}hPru0 Pwf8">)9">u؄ggcid!f#schema]essalign="cҗ^Aa"tblnot20Bs@4N xsummary=""⟀erwidth="80%"rbhs0s"uroupxcellpad="3ApbodyIrqdo="ppSq7haveen1 u,?n.IointMgu04funB`tyy3Hbuil \g(reQesKnl771,JcĜW>Sy홯G2rWT77770"9:oracle:(n:@localhost:1521:ORCL";6!o@ h޲熷߆hr߫݀ÆWMak깁%7oɓ`finishR>Fm8@mS ꕑf(8PpЬpes,f+O AS}GAYJavhouXnow{ Examp3-4e GaHet.htmCACGEIDC""߀߼HP/-TDPJD30/߀ܾI+"titleinexample"id="20J">E 3-4eclaringonnectionրablesndhenbj8

    xkager; importava.sql.Goracle.jdbc.pool.ODataSource; public Hler r()} St:)Url =ullȀuidׁppwor ; } re>

    /-TDPJD146/߀ޑM+ <(Ms2&N
    3.3.8reat1oRMethodToҕoJdbase,ouustejsollows:3olRlialu1SAdc뙙d"aft̚n:T vo DBXthrQLExcepAt0UpJ`densightuhdisplayȉpss!remind8onrrori[.СhsAlt+Enke؃it. ?"210">stmen08ddeHliofEds.'11!esn0pen⥘e (2">{)n C&.DevelPrutomcallylclosуb`p ursiewmptyjetwe@bs.33O=sn?4">]inn////*5/*s;7R466kgʢXMaߓ7ozggggb8`dsa𶯶()59pStaodžesURLФךA">gφϿ////fB.Ѓ(/1C">wuproPsbyyviwithh5Xilablo2D77;s.cr@ugh牚l'E">)I,prdXICpxnsCfunZ,`F">t,G`aref="k8le::fid:000Q:offI28F^H">Fig3-9
    Assual,wiXˤ??Q">dsԞtP,8R">υɣ3,o;_1S">Ӽ ,OT">ECneUsemicol(;)sU">YM)uldookim0oJrwwww3ABnV">Examp 3-5yߺe =20BBFHС碿܂ 10߄42{3dza͵btbaspve"lass="oac_no_warn"id="224"> packager; importava.sql.ConnectionSQLExcep oracle.jdbc.pool.ODataSourceapublic Handler r()} String )Url =ull(useridׁppwor W㇨c

    hli0lialue="75Compile\tonsureateXaxnoyntaxrrors.oo is,ight-cknʓ Editor, el Makeromshcutenu. Successfulass1isisplayedeLogindowel0or$./ol!Z 4UQ`yfXYDCIT dfunsBДF">r.}fɄIbaseraЗfolɇ8:@GHyaef="kle:pos:fid:000T:offI18I">Overvi of߉٬Q1ë򅡒 J1012K">BaAppL1~M">CtJSP sϊ22N׊׆4׆ϹO">Addy ( tenh:֕esultOHPOOG7OG Q">FilyaWPet22RAS樐@FcS݈鈹usdsaZ_3FEUf,un!ies.ْXP5F">execute"`< ȳandroducsetarowhhatatc;#di`rrtaaaG">󲚔4H8ՂIBjisplatAa./oѢJ`hѐ@scribemportaȠ*nUv(JDBC)ceprel`´mawonuKlLU7S.M">٘sid="23N"> QueryethodsorhetatementbjectResultetsulPdivlass="inftblnotealsoR">
    See :OJaase Yeveloper'su@ndeferenceA Iq dp.htmCIACAABF"S8?=TDPJD149?C3ion,nextsI?GEstq29/3T244Ey.Ԣ(5">mfҕj6eturns`?? 7wvtype.ששש33B~8">Examp4-a>hows (ߎ+9"eAABDGAI_$B305\.titleiD/(Ö(preml:xxservlEصwstmt =j.R();NF">GusedaruncQiehatbdapp0HonH">In Q,rscenarioshXanyimilar~withifhuppealu`mustAYoK,چ`w723,I7JDZ?μHGKKPreparedgbwhich henda_ZLǥǥoc)@o duXߊo24MECall٩_ןϵѽgn="terNٶ"inftblnotealsoOX J=N@A@ summary=""order="Hwidth="80%"rhsides"8legroupxcellpAng="3P(bodyirdo="pSee :ulli0z1Q002KUsǐǴ1/ׯOOׯa5G׎'ׅhttp://www.oj.com/pls/topic/lookup?ctx=E11882-01&J nVtcEDeveloper'su0 deence4.1.2$ǻŃǩUϾ(VQ0yetho9Ѻh3fe@>(azymbed#ظ/h9//1vantfgu2">execut#m.mportȂ  istӠ0UJ~53r4-1ɫouX0mal4O+306G/5g4oeϛIIABB"ame="querdata.htmCIAIIABB"id="257"> 8">T 4-1eyтyxecutionethodsorava.sql.StatementΏ <8]cer"250clasinftble o>AHuN@A@ac_no_warn"` ry=""or`="hwidth="80%"!="hsides"legroupxcellp="3spactÿp pSee :ullittp://java.sun./j2se/1.5.0/docs/api/indexl">"(@?}CIAHAGCAw_珬BTDPJD15翯CsؒDh325E8ncnumF">4.1.3 sA HeI"ntai* QprespabaseBse>isenerdy Ӂj@riesheatabase.

    Aursorointxorentowf n ResultSetbject.nitially,tssonedeforefirs:.ousOOL5O7-ML25N">nexmethodI25OYmov;,ڋr*eeturnsgaP">falseEwhe@a`nisg`QggdTypiccontsѐR{1reay8ingoSithloopntil75T7qU">T+V/.Xerfacerovid@accesIks (_"260x6-1getBoolean,a2g73fLongO264ON8O75In5,ndon) `rievcolumnalufrom.րcan`ɒeeindexumb$yx׃O6">Byefah,ly؟_7ww[p`בx8">Statem(נopa0s timeXXoBmXipl9772s,muт726Ag7.9B{automatcloshMߚCߩhgenerdk,XrunrYd#ת|a0nX@sdivlign="cerD"class="inftblnote`oEhbr/HtN@A@ac_no_warn"ummary=""order="1"0dth="80%" hs"ulegroupxcellpadd="3spac@(bodyird p@See :ul8li`2ittp://java.sun.com/j2se/1.3/docs/gu/jdbc/start/mappl">''''''#JdqRXorqoHn QLypJȀ{ OJıbaYĥlr'slj Ref4..1ƊϪ relW\'?ﱖQg׀R74πS/057T;ؙP?g3U"Xsolutx.ypecifipHbHrow/&1curtQ./GG_ |,ount꒬Qbegine8V">Wher赙݀,ustspecify sensiOOL7O72Ktivity.his ersohebilfsultetdetectndvealhangesade underlying baseromutsiA0.h؀ǃcsee''whil\open,rovidQayiciew_^.Æcolumnalurowsncare@sible.??<3">Upda7748747x9g54,Dut{9)8ophؑu/

    CIACJICDg6wTDPJD1537 <sЁ8"br/h4279Х numA">4.1.3.2-SummarRSObjTypesScrollաpidenfmR,Ur􃱒Kwoncurrenccombin`f0owsixategories:uleCYliDForwar /^0lig8Egc&gF;-vGgH*I'&/ul27Ja )="kle:pos:fid:000V:offI6GSK">Exampp4-a>xmonstrsow30LdeȬ8a󋷳# L"e{NʿECtOww30ooePptitleP Qĉ{dS,O#pxml:xcx8voac_no_nR@stmt =n.cteStmX(n.TYPE_SCROLL_SENSITIVE CONCUR_READ_ONLY);Юw"inftblnotS 3N ߅sC=""order="1"idth="80%"rhsix"ulegroupxcellpadd="0tbodyIrqdO="p1">[A~?_tasorovisiononxacuth"טטoun ⃸yite)oughms蛞method/B//2Ԁ?BOOHFIHHJO/LTOOO154O/LUOOH\VOh2g28OOh4/Qy DHomЪ$2Javappli@Thisciscuss,jseDevelopeꭐ:2ذq Orac@ba84Կoe4o5ooj10oOV6">CQ[MrɆabJs7_5GA8esCȋTѝӄse'7AFGFBG甌97_7155W?AP2Bh328CD.17h3}E">Theollowingtepshowou Atoddimpleueryethod@r DpHandler.javalass.f 0H0__[3_G]I[߃߃isotpennJDevelrtegrated䀫mentnvironb(IDE),ouble-clickteAppationavigator1display_ʈӌcedi@.

    ort5stHsftiexistNusegO">S͑`P">ResultSeJDBCes: connecedepjerias28TU,?iUםVrobjЏ`j90֤m.s9ۤ{v0??>91CreX覄callФ7h2">getAllEoyeeswhichille!re偌8(mfromIbase.šsignatu٫K/////B3p0ic oj()r`QLExcep{ GG464P`s oclu osbrtбÒkaewin dpe / .צ55 <6v7r?darlier8Gz();69Uo?AؗrϾaofwMB">OnnprovitextjexecuᒰGdefߟCWtypSpecify@d-only,cr8-sensitixGDohE@A =Yn._(.TYPE_SCROLL_SENSITIVE,.CONCUR_READ_ONLY)H F">T CI(ghcanelpou`sthat3yntax corr.𳸳7GDpPmag9k``:en columȠ0'\H">ǐɿREorderby­uD2I= "SELECT *ROMsRDERYn_id"ys.out.ln("\nEֈ" +.8JRu#dzvW29Kޞ^Lə.+eQ(9M!BNobj0Okٌ10PSarork.ƾFilebxԷ/ol29SJcbTǚoshoulZhwtUnh="kindle:pos:fid:0010:offH4PIvVxa*4-3Qdive A0ǿCIACCBAG1TDPJD30T2󮩿DtitleЅ3?8sտ, , ,R~ϘB aid="2A4"> publicesultSetetAllEmployees()hrowsQLException{xDBConnec(); stmt =.createSt(ment(.TYPE_SCROLL_SENSITIVE,LCONCUR_READ_ONLY);nquery"SELECT *ROM nRDERY_id"Sys.out.println("\nExecuting: " +[s=.eeQq(Lreturn}
    h: ?>TDPJD156?L6; 4.2.2 ߇s0ef33ǀATesthe7oBwndZethodsInJfollowpps,ou ieava{o@*mHHler.j.ԂTrppaCisagep`porarily 9valuefE">jdbcUrlvabpQstg`rsbasg`sooAF">useridYG">ppwor&require`occeH">HRschema ("I">hr"eachHse).olJli{="1KOpeLVisualditfrom*Aaviga.liОMHChang0+NK,)O//8P//talok/Q?>ass:reml:xcȒ8ve"oac_no_warn^RhS)ita@S">l-S"EahrưӢ?AT">whe ߾pU inlineǿVDŽǫMixexa9:2B0y:cPn:@dbhost.compy1a:1521:ORCLw"inftblnotealso1ЩN@A@ OHsummary=""⠈erwidth="80%"hsides"u8="groupxcellpaddh="3Ypter 39ck(.met'4">ClientmakZaub,generdefault9ucѾaG5">m廛@skeletȻϗX6ntǬsXdisplayxaӼce7776ڠorm[paile4~8Importϧ]9">ResSe=Ais9.sql.5BqWVCߖߘRddcepʿd8''''''D stcoQ([]rgs)hr`ń5{6vERe\FbjbywithsGataHyef#.ociɉ+H?\=()uIe膉Ureml:space="preserve"lass="oac_no_warn"id="2BJ"> DataHandler`hd=ew r(); ResultSetbjectooldhe sfzxM">getAllEmployeesMquery, 8teratehroughow et,isplayingfirstourolumns,'N">d4'O">FBName_2BP">La+቏Qiaill.oo(iad{follow bP,R">8nmethod: <S6(@r. while (q.next()) System.out.printlnInt(1) + "+ JStPg(2 3ׁ4)(}??98TCompɔ?U">JavaClient.jXfoheckHA)ationrrorsGAright-cliinӔ(ceditorseli<nbvV">Makhromshortcutnu.ȟC0">I:Papno$Yn,ou9u(sיmessageLog dow:x@1">2">Succful_on: 0t,Pm9C3!ucx4ǍǍƛnjnjnjrOOLO7|8Ktr,edy'_9?tab(asqwnaׇׇ4׈A։="kle:pos:fid:0010:offHB0U.B1gu4-1divmf╞CȍGECIACDGDE?'dD7zTDPJD30/_砝Ek)
    z"WWWWW"jdbcUrl|,߯J">u0idɶﰠK">pwor&vari񰺸WL`H_>aX׳M">nulv/ol@align="cerNp="ptblnotealsoO+k$heA@ac_no_y"ummary=""`erX"dth="80%"hsides"u="groupxcellpadd="3cȄ(bodyird="ppS`ٹLGGB0PG006PPDe(rConnؽ@-ReXV//B//?vBFAײ缆PO157G/羼QԚs T">4.3=Crex??l2?'U;JSPжȴh2ܪq$TDpHRApp? psʚServer (0)chnologoisplay 2 9rov9iػaw(c9e!-0epe(nttmπdyicebpxnt.pXχT.jsNexs.his ifiۨ0a"Xuldxrocessby )ainepret+ragx[l,ecDequired,Xcresul偢liBTML X81.{D2Pevelopf@ome allI:

    HTMLagsoesignndormatheyicallyeneratedebage See :Sunicrosystemsocumati"atP>/å // /}/YIIisec,oushowcanreqappli|guxse llow5sSDG߫QHۉkindle:pos:fid:0012:offH2IFnI">OverviewfШresQOJwww3wK">Caimpx_2DLφφσ_1FA6M">A2 HtHCLpaGDNooo41OtyXShee?mCIAJJJCDw,PϺTDPJD15eQ!2RqKh32DSpnumT">4.3.1 ߓܻ9߀%U'!h3֞^V\id,'re`dowrtask_EnE Display B2Hol9put2 ڿxbyrPe(oyenddi򀵃3eedcesXv(Ф di`ڱ,p3,delerecsebase>E4">BecaW2p;[sTML XML۬R rol nsHou( s+A.ٯ|8ndard;tag0omatIrR,clu򰁷u5">titlxR)heaspecifyrrbpÖe.6">G9 s,Ph@listor n57#ss›efinGF.fzDevelopdk3 sXctXнhrom( 8">T77spscriH9ma1߀9@msǽn|ABggg2ghHIC">T ׽2ED׽׽ׂϽ63MfE">S(p t߽F(7G^EG">߭cH߿߿߈w89EIFXJJFFHJ15MK3FLh42EM="2EN">4.3.1.1 JSPags


    Tjsp:9Y M鈂scontainllʈUneedxbygClThpecifi舉.oudrxiyrom"Componentalettf properti8݉r{0respdQdogoxdisplayeddivign="c*&U"="inftblealso^VXtabPtN@A@ac_no_xn"ummary=""rder="1"idth="80%"hss"ulegroupxcellpad="c0tbodyird p1">S:ulli>Qttp://j.sun.com/ductsbs/">OOONmoPormНu ?>CIAHBGDF7+FwuTDPJD160oWpJﲨh 7߀A2Zaariety!taskAxap@Xߴ?B">DHlerŹreturC">ResultSet}obj%Ѽ5eoye D">E ߲0,hichb쿓-lC\Q/oughO1EapmIaow!as\CBAAH笼F16GHױIJ38ﴵKHTMLagL9 M_ctyp`llyYoutbprespnondyicorasݬr xfacADxq aȚ(7!mustpecifiumbȣЄcolumٲıZautom0cxted罷GHHAJ罤NG162O翰PQR460SƽTf߀UGmawith gainamhesersnebages.ԀFORMlementctsontaineror€rola,ndpecifiesmethodoZZproces xmnput.

    V.jsputf݅. 1login,Hpt,di0yd`teperations0dXalSPrreats+ondxtIhow 'inippliczinrel,ef83">YouaddЎ myingrombComponPafTMLagIfampt#͓^utsi6cthatonotM̑2nDevel!sBp=i/div> ؚquerdata.htmCIADHJDD"ame4">?>TDPJD163?5; 4.3.h)>߇stA369CqaiSPfollowstepsscri𚂍М*s:Blialu1&CIYeWavigatoright-c(k;="boldD">ViewjIchoo E">Nߛ.shortcutnu.liOȏFOHallerЪׅׅG">AllechnoestabNJHExȵTino`gorQlisI">d64VJ7Ix+旗KpJB''KL">OKڮDiaox еedǔ5.MO Fi(ee(a*f֊'N"TO7y6OwDŽPnh3penB/bVisuE н)dyԻ(rH`(texoir!^/olWWWIAIDHBBW7绌QWW167RWWWSWWoTWWWUS3UAg7OvVsStcÿh4aH0p߽vixvPalet|PrItynsph qJHfϒϒ.ْHcalsoXSce byB`زDesig耸abott؄lR+s ؖz__]'*e;aO.lankt/)شwna="dle:pos:fid:0013:offH2CH1">Figure 4-2.sw"f2ߜAHBEJIߝ3ߟ310,4p5titleinj5'-2o^ߧϧЉimgrcvembea0E?miim/giflt="criptih"/><ןǟå6">z"7"ҧѭ7">۰Istepc !a`"488coH|9">employees.jspy>'*oodifyuB VisualditorsikeYSIWYGandouansetoodifyontent.

    employees.jsppennhe x,topnef1rage, er D">AnyCoorporation:Rpplic.romlistIstylesP!oleft-hsidselectE">Heading 2 Desig enuHl,ʍn??CZ3JInsimilarayjaew2ϏϏϔK">ETataw8formwLw3U.osiaoor/ol1div> ?>TDPJD165?DN; 4.3.4}Ada '&sthref366/=R7oOH7wW礪S{Shee*aSPУYԛтs@erenc!ߡ8oxئrs,extopr ht0retediasXș!oprespreatuuchs2fЯcolorsWebs. dždžð]follows:UVI0cHkarrowpighzComponPaleXOO1SSwww2Vߖ83 4׮ ,rag,5">JDevelppss¶"iFB9ǨM6ˆGt.y="kindle:pos:fid:0013:offH5IF7">Fig8 4-0ahpŸo1[viou0ٸ Lappli%"f8HggAEBEDCgG9gg31賟GAepetitleinZB-3uSc8,imgrcembe0F?miimx/gifplt="DescripRO"/>ܻwWR70_C">z"χ///%"[ align="cerD"`tblnotEtab,N ac_no_warn"0mmary=""orderwidth="80%"rhsides"u="groupxcellp8="3cbodyIrqdW="p`[Inrers10.1.3,Һssocia`㷖hiryϾCWizard.Թhonlyif5xebsloc9Fnb8wain0afu gyAdroppl*./ol'AIGFJE缜F_166W?G 4.4}DyX:ĻbaQPyesultsThincluPQsub$sSa2useBeThInitiz{!Hl`C3/li> CreatingesultetAdd#TableoheSPagDisplay„OOxul2querdata.htmCIADDAFB"ameTS">?>TDPJD167?狌T; 4.4.1 &useBeTagqInitializDHa9rÄjsp:<pidentifies sjatoldmethobrun p.odd4,ollowseteps:employees.ȇDVisualditor.ׂJ8PIComponh lette,el(דbP9">ȑsetfms.crroughRliso A">Uhen,rPdrop部n0your:Q,eeasof3BoInsert hogox, x8Czsb{D">IDd,for___JEbrowɍgǞF">hr.r:G">ScopeͪpH">sessioņ{leavTyp#N xablank4IPClickJ">OKˠ ^/oK09GL">Figure 4-4!hbreprxntpon׫M">[N["fƽh77IAIIGBD7ܽ7o531@oSp%titleinRdzR?il8imgrcembeq0G?miim`/gifXlt="Descripmǭs"/>g ?OVS">"G"jۻ4.4.2eCIXResultiT:䐲b(|(mBa"3hL4getAllEݳmetho hP ats@turnedxydefiK5.袟d6ߚwp5ǀ7init iz:byǓd8">P:ol9ɵ1~AOpe.BVisualditor.ɶ;JSPXrtComponPalette, lȾˡ½#obj:(xml:czrvClick//dI">OKT. ﵿ6׀id="2KJ">Figure 4-5.


    "W7776"* SelectSourcP!>abၳbottom5VisualditoroeecodIh8beePreatfQ%soar.avyinender <\T">ResultSetdicsCPaperrorsU.4>UTStructyw oweleft-handilany.Yqtop͂삁exdoooKV">En05N6L0-6A"s H‰0>щGC裗{1OFDGIEG/煔231Xw34-6epg]WZ0Igg`9gO577ט45n6Youus@mporܞ2L7pack:Tois,ickߥߥL8">G ǟy˼propertiPynsporw.9(CJempboxeright //KA">-y. rllipsym (B">...)а7WR80?}CCdialogjed,hichWx6R1D-7ߣߧVE߽WGDFA߾7mF߿31X嫤Gߣߣ߬H-7əPsJDevel)0Jǣ茘ϤdIrW7JPIllist,elȻGGGLK">Hierarchy=tab,777L">javade,ѺC{M">sqltnŧwwkNߡ=O">OKu8POourceaminhHB@se82LQ/statementaseaddeforSeuldappearromIO.eqnuwithZ[sXHrePdesign Zby̹ѴR0b6/ol)bWWBCGDIOODSϥ169ǯT"2UءDh32LVO num]M0">4.4.3eAddiaablYJSPнpDw h3fp1">stepsescribeowouanddableoheSPagdisplayresultsf:getAllEmployeesuery:

    e.jspJisotpenn*Visualditor,ou-clickt5AppationavigapA[t,ndorDesigab.ith_]6WWHfiposiJ!cursPafteptletfrombHTMLomm쀘ponentate,electspclass="bold7">TaE. 1MrqǒA">6Ucolumns.eavlla@trrtiesAfaI.ÏzwwB">OK\3C[ied , exXsollowACheadingeach}:,D">FirstXm,ooE">La2MF">Emailב??zG">JobH">PhHwߓߢI">Salarys__J">Hk 4}Hma;ps4KpAJ;pmɓ puhthPtimߨܦ:sturnؤz.ԫis.РߠޡLtoprd8Įb˧{whmchang.ƢIOOK//kLP}n(YnepYdragǦinq;:(autoЭxlly.)-5.M\;alin8 : 746O02MP/olp%Q crea shown1.divfS">HYquerdata.htmCIABJJBE"Ҁ TX?>TDPJD31?TU;1LtiinV'-8ԧnȧaPimgrceȉ0K?m=/giflt="Dḙ ?%"/>
    z"" !4.5Ay3}6 Fil` aїhyesulз!h2?N7">c(fڱ a yyapar质rnds. ]alsiȵRapphcuspizeʜф,.ampǾ`Mٻguid9procedІ{i+ÅsisǁZasks:olm8P"79DQminwhatDXyrequiNA">U‹specifyྰeoyeIcordsȌyanPoiewen )(field,casaYONsearches.jspaccep0:inpurougrmtrolsHndessest.

    Creatingethodoeturnquery ResultSetThesernputtrisce@SQL$stment.hhelectsllmployewhoseamYnclusencefharactershat҃8QeearchforЄ nothrfirstn lah OOH3NFHDisplayYr"s9IJGNGAdoneyddAb ώpH">.jspag=runl@גol2NIsionescribق"adataollowAs:uluJp9Kyaref="kindle:pos:fid:0018:offH1VKL">ava͖ˎF&+sA,ControlJSPА?'2NQ'''9'JR">Dϋ?>TDPJD171?T; 4.5.1 gǔǔǔh3O1wstep$owouㄡ?2">getEUByN(m#$owIodghir $o5O34lO4hFromApplicȣNavigator,pe{85st384e6Hler.j-梩Visualdi.??=78Af8bAll~Oi,r?>9???Ӷ: 0xml:cx(ve"oac_no_warnApub` (S+y)rExcep2{ } GGB@Wibody 0conver3ppercaoabloxit߈߈߈߈ߞC:=KtoUiCh();gDxCؼ2nп!bEhDBﷷl5F`SpecifڢG">ntypnde yϓϓϓϓϩHstmt.kStment(v.TYPE_SCROLL_SENSITIVE, _CONCUR_READ_ONLYЅ = "SELECT *ROM HEREPPER(_LIKE'%" + + "%\'x "Rف`DERY_id"O6IxP(ttr0xssJ1ym.out.pln("\nExecuZ+ ߨ[7KRuSsreturnȸ@eL rI=Pmt.eeQ(́A; /I8MavӸ`ompaiensuحnerrors/ol1div> gfCIAIABBD_GNSTDPJD17иLO <sжPYbr/h32OQسncnumR">4.5.2es@SjilMYouxuoCUȌ焯8VJavaCliX.jXZ$d 8h="kindle:pos:fid:0010:offH5GAP0">TestingheonnectionndQueryethodso􁠁getEmployeesByName.ouuad 2)displayq resultssescribednfollow!steps:

    JavaClient.jXEclassՁ!ourceditor. 39T|y8pplicaisage,aemporarildjYٕsfǜA">jdbcUrll,ǝB">u8ideמC">pwor&vabl4_XD">D`HcproviȅϞquirUߢE">HR]schema.avf,compIio @cksyntaxrrors divlign="cerFiinftblnot(DG">
    Runshortcutnu.ɷsLogndowwillrsemo/Jd,ô??_K__("xxx").erL">Pը18б!funžtactuPoperpaIbVdy78o earch./ol. x9)A.htmCIAGBGGG"BFM?>TDPJD17?|N;/s2O h32PP numQ">4.5.3A"ƉKtrolRSPз accep0criIxdisplasLmYmodif'PS">.jsp]pfollogepᵱm @XtT/TwwtЇp!򓄅3InQ4IntXal8box,ɻ*rrowiA2el WWW5?<#eavkors!tyJ''6">OKQ7ڗ8<IpP3ad-lin!ctanglex8/////(clc9exVSsi;drdropinsBZc Lߐ|, YrA">*-a&WWrB">=Ow2QCtpan>.heextieldoxsisplayedithin8formkallowssersonterHl9cripia. Positio#cursorileftfT)Fndd)ing2: FCbymployeeame:Submitutton.elect Ȉ dropainsid @CIx֋LrighWV7JInt alog,Hav'2QK">N%empty8:Ő''M">V,click'N">OK͓QOaref="kindle:pos:fid:0018:offH9R8>Pqgure 4-9hћsms2QQ">Zs.jspe.divf^Rڜquerdata.htmCIAEACEG"tS?>TDPJD31?堬T;YtitleinU-9/lj6JSP gimgrcembe0L?mi(im(/gif8lt="Deip"hWs"/>
    z"ףO'$"{4.5.4D CXDh3R5">previous (,oueataߢ~dthaccepȺqputs.Ȼм,|cspeciftrihichyLYalso"ssbrD^6^WstepsS9SpR7avalenabPP'8">getsBymethod.ԉk dlyfssforesul*y(`1notStageB(q sit)oPrXrtiesialogox.od)ˌ#:0xml:cXؚXvoac_no_warnFRJSrset; Sk9y =@st.Par0p(*y"); ([!=ull &*$) 8sbeangbkelseA(re2RGbɷ.pos:fi919:off1KJH-10Yh (ëvggox mw!ܯ7"IJBBHF紜JO318G/KptiinLsWRBox+im`rc&embe0M?miim/giflt="Deofȃט4"۾߾st38ǀM">"_OO_X"OKl?~4P@SavS9/ol9r ϓACEAϔDQϖ175|R̉c 4.6EAdd.htmsthref389"ame="querdata.aid="2RV">
    T@lfused ȂAsamplesiexofon-manag(secur.tnotfullavaE ment,ut3anr.CreHaethodAuntesers PreparAErroreportsrailȖǚBNJNJCNJCǘIntac?/pD///oH3PQ6E/HJSPZHaQAGpul7CIAJBAJDww$FooTDPJD176\G 4.6.1 ͫoϫllK''&h3ϭ-L">I㟯stepscDDp{r.jX[aHesrsyhecI(avaluyuyN">1idmxϴ O">pXwor&matchoseequir8)basmaoP ="QxOpe߈R߈߈sSourceditor.WeGSةalYT">te1z„fUώ2,V߿T tEzia"rPp`xml:(cȀxve"oac_no_warn%T1XpubooleW(St"jdbcUrl, ~], HttpSess𾰀B)rowsQLExcep }ЅؤHVT2JDevelo@romp@withwavnderlin`ssj QneH 3">r. zelt+EeyT`x.alettp.F4f5Wx,body Hg'60'2T7o?whfxJIѹatbui$currbj؅Xsߕߕߕߕߙ"9hs.=; =L;5>AAtteconn!dus[6psuccfu@returYǠ B">trueEnclIa?Cyyblock''CD!ryAracleY|ds;`dsnew()tURL( ЀgetCsh(łDi;v chOHsifxW"8
    ??catchQ.he :inhisrintsut@logessagpndeup`rrorqc0beisplayedoHeserfattemptailsÆI">jdbcUrl,J">id QK">passwor&variablesreaL">nulψ)!methodeturnsvalu׋M">falseԋo)is,nt@following: : (QLExceptioHx ) { SysP..2ln("Inidcredi");s .Attribute("msg", .LrygaX..C., = 〷kwl8; } `ol0ؗO"> mpletUshownExa 4-4. dive Q">XQquerdata.htmCIACIJCF"amR`?>TDPJD319?DS;)DtitleXT?8ɊmUVa2TUpublicooleaupeA(S, s~,HttpS)rowsǔţ<ߔݣŗ2A OracleDhSourc(sy @ew( iURL(connЀgetChec(e4.6.2re0a餗s0ef393 4пx.jspep, 8whiIs ZetailsHschemaIygoಐkh:ol}7ili#="1F8I@Viproj,iJSPJ.hangeNȃ9andcyll(rfaultsp8Qpens郸/HTMLsualditPpdyyoustarddjexxйons Xreb{וAApply[Develrysheet1o?wBhGivˇJ:h8arlier, boldC">AnyCoorpor":R Yɵ,?KD">HNxiHlignpc of_-4nEXO+`t켘,,_FX with׉__UG3׍ied.¹)>left-`diW/olIAGFBAB穄H178׀竼IJ׭KLPrepagŸețpiwGD/LM5ǷﴕNFHe|s2UOsuncbʯ2UPdisplayeBmesssenٯfqscriptleAexssX@?Q??suذ8riab#hy.ɞ넷, onnpmetho8Wk1ckjsee" su&ہent,tisplaysheessage.

    login.jsppennVisualditor,ositiocursorftertext isZ.hen,romJSP$fzComponentalette,ragndHopspanlass="boldU">Scriptlempӄto 3^1xAdd@orexactlysameay,tion8allbr (o2">},)4F3`Pl!7etweBwosj sŏoreaaew8.pp4">HeadA4sty܂~5F5.still73click__6">Ex2d/6v7/,76ߘP8ܗN79TeQthatasadde oouroA">gg,Ȩ__sHctVBhcetabshoul0ppeaHsDs C(<% GGGGGGGGGGWGB%>h4Z ='O/TD}$/olpD">Befoc inuAwss,eturdesigni`ĸBby,OOE">D2Gb$/div> ?>TDPJD179?$G; 4.6.Ci&GEsthref39OKsXtepQieldp˳oHMwswhichps,ixzdetailsolNO1O1Pp`DϤdouble-iQicH(Naviga8a[tche8½ɧedQHJflAo ^HTMLƯwwCR">Imъ!display늏Wpdad-Xctangl3SoT yZOOOVUL_aڷ>q´۷WW{V">AUafilellH2proc@rxpu~I300`m (Ycan rfromlissʚ[cHyet.)eaveor=emptؙ¿1">OK6302">]:43Aa''4aжY. sihI.pecif3-rowJ2-column 0ouaccepҀ˻faults>55fir| Xowମזetexo햲R:G06G7">UYID:T+68ߤ9">PwordA׼="bold"id="30B">Host:

    FromheTMLagefComponentalette,rag Textield4ntotableell rightUserD:.nInt ialogox, uPi>s #F">Namepropy.eav Xor!smptyndickG">OK.nj7>HsXay,ddߋߏIߋߋϋϋϏUPHwordӆbNJJ">pL׊׊אK׊׊Similarl7L҇בM">hǑǑǗߛNǑǑ 8OD30P">Submibutto蚫Formelow'.ŘǠQGforg0R">VokSf/olpuS">YouT">in.jsp shoun@appearwn Figure 4-11
    .divf V">Piquerdata.htmCIAEICAB"Ѐ#10X?>TDPJD320?<1;yLtitleinz2/(̊ᭈgimgrcembe0N?mi`im/gif lt="Descripti@1xl(s"/>
    "gge"4.6.5Creatinnj|ύg9SP)HȽAc

    m1A">Csteps,ouAopB|_a⠷,hichsnonviewbthat cesse+ ؟oC1Djaito1EDžǸ.8ceptlefaultet1sFWithG GrVisualditor,rom׫Componl8d"DirivȁN InshdiapoxH hrVf1,rzi77I">java.sql.ResSe.lick''J">OKuϽ3.KϽϽϰSL`sp:usebeatxonoo31M">emps˽{xwwND]щselHWWO">hr.DrF31P">Ca.GGG1Q">Sc oR">sbb,K1Sg4T8Posi2cursafA!Bj!ad ו׿U7Bi] >xlVpxml:`cHxve"oac_no_warn20boolѕrIsValid =alse; Strahostrest.getPar0("")fAww("sswor 'dbcUrl@"Y:oracle:thin:@" ++ ":1521:ORCL"; u.au(nticU(,\,,2p@reg51A1no(p/722gM)odeot: if (uXIsValid){ Ford၀dragnI*`add6">jsp:ftp_. In8t ialogox, 0erׅ׉7">employees..߉78AnorcriptP,followingode9}lse 8vA⍧B/Nj)3thisimeovYP`in9瓿9vD咙alE">S͒rclosbrh (F">}|)g>10GSayourork/olpMH">Toex*thataseeneI_actioOexselect* JHceOb.Ԅ%displayЍsimila𛋔:a2K<body>j%@iPrt="java.sql.ResultSet"%iɞYBe襙sbh" _OLhr.DataH8lerW7scop sess"/boolid =a; Strhostrequest.getParamep("")fтww("`ssH 'dbcUrl@"Y:ole:0n:@" ++ ":1521:ORCL"; .aunticateU(,\,);%wt_j+'''&%}/ָdiv> ?>TDPJD181? M; 4.7χsthref39P׀QTJSPпproj4__V">Run30">You9 mpt+specifyPDefa ar`y2|.ƀnowWb1WV clPrhantpertiesd|rxt{bȆanyێ0choice. 2hGZs_ 輂browȶhowni="ki:pos:fid:001D:offH114=33">Figu4-12"f 4ABBBHB5O32/=6pMtitleinz7/(̛*Sa`_Y B3imgrcembe0O?miim/gif@lDescripڝЋ72s"/>ǣ400w8">""ӫSubmi%33B7mC">iDL33D">h ҜwBE-F">P|Ϣ33Gςϧ HI">Hostw33JYinlineita`K3ٴamachPithracD\,O?33ϭ(E|.java쵉01D:off:0 26P"id="33N">Figure 4-13.

    TDPJD322?Q;
    "WWWWsp"r En(tringiletsyhichouanto  oxa@e,傒the 8eld,ndickoo40m.4listsisplayeshownx:GG1GG PG 2GG@OgV3WWW4-14GGGGGGDQGGGGGGG@GgV5GGGG7775/olʀ -AmznP(Break="alwayschupdu"6mBGBBDDAEߗ8G18ߙ9kh1chapFA="secnuB">5UpqI9L,Cill`c modifys*pp()adduncalitiat`Ysedit, atHdex;OracIbase.ԅrcludeXCPIs:ulDɥTEya Npos:fiY1Fp3GF">CaavaBeantG'''G'J6H">9fromtý34IKɦgJn'Record34KNoL gggOMoooOoOyN">Exce[HlҍgO7LRP">NavigtSAϑuwwHIBECwO޻DQ?w8n߽mRIt1~Sd2g34TWWUP.1e4'VD5w;50;Gh2-1outY⟘ p*+hasropies,ventHmethods.orach)i聇,also'accessor`Pget*03">sNAnybjconformcxaxiculPby9nopecial_[8extended©&+N4Ltepsro/406߀l5S·!ݏAholxe=r:.heapÄGfie臑9#pnDl136 ((78)8seϜ(Youill@h羸avaBeanorheamplepplicationnfollowingubsecs:

    Crexaa4XJDeveloper
    Defin IPritiesndethodsul2upddata.htmBGBCGGFF"ame߀߀؉E">y/-TDPJD184/߀ދF+ 5.1.1 stq407ǀ瑄Jˏooojh3puKcodL">Eoyee.jsqthatusedחtooldseecorȐmodifytsontents.oP,oWQoMvalu1NRight-ckZ?@b@O">View%proj,fromShortcutenu,߂P">N.Dže/QIalleryialogox,el7775R">Allechno؜tab~3S0Ex0dGeneral ego`I$o7[T">̓ΨdߨU">t.ƋݛשV">ItemNlis_Ǐ"360">1Îo61">OKggâ62gWS87$3G409Oo\4W410牔5ǝ(, 0er 6碽a,o7">h?packagP9ensureKoo8xdifiese(oGa.lang.ObѨ<ǯϒAxƧ$b5& Savsfile0ǍNϱܾү?36`??unowa0de:(xml:hcxserve"oac_no_warnF8 BGBFHFJJ߀ޠ,TDPJD18X߀ܢTG geë?36)7. ol "( Addmporttmү8sql.DD,hityprRofs" /;717+o37,;sF'372' .ŌɹׄprivgaK7[40{ɾ8gHeIdStrfirstN 漀߁9email~phNumbe ^ire'4joboضxalarycommissionPctdepartQ3"id="375"> Right-clicknheourceditoragendelect Generateccessorsromshortcutenu.Ƀρialogox,top-levelWW7">Employeenode.hePmark!splayedXthatJallfields.ÉB8">OK. Figure 5-1ws//)ithed. A">Pupddata.htmBGBFIICA"ame߀߀ؒDBP/-TDPJD324/߀ޔlC+
    oj"瘟"3a5.2p(98缴R#arom Caa basaoappxrequsouooϺtasks:#olTW"UPCreaatnHa icun@XusQisplayB:< editge.-2FVtakH!dYeځC380O@_,yeveryRof/cluxankۢowr)Bp<1">.jsp8with//ed,ady*H4&2SPߊp3߄,k4ؚ08aT߬`a󾰽ցʊchanϓ54proIR5cwriTOO6">.juv7">=f88">Ywis(htoohisn@eollowingections:

    CreataaethododentifynmployeeecordAddLinkNavigЄ,Page38G3E9HJSP"EditIJJׇHaڏul:upda.htmBGBFADIE"ame߀߀ؕK"> /-TDPJD187/߀ޗL+ 5.2.1 ?????h3&pP">TmKyouesetepHsseZfprrXparticular.twhen(rantsedele77=,dlslthatoo.jav>ge.CoFRDvalu1SIfT">asr*notldyp JHourc or,uble-click App蠌ot.UVHe(rnewJiCieȍ/cPbe X`d:@(xml:cHxve"-oac_no_warn90PpHicWById(ina)0rowsQLExcep"{ }׎3F1Wi8#bo ,mCinstan2/2/beiall3">Ke|0wwwww394p =e();g95 Conn Ѫbaseggggb60getDBWl5&7Qo8">StPmHMobjh9">ResultSetypem@query. @trssdistbuggpǗ77772APstmt = c.ˆ(.TYPE_SCROLL_SENSITIVE,gxCONCUR_READ_ONLY "SELECT *ROMsHERE_idi +; Syhm.out.prln("\nExecu:Jwת6FBRu0(ta@ C`rs=mt.e eQ("9DUtturnP7E">oopתldsݷ"usAǩLF9.颟 Gwhile (9.next())mp.ŬQInteger("gd"))@74FirstNameStg("f_n؁؁ׄLaρρȻDžDžailwteOOetPhoneNumb.p_n??etHirepj"h_Y(a(yDo|"sJobHjobK;''#8fH!zdI Gp/ol1div> /-TDPJD18/߀ܿ K+ 5.2.2 a͞Up aIfollow1ps,ou@lleow methodopdatemployee panhcbase:

    DHandlerlass. Emasollows: ?3VWithbodyf0ist,reY0instanceWA0">;beanontain9dePlrRselectedF1Ȓmldf=n~ById(d);O42Conn@se3A30getDBx(W+5.4Qd/5">Stxmentobjpecify6">ResultSetyps(c7Hstmt =8n.+6(.TYPE_SCROLL_SENSITIVE, OCONCUR_READ_ONLYwK6N8''9!aBuffWXaccumulyw!A">UPDATEMateedsb`uiltbBHwer lumnsnewK( 255 W+7.CFeachPeld.recorheckhp೙uchangA:ifo,dd leva2HDWW>. iPaaft ;ammaYseparis.ԁ"񷊆sY/E">׸%variablɇWPsvqFדלHwilliS6'''''yG (e !u&*L!.equals(Ge.FN()  (.append( "/'" +eh" %H">I">^, þ S*elธsoۑ'J>ǔDŽƙromrviouxne.s:AKT!L length> 0./., 4A??"4////L(dsJlogic۷؏~maC M">emXnA0N">phx_numb7{divign="cer.O(inftblnottP">
    +OnlPifictfc`incluwithisXocedur@@nHᾸbmodP//U/Q?׽R">sal%2,bG(SEA׹T׹פ0sdswU#gg]3M WRS"().toKϳȅij4kStringBuffer
    ontainsnyth.fo,structQL UPDATEEstatements(henformation`/2>Pdxecuttqeroesothanges,utpumessageayso: if (lumns.length() > 0 ){( sqlS = "updmployeSET " +FtoP+ %"HERE_idd;Sys..p tln("\nE*:)stmt.L(}pelse "Noo1ojdӆRd Exae 5-2
    h: /-TDPJD189/߀ނ,F+ G"br/h33BHPspanc@NI">5.2.3ddainkNavig@0U+PageInheollowIps,ouddleachowfmsableS>.jsp,atsersiclic[dit.XolLIlialue="1"id="3BM"> Open employees.jspnheisualditor. Tromshortcutenu,inwww!Q">InsertowsrÈ2s.ɊÁ7s 4alogox,߅߅ߎR">ꇑ__ S">Afterӈ؁d艡OOT">OK=OM3FU@T?9willnH$inkreads eachow.ŀQssjaparateageher ЏedrecorbehedoidoȕcriptletxinsiV">EtljSProp0ieox4C0Modif[inclu?18 >(miulllowingde: 2( whix(rset.n ()){out.println("<tr>");d + getSt@g("first_name")0/  em job_idυχχχχphone_number߇߉ GG3">NJD("salary$7w445Yaref=\"?Int(185\"QaՐ,}X`p6">W)@rxanyqpРh⸵ID_C7__gЫJhz-updaO8''ѭuzsear i٪Jticuăabase.'#5v9 SavW"A(UW<"ki:pos:fid:001I:offH2UPB">Figu5-2竰Chn 0run¯La, usHtѷΊxrоҳoY8divfrD">юrhtmBGBFBEEH" I߀߀زE/-TDPJD327/߀޴F+9tiinwGw-2̵<1R1imgrceH0S?mi(im/gif`lt="Deion/s"/>
    oj"////"*5.2.4|reaIf42w5NϏ421אlOJSPЩ_DHI!(,oucQQfia PW۫olRYSew QbQ٧鴷TAccep ︰refaultsȯUGiI sheadJs li߿߿V">AnyCoorpoon:Rpp,ဠyk߂D0">HstyIop(@aligcentظ򆃇3&1OsnextqtypχW2">_aRb,ithhe Heading 3tylepplied.lign8is\toleftfpage. AddD5">JDevelopersheet݃x56|a jsp:usebeanag.nterw8">emps_>sD9">ID\,ndA">hr.DataHl)ύ__^B">C<.ӈyC">ScPՍwD">sessioUclickE">OK=6FPositJcursorfYьHBHbano_JGύύTtime Hloye0I0browseselectwwtJEleavЌËםDK׋כw7LMriptletwț :peD_N">finduByIdmethoIdetridnsidO">ߝ˞)էIfollowqiInsert`]dialogox: 8QR">Formot 9,OS">upe_ac.@fGGGT">A-fielYouanJqromropownistyh!yredt/.9~UV">Tabl. vitGeꭈpecify6-2-columataccepب:efaults/.10E0ʘcirh󍕙'|each a pXte :1`NX2">La.3)ail3E4">Phon5">Job׾3EMonthlyalary1~7Drᾗ8">HiddenƔmcompXntOHTMLJofCVPa`tHD"secoɍladj`Ь|ld79EA">pPVB"><%»!Ŧ) %>EC">ʄ 'o2nDooExexߌߌߌߌ߳Fq_n{Gǩ_Htjaw6Io.lickooJ">OK\??3>KǘܶLe ߷ώϷ3EM">tNOtIo3EPuQO14RòimiayAdrsǹ renlusQG S!T">p_numberG_3E@jobv8sO/" 1correspy Xamethodxr,Thesrpecid5tableWW5UFQA׵ aid="3F1">Submituttonnheorm,elowtable.nter Updatests Valu. Savapplicationp5">TresultantQ6">edit.jsppagehouldookimilarowFigure 5-3.

    Hupda.htmBGBBIDJA"amȀ߀ߌM9H/-TDPJD328/߀ސA+titleinwB-3rengSPЊXEmployeeetailsCimgrcembe0T?miPim/giflt="Descripf Pl(s"/>
    oj"WWWWWR"z5.2.5ǑǜHaA ok3O4I cIis ,ouille pcYs?K4笜L p_aj>iT processes ׯTMϢϘ5יlN۪??pat !serpo #erecordeanoisuallemen,_ dly)܌?uOoɒturnsontrolmwPhsк$QgR0ewAcp?S"ϏϺ.cep2refa`sAWiza'%TDra񽯽;U">DiHtivpmponromPCPaletPW. e8)Gdialogox,rXi`wV">java.sql.RespSet.lickG0">OKu]G1Addn2Xsp:beatag.ntxW3s[aTߌz4D,jp5">hr.DrςϏG6">CaΊ(gWWG7">ScopW8">sRʅcG9>GA_wB!xGĪæῙziՕl>Gx: xml:hcxve"oac_no_warnCIg_id =(request.getPar("d")); Strfirst_0ׁ(""ǿ"`ailO'h_numbdž/eralarywrobS(".3E(d.V(),x,S,,,m0re߲JGD߬߬ߥcE@xdg???F(SFGGMpyg6HSayourork߻N7>IRujؿZthejXndA coohJ">E෕anyG83GKXIshould1eظπwnFiguH5-4us.jspage. F 5-4ditingŌD
    oj"ta" !5.3 __[8_?l2[InserJfRecordTstepsr0ewor2o"MsablHsimilaproces ał:;ol4"lialu5CreatHoz|owt6">*.UH7Addlink=maapplic,HH#uce. 1ak@ݒ 8">3>ithtyQmadZwent݀Y39aSP2UҢذ_AGB46Bk"controLa%a*?ϱɘCis y)covJava߁Byq(-[subLsTuVDTEa vpos:fi1L:offɀ1IFVF">MΡs\GGp4VOH">X#LtNavigٖP'o3HIoooMoJo4!Haߋg3HKggggH67HLg*ENuoCBCCJg޳lM׽9(ܵNr.jHESourcPditorI0De(ײȶ7xxml:`c0x0ve"oac_no_warnF1pubhtrzdde(first_, Mpelghone_hber6job_id,Yay)sQLExcep{ }P7R27innH)bas3I3getDBC();ǻ߸?4ߙH3I5">Stmobj,(f1r6">ResultSetypseȩXRulpLB7hstmt =Ȋ.(.TYPE_SCROLL_SENSITIVEg CONCUR_READ_ONLYsql"INSERTNTO sALUES (EMPLOYEESQ.next, '" +"',Ŗ2WG"؄SYSDAT(eC +,.30,100,80)"%align="cer>8y"inftblnote"id="3I9">
    :

    The Xthreolumns (CommissionEx5-3hows zeF">Exoyee()䋘thod<-e#fGrupddata.htmBGBGGHBF"߀ߜmHhh/-TDPJD330/߀ޞI+"titleinJ70͇28New ecȈ3preml:xvXߡأ\K(pub0tr w(first_Y, MQemailghone_number6job_id,l)YpExcep{XgetDBConnec)();stmt =1n.creS(ResultSet.TYPE_SCROLL_SENSITIVEgCONCUR_READ_ONLYql<=J"INSERTNTOsALUES (EMPLOYEESQ.ht@, '" +L߀"',ߊυ2wWerS SYSDAT؃ nkA,.30,100,80)" ys@.out.pXtln("\nICng:R^.execute(ߎ1rc; } ?r BIAAFC׀޺dL'19'׀ܼMO"s2Nih33IOncпP">5.3.2Link9NavigP0sf4&QÍм.jspiVisualditorVVPDra8boldJ0">HypȍYcomp(fromHTMLommpD\Palettylumnceltndu. 8:dialogox,t`oH1">iz2>el aX3q߃?77J4">T.ٔ`hnot!fiǍ5אwasZhave yet dt.Õ Ǐ6">OK7.370S1/8//eW/ol777BBCDJG7ޕ97_795_ޗInsertmployeeecord,ndpplyhe Heading 3ormat.lignis$toleftfpage. AddOOOJS">JDeveloperUstylesheetՃwwp5TtaU">F l.ɇ1e8ialogox,nter iB_action.jspAprtyclickߏ߃2">OK% 6F3GGR4">Table%i@5GBSpecifatouant 6ows2olumnsacceptll0ratefaults76firstԏuollowٗs`achnseparate:$7h N 8">La3K9">EmailןggrA">Phon/BpobwC">MonthHSalary8DDrag2dw>Eexiel \righ֧F"erwtxtyp?3KG">"_9i߫ߟH">gf9I֮J}n 3KK/77CL/3KM/WNwsAsڇGes@ f 󸯸OתtyאױH.Ԅare dicdeta: `_X NjNjDž7377we'4''~gp)_numbe0ߕߕߏO5OOwׂWwts_/zhbr/p> Combooxcomp؃romHTMLqmage݁؁TPalettocolumnvT">a\UI?8SelectGx, jmV">job_ids9$3LX1Wjsize.lickKH (+)cAςV1xA_REPͶ,2">VAUC3aption򈟇&Isepr(ntativ_]QsYѿg 0ss, oo[5">OK\༗o6oܼGDJSPsrawhiyou㙠#new !r"order="1"idthP00%"rame="hsides"ules="groupxcellpadding="3spac0"> ValueHR_REPViPXntߥ|/tablebr/divliPliuh12"᪑3L7 Drag uno ormwz.ɁInsert dialogx, Xer „9">AddmployeorOOsACprty.'&p$B@Saveourork/ol puCaref="kindle:pos:fid:001L:offHD7C.Dgu05-5howskata.htmst 434"EF">i.jspp錫Visualditor.oj"?׆׆"+O蠂ώwGBDDDGOܡLw'v196ǏOޣMu"sectNCh33LOХ numP">5.3.4Crea:`穽QJSPКPHa Ac!seteps,)3LS_aǞ.his aCthatcesseKmputrom9T,hich1usaewrecordenoelemsIt,tonlyd U QreturPontrol5V">s/iبй#M0YM1蒪 a"ash` Callɶx27焔3QM4񿏿5">:(beatag.׽M6sxo7`D[o8">hr.rςφ77M9">C.etgχMA">ScopeoOYB">s™,clickC">OK=3DPosiQcursofIٛBia___MElet.Ş rheollowingodentoInsertcriptletialogox: StrYfirst_name =equest.getParter("");ł聿"mailOOJ'hone_number/erob_idIntegsalary(new(("[")p empsbean.addEmployee(,W,,dž,T, .Value( jsp:for0d
    o%page.PtƁxpr < lI"> s.@.腿5J aveourork66KRu??L">Viewproject 1he0rPiacord/olpM">Ton,pickϛ1N">ܐň܋[?3MO">Figux5-6A.divef>RBGBFCCFE߀ޥDSLjTDPJD332߀ާlT1ti8inwU-6iNČȇimgrce0 0?miXim/giflt="Des iof _s"/>
    oj"φφφ"j#Q N0*ߑߑߑ3DN1-7Rs֜8׷ǜitho`zfilledH,`d"liPs(gs Xselyaٕߕߕ߇H2wwICDHo܉T3ߞ33ދ|4ߕߕߋ5-7ߕ1=440׀6g՚g(IFEI߀ޗ|7Ǥ197߀ޙ8O"s19(h23NA numB">5.4DPan埌CRCCMIdentifyipcurow.his =bed.liVNH@Ze0thatsQfromBbaseIPAd8Hnk@aapplic8ach9![c"rhډ$уak8-a S_acY.jsp,IDwR4="KT//Ȋ,l0JSPQ+SϕS 2/ol3NLɒ8discuss\KtasksXlչ)G@tuvMt|NWWSNWLOOWWAC6P4DQ">#L ǃG3NRGG6GJSLPLHlA*
    /-TDPJD198/߀ނ,U+ V"br/h33O0Pspancnum1">5.4.1reating sthref442#MethodoreleDThe큫cqednfollowstepssstoemployeeecordsyD: Jourceditor.w8DerXewthatentifies߈ډbed:(xml:hcxserve"oac_no_warn9publictrCEStm obj,@fin,E">ResultSetype, )mulyPHL.ddtrssag8osistith0bugggjFstmt = c.~(>.TYPE_SCROLL_SENSITIVE,g CONCUR_READ_ONLY`sql= "DELETEROM EsHERE_idY + ; Syxm.out.p(tln("\nExecuY:J&ϡ;5GRu71GGGGG)H.ee(wW?6I0Ifunsʇؒyrrors,turw8,JuccנKT"s"ͯOL="ki:pos:fid:001N:offH3MQM">Exae 5-4qh Q򳙱gN">'&)M."e[OBGBIAEIG߀޼P/-TDPJD33H'߀ܾQtitle:Roh an~p񹳰ǰǰǰǰ3OSǰǰǰǰǰǰġL߬ޢSGGGGGGo򤯤+ϤϤϤϤ·Gқ}p+/ola OOBBADICO'޼TOwN199w'޿ UM"sp2>V8
    5.4.2inkQZpOIfollowinstruyouxspef44熕3+aeach x﯃abPا4">>.jsp]page.Ý(gat[willX Ý`ȩ\ol55I16Openo7HiVisualditor𼧼81column2d@ta,BanoXr;1ooidoe-cٻscriptisi$9,display[Propertidialogoxg^3VAModif[0incluia9B߶ߕ5疧TCK_aғߓTHm1i0uldG0:Dwhi8(rsHt ()) { out.println("<tr>");d + rset.getSt@g("first_name")0/  la("emailjob_idυχχχχphone_number߇߉߉߉Double("salary ߊߊ؎9aref=\"edit.jsp?empInt(1F\"Eab delete_actiongG?;Dm} Save ployees.R/ol1div> /-TDPJD200/߀ޑK+ 5.4.3lreatSPageo wustQ446OHandl kbInheollowsteps,ouI/0Q">OLLp,hichsatnlyrocessesperherp noisual mentsh).olRIW1SP8allt!Tό_Z7׍?:usebeatag.sefor(er1saSk2(DL,`3">hr.DrςϭooQ4">C!,.etgQ5">Scp3Q6">sʅclick7">OK=吝38''9!riptXG2Ō›Y"xCInsert >ialogox:xml:0c@pve"oac_no_warnApeg p =pnew(requesPar (" ").SEdById(d.V(gggB`DragordromCompon8ؤqoQC0igGA܋l݋_BDwtǹ5Eūrork>QF8Ru+jtryJn.A="kiQ:pos:fid:001N:offH8HAG">Figu5-8how#linksrecordG8Hw"f¦IFJBIF߀ިJw33Po߀ܫ KcYtiinwJL-8̉PJڌ̙imrcember2?miim/gifPlt="Desf Ǿ,s"/>L??:8?oj"7wwww"˄5.5EWS97\UExceHgAϿR0t50ǗW1Ϣ45e="upddata.htmsthref451"id="3R2">SQLExceptionbjectnstancerovidesformaa a baseccessrror ther{s.ach <3"׃׃manyypofon,cludingHstrI(crib{,hiissedsJava age, ilableia2ω4">getMsmethod.

    T(samppapplic@sq6pa э2"ameᎌ7tryEand _[3?<8;9">HchblocksEaremechanism XdleWithrfkrows o,need(oȃet.enerallyA (ʐƊ!specificourpacRinkvent0끨lHiXydisplaH#B">JDBCLjÚqCW//(cc@.Ɲthreas$ЌׇIatecutsumust /ϣD">All̙Ѣѝgf3//*1exR2waE(onnЧ_㒠cVAa])ҩ׉soW@F׬}4׭_\G[Epoyeesfoll:D@xml:spacxserve"lass="oac_no_warnH"> pubHesultSpǃ() } re3RI">*;(B}JRܴ,fH$|hJ">aunteUP]gK">DHr.j".ɞٱȒޢW*L"Fontaٴyworkdon*tarMt9wوrfs.y+s[ȹeowdd{ܶG׍׾kTDPJD20߻dN 5.5.1ddA*ٵMTnȹ^שש׹rdӏolTx:クS0隷4returntatemennclosedn߁G">tryblock.Ԅ(couldHsollows: publictringeleteEmployeeById(id)8r`QLException  a getDBConnec!();stmt =4 pnn.creS(ResultSet.TYPE_SCROLL_SENSITIVE,{'wCONCUR_READ_ONLY7qld= "{ROM shexe,_idY +0]Sysh.out.ptln("\nExecut8:zV't.eBe( "$"}"catch (e)eSXckTr0́} `ol1div> Jspef459'lK-br/h3WW3SL`nGcnumM">5.5.2Óᗩa͞for gb60GNHandlAnyAsHin;toҢɤ9saУ ppon,ouZhdɡ`udahtighPш0P">_:oee]. xcallשQ">Zf8s@yclugh AٮHhavccumulhd, 8tёBeach.߫A&RBGDA߀޲DS//(336/޴lT-ptitlePU">E 5-5ddo eULA׈ϴϴϴϴ3SVȴvolog( x ) whi(!=uexߨ߀Ӱ(Next/} \T0">Ix+GFT1OWdtȝcexplaihwhy7dxPadwJ2wwrXoxwrittexȝs:wwwww]3pO  qmureh=T4">ToIhf`rWonol%58N4.ȽGTA@Ebߨ۱incluǕB">try0Cs?~3D EOOIz3,u'F4vGF8>ϛHtxgVϟI">۵ t1ssagedZ(duas:qJwu/ol1B~״CCDHE׵ިK׶20ܪDLպ'"sectoM1br/@h23TN(ncnumO">5.6 ȼPNavigBSøh2QYWRо7R3TS">web.f_ǀ緥TdeploydescriptJon.ne 4OhUe*husdefinAartٰWxIex׶׶׶׶׶V&lt;web-app> ... &llcome-file myWF.jspl/wtIԂ Ifouootefine agen!r .xml Y,enerally0ithhea'2">index,cextensioni3">.ht~,Y4VoZ5eifrsn@usedsbstarting .׆!JDeveloper,canwhichloeaultun getЈqlicat@,atXIo 7p,isplayhfirst,y˅i@YrYtiekject.@73U6">Oncn`Bed,ndϐbee(, vig}rougۇonachi`d!followscheme:+ule7"li8xLinkmHTMLxchIagl,uzidentifyahSP#$`s9t.hlih9 a8="upddatays8ef465"ᝌA">submpbuttonap䈙suP0qeranewchangXGBGGF6G'CChD">:wardexecudqup oe:.agaihؐ~/ul77BGBIEIAJ/߀ޫE_\TDPJD20W7߭FK 5.6.1rexӨP`Awillǭð?E߭.ԭdoP)incluInclnt9imp\o篴logKM">⶿>poYthNOOY.'!OʜGoPvalu1.QPb(ch1R"eShFL pwe{yaddZ" romFComponletadrboldT">ӝ{VUWW\3FVh\Int 었aox>7"3V0">,#Q1?2">oMV3">Ynowpecș)sà]ge/'nss:/{4//A5navigator,ight-ckViroj8ShooP@pPؽ߉6ߤXtre@s0ధ/7">Run/Debug/fil^H asuRUӖs ed3lnfigur؂DOJd.ÊZ8">Edit39aunf7WߘA">b{[Y:,B">BrݨȤ}eYTDieldȮ /Cjustwww3VD">OKֻE@9qclk͠F!Pyck׬קG">٬dlect Runromhehortcutenu.ԀapplicationunsndKindex.jsp,hichaseenet `Idefaultauntargfor:n+_J_]wardsouirlyologinage,1K">Ⅿis8splayed rrowser.

    e6Enhancing"A:dv،JDBCeaturesThT scribeddi al y[ithatc@useVJavaߔ9Somef9@fTveotimpleta?on€sNareJ S @ropermvSwrincluBfollows:ulT"liUya Y="kXle:pos:fid:001Q:offHTBNV">UsDyicQLs/li"400R:\401">CallStorxProKWW2gggUg2V3eCursXVariabl?/ul_CIHCIDFȟ׀߀܈T4_07_ފ|5't16<2?4P//8(.15C7 9?<9sxh2w}A"'QL, generPQQLtatdly,aHnntea du@vironI.eryteȷespeciymatup!oabas(iyquhknow8ntilYim4B">F0scenos eРyimilariwithhffxalumusJx߱7@_C?40Do0O塜EOraclePrep(dSbj(exPd;F">߁ߩ. ²donePubstitubpl'" bh\.ٳ|alsosL/ cL(LroughG?࿧H473 IwlewwwJ|scuss|topicoKoYLooooK6^Mm϶N߹߹߹߹5G8OwwO8POOOOh8CR>QMB߽g߶߶FAACA߷޿,R߹߲ݿS߶߶ؽWTh340U߶߶VڶǶ474Ϸπ10/h3O1o׭׭412צHoweverȃKmultiplز{r'hathct{colum@4itfeasihard- ea@narpplicon3">y'4">hspqBCidalikCNpxml:Hc xserve"oac_no_warn&5`SELECT *ROMmployeWHERED=xyz;P7416">E@yHmehealuef xyznXisueryhanges,SQLtatementeedsoeompiledgain.

    Ifouse9">OraclePreparedS=tionalitywarun ׄׄ6ׅBprendoIaOIC">object, Qcan;tsanyimesqrequiwithoutingyevɁiPp. datxe_7ՎBǍǍ7ǎ瓼Dbivariablplaceholdersorω@nroviheralˇtڈI'+E">Consfollowexamplus!F"גג>:kdivlass="G''TDPJD33_ߝ HOOK8O/DIKɅTtitleinJ">E6-1? 9K Creat!a 76reml:sp="servHoac_no_warnL"> ߟߥpstmt =nn.0Ѡ("UPDATEŏoye _ETala= ?HEREDi");.setBigDecimal(1, 153833.00)/(I8210592) rex> 1M">TadvaɮNoo"f0pclude,ulO6.1.2խ[r13Call)/h3ƲU24">]accesscedu0Rbas?w5mغ劼6ws.hextend7r8=3G瑌9όϻߦGDsistndardDBCscapyxIc8. may٢0withrBoutular.owever,fdo2_]tubegheas iAUTeoϯXryzʮ@Ph7B">IN,qCboth.,D@ 谷(hoXin itPfromUE4lF'''5G,/42H'ǽdI">\Ϫ0J"inlinalic~K">XXX\'LuretridWWM">g42NObPO777Q77bkJava2yȻR">AS">lsournltiT">RSbjswHAZexamH,z)cre7ableStatementoallhetoredrocedureҀfoo,sollows:

    E# 6-2reating G7O45SCa!pxml:spacxservHoac_no_warn6"> Oracleds = (P) conn.par("{@(?)}"); re> ɐt7">YounbarisWnnefJQtwoayψψψψ439cs.setS(1,"` //DBCandard or...xAtN(X, "valueԋkxtension'#WTCIHCIIJBW߀ޛ4AW~210Wޝ\BE"sect2C
    6.1.3s?G-FKBindari!sFPL/blocksxlls,̏hqualifieroifferietweenpuoutY:1?$MD43N">INO">OUTwP .Ʌ.ɩ8yQ"> ̮R¯inlitHcS">XXX\mhod/sTobepevx43U">g43Vυ40,ho121Javaatayp֛ۥQdepenФ蛭кccolumntaccesRȽIbaseC__^DGFF_7߉3__1_ߌ$4\v2ctG6wwv47q2eqS P Q2WE88Donnivity (JDBC)rivsupport p<W;079#'anonymousttckyxmostooS3oOAkscap3լouhworkanyR:#xexampleB//33'ߟCWW494WW4DE# 6-3//-xml:cxservdoac_no_warnF"> //;QSs1 =nn.eq _( "{2 (?,?)}" ) ; Hc WW2WWWU?كqwwx 9773os3beg ; ;χ7s4777? :=ꃟcPX Asnxamplefsingheracsyntax,erexL/SQLodnippetatreatestoredunction.ԂĀetychaPterequencedncpnuffixot:

    E,6-4ÊQIa G6O,LSSFpxml:spacxserv8oac_no_warnM"> Kreplfoo (val1) return*s begin:|| ''; end; re> 4N">You㕈call(xWinJavarogramllowsǑǑǘOǑǑ1ǒޚPǓ497QǑǑǗOR6-5È498STDataSourods =ew(); .setURL("jdbc:o:n:@<hoststr>"U("hrtPwordConnen@τ)ableStmenp.8pare (" ? :=i(?); cs.rshOuPe(1,Types.CHAR;S(2, "aaexecuteUpdH+8sultځ1ooU">ӯs+sescribeowusPcedu`iQsappliOLP5Developers/li2(75P3Methodg454T"5IsChooW637t_romA(ul/*CIHFBGEF/߀ޑ8/WV212WWޓ9"aAqbr/8h345B@(@numNC">6.2.1/h3&5D"> oGC9w'E5q_ F߸50绿EGGGBabarough9Naviga.ɥ¦eps,3a? thap(@ds al8nxveayf{nHoyeecook.so5Hvalu@ISelx“hboldJ">ŇN @Avi//(7EK(Expe dnode (byxfac1)Ys!obj0HR.NMRight-ckWWN">^s,dJNj/O">N׎4PГ+edialog,nOIQ">_툵7.Çߑ//5R">OKS">TkPt`ZforbdisplayxSourcediA?{5TAf1׽ш9fo=xxP:`xml:chx@ve"Moac_no_warnUhPROCEDURE "INSERT_EMPLOYEE" (p_first_! Vs.%typ( p_]os.cZemail_?_phone_bЃer_job_idl_salary employees.salary%type ) Afterhe BEGINtatement,eplacelinIatads'!1">NULLwithJfollowing: <ml:sp="serve"lass="oac_no_warn62 INSERT8TOňALUES (EMPLOYEES_SEQ.next,_first_name , 8 Xp_emailRphone_number,YSDATE)job_id,.30,100,80);3">Youaneshard-dˀً@aHd0rcolumnsn4">addMmethod65">DataHandler.javam.7>6ddproceduh҅7">END'''''8؂xXt#Ř89Savfile, heckhȌaanympilationrrors./ol/46A">TXletUstorpgishownXxfunc.htmCIHFDDAA"߀߀ءDP/-TDPJD342/߀ޣE+LtitlepBFä8tL/SQLӊPtoɐ As46G0PROCEDURE"_%" (ǣ.wXs.>cZkWT"?WP.erĴ??? AS Z?;y: HEBEBB޺HG213G޽Io"sect/J
    6.2.2aͱӚpUscW[M">Isteps,|Nb asltern஑ǸOǸǸ. inewEUmakf}P">继گ?Lol]Q1Rel(="boldS">Applictabdisplay7naviga TIUc)anotxdype)J`ourcedi0,ouble-c k釀otVmpo70">CallaStatementin0ffollows:91xi).sql.ǃĢOj4F2AfgU3,Zderfo?4߸0SPwwwww15ppicrZSP((C2?̹Ў0 )r QLExcep{ }|76">1sigh𕉦sX97'C58!nsiɍϨ!9">tryMblocknd9at,onnd@baseBAp getDBCP(); &/L6&B i ,Cc1QL09wwwwwD \= "beghr.OJ(?,0end;"7Esquesmarks (_HF">?)%sbivariias ceh`erIJs9"47G">first_name
    , laandonxpectedyhetorpprocedure.

    CreateJ">CallableStment4: ol8nLhSetW5M">IN xters77777N .set(1, //(2, 'OI3,mail'OI4,hone_number_5,ob_idgInt(6,alaryߑGC9FO@AddressagecrunIq8|.GGGGGPSys.outintln("\nIn@tith: " + gwexecute('10QVreturn] Rj\"succ"; w߄R1SfHߡT">tryblockU">catchWPo1p@yrrors. QVogExceptioncdn ExampP5-5
    GJ1 (QLF )'' Possi:our`of3:ak ouav\")@ on(ڀfHi; }22!ɱ?3">DataHler.java/olP#4">To9hoshownߍߍ1S00BM556-7ڴdivlign="c@erv6inftblnot`7">
    6.2.3llUsohooseʧ/+Tep2t)ɿaadioutt`groupQJ">[.jsppagPwhiXaxickbetweenܻPcordsinghetoredrocedure,ryaQLuerynavaode.

    insert.jsp Visualdi,ftsotlready. UseBeanromJSPagefComponentalettodd P">p:ut8a.n)Q">empsbsCD,rowsselect_R">hr.DataHandler S">Cш , t׉8T">ScňhXU">sessiow ill|,styl$_V">NЕstHK 37390DAPWW*1">Routt{cHTMLormspei؟qfbov{tablI˘odialog, 𒯆2">XSP93pam,Y4">falsf5">Vi 6hecked.lickWW,7">OKu]4v8 \'"posit0rightUbKtexoescrib3purxa0'lyDBC|r''59PrXae0Ԩrc'6AsSB//>elowirs@{ QCoDooE">tr٫gWoFFgWens(ĕbox5>7VGrdit///////ߕ//s8 procedcallviaǿ8HSa%/olPpI">Fig6-1hoK">.ewEr{v0opsoJ.
    oj"X"6.2.4Cؑ__romAppah3.V">T0steps`!modifذ4A0_aJ>whichKss\m@}1q,ŢOLSaýapprimethodBkeoye24ol2W1UA3POpen4gdiftalreadyhenA5Double-cleinvok Ƣpdialog ѩvafJalaryֽ`s}:ཐxml:Xcxvȿoac_no_warn6trxSPFlag =Xquest.getParX("");h`(37Be8 ,@illP thecriptletropertiesialogox,eplace iexisting empsbean.addEmployeeineithfollow!sf btoelectJ9">eSPmethodrpureDBCA݃insrecord. if (sFlag.equalsIgnoreCase("true")) SP(first_name, `]email, phone_number,ob_id,alary.intValue()); //rwise elsegWWWWWWWT _action.jsp(s/olp]E">Youanowunapplica)ndradiouttonXkpagchoohxywanǚnew-ɃProw, willyearsn Fig6-2.HdivUf.G">H@func.htmCIHGBIBA" ߀߀؟\HH/-TDPJD345/߀ޡI+tiinwJ-2sSthdacedsEnterҝs#imgrcer4?mi0im/giflt="DesJǥs"/>
    oj"77777s":216gްM< 6.3Ap׀dQ kCursVariableh2AR">Oracldriveruppoc+v-_/(S">REFT">CURSORtypes,hichᶸnotppaHJsthaqU__[V__s"BulttsԫEB0">A׉ld(memoryo(aueworka,pco@ntH#1.eragc@toerSQL,@dataڳ7Y1όχ32׿´inlineitaB3">x ex4' iPf ϊ5bERENCE67resbitygfn.8߲߀9 X @n,ifi^A|.ecaYmanyGEmightxisr>@GAGGBG3cbhouY1aegspecɗtOHdif…`(פ4Cu'_MD'esiallycap`bѠӝJġ Edo( return8SԎccXby,ou )wFSG4=W:H? ainlEmetadIO(J/)σZpXYetwee RDBMSRzlip,1-PL/bJav˨basalsoьfromaor`proPuredivignp`er&K"L넀N ac_no_warn"mmary=""order="1"dth="80%"bhss"u="groupxcellp ="3HcbodyIrqd4p:þn.scrollThecfowsubsDul Np<liid="4BO"> OracleEFURSORypeategoryAccessingRataWW4BS׆׆׆׆71WT">U7inheampApplication/Xulbaddfunc.htmi1058743"ame߀߀،tU">/-TDPJD217/߀ގV+ 6.3.1 st50焕3ω?5084הההh3p5">Toreursorariable,eg8byentifyQathatlongsoj@К .Ƅex:ס0LG"tVBCIHGFBCI߀ޗ\C346oޙDptitleinE">E 6-89wDF{DVaws%GDECLAREYPEߐISR$ CH?4??J?*,(isids,arnparticu/.toredrocedunetur71s?10GgKL'4CL''M''#ThoutputaequivalAarbasaDBCsultet.CFFFJ_ްN?1G߳OP/)QR2Acces¼g1'GS+R_#Pg4Tk/Dг4CInava,ǽQaߺߕZ3߻kDhڳaǀ87mXlizaRSetobjnd xa followsy3Wl7Gއ4514Ǭǀ牼5د9G[ÏOOOOOU7Himport8acle.jdbc.*;BCallStm cstmt; V4; //բaL/SQLlock)openr  =onn.8eI ("beg؁?@rlQerommp;d;").rs0OutParH(1,φڶs.Sexecute(= (()).ge(1܇'ikYnormal whi@(.`t ()){Sym.intlnNStq);} 8q tlxhod}iot.plixDET󗖘l⥑prouthatturn4FO67ΪGɨlways,4 sOmust-0xdeft.Vq Hwm6OK16"id="4DI">OracleTypes.CURSOR
    or REF G@. Theallabletatementsun,eturningHL}5M|HN">CS%objecbcasto!O"*useߊPa Qaddfunc.htmsthref517"amHQ getCursormethod,hich9an 3xtensionQyxndardDBCpplicat programminterface (API),dsR/oowSpesultSe/ol1div> CIHBIDDH߀ޖTTDPJD219߀ޘU`br/h3lass="s@2E0spȀnum1">6.3.3sߋrSampAIfollowqPs,ounhanwzdisplaydy@lly-generdiofobDdbtitlesJfielde*resert1aewoyeecord.Dk$ǑLװ(uYC">T9i$cQ`䉭ɤq,?D">GET_JOBSl,atYxYEHrievr2 sF">s.Java渷hG")υpٷ(o跡<ϨGEBJEGߤHGG2@ܧID<Шct3J ,4/4E//%*.1=___[h4usteppihox N//dehpoOvalu1^PPSel[="bвNavigatorN-hviit^/ Exd///EConnnɱmVs.crwRight-cHk//̾0Is +NĈƖVeL/SQL6dialog,terFPKGaqe.Ç/WWF1">OK% ٔdefiniٽSour(Edi2Pos[cursor (9e`firȳпphsŇ0'). ,ɮ7(GExample 6-10Q:3"e8 //FAEJC/ޖ 9/W.348Wޘ4A-ptitlePzB'!GGGDA4FCACKAGE ","SEND׷АQ:IHBGAAIwޡ|DǼ2hǽwܣEFG">6.32reatingatabaseunction


    The8steps edf GET_JOBShatsesg8K">REFURSORvoetrievqresultetfobsromeLJL">Jable.HVU.ight-click ǎboldP">@Äselρϐ|Q">N菇Nshortcutenu. OK. efini*forEUomdisplayFSourcedi'e3VgfirstinfF,ubstitug"4G0Pkg.ref_cursorߗ*`urn,8hX1">VARCHARG4 G2HAfO3">Akeyword}ollowX:hreml:Xcxserve"oac_no_warn4 J ;>O556">BEGINblo jrȀnt7PENGFORSELECTQ_iAlpROM ;RETUR-68SaOonu/ol4G9+ݮiswHa="kindle:pos:fid:0020:offH4TEA">Examp6-11\diveBa add.htmCIHJBDJF"߀߀ؚtCP/-TDPJD349/߀ޜD+A܌E'!aӱed*_____4GFxFUNCTION "" AS_WEND`: ߎHHHGIJߏީLGߑ22ܫtHݔ/"sPGI
    6.3 CalgBREFURSORaethodgetN">DataHaa˾xOwJtriePultetolP11QDouble-clighR.j00opetoorfsotlPdy'FS@ErPo4GTp(ic҉*Set ()rowsQLExcep{ }UWithbody,n`dbase'''''"V`DBC˳P()ǽǽ4H0&,)newriap71">query4GGGGGb2BS = "beg? :=_nd;"77253jaStmentsu߈4">p衉3Z5*StmtP.l(͎_{6^6RPtypef7">OUTM(`,lpOracspecifЂY8-ЅOutP(1,Ts.79hXyou sywaPu,D lrisplaysHmessagskqLAlt+oracle.jdbc.ObTypes.resslt+Enter,ndhenelect I> (<фC)rom1istxatppears. RunstatemenЅreturˆultt`preml:(cXxserve"oac_no_warnE0 callStmt.execute();r = (R*Set)FgetObj(1Xgd9F`EncloseRxeredoarn G">trylock10.HAdd@catcho|anyxceptionsourogEethoHsell甒IK(QLex )on(; }߇J1vJIfsof*K">R' ,L8oύ;2fMMak[filhe`foryntaxrroTMߠ|O">(Jobisfollows:؂ייייHPpublic  ()rג aDBConn Stringobqueh= "beg? := _s;d;"CableSNc.pareI(Ճr0sOutPara(er(1, gs.CURSORסǡơסססף*}d=div> /-TDPJD223/߀޴R+ 6.34Displayay`iyenerHd̴PREF ۳#vious`j.ol-1YOnI2HDo@e-c`k/3">i.jspeAppaNavigatYopentVisualdi,fsotl`dy&I49raboldf5">P0 rveon8Bdrighϋ6">useBeantagWQa ox,طg(7">java]ظz߆_8">Langu,'s9">Imporfield,ybsel??Ac.sql.ޞ.Ñ3/zB">OKuUICscrippWHnext}׎ьwSOd'כuD׼׼ѡ鮬a𺑛pXainbs׽׽׽׽4IEнdempsb ;4FSkoǙGhBox5co nQ 4/zH">nTJSPÂPatP(YneРd2P)G9case.)Ԯgwppear?s5vIEߑi5/yJ4IK while (.J()))ut.prln("<opR +ڒSt8g("0_id")">!ZOOd/ " H}6Ljmoy׵Ks zM">W'Nstill\eD`uc endowѿ O">.xamineheistfard-codedptionselow*selecteyword.ĀteachA,nsuringatouetainKcript.

    F 6-3tructqViewDropdown̋Boxϋ3Cimgrc="kindle:embed:0015?miPimage/giflt="DeS@ols"/>
    oj"GGGGGp"j Sav;p.u/ol\V">NHru#applica!,ickonsertemploye`ndsWQdisplayXavailableobs. Ȓvpos:fi21:offȀ3DLJ0-4h@"dyxic򜋙|brXerooo1ooCIHCAHBGo߀ބ2o51oއ3___^4_-4ćallyenerat 11B77716777777_752g?577+ B data-AmznPBreak lwayssةp_mastd!l!"ǀǕT6GCJGC5'8o2249ͧ;h1MchaptAPspanMsecnuB">7Êpta͉er-DsJPAOracADFThis bes c 9S7uJ0ersencPI(0)!gwr=dDۆݪvelop@Frwork (O_ 2WwLE)uی:ux3FiGyook5o2PnH">Overv ">|Iױ??ױX4RN>J">~ ithǓKߵGG6GjFL">Build1DpodelEJB 3.04ـDiagHwGMG9RN">NProjحrZUnpfaceW'4JO'!GQPMqƱ_4JQ___x54FR?S8ys"W4JSWWWAWT7QueryEdit\UϚϚσ3FSV">Runn?ulpaaligne!uK01Yinftblnote1`tabN ac_no_warn"ummary=""order="`width="80%"Q="hsi"ule0groupxcellpad="3pcJtbodyIrqd\pXcTo",;asfd7,ouustavn stallJ11?xic">g훠Studio.7.1ճggg`h2p}7">A //mastdetail.htmsthref523"id="4K8">
    HRchemaaccesandpedn ߕߗoh5ߖDjectXllXE">ml. 1/ulpmH">Iw YJߏ ԞreaEg6g K M-VP-Contror (ǧǩWP7ǨߪolLdVC)signt 8XeasilymplemHus1Orac蚐.cM a ="khle:P:fid:0025:offH42JN">Figu87-1)hq"Pshipp80itemsxvelop ۧndivlass="f:OtmCHDGDHCFPmTDPJD352/QنtitleinWR-1ͳ+DAМimgrcVembeA17?m=imH/giflt="Descrip02"/>
    ߃"w___es"

    _KTYǿ{ðhUD0Qtdepart¨disp-e@oyeٿ (bЙоVȝwF((JDXoי׼)mϵϙ"IHFEHDIǶ߁tV'gg#2׹w7L0%O"s118h24L2xspnum&3">7.2ըB:PerenAPI (JPA)SGg-Qiveʐ:vironcov@fulؿÁ pecybPigᩑAdrag-H-drb`,isualI teaofxs"t-iUAy01subiXroduXsome):1wip9gײMn:uBlieCQa 9="kle:pos:fid:0025:offH7BE&D">{/li_E_Zdle:pos:fid:0025:offH86E"id="4LF">OracleDFaces
    DataontrolAulpdivlign="centerIclass="inftblnotealsoFJ">
    Se:Vhttp://www.oB.com/technology/products/adf/p @_11_overview.">??????>7.2.1avaersistencPI (JPA)sartQthe3EEpecific[that!thbjP/re;alappndpWetweenbases.{QȎߎߕ)sty53RTؑς4\SconpffT/U(ɍ׍ ׳Vqueryanguage\MO:YWVmQߜJ2HBEIHT8234M52ǔ5߁6a __4M7"OLd9ɨ6ׁ8??fW9Sxer\(JSF)SR 127׸).Ͳonenau!i#`rterf"lPs1.cbGanyDEsupporh_ A">You _ toXminŅookJfeely?;allowsqfocu*?9acra(rn?:lia.oisoulti–%transiemPcaelhcsibility8aturoBDevelohrovidsr`igools,zardHҀ(ogг賈`editorhelpinta7o!:pxs.Ƭexa,VisuHE eɅ4ߓbyragg romCatIffam@arXMLSP/HT`cod,*Y:1zsȼil󈬢agݰtmCIHBJDCEǁCOO30GGtDEFG3''3?H3QDntrа4MIؾ9 hm׷1ious؀Hvidefhd鲙modobjayer.coll0,aluЦܪJßʃAtuntimMeadɧm+crP@9_Y)ؙ|`XriateZsiv#two-wannectionetweenhesernterfacendbusiness vice.

    TDPJD353K@br/h2lass="sect1MspancnumN">7.3uildingDataodelithJB 3.0ՉDiagr@rIcnextewteps,oureatpplicainDevelopE䄡mfor!ߎLulP"liEQyaref="kindle:pos:fid:0027:offHNMR">CYيXAoProjRunn-JavaӜ;utsidEEonn/ul*IJFDT22334ɝ3ׁ4N5םםN6.1n st539\74(ǁ8__Zh3o9">BeeproceeosխȭonmustGGgϰ_ATc]Bonnb OC">HRY-thatstablishesTWPibase.Ʃ`instru"sg4NDggc, ''#0K'ϡE hapɳa>oeNFdvaluwG(FromoXboldH">Fileemenu,l:BI">New aisplayallery(@Gea躓egoryWoϑ@lnWoLicF.Ծ*e ?wizards ed.oMEn9gN_EJB_JPA_HaOH}ofǝe=oracG??Q?Packagixl,c(kRxߖ3SIS)r>Hbse?4NT">VU">tײ_VYnW4O0Navigatpe,O1">DLab.Ӟ#?0ԩOi#IDE(tdraIoptaiW4O>yHmak?ve ؏Ӵn./olg4O4">Y(nowavHgdI5`,hichٿ(a?/6gl\/div> /*CIHIJDDI7|''!TDPJD237|8 EJBModelroject. Fromhe K">Filemenu,elL">New}toisplayjallery.xd/OM">BusinessierEcategory, !WWXNR,.n׊OO">ItemslistPntitiesTables.ClickQ">OK53R(Ss(ersionS 3.0 --PA -asڂv`no_dTxtWߕ4OUDskipPQstencenitage4NVsyTypefonn@hooseP0nlhatabaGopaccept:defaultff namecP1'="5V2_DetailsҝGG3">HRc/HuseǤ4G'?="6v58QuaretrievCav borHRchema.Ԕmo??6">DEPARTMENTS.ߪߐ[7MPLOYEEh8">edstwOO9׭="7&Aeis (p,akeurpack oracGCDz?Dnish/GC8~E@RightԴoFomnicAppaNavigatpO?G"9M_yOOɽH77Pܷdou߾gg4P`)Diagram (/,)10޾Cre質dialog,0anhtĆ@om1)߽߬M|difyzϿϰȼ1n` Ossoci WithOM>PQ/ڳGropHd75 (R.jpП).emptyopensmediX2SۻǿPT`epartmentsggU`mployeeitierom dragsyPnt.eorganizlayoutfϙȸ8habo&horizxligned.ӁI Hrork/oldiv}figV">7.3.ingzDataEh3^p8">`,y#assbethatXemethod fȣq:۠Fecords.kol9OQAǾǗBCompon>ޱ0letlibraqϾQCN@mȨO߾ߜD">SB"n>omponentndragLoptntoheiagram.ԀhCreateessioneanizardpens. InEJBameOpthstep,et@HRFacad{makeurhacfollowingspPerly: StlCxainerKGen Methodshecked7LEntitymplemawwM">JPA ieNPersincenit77MO">Model//ulpPlickQ">Nextl.Departၦn0esc3U">findAllByRangem3forach ؎x. 4QV4R0Ce``ulli٠딀oracle.G2WGW="5F3Wߢweaveothemox Localnterfa i7ed;rÁwuseclipp؛"sSrun8AvirtumuasavaLshesQsWebGGI4ɱXreviewCummaryf cddȫ ߫o5">FshߠR6">JbIm)upreiX7">wq[-GB.//480cribapabilE"9eђ{Ͻ6ADoublʬOoBc`)diagram!h@NdQueryLH,;aWS:`Xxml:cPxserve"Uoac_no_warn>E`y(= ".By", qorom rstiH:p_")H4RF wilook٩s:S4RGE?rP({", "),////(/////.}Gdivlign="cxer&H inftbln@>I">
    M0iXompxӨG4RLos.j] i*Mage@LogndowoPportPyrr߲9FMRight-׽N>ЏqAppBavigaBOditӿ?9¾exhenu10PEx+OOKQXlog. new dDPR߲Ompearsnxposableethod.electtdlick OK.hisillddheewosessionean. 0ol1div>
    TDPJD356U 7.3.4unningJava0rviceutsidEEonpnerAersistenunHcHbefigurebrunnorF&.n0,oureate_XpamplementiXeoyeȓdepartQecords.META-INF-night- ߗߎ6">We.xmlF$7">NЎ_XFacadefromvextnu8C elahoosxowYߐ܏u@R!נח9">C+aГՂC3one8d8PA,heg??xA">Gem():box.Bxt]3>CPN`bWTJDBConn3makہIL tф?F">HR7???SGPHAhouldsҢbyfaul@Deᱰ4SI">byRang7״׫J7ZOOK">Finish"íL//57/?lM/Ƿmsthref54(ϸ߁N=ptitlei$VOɯ 7-3Q7߬ imgrc="kle:embed:0019?miimage/gif lt="ǧm"/>BԦﮤ5Psoureditwow,(쪋Xdd,lfteQ">//ODOXmQʹȁfollo`th:@@@:cxs@4oac_no_warn^Rqܸ=.query.@dBy("P%").get(0);X6SCompilTڻsave銈orkGwTR77GGSU'nٯAppॸNavigaںo__4SV">RuʹpT0">TLogisplaysBXfexecuSrunn,EE"er,@tur*:irs'B1">trievrecor(8T2xdOO3">META-INFdouble$??4">p.𺍲cntsf(95Both e0descri. xo ly-cѲIIStabrevis~106Youw pѿEJBdatarolOracADF谠iifiоwbatQ`fXo4T7ggT8BeaƜoooooT9">"eĈaCcsy1AChoqQI}alog,B">Locappߥߥ4TC">OKd.өall76/ol" ?ǿCIHIDGCE7OD+TDPJD35DEa> 7.4reateewrojporhesernterfaceTXapplicationionsistsf@setIJSPages.ƃris'on,OJ(UI),eferredosBview, defininRparp.6ǃǁLwnI,ouP|all8/>Ifollows:3olNlialuؔ_OXInJAavigator,`ly┗="boldP">HR_EJB_JPA_PݒpndromgggTQ">FilPmenu6R">𘕒display"GQryX S">GeneralegoryWgT">$temsP?:U4icPcXk,V">OK Tagibrar.ӠcDPributlUrW9">AddǔǤ۫UA߄BPDFƷsompons 11C'UC''?UDOOEPechnoyȏ׋mvabl}ߨoFQFNoti tha`zingwwGutomYyArequiIociPJava0ȰServlets粟HSaverork/ol1div> ߿߿CIHEFHCJ׿ׁIϿϿmTDPJD359ǿǁDJ 7.5zYagelo h2Fp5N">YouwseDevel'sF-AMX+agramKYaopq!betwHm.__R">Webn}ށ׾续SEB_IN7DouǾǾ4UT">Is-fig.xml-@"hǸ2fUǏ_D$^XtegwwrV"7ilherja0yPear.eQbrows73EV1Fi߆߆drxd о2'9revious 8V3">query7344׾׾׈5'aǎĹipoxs@J(6)삏des󂷎7nㆨ8imgrc="kindle:embed:001A?miimX/gif@lt=""/>"wt58p(ifyfault el,c aid="4V9">success
    ,ylickingtndypq< A">queryver.oticehat(eresarnconbxavigatiCase.hxbecauseouapnotetreateJSFages.%disappearhen"respecti Sel YojnZComponentaletthCIBforsour (׍D׍),#Iʂdestin3HE">brownncRenamlabeloߒFg.ӎ ProrkdivMfigureG">F 7-4j7.6mCa͒er-DavaSer9Fa0gh2pP">Inextew Pps,W@husADFasMLocuopOOV">OKİ500">YHnj@empty11[ adddata-bou)k*緀play9dalowitۅTп3502Fromp,&library___3">Laޠy)draɼOOC4">PanStretgQone45脟506pliroomid fWPeursPǁlefHsctagwN57IpeDntrolGȔexd8">HRHadeLocal,n__T9">query'sFAlJ*sop0A">smni{firstpup puvWKBormסC">YRead-only ǭ6FD,Editª(eld8che\ϨE)cluNavigx}ϨϨϫ Fυdz_7GǓ,WWHGGB___I">VLisZnoJ">Ta''0KwK8L¬8lumn8ig `llexcep3fol:
      S511">Row CƪSort׷s߹߽="9thetructureane,electaf:lSplitter2ndn*Propertynspor!516">Orientationto vical. S9etchLayoutNag. exhd A">StylenBoxbWidthŒggbB">600PixelHeighhgeC">4soa3Employeeslppearsldi؋p%DgggcEbgsecoh዗51FG">1PpH.Reduce*hofDepartmlock3pagesing @rousor`BiSimgrc="kindle:embed:001C?mime=imp/giflt="Adjust"/>Firsnbutt8iI)M">fCID. )fqremain3SP??;N">PrevihQO">p,ǰǰP">Nex?Q">nL'//R">La?#S">Ј,2TӐgfeojeclicksy{oU1UϺ//.V">VϓߑG"520">Behho,n1PTp׽׃2">E`T=0far fieldO71330ʼdog 4ac( )775hHlFormL-t.6ooterԍg74Group;I񩄫 A0all0OK}߰49FromComponPalette,ems,߾2A錸enua^ d HondB Topߒخ Desig}߿C">!]bWtxsiwDnjo15Ex(AFBrxTitl0AFHeaLevelTwo,BrowPEQ́2.ąڈؾ)p )6^Fg>chanaT!'XG">u 1-cH(pO''IbԮϺ52J">DetahͦK">truw7&L/Sctux1,-[OM">af: RcP,N">P9ڦooOItemwt8&P/Ϲ'usz,Q">iR">Queryvidown___ZS">AcaT">qSave rork/oldiv> 7.7reatingueryndditageInheextewteps,ouseDFacesouildzqpȀe1Employees.f!-config.xmltabswitchaaolowiagram,double-c7">Bi9launhwizard. ROKA"> sMLocumentshecked. {_B">OK3CAwesigncopens. DataontrolxunderJHRxadeLocal,elؐ///3DtFFindByN(Obj)]krop @.romopup `u.7E">Pa@eters,nߕߟ4F">orm4G*ieldp/3H/occepposedPY5IBActiBAlogoG@Jw6Kex(˨/Lǐē M">dDXiۏwrm N">i__773O[7P oQcluNavigب蟍ϮR'SubmPButtonboxǸwpSǚdz8TRneeepd.Բpecifyi???U">mergeEntityhodHn8V">eb,downrr@׼ggk40hELxpressuilϸ_91VarisƟT2$??__43">׭׿M4Iato}/5">currRowwr6">Provi.soueach.ordxl7txofBwowp7">7''548υ(549?XgaifiComponebǖ'TA7>.TexNRbsf}j list. rorkoldiv> TDPJD2ЂJ M">7.8EsthrefɈNRunnApp*YmayHwu;asollP:solPwOQonavig,ight-d54Rse.jspndelect Runromhehortcutenu. Asouunapplication,willbleoavigat`hroughdifferentepartts*nUindividualmployeesorditing.xperithpdXngperalary hireef傤/olp}U">TpagsplayedrowsPisAwnFigure 7-5.Hnew_mastdetail.htmCIHBJFIF"m|1xTDPJD3632|titleinWR3-5͆Per-DjiewBÉ+imgrcembey1D?m=im/gifXlt="P"/> 7543imi`that51T5-66JCHGI7''4'789o-6şsbאCont1E="cϐʑڣxa-Amzn)Break="alwaysyda4getun"ҀA"XB΂249oCo7s8ef5GOD 8Get"Uan`jOracDbaseWhi'،׀HAɹф19JDevelo`AaIpask, notpprocessyf+JavaWɺmustxXy/ׇ-1W=Iclo`aResultSe؀>,9K">StQGhL">*onLbj8fqaoug`sm.hen;?`MÂɎF?se. aN"}methodsxe@upmoryjrehcursorsorePf"dor7ϾOϋ͊P., ious5khayc#runutfͻ1?Y@9MsQٸdcludesRfollowXs:kulR"liUSyWWSBWJTв"a͎2!CAOpOs /lipU77P3RL6Vе//ulZCJHBCEHD'60W_27ǀ>1wv629256364.1oooojh25tepdd 6_>2gπM7epMz_s38569">qHlerżtou6AtvaluB8בC߂.jŠܵSourceditordouble-c` go aviga.gՊDDexE/.FDajpгG#ss:xml:cxve"oac_no_warnHpXicoidӥh() } Withinheethodody,heckherResultSet ׂׂ6׃Lobjectspensollows: Statemen&.GGGGGSEstmGAeɊgggg3fǜǜTFinallI258wUVV">Conn@7777705n7ʔWWWW3/ol1div> CJHDCAGHo1ܦǦTDPJD2512 8.2âHingϧ)Os 77497}63Appli2h2p7">Youust8"ol,Ǒ9_AkXnlyftyhaveinishedJpm.ɉ57B">DataHrr,*in8t,pddeletsbeforrn.othqueH=canno_OsntilC">employees.jsppage=procese򸘄 byw.ȏ/57D">Sstepiaddappri8llsoME">"All݊#ga60geF6G' .javafile:olHyWIwJJourceditor@׺2K AePofϫL">EojQbrhWg7MaEblock̏CﱦNvOa׳P"> υ:Q|5`3RTsg[SǝSP57T"> ByIdw57`VOO+w8au`HeU6483̹QhϧϞzMVisualƉ0 cripti``smtablou`-ck9oeIZӃdialoox57s9@whloopX Psbean.;ߥg6n SrorcompiYru˱(a!ensurevPthiHQorrly/ol1div>< a-AmznPBreak="always[4lobs"\9{'TDPJD25皝B?p׀俘br/@h1chapter"id="58D">9uildinglobalpplications
      a灻InnethatupportsifferentocalesequirHgoodevelopmpractices.|pson xlanguagend1ginhich.ispoken.ԁ`gtselfustxwarefserpenscofollowiQculturvexpectedyr.timAadataithropriatchaAerishs,`as.orrA#@bformatOPD@basfullyDizovidpplataʌxdeploy,ns.ThYpscuss͑_n0Java{environBaddiicaskssocdooo,cluwn,stru(HTML.А-rE,ϒ1 ϓϓϞYYHhHtcs:usI"(liJya蝀="kindle:pos:fid:002C:offH1UTK">DLAEnco:PhoϭPωωEφoqQ">OrganizCTrans58R/50DS">Py!τjTexnSPXJer?hulR:pps.htmBACHAIDB"8me\VX؂?>TDPJD253?罓90; Goo߹ݣ-sitivun8µݵI,im\mo ary builgramhgnthSQL.x y{jpacb׫׫׊5ifPoojredwayxF8exampl1F(Canadian)mHh3O"inftbl0lmax6ٻXI4M1titlE"`mmiz4tu."`r="ltr"⋸ehwidthP00%"0hsides"uroupxcellpad="xcPheadr gnxeft"t;="bottopsr1c1-tEfr_CAOracleatabasexpressdition 2yeveloperuide. 0r2bodyzablebr/> T 9-1
      hows (omef*commonlysedocalesreefin8Javand ewsp]tblformalmax~92gpps.htmTDPJD365"ameLAHH?>st564G'BOBACBGDCFgCYitleinNDO1̋ eha,QL,JPL/`rogrammyts• FM:="ggggggs"ummaryDiffer腗4dir="ltr"ordeh1"idthP00%"X(hsruXroup0cellpadd="3c0"heatr hgnxefvttop;="bottom/sr1c1-t3">˞h2)?3NLS_LANGUAGE, qTERRITORYň=Ch(P.R.C)+炷A v!zh_CNג//77wsr5nitKdom0GB???;ENGLISHGUNITEDINGDOM7sr6Fc@Canadafr_OWW7?U ANRENC_D7ǵ777France7777FR7oo?7k׭oANCWw8gGerman (Cyde_DGGw?DGERM/YWWsr9ItI߿炷>it_IT?ITAL'׿''''''Q0///,Japa3R///ǿ77>ja_JP7777G?KoreB߾߾߂>ko_KG

      KOREAN Portuguese (Brazil)߂߂ H2Npt_BRGGGc3GBRAZILIANORTUGUESEwLx3~aPTϋώG?GAOǒǒǒǒǒǒ4ǒǒǒSpanish (Hin>es_ES痿GSPANISHIM/tbodyRablebr/div> ᛩ59E">Whenriting :l Plicationscrossifferentrogrammenvironms,heserocaleetsust ynchizedtwe'ts.orxample,avawqthat lL/SQLqcedureshouldapRSocorPpondyeF">NLS_LANGUAGndGGCTERRITORYMȤchangezpaXetHmatcholbeforYa.a.htmTDPJD254"xᏴH"@a@xlas0sect2I/-sthref5657J= 9.1.1ͱ8YBOracX9rLT GrizJevelopYit (GDK)ivid N">cer.tAsqui] s^, A0SO,.Xyeceivein8fromliљiHpecifi in,. IL[`o(OtϖcjhIO؜ctly OJ="kindle:pos:fid:002C:offHAEBP">E# 9-a>ws (Y(mQS"$RmBACDHJBCǝtSÞ366߀箬TptitleinU70֑awS\LuaTerory̦xml:c8xxv0Invi,ourWTП[ccept)differ/ep.r贔عy.ρFknown,ڶnYul tructTMLytᵜl5follIul`pvؘзbyeߟ37">OmoȚmethodd.^PYd P1defaxѽu $br(0Usuallysen_\uoHTTPL'X8">Ar-header.fhiseader Pseto NULL,en)renoocalerefncnformationvailabandpplicshoulddeally0ack1adefinedault.

      BothSPagesJ@ervletsanse@llsPI)retrieveB">Accept-Langu TTP}axhownp Examp9-2Tdivlass="e D">XglobHs.htmBACIHCJI"ame|E`?>TDPJD36?呴F;dtitle`G?8eterminingsL(Usђ9Ȗ2lxml:spac؂Xv@oac_no_warnH"> Sl =quest.get("Ǐ")Tokeniz0stnew π(, ",if (hasMores())r=H.ht(); 8re> AI">T1XJfrom , racfirISO,0stq-desiН2564K"sect2Lmst567πMbr/h3gg5AN@nWcnumO">9.2.1%AenestA_sWdlop1a bx,"commend;tśВQrXhDžď?tha}]cunt_Yɂ/ׂؔxntifi0byU">A_3ԈnǽV">DateTimeInstanc̨е輸I="kindle:pos:fid2D:offH3A9uB09-3d'"1771CGBHD߾烼2ۭ738w3ptei94?8 ӘU)_____5XFormdfh(.FULL,epeSXdf.X(); /* aie */?sDF׀T6//257/甌7//(18a2G5B9BAhE-HTMLageA2GeB">ѶQnpimporn{arow9AInternethinkefh harac 2<ʃWW)轃neeknowbouy'sy1fonts71mabledispla;Vs.ns yjcespharomfC">aead9ubdiffen0}ss77UTF-8 (Uniʽ)nallR.0enotn0lɑL7,X`multilu0tA@ang(ySDc ncludesheollowingopics:

      SpecifybPagencodforTMLs?>TDPJD258?K; 9.3.1 h3puO">There twoayHo딢eofXpp,nesHTTPeader,or/T. '369'瘴P ub'QǗē7Ȇ2nR">IncludXXContent-Type!7ication.tExample 9-4<"e U8WWCFIAHW7VWW370oC0U>titleinK1?8wgoזԐ xml:chxsЈП4oac_no_warn&28pe:ext/l;j8=utf-8> C3?4">pmeʒSϯ(. (sibvalu=P5|IANA:'oݶaxbrowupports/371/琤6.C7Ϡr7C8">Usȋhodrimarilystc?s.E׻lVO&99-5AgaHGGhgGBgg37pGCDO8nֹ)ǞǞǞǞǣE <ttp-equiv="pѰcП">ןק FןGןןױןAsithHk,"ѤCFCEJIW259W7J"sectGKlh35CLncnum>M">9.3.2JavaӴletsxdSPRsYouб of=`OǑǑĦ\a@ ()ius]g8P`dirhiv`F:}Q%@[Ͽ׽מ* %?5CRѰS">MIMEtxbֹATW xponXitendoliP. 큰y߾TGFridN Yar. defaultUV">n,2!iISO-8859-1.ɾabov0󥳻YpUTF-8ü9ةD0ԬKengѿrdyXicndetheTTP Content-Typeeaderithspecifiedharact肨.

      Foravaervlets,ouan ll:3">,'>ethodfڂ|PIoyageningnO+.ԃ4">doGetufunctionExample 9-6hows (is̉divlass="e#6">pAglobapps.htmBACJEADC"ame7x?>TDPJD373?48;Qdtitlein{9WPӍ3P9E?sɐ'Creml:spacPxsoac_no_warnfA"> publicoid J(HttpRequestC, sponseK) thrQtExcepY,On { //eneratebMIMEa 5.)("text/`l;=utf-8"); ... wtHTMLZ Printwriout =n.getW(@.paln("<>//'; } re > ?DB">Y ulϖbefoD">>Wcau,Einitializes@pstream 4that s"byF稒.nycS¬Al9evPu@hobH߅Gڮ>CIIBC峔Hפ260קI"sect1JP
      9.4rganiz1a s ranslaM">MaK rf8 ilab`dloanguYsn8dntxtasks 8@)`p"sourcTG FloY#followegories:ul]NliOXTPyxard-7?li/`PSthc#files,m{steuchsSSQ(Dy0dh怙basv/ul5DR">TAydiscusern=t?/S/T1aref="dle:pos:fid:002E:offH165U">ShJJSPˋKV3I2E0rFI5E146L2">Dqfrom"qI'm//CEHFFC/<3/g/268gt4//(5/h3G5E6//.E7*.1=h3ύ8ϾȖw@with)(re8оxcxbϷdepe(i¿0fb,zrr[sh AsBEnglishu,ȇǭesuffix. 7 A;diroǃ‰|oo ok-upech(so properly"inftblnotealso69 ӥN@A@ac_no_warn"Pmmary=""order="(width="80%"hsides"uroupxcellpadd="3c(bodyirdZpSee ٴSunicrosyssocuҳRabohtH><1http://j.sun.com/j2se/12/s/api /util/RtBjl">??????>/</td> Becausehe @rocalesotixednultilingualpplications,yhould lbgetBundleethodyxqitl0pecify8ava}object0atorrespondsoׅ.ԆX憐x C">_Äfollowyexample: Resource[b = .N("0r",څ); Strhe`(rbɀ(""HprE">aboveHwiree9izvers ftext,IF">j,rom%⇛)desir@m{y.ȊinftblealsoG">* See ْForoorm cre@O:s,fPL3YT8JSPagDloper@>a 1globs.htmBACGCJJE"癆HЂ?>TDPJD262?$I;'s`Jh35EK`xnumL">9.4.2tcisׇb8hnفXg+/dcto@rsJIDFI繄Nה26`ו廼OPQR3DȬqbash/S">Dywn&produh b@cripmosikex;garwheroupsrSHlets.ɴȭ1nariou ܄schemolhiѬinclulumoPdicd?nsel]n,mumi?T">WHERE<)Pruer@oGzݻu___XDJIGA_?U__264w$V\v2ctFww9.5ePȦA"byseonv9onH2Oe3`ٖPlneedop3;aahatz:rxp萔ifotmeani sometiQ0miserx(.ƨexample, '12/11/05'逐'11`Decemb20KUniqaдPd˱dit 2Nov'.imilarzusiexists P鷩moneta(` ped (.) Xacimalpara9Geny`sAdapn~4صW^hav:irwrruǾ0kac0ۼpnclpha@tytrokyu;,جWwhiHJ*ronuncɾLwp+BPʆluΘ—ɱpomasearchnicultK@-sumh砻5epe9logAzZriev.Bm )roprZgll ɠKo).racs0nyeatureshatelpouoefineeentationfatahenuserocalRferencesnown.ԂfollowingecAsncludexamplЂ;-psitiveperQL:

      Orac DateormatsA?>TDPJD265?LG; 9.5.1 /h3>p5K">8re teifbt/*fabasezsCstandard,h, xP(s. OOOO2hL">E 9-7 llust@Bנ0betweL*Oiuothnitedӣ؅Geny."FMhCIGGEAg碔N374OputitlePĉBby̫s(GGB)3ml:c0Brvhoac_no_warnNQ@>LTERESSION@TLS_RITORY=ricaLANGUAGEn; Saltd.SELECToyee_idmpID, 2 SUBSTR(first_),1,1)||'.'||耫 "N"3 TO_CHAR(hire_,'DS') "HAJ4OO'DLILqA"h5 FROMVs6*HERE<105 EMPID /{x - _?= 100.K9 06/17/1987ednesday,une 17, ɂ_1.Kochhar_9/21Y9urSSepte21z92.Deaoւ`393ׄanuary 1393G3.Hunoldόp0r0Gwk04.Ernst/ 05S91uMay91ygc)ǚ_'wϜgg7.06.Mittwx87.ij21.09.pDonneag,S3.01.pgggWS0 OGGG5.0Die`MaI8reп躨; ggACJBCBBggdRggg266ggdSeusect2.T
      9.5.2racleuFotsExae 9-8AllustrsheiffncinecimalacndroupeptoretweeUnitedtqG.e2ҐAHJH3W375W7$4p titleink5pˆyPca`(WWj)Sml:8cؙservxoac_no_warnid="5G6"> SQL>LTERESSION@T"NLS_RITORY=america; Sessionltered.TSELECTmployee_idmpID, 2 SUBSTR(first_n,1,1)||'.'||la "N"3 TO_CHAR(salary, '99G999D99') "S"4 FROMs5*HERE<105` EMPIDI/{# - _M 100.KingO(24,000.001.Kochhar17$2.Deaan73.Hunold 9D4.ErnstGp6Fgermanyϓߒ?0?'ϒ_Eh: ?>TDPJD267?<8; 9.5.3raclẹuisticortsSpainradithallypeats 'ch'(ll'sellA'ñletsfheirwn,rdf, ndespively. 8href="kindle:pos:fid:002F:offH72QD">Exae 9-91llustes)ff(usQa (nishXgZ shexPChung.eӑFE@__CCFGGJ_?\F__376w畔G]pMtitleinHarias 89(Binh<)Ûml:c8servToac_no_warnI{YSORT=b////"L /,Ȯ+'LIKE 'C%'#ORDBY''#87abrio48mbrault54v10gЕ9olme8Y 6owselXǽ=_m߼߿/߼߼ߌ/ߌ׻/o_ggg`϶϶϶϶FEBϷJϹ268K϶϶ϺL϶Ϸ)M϶϶N4϶Error͠ageO">T@LANGUAGEar@1alsoontrolCla 0atabas""apreturnfrom.ӹHithisroubmiyour 0tt nsuzlocal-ifh''! balic|6Q">CiXfollowB:mRxORA-00942: viewonotx7GS">W_T___r setFrench,zوearsssOǷǷǷǿ6UOOouue ante."inftbl@eVN@AQsumm(=""or="1" width="80%"rame="hsides"ules="groupxcellpadding="3spac0"> Seelso:

      "Worknlobalnvironmenthapter the Oracleatabasexpressdition 2yBAorxdiscussofizasupporteatuhith(_Z.?>TDPJD269?<`9 <-sect1N2 9.6Loc yText JSPagJDeveloperYourava ؏kcmakeX@ceund,orovffer섃eder9sA1thd!yHpI6">Rzonta e-specificbjs.heĄgeeds],chsom pl(a,loadXrom"atp priatecurbr.ɜaway wrioXlargely(depe(TeolpQactuhZG7">outlinpGGtechnologyHyfollow MMys.ߖܚGerman,2vwould l?B?8_deUliC@EaX/3 #sm@q9z;be`trans`ՔreaX8b`NjayDtrat۸߯8Eߋߍ defdagF">Can(<タG_;H">AbbrenkIjFsZՀǬ[coun(Y=Hngux (7J">)QSpzerxd_K(H]/ulO5HL">TojWܵ8HmustolonMlvalu@gN`Cr yvO2VO@kvis ,ǰ?7Rwill1us9yɜ_3FP ɛYJ!aho,pѧֵWO$step d-adodivlass="inftblnoQ">
      ??????>T#/R///P HR">x вH/1dufSd\THP0labelsQJSP. isray9ditaQYacriptle򰨘(ϹUVSo2rol/,s@V">"propertȻܟx!s׾"5IpT9s(Icover{taskݚ 5I2=k le:pos:fid:002H:offH3JEI3p9a E {g4____x61F^5">Uz7{TPǶalobs9BACFJFEH"i"globapps.htmBACFJFEH"id="5I6">9.6.1reatingesourceundleToぱedefaultb:MyUs.jp,hatxtend8F">.util.ListB. E 9-10."&M _CEIDFF? IRҔlizec@,Rlo0e-specifversseiffersBapsupHA,ainA׺ 1{,/ola4כCFBIGAל羼Sמ271TաG"s82U
      9.6.2s1[TѹJSPйe.jsp.'J5*ew쨨 opbe`+firheadndeWboldF6">StyleE0?7">NonXdd 7#8">:beanUta0e.ũ8r9">mĊنA">ID,*_B">hr.ǂςωWW5JC">.ӊ?(Dcop+E">sesIckF">OK=Om3.GDr7UH3scripto.,h0?ҙbsplayed,J %vIIntӄݭxaloxɅriev7romlml:(cȴphve"oac_no_warnJ out.println(s.Sng() + ": "8p));24KIҵPwalreadyisplayednhe耸ing,ouanemovetow. IfselectSourceabelowRVisualditorshouldeodeorpageimilaoJfolPX: gd6fO`Toseundleextsrla:atton,ouble-clickˑ .ɑ$propertiesalo@%GGP">Va=parXfЌPscriptQ%ut.p8tln(UpdateB17RvieC#will'''''''S$inpupypsubmit"Qt; //olpT">unᔐppati_A2!defin{ m.Idiv> < a-AmznPBreak="always"cAq  2VQ^2">B77703NFv3">C77OOO078E4">DOOgeKg0040N5">Egg068A6">F706KK7">GO07708">HLjg07U9ǐǒߒLߓHO1A">JߒߔM`NT6B">L03AJNC">M'7'0467D">N''?O?04DS~E">O??WUNWذF">PWWoo076oG">QooOH">R03I">SPY4J">Tς017WK">Uϧϩ702BL">VO02IO>M">Wg034PVN">X8(س$OLabsolutosixXultts,g|0VHV8S">4.1.3.1xdG'T@ccessorethod'&1F'005G/52߈VpDFataontrolOǼ5009VIL7.2.3?_QpacheomcatϾ/G/QD(25߄ѽ`appliXȒvigZߊTGN5.6w$2LH l#_71`HTMLubmitutton߾ߐ7׌EFO׍Թjspߎpwp3wL8oo7Pforwardagǖg Ŷ`! AΎor/ndle:pos:fid:000L:offI1LH"id="5LE">3.2.1
      dLG">using, 7.4ڂn,reȅ270LJ3a Qex.htmB"amelK" @
      Bbariables__]1Q_005BN^O">6.1_DP5LQ񍱎 G'QR">IN,UT,pINaparpterh9CS3G'QT">OracleCall9Statementו׉008VRU׉LVPreedיO08S1M0OǝM1琏KOF2ᗯCt394">C5,6LASSPATHߣߧHߗK4>7">22ߧ8a'8xT&M9">/A">clo9bjectsBC7D">8B0044A汀8#eAll hodUM8M7FfConnЊ߸__߼j3IM\ohDataH(ler?@1Ixgϣ\؃gr.javaGGǿGQ7ǭ7g@employees.jspϿϕ7϶XP97תTResultSe7N/'𳇼׼038wgCompon0aletten90064P 1m cTpfromDeveloperحg"5N߿߀8drivispecify00KRN3hostʃǸgwwDZjVǿwwOJDBCorgggE28ggxservice__IN_ goracle base/PwSourN06SF83.defa ̿OG2GO3getg??7?08QKv7Oƺoviewf(ON(6xusJWDNPlQVN8Hl׽ש׌y.Npߏ/ggc7gA1ּ 7W7="l2ix"id="5NP">DataSource, 3.3.1 CSS lONT"DŽLj+U">listfomponentsoom13o00502V">4h4ocursorariablesW7O0W1">REFURSORVAT2">6.3ooo93">using71D.47 a ɒex.htmnameL5"axhr/126brow10/008L6D+E">9objec1edit?BFOfFOOG">leLview珞9HOIefinHonwww0B2wJwURLWWOWY RzW7LWM_specifi?oBHONo'OO_typ///ߥ5I@w//xsyntaxww'wM wwF@thin-styservicerOOё͵ Har.javGGGAG006V5Ʒ04GG0GH9Hƶ2CSourSggggHQeP`f3ǂxNH?@HA>`>_Qۃ//Ǽ3508ƶ؃?`descrip뿟75B96p[TW׿׎7F>Pg/networkProtocol77/7hLT.h~phd 4PbOgԺ`portNumbϽϘFCꔷϽϚu'54&Lﭿtas'ctC"؎gg?gWPgg tyoooEЪO deafaultu7˸`HURL(examplWWWC/RGe??׽Q׵⵰syntax53޶ȄQusingϾψO00 3E4"id="5Q4">3.3.2.1 0l> delete_action.jsp, 1.3ingatawwu1Nw826">5.4r crea2aethoddžDŽWDŽTQ9Rǃ#A">DHar.jav_x267nBQC">5DLD;20075CEKOύF">h) wP1Gߍ'QH">koėooo004NT~IwokploymentscriptorilOGO85AJA6ynamicQLCK$L">OracleCallableStatea&Q840M">6gGNPreparedǣWWUUW`MO">Sggץg`JRvPמQ">usH56R a ex.htmE" eS"h
      Eeditwwww|CR0v/&R18meesFR23____jSMh\__3_VRX@W?';8Entryevelfhe-92??>8?818θenvironZvarisD"W7QhspecifyO00HBR02.t''s,hecwQ73޸Pv excep G5BoOOcatchlockg@V7$gBS5DataH)erǾϾϷURxGϾϤ辋}ϾϻϾ8Bƶ'WgetAllUpԺ7תWny)E EG&vPBPXOܶШOomSHЗOϽϝo9ROߣxecut߹U`B&S4.1ƂRB6C~ЂQueryMSDUpdaww855vPw Iex.htmF"ameD
      4.5.1 0l> GgetAllEmployees, href="kle:pos:fid:0015:offH35VH)4.2/wIICursorethodV006O5J">6.3/K*DBConnectionχggc0g002PQ^L2׍MlobalizaesileOOM0HO7MFN">2OtgcHgdOgg)P">HgggQgGRRccount/ S22STg7U">testing''F' I4V1_\userؚgW"5T0g71">sa8epplic_DT>2_3">unlocpϝϖG64ϥ'TMLormǠǠ2008H534ztag777wP7OA6u3b I78">I9ABMebSpherG0B5'o pIDE//9/TR 1ͯ??G?Shj?C'5T@G0OracJDeveloperI_0O impor!ackagesokϥJ[ialogox߹߹߹߶@K1zߤIN r(terQ QB~6 jspAIЛ͂Wreج''1O'87~P5.t_aGG50(GidatawwvLwb5и籒eoyees￿@MOƹ0ϼ7g0han _׮߹״O75UWWGI5VPq2gggSU˘׽ww{D2U~ggxJSP77O7@HU7'oNXlinko pHp7QɤW0Xhod777HFa:onewen@W?3F9'߾ߩ04G~tallon_; ?directoriesdilewwHw@KU2.wϽټvfyonhe8i׼hPM^gtegratedevelopmvironaG@CF־H8 IAnetworkPacketxcgex¾OracJDBCCIrihref="kindle:pos:fid:0008:offI8U8"id="5UM">1.1.2 0l> IPX, JQ"dUR2SEwF007J1S">239T2UUY7V">installingLAV0/V18avauntimenvironment_P552wV3DBCPIGGG0T64GGAOpMU5">3.|w(6W 7">creat''#SL8'?V9">DataHarSIAVbaseonnectivityOߢߢߣHBSBؠ*libraries/SC/4D">add(nDevelop0PNE47FSP򙔆+__2 MGoH">Oracle`Ǭw11MIŌr/PersistenceGGx5G@Q96J">7.PVisualdito_9004O6K2\BeanGE1G)D'L">5/R`/2C)e !ialogox/64XxG׿1B3؇Զ8=''Ϲϋ32CȇW0defin''254GXibxEmployee.jXgJD60ﻗVs le'''DM60H''HprtX @ethod/ggg5660/ggsa0epplicoT2V翧Client7ϿϿAϻU601Serverace`???8K08wPaggg0Gg6FV.5:.sqlw08 60rgggg00C38a|Bos'׻׆7پoxIPDo_1E܄risϼwFϽWl !RdetermH006M𷰔뽇yescapeyntawwSwBKI">6Thiǿǽ7Afgwwww0AOs'$QM,ۿApacheom,upporto/?'X2L=608??W8APIWWPWxEJƿP3.3.4 applicationemplates, 3.2T,reng002VO&ULJwwsVwp////I8010/ߊ߁F1">basenstalZI452">2x13rows`ata??>K?I3491.3a5">Componentaletteߑߑ90068'6">1/7eeanialogox1F0043T~8">5hgg9">MavaÚggfOg007Q/Aa'''B">aiXonneco#1A9Cɟx4ID/ߢߙBE,0sעLVFצ1G,ePO6Hwww1IPefaultayout??g?SJJcbKownload 7L󭿱ooM">fullOO7U&N1O">IBMebSphersupportor776G7QPPy1.5YQ">guid߸߮'USH requirem3KwhֺHodensighw5FG&Hw2pRSourceditǼϼϲ5B^߼߃VisualDZQKǼVWP]hWhJBoљooǼǙo0EpoǼǎVHJDeveloperĵavigacKARlookndeel.38Qh44ѺPn߼ooOIBhOoo>honlineocuq''e2Pg@Oraclepplic+ServeجGGG9F2G.LrtMach(O1λ((<0Logic'g__g_g__LpmMwwwѻprojec crepngwwvLw %wwso_A7~8_׾׳8PrItyQp0׾׷g6JCgfResultSetbߊ߾ﰠ5EH4.4ss="l2ix"id="630">scriptletepresentation, 4.4.2 2.1.5ga4`tarting^I007A8n5Y3.3犿6">tools''9' 9F7">1.2''8">u(nterfaceP46910031LFA3B">wxow0NCggLDw/dl> JDevelopDatabaseavigatorKI3E">3 Xl_73F"?G">brponnecלo979~H3I">viePgeobj𖯠ϝGWCJWK 1.4,?ǣǠ jspϩMתNBeanagGGGaTSOC.SPagesPQ">cre/12MR 31RSTXustom1ibrarieǴDžADNUV">deploy71H4V`elems 8d14@߻oҹXhaPYloginjWWVCWVFx4.6ϿWWHTMLorm7KI*.4GGG zO'iPT''7Rv4szJava-qdcriptle7WWR14?77,0I?TC>4(tpres _QWp006Eǹ [ϟb0Stard ׼ת0UǼǢ@sYcont,ddwwNCnq϶styleheeoo'o0497!g_?j8updz 8anI003MB5.2o'''_7'`_''_PFV[`2SPv|$R 127pecificOOH25OM/7J X@ex.htmhname`j
      1.3 login.WWWWb2UAV9W P8ex.htmM"ameA">
      Mmaster-detailpplicationfiles775257G36H">7.11߄gI">overviewO(DE~JOOK">projectdž5ULM">running֖ODN8׍R model ט׌7טMCO3.2M-V-Controlleresignat@nߜKFP MVCwNRQWTNWdRWW)S">NWWWTW7U">nextethod??>V?O7>V">4.LOOJȣO[60OO1">OOON62O/3CI8004D64­009AH5#_6 DP.NETGGFFG006D67">2W'=ojdbc5.jarH005Q6X2.7OJVMI結TV2DzoOڳHOracleDFOOO97O??967?疸痘ʳsce-orienteȹwcreȭ'zJ4ε'usinessomponsؿ@ o"fXurWWWWi7T2.—PgwuFacOOOOa8F1&x_evelopFr8workOOOOpD6///pmP?????P*wwrSe'ϯGϿ8H5Weallɕrf6諜 Datarovidfor ?ww?<96>tabase?ӻлes12*.*upport??7?OPX1?׹jcla-s dooo37H7clogbject7B7K78Gg@conn8to7׆JDK ǼǼǼ8HJfǰg3߼J7缯ojdbc5.jailX ??S7~ ?ξ6σϽonU7wwGsConCacheImplO009A5&WW'vFpracle.jdbc.driver.*upport, 2.1.3 unconnecting}2BD4~I">8_l> Oratabaselien56BJ2O003JK">3.3. l7L"ggM">developmPoolsJ9N7O">installation001GC~P{ڒFNQH8RS">JDBC ????N7>T???7UOD2`T2Vg80^ProviderorLEBϟϟϟ0063P1Oϟϟ82FServicesMicrosoftransaongggGA63ggg84">ifyH //BRV5ǤǤc 367߭WWqE88鈯X'9'A">environ"variableGGG268BGGgCFedirxoriandiWWMM&DWWW8ERACLE_HOME /jlib_3F8@E/TI^8O`p`Hm-specifiCEǾǾǾǾǴ25μC%D/|?xO8avairtualachineI(Q3,羇羇05PG䂷raryo.gPB׾`34ǿǼhc.poolPBQ9`ǿǿ9(,sqGG'V9'OCIď28hG,LJ¼( wsNH&PvPackag9VD>3gdpP򼐖gggBMTЄ޻g'ϾϏϾ00ADR~xosupportϽϒ߽Ϣ09ȯͤCԧ@6A98ϼ9Znetworkrotocol'768f69I">SQL*Net, 1. TCP/IPOOOOHLONLOOOO9MHTCrotocoldždždždž99Ndždždž9OypeV006JPP/dl> OracleDeveloper9O1Q2 l9R"ǍǏS">installing//.I/4.T">2.3 tudioditionoADUnODBCriv//0F/005VB.V-ProvidforLEB62A0REFURSOR ߜߜ1V002A1">6.3ےmServicesMicrosoftransacgwwObIJf2OWebLogicϣ??;G?QF.35lϘP00354">3(4RACLE_HOMEirectoryררH׋UL5WeC(ableStatemenQ1A6ɫxU~A76A8g9">creatRAAB">IN,UT,NAarametersMQC>usGO5EG׮DatabaseMetaa?8NF;o.jdbc004KCnGz߽777;BPH3bGGGGTI߽ߞa8GJӷϫKL">java.sql00C5MMOAN">V@libraggw:DEfOߠoo[FPc.poo߽93Q/Preed߿UxPR">ggVMI~Sߨ߽Tߩ|U">baria''I41V#'gG9B0gJA1_gBpompiledWWWRBPϯ״μثϾϹ/SG.׾ǾǩH8AG9׏dypGB26_׿01SBȬ׿ǿǿBUCS-2hxcpe'UOHoOgql.pumGGG6HT.CURSOR^V006x2 i18n.jarHp1Ͻ2.<ad="index.htmP"amea6BI">
      Ppositioningnesultets, 4.1.3.135ߊPhcreat0270013AQ">7]Riynsporggf9g006G0S">1.2.2Wl0גQ׀TגדU">QגגVדC0">querydataoonUo4M61jєoooyN62O 32C4Q75">DHar.jav71056f62ϊ7">J8pplicxon7778G8W99DBConcep?2DnA?ǑB">Lwowutput77700ARCרgJD">ONJEOoGCFethodV2G/H">kHtes߮$JCǟhtracessageLC禷 ǹR ع6CR紸w²REFURSOR~1Uw6.3X𭇦xҰacc߼777747C77w^8CallableStatemenתO׿5RfD׿ׯVder73O1f،1wPOle ypw1I.Ͽ ǭ?wGϻi4Dh(pό mrialize`s #etbjec'__Q.D relHve Xiinϵ0GY1HvYOnhaIsOosOORPǾ'GQD"GG0scro1ilityGGGPjggfxsenvobbasege׸ HC& ׾砄up?2?ٓǤ''X?/06AU8+featu׼טקHKȘ:S6߿ߛ߿9𛚤G'clH2BpP8g[`getBooleanGGGBOT">4.1.3 getInt, JDeveloper,reatingn''%15'003C23i4.2ooo!4">nextethodLG5ߍ/dl> ex.htmS"amet6"ahr/12=7">Ssamplepplicon\A6EB񆉔iC">jesA006M5nD">E@onnec N_EF">3.3.1___G">DataHar.javaSM^H盞I">delete_aon.jsp???4KJww.K">editOϢ59R6LϥvM">E@oyeesWG7DCNG77O7ooJQnEP^Q0rror@ssag/1BJ1R)6///S">failedogingGiGOT>HRserccou0F002B28OOOHFӘ/ggsGDT ert?X4UEо///OO\؈??? scriplet2Vϸ4.3xstx lFGxrep8Z@Developer59G4.4߅mOOBJv>HNGhollabiYultww00VwP04 ensitivo abasehangǼJL6> Sequencedacketx'x"id="6G6"> OracleDBCCIriver, 1.1.2 SPX7D9> SQLException 1OxE0fA">5.5ktatementbjectU002L4B">418l??GCD">executeethodߋ߄O006DS6EKߏFBatch78BGWWGH>Queryg??O7IggGJUpdg87gKGLPreparednǚǕQ003M9M">65N">qdsGGG0051OoGAstopunc)ϣPQ">calling77.S79Rq' creat7gg7r1NS6proceduresWkTooLUǪǪ HNVǟH0߮??PA1 [2">Databaseaviga玷 TO3H4">JDevelopOOOR^H5wHCable__064UYy8sheetus//012/hO(4.3??63?004BG4a ex.htmT"ameܻR
      updatection,andling, 5.2.5 useruthenticaB GA6J">4.6.1 鈨ex.htmV"ameK"8
      Vviewrojectgge29gJKO">7.4WWPQ">WRהSeb verGGE0GGEPT">2.1GCUҋ6IVJ0">ApacheomЙoo/oL461/oo?J2">qletontainϝϖZHJ3ϙoiweb.xmlO1J46tmXD5 6">X7ߌ8/OpenQLallevelnterface8QG9">"70div%fooNA)table]simppoac_no_warn"ummary=""ells@="0paddwidth="100%1col*rdtylf-size: 9lign="c腉$copyrightlogoimgv4he8rcembe1?mihimage/gifIOracle"/>? 0000263625} 0000267240̀ 0000267366ހH 0000276593ހb 0000276761cf 0000289940JK 0000299557 00003034213 00003035915m 0000317601" 0000321552AI 0000330968 f 0000344110q 0000344236ʀrP 0000354578ʀC 0000354746܀Df 0000367896܀*/ 0000373974Z 0000374144[9 0000381534E 0000390482Z 0000394476z 0000394483z 0000394490Ȁz 0000394630ڀzT 0000405425ڀO 0000405621P_ 0000417821/ 0000421600M` 0000434014.+ 0000439561Y3 0000446212 Z 0000457783gS 0000468471;) 0000473776dA 0000482168& 0000483642ƀ1G 0000492769؀x 0000492891y@ 00005011069@ 0000509307y[ 0000521000UD 0000529776 C 0000538397 ]A 0000546737! 0000550207!9IDXT 3GZn$9Mbw1F[p-BWl(=Rf{"6J_t1F[oP-//*[@aid='0']P-//*[@aid='7']S-//*[@aid='7']P-//*[@aid='Q0']P-//*[@aid='10I']S-//*[@aid='10I']S-//*[@aid='Q0']P-//*[@aid='149']P-//*[@aid='14O']S-//*[@aid='14O']S-//*[@aid='149']P-//*[@aid='1F9']P-//*[@aid='1M3']S-//*[@aid='1M3']S-//*[@aid='1F9']P-//*[@aid='229']P-//*[@aid='231']S-//*[@aid='231']P-//*[@aid='2CR']S-//*[@aid='2CR']P-//*[@aid='2IH']S-//*[@aid='2IH']P-//*[@aid='2N3']S-//*[@aid='2N3']P-//*[@aid='2RS']S-//*[@aid='2RS']S-//*[@aid='229']P-//*[@aid='347']P-//*[@aid='37O']S-//*[@aid='37O']P-//*[@aid='3GV']S-//*[@aid='3GV']S-//*[@aid='347']P-//*[@aid='3VM']P-//*[@aid='445']S-//*[@aid='445']P-//*[@aid='4AN']P-//*[@aid='4DV']S-//*[@aid='4DV']S-//*[@aid='4AN']S-//*[@aid='3VM']P-//*[@aid='4J7']P-//*[@aid='4ML']S-//*[@aid='4ML']S-//*[@aid='4J7']P-//*[@aid='58A']P-//*[@aid='5F0']S-//*[@aid='5F0']S-//*[@aid='58A']P-//*[@aid='5JV']S-//*[@aid='5JV']INDXTAGX SKEL0000000000IDXTINDXSKEL0000000000 ۀIDXTINDXTAGXtocIDXTINDXstarttexttocIDXTTable of ContentsStartup PageWelcomeFDST gg}S}SFLISAFCISg DATP  f1(5BO\ihv#p"]ɀvF8".9yEyQ\kGut:,i~)X&.z5@XKS^lyK[`~ڐ  ,]\)G5@MZelq~f4+Ĝӱ2(2:DrKSxZ?aAh"ow457VfȪю$ (91;7FzQ[en{xz*d ߛRbm;)5@LaXblxQV?nN/Uu G(_1=GDLS[dm/uvy6F{P~'l3=?LXeSzs6}zzg}zglC hn_Lke xgw<xxUy}jS~[85@~ = yyy}yy xlyy:P?~yL*hpy~>cQah?\ G> OYDkxsxLx:fy/sjo^l(ovoVYohx}yoqmxxj_diyl~yoZSypw?~#-S_8#{spx^gmwxVuoQzA[~ukXsXsFSL{nTHscAhplx{xujl<?x{xxp\ycLx!2y)Tw{y my,vuBy0s>|yvyhXyAJPU}+sPY>tvygywoipyy!bn\+f\ReIXjyyr}Cjm~{XpyhytCxXRUX_?ScdOomm_igmk^mOU&W{{c@Ba\lug]wnwnrctyzwn/ceM\fzwsfxKmsrkmwnjooxhyPfruhvy0yrQ\9yt`Qo^ylyRmyys2S{@~Oy}{o%F|hs%2%yWw~baXptfe$oy}yOk]eG{ryyphzPpP<zp}WyyyKhu|y%~y\Kw{mw\nclImTd{u]}(qa`Vnl"ylyax]hdyul2i|vm9Zy2|'~syyZZ|k)tyxhmah^)-jJ]]YXHZFbN{TybZryvtimguVufuzzzy.k~GGCq}x\uVcqyyypkIaXShe\cip]xyb`UCx+c=ASz(s`dXb^ah[bR[eM`kFN!yytKsf~wayyy!hqumyKPy{~Psy.SauyCyxg~\sNu^z`c}mt\S]Le,uy{_my~!yyyqx+)~yxv~hyuR~ng qf3xn-y}Dfuozwchxz~!~yynyp]xyThwJNngYehm`c/rC]{yy+{^VrzYzf`yTyeWyNjA`y\yy\~ayxyyWyYiGbyh}}ch`yqy{kllyC~-{MQvaQu-ek{mZPffXnhwayg~+^\\i>hywnlxlrtkw^rfxlksyH^]uohmlo${kaeo]MQsq-ymmxr!Shyx]uvaui\\lxxzq\\v~c]yZXm!st{zrvsiBieyAyj$d<ccyjznk}$^v-hm~nynynyoknfyxlfbpgyyjx#!FXWl=y_bdgV!._~y}yxm^]G}y}p{j;yx[~%o~bghm?u~|y^yS~x;JLmhymN~ym~jmyvrPmyyh[pU\yxh'{XcMlVrG/d;}d;}dD|\L{ULyWLySPxYLzWLxYXo`NofH_mXtu/my4|dGq/w2~>4{Xy~4{hsTkyueygyly~/{}~a`uyyG~^Qpyypy?H|/^/{ie[dGQQLLfpb?zGQQLd=/ihY_2J<2]pYO@E32@/lVUNGiNhEJ7say(nh\wylRy?xeiy]abkZ]ZWkuXut