一.建立存储过程(带输入,输出参数的存储过程( 根据员工编号查询 工资 ))
create or replace procedure proinout
(--参数
v_eno in emp.empno%type,--入参7369
v_sal out emp.sal%type--出参
)
as
begin
select sal into v_sal from emp where emp.empno=v_eno;
exception--异常处理
when no_data_found then
dbms_output.put_line('员工不存在');
end;
二.Mapper
<pre name="code" class="html"><!-- 调用存储过程 -->
<select id="selectSalByEno" statementType="CALLABLE">
<![CDATA[{call proinout(#{empno,mode=IN,jdbcType=NUMERIC},#{salary,mode=OUT,jdbcType=NUMERIC})}]]>
</select>
三.测试
import java.util.HashMap;
import java.util.List;
import java.util.Map;
import org.apache.ibatis.session.SqlSession;
import com.web.dao.EmpDao;
import com.web.entity.Dept;
import com.web.entity.Emp;
import com.web.util.SqlSessionFactoryUtil;
public class Test {
public static void main(String[] args) {
new Test().selectSal();
}
@org.junit.Test
public void selectSal() {
SqlSession session = SqlSessionFactoryUtil.getSqlSession();
// float returnValue=returnValue;
Map<String, Integer> map=new HashMap<String, Integer>();
map.put("empno", 7369);
Float returnSal=(Float) session.selectOne("selectSalByEno", map);
System.out.println("入参:"+map.get("empno"));
System.out.println("出参:"+map.get("salary"));
System.out.println("返回值"+returnSal);//存储过程无返回值,函数有返回值
}
}
结果: