1.存储过程
CREATE OR REPLACE Procedure aaa(num In Varchar,Type In Varchar,Name Out Varchar)
As
Begin
If Type='1' then
Select channels Into Name From bdp_bi.xx_test Where nums=num;
Else if Type='2' Then
Select types Into Name From bdp_bi.xx_test Where nums=num;
Else
Name:='错误';
End If;
End If;
End;
2.MyBatis的xml文件
<parameterMap type="java.util.Map" id="paraMap">
<parameter property="num" jdbcType="VARCHAR" mode="IN" javaType="String"/>
<parameter property="type" jdbcType="VARCHAR" mode="IN" javaType="String"/>
<parameter property="name" jdbcType="VARCHAR" mode