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.it.master.dao.impl.MeasureDaoImpl">
<resultMap id="AllResult" type="com.it.entity.master.measure.Measure">
<result column="id" property="id" />
<result column="name" property="name" />
<result column="py" property="py" />
<result column="memo" property="memo" />
<result column="create_time" property="createTime" />
<result column="edit_time" property="editTime" />
</resultMap>
<parameterMap id="Measure" type="com.it.entity.master.measure.Measure"/>
<sql id="table">`measure`</sql>
<select id="measureList" parameterType="java.util.Map" resultMap="AllResult" >
SELECT
*
FROM
<include refid="table" />
WHERE
1
AND `is_del` = 'N'
<if test="keywords != null and keywords != ''">
AND CONCAT(`name`,`py`) LIKE CONCAT ('%', #{keywords},'%')
</if>
ORDER BY `id` ASC
</select>
接口:
public interface MeasureDao {
List<Measure> measureList(String keywords);
}
实现类:
@Repository
public class MeasureDaoImpl extends BaseDao implements MeasureDao {
@Override
public List<Measure> measureList(final String keywords) {
final Map m = new HashMap<>(1);
m.put("keywords", keywords);
return super.getSqlSession().selectList(super.getStatement("measureList"), m);
}