import java.sql.*; 

 CallableStatement cstmt = null;
 Connection con = null;
 String nsrdzdah = "";
 try {
  con = DataSourceCtais.getInstance().getConnection();

      //P_GET_NSRDZDAH为存储过程名
        cstmt = con.prepareCall("{?=call P_GET_NSRDZDAH(?)}");
        cstmt.registerOutParameter(1, OracleTypes.INTEGER);  //存储过程执行时数据库返回的状态码(成功,错误之内的...)
        cstmt.registerOutParameter(2, OracleTypes.VARCHAR); //存储返回值,
  cstmt.execute();
  if (cstmt.getInt(1) != 100) {
   return nsrdzdah;
  } else {    

  nsrdzdah = cstmt.getString(2); //得到存储过程返回值
   return nsrdzdah;
  }
 } catch (Exception e) {
       logger.debug("取纳税人电子档案号出错："+e.getMessage(),e);  

 } finally {
  try {
   cstmt.close();
   con.close();
  } catch (Exception e) {
  }  
 }
 
 return nsrdzdah;

 

QQ高手技术群: 22835520

QQ: 676031411