Mybatis开发总结

Mybatis开发总结

1.插入 

       1.1插入一条

     <insert id="insertInfo" parameterType="UserDto">

        insert into user

           --本行可以去除insert语句的最后一个逗号。因为插入列数不确定。

        <trim prefix="(" suffix=")" suffixOverrides =",">

        <if test="name != null">

            name = #{name},

        </if>

        <if test ="sex != null">

         sex = #{sex}, 

         </if>

        </trim>

    </insert>

1.2 批量插入

    //mysql

  <insert id="batchInsert" >

        insert into user (name,sex)

        <foreach collection="lists" item="user" separator=",">

        (#{user.name},#{use