1.调用JDBCTemplate执行存储过程
public List<Map<String, Object>> executeProce(final Object... params) {
return (List<Map<String, Object>>) jt.execute(new CallableStatementCreator() {
public CallableStatement createCallableStatement(Connection con) throws SQLException {
CallableStatement cs = null;
cs = con.prepareCall("call _procedure(?,?)");
cs.registerOutParameter(2, OracleTypes.CURSOR);
cs.setString(1, (String) params[0]);
return cs;
}
}, new CallableStatementCallback() {
public Object doInCallableStatement(CallableStatement cs) throws SQLException, DataAccessException {
List<Map<String, Object>> datas = new ArrayList<Map<String, Object>>();
Map<String, Object> mapDatas = null;
cs.execute();
ResultSet rs = (ResultSet) cs