<insertid="register"parameterType="com.wyj.entity.po.User">
insert into <includerefid="tableName"/><trimprefix="("suffix=")"suffixOverrides=","><iftest="id != null">
id,
</if><iftest="username!= null and username != ''">
username,
</if><iftest="password!= null and password != ''">
password,
</if></trim><trimprefix="values ("suffix=")"suffixOverrides=","><iftest="id != null">
#{id,jdbcType=INTEGER},
</if><iftest=" username != null and username != ''">
#{username,jdbcType=VARCHAR},
</if><iftest=" password!= null and password!= ''">
#{password,jdbcType=VARCHAR},
</if></trim></insert>
<sqlid="tableName">
user
</sql>
批量新增数据
<insertid="insertUserList"parameterType="com.wyj.entity.po.User">
insert into `user`(name,sex,age,address,phone) values
<foreachcollection="list"index="index"item="user"separator=","><trimprefix="("suffix=")">
#{user.name},#{user.sex},#{user.age},#{user.address},#{user.phone}
</trim></foreach></insert>
publicvoidinsertUserList(List<User> userList);
删除数据
<deleteid="deleteById"parameterType="com.wyj.entity.po.User">
delete from <includerefid="tableName"/><where><iftest=" id != null">
id=#{id,jdbcType=INTEGER}
</if></where></delete>
<sqlid="tableName">
user
</sql>
修改数据
<updateid="updateByUsername"parameterType="com.wyj.entity.po.User">
update <includerefid="tableName"/><set><iftest=" password!= null and password!= ''">
password=#{password,jdbcType=VARCHAR},
</if><iftest=" name!= null and name!= ''">
name=#{name,jdbcType=VARCHAR},
</if></set><where><iftest=" username != null and username != ''">
username=#{username,jdbcType=VARCHAR}
</if></where></update>
<sqlid="tableName">
user
</sql>
查询数据
<selectid="findAll"resultMap="tableResultMap">
select * from <includerefid="tableName"/><where>
<if test = " name != null and user != '' ">
and `name` like CONCAT('%',#{name,jdbcType=VARCHAR},'%')
</if>
<if test = " sex != null and sex != '' ">
and sex = #{sex,jdbcType=VARCHAR}
</if>
<if test = " age != null and age != '' ">
and age = #{age,jdbcType=VARCHAR}
</where></select>