mybatis 注解调用Oracle存储过程

看别人的博客试了半天注解调用一直报错,然后试了试xml里面写,成功了

就根据xml里面写的改成注解也是成功了

service层调用

    public List<QualityTestLogResp> logList(String logicId, String startTime, String endTime) {
        Map<String, Object> resps = new HashMap<>();
        resps.put("loginId", logicId);
        resps.put("startTime", startTime);
        resps.put("endTime", endTime);
        tbGxjhSjzjMapper.getLogList(resps);
        return Convert.toList(QualityTestLogResp.class, resps.get("list"));
    }

mapper

@Select("{call Pack_checkSpgl.PROC_QUERYCHECKTOTAL( " +
            " #{map.logicId, jdbcType=VARCHAR, mode=IN}, " +
            " #{map.startTime, jdbcType=VARCHAR, mode=IN}, " +
            " #{map.endTime, jdbcType=VARCHAR, mode=IN}, " +
            " #{map.list, jdbcType=CURSOR, mode=OUT, resultMap=resMap} " +
            ")}")
    @Options(statementType = StatementType.CALLABLE)
    @Results(
            id = "resMap",
            value = {
                    @Result(column = "xh", property = "xh"),
                    @Result(column = "logicid", property = "logicid"),
                    @Result(column = "zjgz", property = "zjgz"),
                    @Result(column = "zjjls", property = "zjjls"),
                    @Result(column = "hgjls", property = "hgjls"),
                    @Result(column = "bhgjls", property = "bhgjls"),
            }
    )
    List<QualityTestLogResp> getLogList(@Param("map") Map<String, Object> map);

这里需要注意的是,没有用到返回值,实际上的结果在map里面,像我上面第四个参数那样定义的,键就是list。return的List里面是空的,不会有结果集,但是也得用这个返回值,写void或者object都不行

上一篇:实验五


下一篇:实验五