mybatis树状多层级链表查询

最新推荐文章于 2024-02-08 15:23:49 发布

尝＆试

最新推荐文章于 2024-02-08 15:23:49 发布

阅读量223

点赞数

分类专栏： JavaWeb 文章标签： mybatis java 开发语言

人生的道路虽然漫长，但紧要处常常只有几步

本文链接：https://blog.csdn.net/qq_30512275/article/details/128375942

版权

JavaWeb 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

代码

public interface AlarmConfMapper extends BaseMapper<AlarmConf> {

//    @Select("select a.* from (select * from cms_article_category where pid = #{categoryId} or id=#{categoryId}) c join cms_article_category_mapping ac on c.id=ac.category_id join cms_article a on ac.article_id=a.id")
//    Page<AlarmConf> getList(Page<AlarmConf> page, @Param("categoryId") String categoryId);

    List<AlarmConf> findList();

    List<AlarmConf> findList1();



<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="cn.exrick.xboot.modules.stm.dao.AlarmConfMapper">

    <resultMap id="pd" type="cn.exrick.xboot.modules.stm.entity.AlarmConf">
        <id property="alarmId" column="alarm_id"/>
        <result property="alarmEvents" column="alarm_events"/>
        <result property="alarmLevel" column="alarm_level"/>
        <result property="alarmContent" column="alarm_content"/>
        <result property="alarmStatus" column="alarm_status"/>
        <!--collection:一对多
            assocication:一对一
            -->
        <collection property="midAlarmGroupList" ofType="cn.exrick.xboot.modules.stm.entity.mid.MidAlarmGroup">
            <result property="id" column="id"/>
            <result property="alarmId" column="alarm_id"/>
            <result property="groupId" column="group_id"/>
        </collection>

        <collection property="intoUserGroupList" ofType="cn.exrick.xboot.modules.stm.entity.IntoUserGroup">
            <result property="id" column="id"/>
            <result property="name" column="name"/>
        </collection>
    </resultMap>

    <resultMap id="pd1" type="cn.exrick.xboot.modules.stm.entity.AlarmConf">
        <id property="alarmId" column="alarm_id"/>
        <result property="alarmEvents" column="alarm_events"/>
        <result property="alarmLevel" column="alarm_level"/>
        <result property="alarmContent" column="alarm_content"/>
        <result property="alarmStatus" column="alarm_status"/>
        <!--collection:一对多
            assocication:一对一
            -->
        <collection property="intoUserGroupList" ofType="cn.exrick.xboot.modules.stm.entity.IntoUserGroup">
            <result property="id" column="id"/>
            <result property="name" column="name"/>
        </collection>
    </resultMap>

    <select id="findList" resultMap="pd">
		select *
		from
			into_alarm_conf
			left join mid_alarm_group mag on into_alarm_conf.alarm_id = mag.alarm_id
	</select>

    <select id="findList1" resultMap="pd">
		select *
		from
			into_alarm_conf
			left join mid_alarm_group mag on into_alarm_conf.alarm_id = mag.alarm_id
			left join into_user_group iug on mag.group_id=iug.id
	</select>
</mapper>