<mapper namespace="test">
<select id="queryPaper" parameterType="int" resultType="com.ssii.pojo.Paper">
select * from paper where paper_id = #{id}
</select>
<select id="queryList" parameterType="String" resultType="com.ssii.pojo.Paper">
/*mybatis中实现模糊查询的三种方式*/
/*select * from paper where detail like '%${value}%'*/
/*select * from paper where detail like "%"#{value}"%"*/
select * from paper where detail like CONCAT(CONCAT('%',#{value}),'%')
</select>
</mapper>
注意:测试时,只放一条语句在相应位置,即便其它两句加了注释也会报错.