JavaWorkshop--(3)JSP

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

  上一期PreparedStatement的答案如下

  importjava.sql.*;

  classJPC_JDBCSample2{

  publicstaticvoidmain(Stringargs[]){

  Connectioncon=null;

  PreparedStatementpstmt=null;

  Stringsql=null;

  ResultSetrs=null;

  Stringdiv=null;//Division

  shorttotal=0;//Totalamountofmanagers

  //SetaStringinputincommandlineasinthedivisionvariable

  if(args.length>0){

  div=args[0];

  }else{

  System.out.println("Pleaseinputadivision");

  return;

  }

  try{

  //Loadthedriver

  Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");

  //SetJDBCURLinavariable

  //TheURLisjdbc:db2:dbname

  Stringurl="jdbc:db2:sample";

  //ConnecttotheDBspecifiedbytheJDBCURL

  //withtheuserID(db2admin)andthepassword(password)

  con=DriverManager.getConnection(url,"db2admin","password");

  //+++(1)SpecifyaSQLstatement

  sql="SELECTDEPTNAME,MANAGERFROMorgWHEREDIVISION=?";

  //+++(2)CreateaPreparedStatementobject

  pstmt=con.prepareStatement(sql);

  //+++(3)SetaparameterinthePreparedStatementobject

  pstmt.setString(1,div);

  //+++(4)Executeaquery

  rs=pstmt.executeQuery();

  //+++(5)(6)RetrievetheresultfromtheResultSet

  //+++objectanddisplayit

  System.out.println("*****"+div+"*****");

  while(rs.next()){

  Stringdname=rs.getString(1);

  shortmanager=rs.getShort(2);

  System.out.print(dname+":");

  System.out.println(manager);

  total+=manager;

  }

  System.out.println("Total:"+total);

  }catch(ClassNotFoundExceptione){

  e.printStackTrace();

  }catch(SQLExceptione){

  e.printStackTrace();

  }finally{

  try{

  //Releaseresources

  rs.close();

  pstmt.close();

  con.close();

  }catch(SQLExceptione){

  e.printStackTrace();

  }

  }

  }

  }

  这里给出了一个javabean的代码，然后请试着给出JSP和javabean交互的代码

  packagejpc;

  /*

  *AddBean.java

  *

  */

  publicclassAddBean{

  privateintdata1;

  privateintdata2;

  /**

  *

  *Constructor

  */

  publicAddBean(){

  }

  /**

  *ReturnthevalueoftheData1asaString.

  */

  publicStringgetData1(){

  returnString.valueOf(data1);

  }

  /**

  *SetData1

  */

  publicvoidsetData1(Stringstr){

  try{

  this.data1=Integer.parseInt(str);

  }

  catch(NumberFormatExceptione){

  this.data1=0;

  }

  }

  /**

  *ReturnthevalueoftheData2asaString.

  */

  publicStringgetData2(){

  returnString.valueOf(data2);

  }

  /**

  *SetData2

  */

  publicvoidsetData2(Stringstr){

  try{

  this.data2=Integer.parseInt(str);

  }

  catch(NumberFormatExceptione){

  this.data2=0;

  }

  }

  /**

  *ReturntheresultoftheadditionasaString.

  */

  publicStringgetResult(){

  returnString.valueOf(data1+data2);

  }

  }

  以下是调用javabean的JSP代码框架。

 

 

 

 

 

 

ExerciseJSP

 

---

 

  [1]

  JSP/Add. JSP"method=POST>

  DATA1

  DATA2

 

 

 

  [2]

 

  [3]

 

 

  [4]

 

  [5]

 

 

 

<script type="text/javascript"> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>

<script type="text/javascript"> </script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>