mybatis-plus设置查询返回的类型是map

最新推荐文章于 2024-07-18 09:08:20 发布

iamlzjoco

最新推荐文章于 2024-07-18 09:08:20 发布

阅读量2.9k

点赞数 1

分类专栏： Mybatis

本文链接：https://blog.csdn.net/iamlzyoco/article/details/114060440

版权

Mybatis 专栏收录该内容

14 篇文章 0 订阅

订阅专栏

1.在mapper.java文件中

List<Map<String, Object>> getPaperList(String dwmc);

2.在mapper.xml文件中

<select id="getPaperList" resultType="java.util.Map">
    SELECT
    p.`id`,
    c.`company` companyName,
    p.`paper_num` paperNum,
    p.`paper_pwd` paperPwd,
    q.`test_name` testName
    FROM
    `t_paper` p
    JOIN `t_question_test` q
    ON p.`knowledge_test_id` = q.`id`
    JOIN company c
    ON q.`company_id` = c.`id`
    WHERE 1 = 1
    <if test="dwmc != null and dwmc !=''">
        AND c.company LIKE CONCAT('%',#{dwmc},'%')
    </if>
    order by p.id desc
</select>