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
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