ibatis3 调用存储过程

参数bean

package com.cwfan.dao.bean;

import java.util.Map;

public class SimpleQuery {
	private int id;
	private String cols;
	private String table;
	private String conditions;
	private String sortFields;
	private Map<String,Object> args;
	
	public String getCols() {
		return cols;
	}
	public void setCols(String cols) {
		this.cols = cols;
	}
	public String getTable() {
		return table;
	}
	public void setTable(String table) {
		this.table = table;
	}
	public int getId() {
		return id;
	}
	public void setId(int id) {
		this.id = id;
	}
	public String getConditions() {
		return conditions;
	}
	public void setConditions(String conditions) {
		this.conditions = conditions;
	}
	public Map<String, Object> getArgs() {
		return args;
	}
	public void setArgs(Map<String, Object> args) {
		this.args = args;
	}
	public String getSortFields() {
		return sortFields;
	}
	public void setSortFields(String sortFields) {
		this.sortFields = sortFields;
	}
}

 

mapp代码

  <select id="simpleProdecure"  statementType="CALLABLE" parameterType="simpleQuery" resultType="hashMap">
    {call test(#{args.id},#{args.name})}
  </select>

 调用方式

		SimpleQuery sq = new SimpleQuery();
		Map<String,Object> args = new HashMap<String, Object>();
		args.put("id", 1);
		args.put("name", "test");
		sq.setArgs(args);
		List list = getTemplate().selectList("simpleProdecure",sq);