大战熟女丰满人妻av-荡女精品导航-岛国aaaa级午夜福利片-岛国av动作片在线观看-岛国av无码免费无禁网站-岛国大片激情做爰视频

專注Java教育14年 全國咨詢/投訴熱線:400-8080-105
動力節點LOGO圖
始于2009,口口相傳的Java黃埔軍校
首頁 hot資訊 MyBatis子查詢的方法

MyBatis子查詢的方法

更新時間:2021-12-20 09:52:52 來源:動力節點 瀏覽1552次

首先,父查詢basechildResultmap:

<? 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” >   
<映射器命名空間="com.dayhr.web.module.hr.td.elearn.mapper.TrainerMapper"  >    
    <!--表字段--> 
      < resultMap id ="BaseResultMap" type ="com.dayhr.web.module.hr.td.elearn.model.Trainer"  > 
        < id column ="id" property ="id" jdbcType ="CHAR"  /> 
        < result column ="name" property ="name" jdbcType ="VARCHAR"  /> 
        < result column ="title" property ="title" jdbcType ="VARCHAR"  /> 
        <結果列="推薦"屬性="recommend" jdbcType ="INTEGER"  /> 
        < result column ="trainer_type_id" property ="trainerTypeId" jdbcType ="CHAR"  /> 
        < result column ="phone" property ="phone" jdbcType ="VARCHAR"  /> 
        <結果列="email"屬性="email" jdbcType ="VARCHAR"  /> 
        <結果列="地址"屬性="地址"jdbcType ="VARCHAR"  /> 
        <結果column ="pro_field" property ="proField" jdbcType ="VARCHAR"  /> 
        < result column ="intro" property ="intro" jdbcType ="VARCHAR"  /> 
        < result column ="head_img" property ="headImg" jdbcType = "VARCHAR"  /> 
        < result column ="labels" property ="labels" jdbcType ="VARCHAR"  /> 
        < result column ="corp_id"屬性="corpId" jdbcType ="整數" /> 
        < result column ="creater_id" property ="createrId" jdbcType ="INTEGER"  /> 
        < result column ="create_time" property ="createTime" jdbcType ="TIMESTAMP"  /> 
        < result column ="modifier_id" property =" modifierId" jdbcType ="INTEGER"  /> 
        < result column ="modify_time" property ="modifyTime" jdbcType ="TIMESTAMP" /> 
      </ 結果映射>      
      <!--  返回頁面bean --> 
      < resultMap id ="BaseResultRespMap" type ="com.dayhr.web.module.hr.td.elearn.response.TrainerResp"  > 
        < id column ="id" property =" id" jdbcType ="CHAR"  /> 
        < result column ="name" property ="name" jdbcType ="VARCHAR"  /> 
        < result column ="title" property ="title" jdbcType ="VARCHAR"  />
        <結果欄=“推薦” property="recommend" jdbcType="INTEGER" />
        <result column="trainer_type_id" property="trainerTypeId" jdbcType="CHAR" />
        <result column="phone" property="phone" jdbcType="VARCHAR" />
        <result column="email" property="email" jdbcType="VARCHAR" />
        <result column="address" property="address" jdbcType="VARCHAR" />
        <result column="pro_field" property="proField" jdbcType="VARCHAR" />
        <result column="intro" property="intro" jdbcType="VARCHAR" />
        <result column="head_img" property="headImg" jdbcType="VARCHAR" />
        <result column="labels" property="labels" jdbcType="VARCHAR" />
        <result column="corp_id" property="corpId" jdbcType="INTEGER" />
        <result column="creater_id" property="createrId" jdbcType="INTEGER" />
        <result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
        <result column="modifier_id" property="modifierId" jdbcType="INTEGER" />
        <result column="modify_time" property="modifyTime" jdbcType="TIMESTAMP" />        
        <result column="trainerTypeName" property="trainerTypeName" />
        <result column="trainerLabels" property="trainerLabels" />
      </resultMap>      
      <!--  Subquerice -->
    <resultMap id="BaseChildResultMap" type="com.dayhr.web.module.hr.td.elearn.response.TrainerResp" extends="BaseResultRespMap">
        <collection property="trainerLabels" 
            ofType="com.dayhr.web.module.hr.td.elearn.response.TrainerLabelResp" 
            select="com.dayhr.web.module.hr.td.elearn.mapper.TrainerLabelMapper.selecLabels" column="labels">
        </collection>
    </resultMap>    
      <!--  Foundation field in the table -->
    <sql id="Base_Column_List">
        t.id, t.name, t.title, t.recommend, t.trainer_type_id, t1.name AS trainerTypeName, 
        t.phone, t.email, t.address, t.pro_field, t.intro, t.head_img, t.labels, t.corp_id,
        t.creater_id, t.create_time, t.modifier_id, t.modify_time
    </sql>    
    <!--  Query conditions    -->
    <sql id="select_Where_Clause">    
       <where>    
            1=1
            <if test="id != null and id != ''">
                AND t.id = #{id }    
            </if>
            <if test="name != null and name != ''">
                AND t.name like CONCAT('%',#{name },'%' )    
            </if>
            <if test="corpId != null and corpId != ''">
                AND corp_id = #{corpId }    
            </if>
            <if test="trainerTypeId != null and trainerTypeId != ''">
                AND t.trainer_type_id = #{trainerTypeId }    
            </if>        
            <if test="orderBy != null and orderBy != ''">
                ORDER BY ${orderBy } ${sortType }
            </if>    
       </where>
    </sql>      
      <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
        delete from t_hr_td_trainer
        where id = #{id }
      </delete>      
      <insert id="insert" parameterType="com.dayhr.web.module.hr.td.elearn.model.Trainer" useGeneratedKeys="true" keyProperty="id">
        insert into t_hr_td_trainer (id, name, title, 
          recommend, trainer_type_id, phone, 
          email, address, pro_field, 
          intro, head_img, labels, 
          corp_id, creater_id, create_time, 
          modifier_id, modify_time)
        values (#{id,jdbcType=CHAR}, #{name,jdbcType=VARCHAR}, #{title,jdbcType=VARCHAR}, 
          #{recommend,jdbcType=INTEGER}, #{trainerTypeId,jdbcType=CHAR}, #{phone,jdbcType=VARCHAR}, 
          #{email,jdbcType=VARCHAR}, #{address,jdbcType=VARCHAR}, #{proField,jdbcType=VARCHAR}, 
          #{intro,jdbcType=VARCHAR}, #{headImg,jdbcType=VARCHAR}, #{labels,jdbcType=VARCHAR}, 
          #{corpId,jdbcType=INTEGER}, #{createrId,jdbcType=INTEGER}, #{createTime,jdbcType=TIMESTAMP}, 
          #{modifierId,jdbcType=INTEGER}, #{modifyTime,jdbcType=TIMESTAMP})
      </insert>      
      <update id="updateByPrimaryKey" parameterType="com.dayhr.web.module.hr.td.elearn.model.Trainer" >
          UPDATE t_hr_td_trainer
        <set>
            <if test="name != null and name != ''">
                name = #{name }, 
            </if>
            <if test="title != null and title != ''">
                title = #{title },
            </if>    
            <if test="recommend != null and recommend != ''">
                recommend = #{recommend },
            </if>
            <if test="trainerTypeId != null and trainerTypeId != ''">
                trainer_type_id = #{trainerTypeId },
            </if>
            <if test="phone != null and phone != ''">
                phone = #{phone },
            </if>
            <if test="email != null and email != ''">
                email = #{email },
            </if>
            <if test="address != null and address != ''">
                address = #{address },
            </if>
            <if test="proField != null and proField != ''">
                pro_field = #{proField },
            </if>
            <if test="intro != null and intro != ''">
                intro = #{intro },
            </if>
            <if test="headImg != null and headImg != ''">
                head_img = #{headImg },
            </if>
            <if test="labels != null and labels != ''">
                labels = #{labels },
            </if>
            <if test="corpId != null and corpId != ''">
                corp_id = #{corpId },
            </if>
            <if test="createrId != null and createrId != ''">
                creater_id = #{createrId },
            </if>    
            <if test="createTime != null and createTime != ''">
                create_time = #{createTime },
            </if>    
            <if test="modifierId != null and modifierId != ''">
                modifier_id = #{modifierId },
            </if>
            <if test="modifyTime != null and modifyTime != ''">
                modify_time = #{modifyTime }
            </if>
        </set>
        WHERE id = #{id }
      </update>      
      <select id="selectByPrimaryKey" resultMap="BaseChildResultMap" parameterType="java.lang.String" >
        SELECT
        <include refid="Base_Column_List" />
        FROM t_hr_td_trainer t
        LEFT JOIN t_hr_td_trainertype t1 ON t.trainer_type_id = t1.id
        WHERE t.id = #{id }
      </select>      
      <select id="selectAll" resultMap="BaseResultMap" >
        select 
            id, name, title, recommend, trainer_type_id, phone, email, address, pro_field, 
            intro, head_img, labels, corp_id, creater_id, create_time, modifier_id, modify_time
        from t_hr_td_trainer
      </select>      
    <select id="selectListByCondition" parameterType="com.dayhr.web.module.hr.td.elearn.param.TrainerQueryParam" resultMap="BaseChildResultMap">
        SELECT
        <include refid="Base_Column_List" />
        FROM t_hr_td_trainer t
        LEFT JOIN t_hr_td_trainertype t1 ON t.trainer_type_id = t1.id          
        <include refid="select_Where_Clause" />
    </select>        
</mapper>

Subproof id = "SELECLABELS":注意這里的Value對應父查詢結果中的Labels:

<? 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” >    
<映射器命名空間="com.dayhr.web.module.hr.td.elearn.mapper.TrainerLabelMapper"  >    
    <!--  對應表字段--> 
      < resultMap id ="BaseResultMap" type ="com.dayhr.web.module.hr.td.elearn.model.TrainerLabel"  > 
        < id column ="id" property ="id "  /> 
        < result column ="trainer_label" property ="trainerLabel" jdbcType ="VARCHAR"  /> 
        < result column ="built_in" property ="builtIn" jdbcType ="INTEGER"  /> 
        <結果列="corp_id"屬性="corpId" jdbcType ="INTEGER"  /> 
        < result column ="creater_id" property ="createrId" jdbcType ="INTEGER"  /> 
        < result column ="creater_time" property ="createrTime" jdbcType ="TIMESTAMP"  /> 
        <結果列="modifier_id"屬性="modifierId" jdbcType ="INTEGER"  /> 
        <結果列="modify_time"屬性="modifyTime" jdbcType ="TIMESTAMP"  /> 
      </結果地圖>      
      <!--  返回字段--> 
      < resultMap id ="BaseResultRespMap" type ="com.dayhr.web.module.hr.td.elearn.response.TrainerLabelResp"  > 
        < id column ="id" property =" id"  /> 
        < result column ="trainer_label" property ="trainerLabel" jdbcType ="VARCHAR"  /> 
        < result column ="built_in" property ="builtIn" jdbcType ="INTEGER"  /> 
        <結果列="corp_id"屬性="corpId" jdbcType ="INTEGER"  /> 
        < result column ="creater_id" property ="createrId" jdbcType ="INTEGER"  /> 
        < result column ="creater_time" property ="createrTime" jdbcType ="TIMESTAMP"  /> 
        <結果列="modifier_id"屬性="modifierId" jdbcType ="INTEGER"  /> 
        <結果列="modify_time"屬性="modifyTime" jdbcType ="TIMESTAMP"  /> 
        <結果列="labels"屬性="labels"  /> 
      </ resultMap >      
      <!--  表中的基礎字段--> 
    < sql id ="Base_Column_List" >
        id、trainer_label、built_in、corp_id、creater_id、creater_time、modifier_id、modify_time
    </ sql >    
    <!--  查詢條件    --> 
    < sql id ="select_Where_Clause" >     
       < where >    
            1=1
            < if test ="id != null and id != ''" >
                AND id = #{id }    
            </if>
            <if test="corpId != null and corpId != ''">
                AND corp_id = #{corpId }    
            </if>
            <if test="trainerLabel != null and trainerLabel != ''">
                AND trainer_label like CONCAT('%',#{trainerLabel },'%' )    
            </if>    
            <if test="orderBy != null and orderBy != ''">
                ORDER BY ${orderBy } ${sortType }
            </if>    
       </where>
    </sql>      
      <delete id="deleteByPrimaryKey" parameterType="java.lang.String" >
        delete from t_hr_td_trainerlabel
        where id = #{id,jdbcType=CHAR}
      </delete>      
      <insert id="insert" parameterType="com.dayhr.web.module.hr.td.elearn.model.TrainerLabel" useGeneratedKeys="true" keyProperty="id">
        insert into t_hr_td_trainerlabel (id, trainer_label, built_in, corp_id, 
          creater_id, creater_time, modifier_id, 
          modify_time)
        values (#{id },#{trainerLabel,jdbcType=VARCHAR}, #{builtIn,jdbcType=INTEGER}, #{corpId,jdbcType=INTEGER}, 
          #{createrId,jdbcType=INTEGER}, #{createrTime,jdbcType=TIMESTAMP}, #{modifierId,jdbcType=INTEGER}, 
          #{modifyTime,jdbcType=TIMESTAMP})
      </insert>      
      <update id="updateByPrimaryKey" parameterType="com.dayhr.web.module.hr.td.elearn.model.TrainerLabel" >
        UPDATE t_hr_td_trainerlabel
        <set>
            <if test="trainerLabel != null and trainerLabel != ''">
                trainer_label = #{trainerLabel }, 
            </if>
            <if test="builtIn != null and builtIn != ''">
                built_in = #{builtIn },
            </if>
            <if test="corpId != null and corpId != ''">
                corp_id = #{corpId },
            </if>
            <if test="createrId != null and createrId != ''">
                creater_id = #{createrId },
            </if>    
            <if test="createTime != null and createTime != ''">
                create_time = #{createTime },
            </if>    
            <if test="modifierId != null and modifierId != ''">
                modifier_id = #{modifierId },
            </if>
            <if test="modifyTime != null and modifyTime != ''">
                modify_time = #{modifyTime }
            </if>
        </set>
        WHERE id = #{id }
      </update>      
      <select id="selectByPrimaryKey" resultMap="BaseResultMap" parameterType="java.lang.String" >
        select 
            id, trainer_label, built_in, corp_id, creater_id, creater_time, modifier_id, modify_time
        from t_hr_td_trainerlabel
        where id = #{id }
      </select>      
      <select id="selectAll" resultMap="BaseResultMap" >
        select 
            id, trainer_label, built_in, corp_id, creater_id, creater_time, modifier_id, modify_time
        from t_hr_td_trainerlabel
      </select>      
      <!--  Verify that the label exists -->
    <select id="checkLabel" parameterType="com.dayhr.web.module.hr.td.elearn.param.TrainerLabelQueryParam" resultType="Integer">
        SELECT COUNT(*)
        FROM t_hr_td_trainerlabel 
        <include refid="select_Where_Clause" />
    </select>    
    <!--  Press the condition query tag -->
    <select id="selectLabelList" resultMap="BaseResultRespMap" parameterType="com.dayhr.web.module.hr.td.elearn.param.TrainerLabelQueryParam" >
        SELECT 
        <include refid="Base_Column_List" />
        FROM t_hr_td_trainerlabel 
        <include refid="select_Where_Clause" />
      </select>      
      <!--  Subproof in () will report an error, add '0' processing -->
      <select id="selecLabels" resultMap="BaseResultRespMap" >
        select 
            id, trainer_label, built_in, corp_id, creater_id, creater_time, modifier_id, modify_time
        from t_hr_td_trainerlabel
        where id in ('0'??    <if test="value != null and value.length !=0">??      ,${value }??      </if>??      )
      </select>      
</mapper>

 

提交申請后,顧問老師會電話與您溝通安排學習

免費課程推薦 >>
技術文檔推薦 >>
主站蜘蛛池模板: 亚洲四虎 | 国产成人亚洲精品无广告 | 天天爽天天 | 在线欧美一区 | 在线播放五十路乱中文 | 亚洲品质自拍视频 | 国产精品看片 | 欧美不卡在线观看 | 欧美毛片xxxx | 深夜在线小视频 | 国产不卡视频 | 好吊妞在线成人免费 | 9久re热视频这里只有精品 | 亚洲 欧美 日韩 在线 | 高清一区二区三区 | 四虎影视国产精品亚洲精品hd | 一本伊在人香蕉线观新在线 | 日本手机在线视频 | 久久澳门 | 男人的天堂在线精品视频 | 91在线精品免费观看 | 四虎影院观看视频 | 久久我们这里只有精品国产4 | 亚洲精品无人区一区二区三区 | 亚洲国产精品乱码一区二区三区 | 国产欧美在线观看不卡 | 欧美日韩中文国产一区 | 色婷婷影视 | 91青青青 | 日本a一级毛片免费观看 | 成人免费看毛片 | 亚洲欧美日韩国产精品网 | 国产精品视频一区国模私拍 | 欧美成人性色生活片天天看 | 一级特黄高清完整大片 | 欧美日本一级在线播放 | 国产成人免费高清视频 | 欧美亚洲综合另类型色妞 | 久热这里只有精品在线 | 亚州精品一区二区三区 | 久久99热精品免费观看k影院 |