mybatis的使用

来源：互联网发布：电脑重装系统恢复数据编辑：程序博客网时间：2024/05/20 12:49

1、更新设置（<trim suffixOverrides="," >）

<update id="updateContentProvider"  parameterType="Object"  >update ott_content_provider cp set <trim  suffixOverrides="," ><if test="cpName != null  ">cp.cp_name=#{cpName} ,</if><if test="expirationTime != null  ">cp.expiration_time=#{expirationTime} ,</if>cp.status = 0</trim>where cp.id=#{id}  </update>

也可:

<set>        <if test="name != null">name=#{name},</if>        <if test="status != null">status=#{status}</if></set>

2、删除符合集合中的数据（<foreach item="item" index="index" collection="list" open="(" separator="," close=")"> ）

<delete id="delete" parameterType="list">delete from ott_epg where id in <foreach item="item" index="index" collection="list" open="(" separator="," close=")">    #{item}  </foreach>  </delete>

3、插入数据后返回--"id" ( <insert id="save" parameterType="com.sdmc.bean.Epg" useGeneratedKeys="true" keyProperty="id"> )

<insert id="save" parameterType="com.sdmc.bean.Epg" useGeneratedKeys="true" keyProperty="id">insert into ott_epg (parent_id,operator_id,create_time) values(#{parent_id},#{operator_id},CURRENT_TIMESTAMP())<selectKey keyProperty="id" order="AFTER" resultType="java.lang.Integer">            <span style="white-space:pre"></span>select last_insert_id() as id        <span style="white-space:pre"></span></selectKey></insert>

0 0