模糊查询

最新推荐文章于 2021-05-25 11:07:10 发布

MRZZXzzx

最新推荐文章于 2021-05-25 11:07:10 发布

阅读量297

点赞数 1

分类专栏： MyBatis

本文链接：https://blog.csdn.net/MRZZXzzx/article/details/78449010

版权

MyBatis 专栏收录该内容

11 篇文章 0 订阅

订阅专栏

sql语句映射文件

<!-- 模糊查询 -->
	<select id="search" resultType="Employee" parameterType="String">
		select * from Employee where ename like '%${value}%'
	</select>
	<select id="search2" resultType="Employee" parameterType="String">
		select * from Employee where ename like #{value}
	</select>
	<select id="search3" resultType="Employee" parameterType="String">
		select * from Employee where ename like '%'||#{value}||'%'
	</select>

java代码

public void test3() throws Exception {
		SqlSession session = MyBatisUtils.getSqlSession();
		List<Object> selectList = session.selectList("test.search", "九");
		List<Object> selectList2 = session.selectList("test.search2", "%九%");
		List<Object> selectList3 = session.selectList("test.search3", "九");
		System.out.println(selectList);
		System.out.println(selectList2);
		System.out.println(selectList3);
		session.close();
	}