spring jdbc 操作存储过程或者函数测试

//  SimpleJdbcCall   procReadActor= new SimpleJdbcCall(super.getDataSource());

//  procReadActor.setProcedureName("addinfo");

//  SqlParameterSource in = new MapSqlParameterSource().addValue("testname", "aa1111"); 

//  Map out =  procReadActor.execute(in); 

//  System.out.println(out.get("back") );

//   SimpleJdbcCall   procReadActor= new SimpleJdbcCall(super.getDataSource());

//   procReadActor.withProcedureName("getallinfo");

//   procReadActor.returningResultSet("aa", new RowMapper<Testde>() { 

// @Override

// public Testde mapRow(ResultSet rs, int arg1) throws SQLException {

// Testde t =new Testde();

//     t.setTestid(rs.getInt("testid"));

//     t.setTestname(  rs.getString("testname")); 

// return t;

// }

//   

// });

//  Map m=  procReadActor.execute(new HashMap<String, Object>(0));

//  List<Testde> list = ( List<Testde> )m.get("aa");

//  for( Testde t: list ){

//  System.out.println(t.getTestid());

// 

//  System.out.println( t.getTestname() );

// 

//  }


函数见
 http://static.springsource.org/spring/docs/3.1.x/spring-framework-reference/html/