<select id="getPersonInfoList" parameterType="java.lang.String" resultType="java.util.Map">
SELECT COMPANY company,DEPARTMENT department,USER_NO userNo,USER_NAME userName
FROM user_table
WHERE USER_STATUS = '01'
<if test="keyWord != null and keyWord != ''">
<bind name="keyWord" value="'%' + keyWord + '%'" />
AND (USER_NO like #{keyWord} OR DEPARTMENT like #{keyWord} OR POSITION like #{keyWord}
USER_NAME like #{keyWord} OR USER_TEL like #{keyWord}
OR USER_EMAIL like #{keyWord} OR USER_COMMENT like #{keyWord})
</if>
</select>
只要在相应的Dao接口方法中添加注解 @Param("keyWord"),如下
public List<Map<String, Object>> getPersonInfoList(@Param("keyWord")String keyWord);