mybatis 中调用存储过程

1.首先需要定义集合，集合中定义存储过程所需的输入参数与输出参数

Map<String, String> map = new HashMap<String, String>();
map.put("orderNo", "0");

2.编写Mapper.xml文件

<!-- 调用存储过程生成订单流水 -->
	<select id="getOrderNo" parameterType="map" statementType="CALLABLE">
		CALL GetOrderNo (#{orderNo,mode=OUT,jdbcType=VARCHAR})
	</select>

3.编写存储过程

BEGIN
DECLARE updatenum VARCHAR(20);
SELECT  SerialNum FROM  tab_serial WHERE  ID=1 INTO updatenum;
SEt  orderNo  =LPAD(updatenum,6,0) ;
update tab_serial set SerialNum = (SerialNum+ 1)%1000000 WHERE ID=1  ;
END