2、MyBatis动态sql

1、批量删除

IUserInfoDao.java

	boolean delete(@Param("ids")int [] ids);

user_info.xml

	<delete id="delete">
		delete from user_info where id in
		<foreach item="id" collection="ids" open="(" separator="," close=")">
			#{id}
		</foreach>
	</delete>

2、根据0~n个属性查询

IUserInfoDao.java

	List<UserInfo> select(@Param("userName")String userName, @Param("mobile")int mobile);

user_info.xml

	<select id="select" resultType="com.jd.vo.UserInfo">
		select id,user_name,mobile,address
		from user_info
		<where>
			<if test="userName!=null">
				and user_name like #{userName}	
			</if>
			<if test="mobile!=null">
				and mobile = #{mobile}
			</if>
		</where>
	</select>

3、修改一条记录的某几个属性

IUserInfoDao.java

	boolean update(@Param("id")int id, @Param("userName")String userName, @Param("mobile")int mobile);

user_info.xml

	<update id="update">
		update user_info
		<set>
			<if test="userName!=null">
				user_name=#{userName},
			</if>
			<if test="mobile!=null">
				mobile=#{mobile},
			</if>
		</set>
		where id=#{mobile}
	</update>