Mybatis常用语句

修改语句

<update id="saveArchive" parameterType="map">

     UPDATE xxl_job_info SET archive_flag = 1,archive_time = #{time} WHERE id in

     <foreach collection="list" index="index" item="item" open="(" separator="," close=")">

         #{item}

     </foreach>

</update>

查询语句

<select id="getXxlJobInfoById" parameterType="java.util.List" resultType="com.exceeddata.vstudio.api.model.XxlJobInfo">

循环

<foreach collection="list" index="index" item="item" open="(" separator="," close=")">

     #{item}

</foreach>

sql公用

<sql id="exd_page_list_common">

</sql>

<include refid="exd_page_list_common" />

多个条件判断

<choose>

      <!-- 开始时间和结束时间都不为空 -->

     <when test="beginTime != null and endTime != null">

               AND <![CDATA[ t.archive_time >= #{beginTime}]]>

              AND <![CDATA[ t.archive_time <= #{endTime}]]>

     </when>

     <!-- 开始时间不为空，结束时间为空 -->

     <when test="beginTime != null and endTime == null">

            AND <![CDATA[ t.archive_time >= #{beginTime}]]>

     </when>

     <!-- 结束时间不为空，开始时间为空 -->

     <when test="beginTime == null and endTime != null">

            AND <![CDATA[ t.archive_time <= #{endTime}]]>

     </when>

</choose>

保存并且返回id

   <insert id="saveEdgeVersion" parameterType="com.exceeddata.vcloud.entity.DeviceVersionEntity" useGeneratedKeys="true" keyProperty="edgeVersionId">
      insert into edge_version(library_version, vcompute_version, vadas_version, service_id,service_name) value(#{library}, #{vcomputel}, #{vadas}, #{serviceId}, #{serviceName})
   </insert>

删除

   <delete id="deleteVersionDeviceMapping" parameterType="Map" >
      delete from edge_version_device_mapping where device_id = #{deviceId} and service_id = #{serviceId}
   </delete>