首先存储过程,内容是根据名字查工作和部门
create or replace procedure manyparm(tname in varchar2,
tjob out varchar2,
tdept out varchar2)
is
begin
select t.job,t.dept
into tjob,tdept
from test_procedure t
where t.name = tname;
end manyparm;
XML的编写
<select id="manyparm" statementType="CALLABLE">
{
call manyparm(
#{tname,mode=IN,jdbcType=VARCHAR},
#{tjob,mode=OUT,jdbcType=VARCHAR},
#{tdept,mode=OUT,jdbcType=VARCHAR}
)
}
</select>
此处重点在于 statementType为"CALLBLE"
mapperDao接口的编写 大坑在此
public void manyparm(Emp emp);
他他喵的据说是没有返回值!!!!!!!!