BusinessMapper.xml
<sql id="Base_Column_List" >
name,pic
</sql>
<select id="selectByNameBusiness" resultMap="BaseResultMap" >
select
<include refid="Base_Column_List" />
from business
where name like "%"#{name}"%"
order by id asc
</select>
Dao接口
public interface BusinessMapper {
List<Business> selectByNameBusiness(@Param("name") String name);
}