servlet program

Upload: dinesh-kumar

Post on 06-Jul-2018

240 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/17/2019 Servlet program

    1/28

    SERVLET EXAMPLES

     Application1: To print Welcome Message on Browser 

     package servlet.com;

    import java.io.IOExceptio;import java.io.Prit!riter;

    import javax.servlet.Servlet"otext;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class !elcomeServlet exte(s $ttpServlet ) 

     p&'lic !elcomeServlet*+ )

      s&per*+;

     ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*4!elcome To Servlet !orl(4+;

    Servlet"otext ctx3getServlet"otext*+;

    Strig s3ctx.getIitParameter*4ame4+;

    00Strig s3o.toStrig*+;

    o&t.pritl*s+;

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

    ,

     Application 2: Retrieve form fields using getParameter() metod 

    Text5ox.#tml671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .4

    4#ttp?00///./:.org0TR0#tml0loose.(t(4@

    6#tml@

    6#ea(@

    6meta #ttp2e%&iv3!"ontent#T$pe!  cotet3!te%t&tml' carset*+#,,-.#1! @

    6title@Isert title #ere60title@

    60#ea(@

    6 'o(@

    6Borm actio3 /ormTe%tBo%es@

    9ser>ame?6ip&t tpe3!te%t! ame3username @6 'r @

    Pass/or(?6ip&t tpe3!te%t!  ame3 password @6 'r @

  • 8/17/2019 Servlet program

    2/28

    6ip&t tpe3 su0mit  val&e3clic @

    60Borm@

    60 'o(@

    60#tml@

     package servlet.com;import java.io.IOExceptio;

    import java.io.Prit!riter;

    import javax.servlet.Servlet"otext;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class -etParameterTest exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic -etParameterTest*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    Strig B3re%&est.getParameter*4Bame4+;Strig m3re%&est.getParameter*4mame4+;

    Strig l3re%&est.getParameter*4lame4+;

    Strig mo3re%&est.getParameter*4mo4+;

    Strig email3re%&est.getParameter*4email4+;

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*BC46'r@4CmC46'r@4ClC46'r@4CmoC46'r@4Cemail+;

    Servlet"otext ctx3getServlet"otext*+;

    Strig s3ctx.getIitParameter*4ame4+;

    o&t.pritl*s+;

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

    ,

     Application : Read form fields using getParameter3ames() metod 

  • 8/17/2019 Servlet program

    3/28

    Perso.#tml

    671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .4

    4#ttp?00///./:.org0TR0#tml0loose.(t(4@

    6#tml@

    6#ea(@

    6meta #ttp2e%&iv3!"ontent#T$pe!  cotet3!te%t&tml' carset*+#,,-.#1! @6title@Isert title #ere60title@

    60#ea(@

    6 'o(@

    6Borm actio34etParameter3ames@

    Dirst>ame?6ip&t tpe3!te%t!  ame3 fname@6 'r @

    Mi((le>ame?6ip&t tpe3!te%t!  ame3mname@6 'r @

    Last>ame?6ip&t tpe3!te%t!  ame3lname@6 'r @

    Mo'ile>&m'er?6ip&t tpe3!te%t!  ame3mno@6 'r @

    Email?6ip&t tpe3!te%t!  ame3email @6 'r @

    6ip&t tpe3 su0mit  val&e3clic @

    60Borm@

    60 'o(@

    60#tml@

     package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import java.&til.E&meratio;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class -etParameter>ames exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic -etParameter>ames*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      , protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    E&meratio e3re%&est.getParameter>ames*+;

    /#ile*e.#asMoreElemets*++

    )

    O'ject o3e.extElemet*+;

    Strig k3o.toStrig*+;

    Strig v3re%&est.getParameter*k+;

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*v+;,

  • 8/17/2019 Servlet program

    4/28

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&',

    ,

     Application 5:Read form field using getParameter6alues() metod 

    -etParameterVal&es.#tml

    671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .4

    4#ttp?00///./:.org0TR0#tml0loose.(t(4@

    6#tml@

    6#ea(@

    6meta #ttp2e%&iv3!"ontent#T$pe!  cotet3!te%t&tml' carset*+#,,-.#1! @6title@Isert title #ere60title@

    60#ea(@

    6 'o(@

    6ceter @

    6Borm actio34etParameter6alueTest @

     >ame?6ip&t tpe3te%t  ame3!uname! @6 'r @

    Select 5ooks?

    6select ame3!0oo!  m&ltiple3!$es! @

    6optio val&e3!7ava! @AVA60optio@

    6optio val&e3!8net! @.>ET60optio@

    6optio val&e3!oracle! @ORA"LE60optio@

    6optio val&e3!cpp! @"PP60optio@

    60select@

    6 'r @6 'r @

    6ip&t tpe3 su0mit  val&e3!clic! @

    60Borm@

    60ceter @

    60 'o(@

    60#tml@

     package servlet.com;import java.io.IOExceptio;

    import java.io.Prit!riter;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class -etParameterVal&eTest exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L;

     p&'lic -etParameterVal&eTest*+ )  s&per*+;

  • 8/17/2019 Servlet program

    5/28

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )00 TO1O A&to2geerate( met#o( st&'

    (o&'le price3

  • 8/17/2019 Servlet program

    6/28

    6 'o(@

    6Borm actio34etParameterMapTest @

    Dirst>ame?6ip&t tpe3!te%t!  ame3 fname@6 'r @

    Mi((le>ame?6ip&t tpe3!te%t!  ame3mname@6 'r @

    Last>ame?6ip&t tpe3!te%t!  ame3lname@6 'r @

    Mo'ile>&m'er?6ip&t tpe3!te%t!  ame3mno@6 'r @Email?6ip&t tpe3!te%t!  ame3email @6 'r @

    6ip&t tpe3!cec0o%!  ame3!option1!  val&e3!Mil! @ Milk 6 'r @

    6ip&t tpe3!cec0o%!  ame3!option1!  val&e3!Butter!  c#ecke(@ 5&tter 6 'r @

    6ip&t tpe3!cec0o%!  ame3!option1!  val&e3!"eese! @ "#eese6 'r @

    6ip&t tpe3 su0mit  val&e3!clic! @

    6ip&t tpe3 su0mit  val&e3clic @

    60Borm@

    60 'o(@

    60#tml@

     package servlet.com;import java.io.IOExceptio;

    import java.io.Prit!riter;

    import java.&til.$as#Map;

    import java.&til.Map;

    import java.&til.Set;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class -etParameterMapTest exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic -etParameterMapTest*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    Prit!riter o&t3respose.get!riter*+;

    Map6StrigStrigFG@ m3re%&est.getParameterMap*+;

    $as#Map6Strig StrigFG@ #m3e/ $as#Map6Strig StrigFG@*m+;

    Set6Map.Etr6StrigStrigFG@@ set3#m.etrSet*+;

    Bor*Map.Etr6StrigStrigFG@ #s=?set+)

    StrigFG x3#s=.getVal&e*+;

    Bor*it a3

  • 8/17/2019 Servlet program

    7/28

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/sServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

    ,

     Application -: Read Te%tArea in servlet

    TextArea.#tml

    671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .4

    4#ttp?00///./:.org0TR0#tml0loose.(t(4@

    6#tml@6#ea(@

    6meta #ttp2e%&iv3!"ontent#T$pe!  cotet3!te%t&tml' carset*+#,,-.#1! @

    6title@Isert title #ere60title@

    60#ea(@

    6 'o(@

    6$=@S&'mittig Text Areas60$=@

      6DORM A"TIO>3Te%tAreaTest  met#o(3 post @

      Please eter o&r text?

      65R @

      6TEXTAREA  >AME3!te%tarea1!  RO!S3!-! @60TEXTAREA@

      65R @  6I>P9T T8PE3!*9BMT!  VAL9E3!*u0mit! @

      60DORM@

    60 'o(@

    60#tml@

     package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

    import java.lag.;

     p&'lic class TextAreaTest exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic TextAreaTest*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

  • 8/17/2019 Servlet program

    8/28

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/sServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    Prit!riter o&t3respose.get!riter*+;

    Strig5&BBer text 3 e/ Strig5&BBer*re%&est.getParameter*4textarea=4++; 

    it loc 3 *e/ Strig*text++.i(exOB*JJ+;

      /#ile*loc @ -

      6ip&t tpe3!radio!  ame3!;1!  val&e3!0! @ RAMMO$A>6 'r  0@

      6 'r  0@6 'r  0@6 '@N&estio H?A9T$OR OD "60 '@6 'r  0@6 'r  0@

      6ip&t tpe3!radio!  ame3!;2!  val&e3!a! @ 1E>>IS RI"$E

      6ip&t tpe3!radio!  ame3!;2!  val&e3!0! @ RAMMO$A>6 'r  0@6ip&t tpe3!su0mit!  val&e3!clic! @

    60 'o(@

    60#tml@

     package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

  • 8/17/2019 Servlet program

    9/28

     p&'lic class Ra(io5&ttoTest exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic Ra(io5&ttoTest*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'  ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    it res<

    Prit!riter o&t3respose.get!riter*+;

    Strig %= 3 re%&est.getParameter*4N=4+;Strig %H 3 re%&est.getParameter*4NH4+;

    iB*%=.e%&als*4a4+%H.e%&als*4a4++)

    res&lt3H;

    o&t.pritl*48o&r Score is H4C4t4C48o&r are Pass4+;

    ,

    else iB*%=.e%&als*4'4+%H.e%&als*4'4++

    o&t.pritl*48o&r Score is

  • 8/17/2019 Servlet program

    10/28

     package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import javax.servlet.Servlet"otext;

    import javax.servlet.ServletExceptio;import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class !elcomeServlet exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic !elcomeServlet*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      , protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*4!elcome To Servlet !orl(4+;

    Servlet"otext ctx3getServlet"otext*+;

    Strig s3ctx.getIitParameter*4ame4+;

    00Strig s3o.toStrig*+;

    o&t.pritl*s+;

    , protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

    ,

     Application ,: *end Re=uest to *ervlet using ?ava*cript function

    SB&ctio.#tml

    671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .44#ttp?00///./:.org0TR0#tml0loose.(t(4@

    6#tml@

    6#ea(@

    6meta #ttp2e%&iv3!"ontent#T$pe!  cotet3!te%t&tml' carset*+#,,-.#1! @

    6title@ava Script D&ctio Test60title@

    6script@

    function B=*+

    )

    alert*4Eter Ito avaScript4+;

    (oc&met.Borm=.actio34STestServlet4;

    (oc&met.Borm=.s&'mit*+;,

  • 8/17/2019 Servlet program

    11/28

    60script@

    60#ea(@

    6 'o(@

    6ceter @

    6#H@

    6Borm ame3!form1!@Select "o&tr?6select ame3!s1!  o"#age3!f1()! @

    6optio val&e3!! @2222select2222260optio@

    6optio val&e3!3@A! @i(ia60optio@

    6optio val&e3!">3A! @c#ia60optio@

    6optio val&e3!?APA3! @ japa60optio@

    6optio val&e3!9*! @9ite( States OB Amrica60optio@

    60select@

    60Borm@

    60#H@

    60ceter @

    60 'o(@60#tml@

     package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class STestServlet exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic STestServlet*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'Strig str3re%&est.getParameter*4s=4+;

    it l3str.legt#*+;

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*4Legt# OB Selecte( "o&tr is?4Cl+;

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&',

  • 8/17/2019 Servlet program

    12/28

    ,

     Servlet-Database Communication Application 1: 4et data0ase into servlet and print on 0rowser in ta0le format 

     package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import java.s%l."oectio;

    import java.s%l.1riverMaager;

    import java.s%l.Res&ltSet;

    import java.s%l.Statemet;

    import javax.servlet.Servlet"oBig;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class 1ata'ase"oectio exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

    "oectio co;

      p&'lic 1ata'ase"oectio*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     p&'lic voi( iit*Servlet"oBig coBig+ t#ro/s ServletExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    tr

    )

    "lass.Bor>ame*4com.ms%l.j('c.1river4+;

    co31riverMaager.get"oectio*4j('c?ms%l?00local#ost?::

  • 8/17/2019 Servlet program

    13/28

    tr

    )

    Statemet st3co.createStatemet*+;

    Res&ltSet rs3st.exec&teN&er*4select Brom st&(etiBo4+;

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*46ceter@6ta'le 'or(er3H@4+;/#ile*rs.ext*++

    )

    o&t.pritl*46tr@4+;

    o&t.pritl*46t(@4Crs.getIt*=+C460t(@4+;

    o&t.pritl*46t(@4Crs.getStrig*H+C460t(@4+;

    o&t.pritl*46t(@4Crs.getIt*:+C460t(@4+;

    o&t.pritl*460tr@4+;

    ,

    o&t.pritl*460ta'le@60ceter@4+;

    ,catc#*Exceptio e+

    )

    ,

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

    ,

     Application2: nter *; command in tml te%t0o% and e%ecute() metod e%ample

    S%l"omma(.#tml

    671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .4

    4#ttp?00///./:.org0TR0#tml0loose.(t(4@

    6#tml@

    6#ea(@

    6meta #ttp2e%&iv3!"ontent#T$pe!  cotet3!te%t&tml' carset*+#,,-.#1! @

    6title@Isert title #ere60title@

    60#ea(@

    6 'o(@

    6ceter @

    6Borm actio3 @ata0ase"onnection2 met#o(3!post! @

    Eter a "omma(6ip&t tpe3te%t  ame3!command! @6 'r @

    6ip&t tpe3 su0mit  val&e3!clic! @

    60Borm@

    60ceter @

    60 'o(@60#tml@

  • 8/17/2019 Servlet program

    14/28

     package servlet.com;

    import java.io.IOExceptio;

    import java.s%l."oectio;

    import java.s%l.1riverMaager;

    import java.s%l.Res&ltSet;

    import java.s%l.Statemet;import javax.servlet.Servlet"oBig;

    import javax.servlet.ServletExceptio;

    import javax.servlet.ServletO&tp&tStream;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class 1ata'ase"oectioH exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

    "oectio co;Statemet st;

      p&'lic 1ata'ase"oectioH*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     p&'lic voi( iit*Servlet"oBig coBig+ t#ro/s ServletExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    tr

    )"lass.Bor>ame*4com.ms%l.j('c.1river4+;

    co31riverMaager.get"oectio*4j('c?ms%l?00local#ost?::

  • 8/17/2019 Servlet program

    15/28

    00 TO1O A&to2geerate( met#o( st&'

    tr

    )

    Strig s3re%&est.getParameter*4comma(4+;

    ServletO&tp&tStream sos3respose.getO&tp&tStream*+;

    iB*st.exec&te*s++)

    Res&ltSet rs3st.getRes&ltSet*+;

    sos.pritl*46ta'le 'or(er3H@4+;

    /#ile*rs.ext*++

    )

    sos.pritl*46tr@4+;

    sos.pritl*46t(@4Crs.getIt*=+C460t(@4+;

    sos.pritl*46t(@4Crs.getStrig*H+C460t(@4+;

    sos.pritl*46t(@4Crs.getIt*:+C460t(@4+;

    sos.pritl*460tr@4+;

    ,

    sos.pritl*460ta'le@4+;

    rs.close*+;

    ,

    else

    )

    it k3st.get9p(ate"o&t*+;

    sos.pritl*46#H@Ro/ 9p(ate(34CkC460#H@4+;

    ,

    ,catc#*Exceptio e+

    )

    ,

    ,

    ,

     Application : @ispla$ s=l ta0le data using frameset concept using Result*etMeta@ata

    interface

    I(ex.#tml

    671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .4

    4#ttp?00///./:.org0TR0#tml0loose.(t(4@

    6#tml@

    6Brameset cols3!5CDEF! @

    6Brame ame3!frm1!  src3!input8tml! @

    6Brame ame3!frm2! @

    60Brameset@

    60#tml@

    Ip&t.#tml

    671O"T8PE  #tml  P95LI"  4200!:"001T1 $TML .44#ttp?00///./:.org0TR0#tml0loose.(t(4@

  • 8/17/2019 Servlet program

    16/28

    6#tml@

    6#ea(@

    6meta #ttp2e%&iv3!"ontent#T$pe!  cotet3!te%t&tml' carset*+#,,-.#1! @

    6title@Isert title #ere60title@

    60#ea(@

    6 'o(@6Borm actio3 @ata0ase"onnection target3!frm2!  met#o(3!post! @

    Eter Select "omma(?6ip&t tpe3te%t  ame3!command! @6 'r @

    6ip&t tpe3 su0mit  val&e3!clic! @

    60Borm@

    60 'o(@

    60#tml@

     package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import java.s%l."oectio;import java.s%l.1riverMaager;

    import java.s%l.Res&ltSet;

    import java.s%l.Res&ltSetMeta1ata;

    import java.s%l.Statemet;

    import javax.servlet.Servlet"oBig;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class 1ata'ase"oectio: exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

    "oectio co;

    Statemet st;

      p&'lic 1ata'ase"oectio:*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     p&'lic voi( iit*Servlet"oBig coBig+ t#ro/s ServletExceptio )00 TO1O A&to2geerate( met#o( st&'

    tr

    )

    "lass.Bor>ame*4com.ms%l.j('c.1river4+;

    co31riverMaager.get"oectio*4j('c?ms%l?00local#ost?::

  • 8/17/2019 Servlet program

    17/28

    )

    e.pritStackTrace*+;

    ,

    ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/sServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    tr

    )

    Prit!riter o&t3respose.get!riter*+;

    Strig s3re%&est.getParameter*4comma(4+;00Strig %&er34select Brom st&(etiBo /#ere same34Cs;

    Res&ltSet rs3st.exec&teN&er*s+;

    Res&ltSetMeta1ata rsm(3rs.getMeta1ata*+;

    it co&t3rsm(.get"ol&m"o&t*+;

    o&t.pritl*46ta'le 'or(er3:@4+;

    o&t.pritl*46tr@4+;

    Bor*it i3=;i63co&t;iCC+

    o&t.pritl*46t#@4Crsm(.get"ol&m>ame*i+C460t#@4+;

    o&t.pritl*460tr@4+;

    /#ile*rs.ext*++

    )

    o&t.pritl*46tr@4+;

    Bor*it j3=;j63co&t;jCC+

    o&t.pritl*46t(@4Crs.getStrig*j+C460t(@4+;

    o&t.pritl*460tr@4+;

    ,

    o&t.pritl*460ta'le@4+;

    o&t.close*+;

    rs.close*+;

    ,

    catc#*Exceptio e+)

    e.pritStackTrace*+;

    ,

    ,

    ,

     Application 5: %ample on Page3ation "oncept 

     package servlet.com;

    import java.io.IOExceptio;import java.io.Prit!riter;

  • 8/17/2019 Servlet program

    18/28

    import java.s%l."oectio;

    import java.s%l.1riverMaager;

    import java.s%l.Res&ltSet;

    import java.s%l.Statemet;

    import javax.servlet.Servlet"oBig;

    import javax.servlet.ServletExceptio;import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class PagiatioTest exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

    "oectio co;

    Statemet st;

      p&'lic PagiatioTest*+ )

      s&per*+;  00 TO1O A&to2geerate( costr&ctor st&'

      ,

     p&'lic voi( iit*Servlet"oBig coBig+ t#ro/s ServletExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    tr

    )

    "lass.Bor>ame*4com.ms%l.j('c.1river4+;

    co31riverMaager.get"oectio*4j('c?ms%l?00local#ost?::"9RREA

    1O>L8+;

    Sstem.o&t.pritl*4ok4+;

    ,

    catc#*Exceptio e+

    )

    e.pritStackTrace*+;

    ,

    ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

     process*re%&est respose+;

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

     process*re%&estrespose+;

  • 8/17/2019 Servlet program

    19/28

    ,

     p&'lic voi( process*$ttpServletRe%&est re%&est $ttpServletRespose

    respose+t#ro/s ServletExceptioIOExceptio

    )

    tr

    ) it page>&m'er3&m'erOBRecor(s3o73&ll 744.e%&als*sPage>o++

     )

     page>&m'er3Iteger.parseIt*sPage>o+;

     ,

     else )

     page>&m'er3=;

     ,

     Res&ltSet rs=3st.exec&teN&er*4select co&t*+Brom st&(etiBo4+;

     rs=.ext*+;

     total>&m'erOBRecor(s3rs=.getIt*=+;

     Sstem.o&t.pritl*total>&m'erOBRecor(s+;

     rs=.close*+; 

    Res&ltSet rsH3st.exec&teN&er*4select Brom st&(etiBo4+;

     startI(ex3*page>&m'errecor(sPerPage+2recor(sPerPageC=;

     Prit!riter o&t3respose.get!riter*+;

     o&t.pritl*46ceter@6ta'le 'or(er3@4+;

     rsH.a'sol&te*startI(ex+;

     it i3&m'erOBRecor(s0recor(sPerPage;

     iB*total>&m'erOBRecor(s@oOBPagesrecor(sPerPage+

     )

     oOBPages3oOBPagesC=;

     , Bor*it k3=;k63oOBPages;kCC+

  • 8/17/2019 Servlet program

    20/28

     )

     o&t.pritl*46a #reB3page>o34CkC4@4CkC44C460a@4+;

     ,

     o&t.pritl*460ceter@4+;

     o&t.close*+;

     rsH.close*+; 

    ,

    catc#*Exceptio e+

    )

    e.pritStackTrace*+;

    ,

    ,

    ,

     Application -: "reate a separate class for connection properties and create tat class o07ect 

    in servlet classsTest"oectio.java

     package servlet.com;

    import java.s%l."oectio;

    import java.s%l.1riverMaager;

     p&'lic class Test"oectio )

    "oectio co;

     p&'lic "oectio test"oectio*+

    )

    tr

    )

    "lass.Bor>ame*4com.ms%l.j('c.1river4+;

    co31riverMaager.get"oectio*4j('c?ms%l?00local#ost?::

  • 8/17/2019 Servlet program

    21/28

    import java.s%l."oectio;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

     p&'lic class Test exte(s $ttpServlet )

     private static Bial log serialVersio9I1 3 =L; 

     p&'lic Test*+ )

      s&per*+;

      00 TO1O A&to2geerate( costr&ctor st&'

      ,

     protecte( voi( (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )00 TO1O A&to2geerate( met#o( st&'

    Test"oectio tc3e/ Test"oectio*+;

    "oectio c3tc.test"oectio*+;

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*4I got "oectio4+;

    ,

     protecte( voi( (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ t#ro/s

    ServletExceptio IOExceptio )

    00 TO1O A&to2geerate( met#o( st&'

    ,

    ,

     ServeltConfig Example

     Application 1: "onfigure connection properties in we08%ml file

    /e'.xml

    6/e'2app@

    6servlet@

      6(escriptio@60(escriptio@

      6(ispla2ame@IitParameterTest60(ispla2ame@  6servlet2ame@IitParameterTest60servlet2ame@

      [email protected]@

      6iit2param@

      6(escriptio@60(escriptio@

      6 param2ame@(river 60 param2ame@

      6 param2val&[email protected]%l.j('c.1river 60 param2val&e@

      60iit2param@

      6iit2param@

      6(escriptio@60(escriptio@

      6 param2ame@&rl60 param2ame@

      6 param2val&e@ j('c?ms%l?00local#ost?::

  • 8/17/2019 Servlet program

    22/28

      6iit2param@

      6(escriptio@60(escriptio@

      6 param2ame@&serame60 param2ame@

      6 param2val&e@root60 param2val&e@

      60iit2param@

      6iit2param@  6(escriptio@60(escriptio@

      6 param2ame@ pass/or(60 param2ame@

      6 param2val&e@ms%l60 param2val&e@

      60iit2param@

      60servlet@

      6servlet2mappig@

      6servlet2ame@IitParameterTest60servlet2ame@

      6&rl2patter@0IitParameterTest60&rl2patter@

      60servlet2mappig@

      60/e'2app@

    package servlet.com;

    import java.io.IOExceptio;

    import java.io.Prit!riter;

    import java.s%l."oectio;

    import java.s%l.1riverMaager;

    import java.s%l.Res&ltSet;

    import java.s%l.Statemet;

    import javax.servlet.ServletExceptio;

    import javax.servlet.#ttp.$ttpServlet;

    import javax.servlet.#ttp.$ttpServletRe%&est;

    import javax.servlet.#ttp.$ttpServletRespose;

    public class IitParameterTest extends $ttpServlet )

    private static final long  serial6ersion9@ 3 =L; 

    public IitParameterTest*+ )

      super*+;

      00 TODO A&to2geerate( costr&ctor st&'

      ,

    protected  void  (o-et*$ttpServletRe%&est re%&est $ttpServletRespose respose+ throwsServletExceptio IOExceptio )

    00 TODO A&to2geerate( met#o( st&'

    Strig s=3getIitParameter*4(river4+;

    Strig sH3getIitParameter*4&rl4+;

    Strig s:3getIitParameter*4&serame4+;

    Strig s3getIitParameter*4pass/or(4+;

    try)

    "lass. for3ame*s=+;

    Sstem.out .pritl*s=C4(river is loa(e(4+;

    "oectio co31riverMaager. get"onnection*sHs:s+;

    Statemet st3co.createStatemet*+;Res&ltSet rs3st.exec&teN&er*4select Brom st&(etiBo4+;

  • 8/17/2019 Servlet program

    23/28

    Prit!riter o&t3respose.get!riter*+;

    o&t.pritl*46ceter@6ta'le 'or(er3H@4+;

    while*rs.ext*++

    )

    o&t.pritl*46tr@4+;

    o&t.pritl*46t(@4Crs.getIt*=+C460t(@4+;o&t.pritl*46t(@4Crs.getStrig*H+C460t(@4+;

    o&t.pritl*46t(@4Crs.getIt*:+C460t(@4+;

    o&t.pritl*460tr@4+;

    ,

    o&t.pritl*460ta'le@60ceter@4+;

    ,

    catch*Exceptio e+

    )

    ,

    ,

    protected  void  (oPost*$ttpServletRe%&est re%&est $ttpServletRespose respose+ throws

    ServletExceptio IOExceptio )

    00 TODO A&to2geerate( met#o( st&'

    ,

    ,

    REN9EST1ISPAT"$ER I>TERDA"EApplicatio=? 9sig Bor/ar(*22+ a( icl&(e met#o(s

    Pro(&ct.#tml

  • 8/17/2019 Servlet program

    24/28

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)**t9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)*%#*9

    /;;

     ; 6*rl*t m%l*m*tat# la 6*rl*t1

     ;/%2l la 6*rl*t1 *:t*+ Htt%6*rl*t

    %rat* tat al l#( *ral=*r#UID 1L9

     /;;

      ; >** Htt%6*rl*t?Htt%6*rl*t@A

      ;/

      %2l 6*rl*t1@A

      %*r@A9

      // TODO t#-(**rat*+ #trt#r t2

     

    /;;

      ; >** Htt%6*rl*t?+#*t@Htt%6*rl*t)**t r**tHtt%6*rl*t)*%#* r*%#*A

     ;/

    %r#t*t*+ #+ +#*t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    )**tD%ath*r r+r**t.(*t)**tD%ath*r@"/6*rl*tF"A9

    r+.#r'ar+@r**tr*%#*A9

    /;;

      ; >** Htt%6*rl*t?+#P#t@Htt%6*rl*t)**t r**t

    Htt%6*rl*t)*%#* r*%#*A

     ;/%r#t*t*+ #+ +#P#t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    6*rl*tF.7aa

    %a8a(* *rl*t.#m9

    m%#rt 7aa.#.IOE:*%t#9

    m%#rt 7aa.#.PrtWrt*r9

    m%#rt 7aa:.*rl*t.)**tD%ath*r9m%#rt 7aa:.*rl*t.6*rl*tC#t*:t9

    m%#rt 7aa:.*rl*t.6*rl*tE:*%t#9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)**t9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)*%#*9

    /;;

     ; 6*rl*t m%l*m*tat# la 6*rl*tF

     ;/

    %2l la 6*rl*tF *:t*+ Htt%6*rl*t

    %rat* tat al l#( *ral=*r#UID 1L9

     

    /;;  ; >** Htt%6*rl*t?Htt%6*rl*t@A

      ;/

  • 8/17/2019 Servlet program

    25/28

      %2l 6*rl*tF@A

      %*r@A9

      // TODO t#-(**rat*+ #trt#r t2

     

    /;;

      ; >** Htt%6*rl*t?+#*t@Htt%6*rl*t)**t r**tHtt%6*rl*t)*%#* r*%#*A

     ;/

    %r#t*t*+ #+ +#*t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    6tr( %+r**t.(*tParam*t*r@"%+"A9

    6tr( %am*r**t.(*tParam*t*r@"%am*"A9

    6tr( tr**t.(*tParam*t*r@"t"A9

    6*rl*tC#t*:t t:(*t6*rl*tC#t*:t@A9

    t:.*tttr2t*@"att"tA9

    )**tD%ath*r r+r**t.(*t)**tD%ath*r@"/6*rl*t3"A9

    r*%#*.*tC#t*tT%*@"t*:t/%la"A9

    PrtWrt*r #tr*%#*.(*tWrt*r@A9

    #t.%rtl@"Pr#+t I+&"G%+A9

    #t.%rtl@"Pr#+t $am*&"G%am*A9

    #t.%rtl@"Pr#+t 5att&"GtA9

    r+.l+*@r**tr*%#*A9

    #t.l#*@A9

    /;;

      ; >** Htt%6*rl*t?+#P#t@Htt%6*rl*t)**t r**t

    Htt%6*rl*t)*%#* r*%#*A

     ;/%r#t*t*+ #+ +#P#t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    6*rl*t3.7aa

    %a8a(* *rl*t.#m9

    m%#rt 7aa.#.IOE:*%t#9

    m%#rt 7aa.#.PrtWrt*r9

    m%#rt 7aa:.*rl*t.6*rl*tC#t*:t9m%#rt 7aa:.*rl*t.6*rl*tE:*%t#9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)**t9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)*%#*9

    /;;

     ; 6*rl*t m%l*m*tat# la 6*rl*t3

     ;/

    %2l la 6*rl*t3 *:t*+ Htt%6*rl*t

    %rat* tat al l#( *ral=*r#UID 1L9

     

    /;;

      ; >** Htt%6*rl*t?Htt%6*rl*t@A  ;/

      %2l 6*rl*t3@A

  • 8/17/2019 Servlet program

    26/28

      %*r@A9

      // TODO t#-(**rat*+ #trt#r t2

     

    /;;

      ; >** Htt%6*rl*t?+#*t@Htt%6*rl*t)**t r**t

    Htt%6*rl*t)*%#* r*%#*A ;/

    %r#t*t*+ #+ +#*t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    6*rl*tC#t*:t t:(*t6*rl*tC#t*:t@A9

    6tr( t@6tr(At:.(*tttr2t*@"att"A9

    t.trm@A9

    +#2l* +D#2l*.%ar*D#2l*@tA9

    +#2l* %+;3F.1F9

    r*%#*.*tC#t*tT%*@"t*:t/%la"A9

    PrtWrt*r #tr*%#*.(*tWrt*r@A9

    #t.%rtl@"Pr*&"G%A9

    #t.l#*@A9

    /;;

      ; >** Htt%6*rl*t?+#P#t@Htt%6*rl*t)**t r**t

    Htt%6*rl*t)*%#* r*%#*A

     ;/

    %r#t*t*+ #+ +#P#t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    %%lat#F&U( *+)*+r*t@A m*th#+

    6*+r*+r*t.html

  • 8/17/2019 Servlet program

    27/28

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)*%#*9

    /;;

     ; 6*rl*t m%l*m*tat# la )*+rt6*rl*t1

     ;/

    %2l la )*+r*t6*rl*t1 *:t*+ Htt%6*rl*t

    %rat* tat al l#( *ral=*r#UID 1L9 

    /;;

      ; >** Htt%6*rl*t?Htt%6*rl*t@A

      ;/

      %2l )*+r*t6*rl*t1@A

      %*r@A9

      // TODO t#-(**rat*+ #trt#r t2

     

    /;;

      ; >** Htt%6*rl*t?+#*t@Htt%6*rl*t)**t r**t

    Htt%6*rl*t)*%#* r*%#*A

     ;/%r#t*t*+ #+ +#*t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    tr

    6tr( 1r**t.(*tParam*t*r@"t1"A9

    6tr( Fr**t.(*tParam*t*r@"tF"A9

    1.trm@A9

    F.trm@A9

    t aIt*(*r.%ar*It@1A9

    t 2It*(*r.%ar*It@FA9

    t a/29

    PrtWrt*r #tr*%#*.(*tWrt*r@A9#t.%rtl@")*lt&"GA9

    ath@E:*%t# *A

    r*%#*.*+)*+r*t@"./)*+r*t6*rl*tF"A9

    /;;

      ; >** Htt%6*rl*t?+#P#t@Htt%6*rl*t)**t r**t

    Htt%6*rl*t)*%#* r*%#*A

     ;/%r#t*t*+ #+ +#P#t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    )*+r*t6*rl*tF.7aa

    %a8a(* *rl*t.#m9

    m%#rt 7aa.#.IOE:*%t#9

    m%#rt 7aa.#.PrtWrt*r9

    m%#rt 7aa:.*rl*t.6*rl*tE:*%t#9m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t9

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)**t9

  • 8/17/2019 Servlet program

    28/28

    m%#rt 7aa:.*rl*t.htt%.Htt%6*rl*t)*%#*9

    /;;

     ; 6*rl*t m%l*m*tat# la )*+r*t6*rl*tF

     ;/

    %2l la )*+r*t6*rl*tF *:t*+ Htt%6*rl*t

    %rat* tat al l#( *ral=*r#UID 1L9 

    /;;

      ; >** Htt%6*rl*t?Htt%6*rl*t@A

      ;/

      %2l )*+r*t6*rl*tF@A

      %*r@A9

      // TODO t#-(**rat*+ #trt#r t2

     

    /;;

      ; >** Htt%6*rl*t?+#*t@Htt%6*rl*t)**t r**t

    Htt%6*rl*t)*%#* r*%#*A

     ;/%r#t*t*+ #+ +#*t@Htt%6*rl*t)**t r**t Htt%6*rl*t)*%#*

    r*%#*A thr#' 6*rl*tE:*%t# IOE:*%t#

    // TODO t#-(**rat*+ m*th#+ t2

    PrtWrt*r #tr*%#*.(*tWrt*r@A9

    #t.%rtl@"