Mybatis使用注解的方式调用存储过程的示例

Mapper.java

import org.apache.ibatis.annotations.Options;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.mapping.StatementType;

在 mapper接口里面直接写sql 语句，不需要使用 xml 文件，PurchaseOrderMapping接口里的方法：

	/**
	 * 调用存储过程，获取采购单号
	 * @param params={storeCode=门店编号,tsCode生成单号的类型}
	 * @return params={purchaseOrderNumber=采购单号}
	 */
	@Select({ "call p_getserialno(#{storeCode,mode=IN,jdbcType=VARCHAR},"
			+ "#{tsCode,mode=IN,jdbcType=VARCHAR},"
			+ "#{purchaseOrderNumber,mode=OUT,jdbcType=VARCHAR})" })
	@Options(statementType=StatementType.CALLABLE)
	void getPurchaseOrderNumber(Map<String,String> params);

Service.java

	@Autowired
        protected PurchaseOrderMapping purchaseOrderMapping;

        /**
	 * 获取采购单号（存储过程生成采购单号）
	 * @param storeCode 门店编号
	 * @return 新生成的采购单号
	 * @throws Exception 
	 */
	public String getPurchaseOrderNumber(String storeCode) throws Exception {
		Map<String,String> params=new HashMap<String, String>(3);
		params.put("storeCode", storeCode);
		params.put("tsCode", "CGD");//tsCode=CGD-采购单，LLD-领料单
		purchaseOrderMapping.getPurchaseOrderNumber(params);
		String purchaseOrderNumber=params.get("purchaseOrderNumber");
		return purchaseOrderNumber;
	}