MyBatis模糊查询
<select id="selectStudentByName" parameterType="String" resultType="Student">
select s_id,s_name,s_age
from student
where s_name like '%'||#{s_name}||'%'
</select>
MyBatis模糊查询
<select id="selectStudentByName" parameterType="String" resultType="Student">
select s_id,s_name,s_age
from student
where s_name like '%'||#{s_name}||'%'
</select>