mapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper  PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
        
<mapper namespace="com.iflytek.dao.AlbumDao">

	 <select id="getAlbumById" resultType="com.iflytek.bean.Album">
	 	select * from t_album where id=#{id}
	 </select>
	 
	 <select id="queryAlbum" resultType="com.iflytek.bean.Album">
	 	select * from t_album
	 	
	 	<where>
	 	<if test="(name != null and name != '') || (create_time != null and create_time != '')">
	 		is_del != 1
	 	</if>
	 	
	 	<if test="name != null and name != '' ">
	 		 and name like concat("%",#{name },"%")
	 	</if>
	 	
	 	<if test="create_time != null and create_time != '' ">
	 		 and create_time = #{create_time}
	 	</if>
	 	</where>

	 </select>
	 
	 
</mapper>