mybatis 配置文件mysql的常用语句写法总结

                     mybatis 配置文件mysql常用语句写法总结
1.添加语句
   <insert id="insert" parameterType="com.baidu.bean.AppAccountBean">
  insert into 表名
    (account,pass,operate,create_date,remark)
  values(
    #{account,jdbcType=VARCHAR},
    #{password,jdbcType=VARCHAR},
    #{operater,jdbcType=VARCHAR},
    now(),
    #{remarks,jdbcType=VARCHAR}
    )
 </insert>
2.批量添加语句
<insert id="insert" parameterType="java.util.List">
     insert into  表名(
             delete_power,
             create_date,
             update_date,
             remarks,
             permission_group_code
             )
           values
     <foreach  collection="list" item="item" index="index" separator =",">
  (
  #{item.deletePower},
  (select now() as createDate from dual),
  (select now() as updateDate from dual),
  #{item.remarks},
  #{item.permissionGroupCode}
  
  )
  </foreach>
 </insert>
3.删除语句
<delete id="delete" parameterType="String">
   delete  from 表名 where cs_admin_name = #{adminName}
 </delete>
4.批量删除语句
<delete id="delete" parameterType="java.util.List">
    delete from
          表名
    where
           cs_admin_name
           in
           <foreach open="(" close=")" collection="list" item="item" index="index" separator=",">
           #{item.adminName}
           </foreach>
 </delete>
5.修改语句
 <update id="update" parameterType="com.baidu.pojo.HttpProjectPojo" > 
        UPDATE
         表名
        SET
         <if test="state !=null and state !=''">
               STATE = #{state} ,
           </if>
           <if test="isPaid !=null and isPaid !=''">
               IS_PAID = #{isPaid} ,
           </if>
         UPDATE_DATE = sysdate()
        WHERE
         1=1
         <if test="proNumber !=null and proNumber !=''">
            AND PRO_NUMBE