上一期PreparedStatement的答案如下
importjava.sql.*;
classJPC_JDBCSample2{
publicstaticvoidmain(Stringargs[]){
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
//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()){
shortmanager=rs.getShort(2);
total+=manager;
}
System.out.println("Total:"+total);
}catch(ClassNotFoundExceptione){
e.printStackTrace();
e.printStackTrace();
}finally{
try{
//Releaseresources
rs.close();
pstmt.close();
con.close();
e.printStackTrace();
}
}
}
}
这里给出了一个javabean的代码,然后请试着给出JSP和javabean交互的代码
packagejpc;
/*
*AddBean.java
*
*/
publicclassAddBean{
privateintdata1;
privateintdata2;
/**
*
*Constructor
*/
publicAddBean(){
}
/**
*ReturnthevalueoftheData1asaString.
*/
}
/**
*SetData1
*/
publicvoidsetData1(Stringstr){
try{
this.data1=Integer.parseInt(str);
}
catch(NumberFormatExceptione){
this.data1=0;
}
}
/**
*ReturnthevalueoftheData2asaString.
*/
}
/**
*SetData2
*/
publicvoidsetData2(Stringstr){
try{
this.data2=Integer.parseInt(str);
}
catch(NumberFormatExceptione){
this.data2=0;
}
}
/**
*ReturntheresultoftheadditionasaString.
*/
returnString.valueOf(data1+data2);
}
}
以下是调用javabean的JSP代码框架。
ExerciseJSP
[1]
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>