提问：如何在servlet中调用ORACLE的PL/SQL的存储过程

[oak_leaf]

如何在servlet中调用ORACLE的PL/SQL的存储过程？愿各位大虾教我。

[salute]

和在BEAN中调用一样.
请查看java.sql.CallableStatement

[l_r_h]

import java.math.BigDecimal;
import java.sql.*;

public class JdbcTest {

public static void main(String[] args) {
Connection conn=null;
Statement stmt=null;
ResultSet rs=null;
CallableStatement call=null;

try {
String url="jdbc:oracle:thin:@oracle:1521:oracl";
String driver="oracle.jdbc.driver.OracleDriver";
String user="scott";
String password="tiger";
Class.forName(driver) ;
conn=DriverManager.getConnection(url,user,password) ;
call=conn.prepareCall("{call AddAccount(?,?)}") ;
call.setInt(1,8) ;
call.setInt(2,700) ;
int i=call.executeUpdate() ;
System.out.println("Call Procedure,update "+i);
if(call!=null)
call.close();
call=conn.prepareCall("{ call GetBalance(?,?)}") ;
call.setInt(1,3) ;
call.registerOutParameter(2,Types.INTEGER) ;
call.execute() ;
System.out.println(call.getInt(2) );

if(call!=null)
call.close();
stmt=conn.createStatement() ;
rs=stmt.executeQuery("SELECT * FROM Account") ;
System.out.println(" AccountNo Balance ");
while(rs.next() ) {
System.out.println(" "+rs.getInt("AccountNo")+" "+rs.getInt("Balance") );
}

if(rs!=null)
rs.close();
if(stmt!=null)
stmt.close();
}
catch (Exception ex) {
ex.printStackTrace() ;
}
finally {
try {
if(conn!=null)
conn.close();
}
catch (SQLException e) {
e.printStackTrace() ;
}
}
}
}