mybatis的增删改查

1.插入方法

<insert id="insert">

        INSERT INTO bs_manage_drugin(

            id,

            <if test="drugId != null and drugId != ''">

            drugid,

            </if>

            <if test="spec != null and spec != ''">

            spec,

            </if>

            <if test="manufacturer != null and manufacturer != ''">

            manufacturer,

            </if>

            create_by,

            create_date,

            update_by,

            update_date,

            del_flag,

            remarks

        ) VALUES (

            #{id},

            <if test="drugId != null and drugId != ''">

            #{drugId},

            </if>

            <if test="spec != null and spec != ''">

            #{spec},

            </if>

            <if test="manufacturer != null and manufacturer != ''">

            #{manufacturer},

            </if>

            #{createBy.id},

            #{createDate},

            #{updateBy.id},

            #{updateDate},

            #{delFlag},

            #{remarks}

        )

    </insert>

2.修改方法

 

    <update id="update">

    UPDATE   TABLE

       <trim prefix="set" suffixOverrides=",">   //在前面加上set  去掉最后的逗号！！！

       <if test="id!=null">

        id= #{id},

       </if>

      <if test"name!=null">

        name = #{name},

     </if>

     </trim>

where id = #{id}     

</update>

3.删除 

<delete id="delete">
   DELETE FROM bs_child_tip
   WHERE vaccid = #{vaccid} AND remindtype = #{remindtype} AND "LOCALCODE" = #{localCode}
</delete>

4.查询

<select id="findListByVaccCode" resultType="ChildBaseinfo">
   SELECT
   <include refid="childBaseinfoColumns" />
   FROM bs_child_baseinfo a
   <where>
      <if test="localCode != null and localCode != ''">
         AND A."LOCALCODE" = #{localCode}
      </if>
      <if test="vaccCardCode!=null and vaccCardCode!=''">
         AND vaccCardCode = #{vaccCardCode}
      </if>

      <if test="propertiess != null and propertiess != ''">

        AND a.properties in <foreach collection="propertiess" item="item" index="index" open="(" separator="," close=")">#{item}</foreach>
      </if>

   </where>
</select>