JdbcTemplate jt = new JdbcTemplate(dataSource);
//System.out.println("修改角色");
String sql = "{call Proc_BatchUpdateRd_Role(?,?,?,?,?,?,?)}";
//使用 Object execute(String callString, CallableStatementCallback action)接口
Object obj = jt.execute(sql,new CallableStatementCallback(){
public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
cs.setString(1,getgroupid);
cs.setString(2, searchRdTypeCode);
cs.setString(3, searchgroup_id);
cs.setString(4,searchrdRoleCode);
cs.setString(5, searchcreate_by);
cs.setString(6, searchcreate_time);
cs.registerOutParameter(7, Types.INTEGER);
cs.execute();
return new Integer(cs.getInt(7));
}
});
//System.out.println("修改角色");
String sql = "{call Proc_BatchUpdateRd_Role(?,?,?,?,?,?,?)}";
//使用 Object execute(String callString, CallableStatementCallback action)接口
Object obj = jt.execute(sql,new CallableStatementCallback(){
public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
cs.setString(1,getgroupid);
cs.setString(2, searchRdTypeCode);
cs.setString(3, searchgroup_id);
cs.setString(4,searchrdRoleCode);
cs.setString(5, searchcreate_by);
cs.setString(6, searchcreate_time);
cs.registerOutParameter(7, Types.INTEGER);
cs.execute();
return new Integer(cs.getInt(7));
}
});