MyBatis案例七：动态sql：if、trim、where

最新推荐文章于 2024-09-23 23:17:37 发布

老实先生

最新推荐文章于 2024-09-23 23:17:37 发布

阅读量1.1k

点赞数 1

分类专栏： MyBatis 文章标签： MyBatis

本文链接：https://blog.csdn.net/pcbhyy/article/details/83715517

版权

MyBatis 专栏收录该内容

11 篇文章 1 订阅

订阅专栏

MyBatis案例七：动态sql：if、trim、where

接口方法：

public List<Dept> getForExample(Dept dept);

mapper：

<select id="getForExample" resultType="com.yy.domain.Dept">
		select * from dept
		where 1 = 1 
		<if test="deptno != null">
			and deptno = #{deptno}
		</if>
		<if test="dname != null">
			and dname = #{dname}
		</if>
		<if test="loc != null">
			and loc = #{loc}
		</if>
	</select>

测试类：

	@Test
	public void testGetForExample() throws IOException {
		deptMapper = session.getMapper(DeptMapper.class);
		Dept dept = new Dept(null, "hr", "tt");
		List<Dept> list = deptMapper.getForExample(dept);
		System.out.println(list);
	}

mapper改进：trim

<select id="getForExample" resultType="com.yy.domain.Dept">
		select * from dept
		<trim prefix="where" prefixOverrides="and ">
			<if test="deptno != null">
				and deptno = #{deptno}
			</if>
			<if test="dname != null">
				and dname = #{dname}
			</if>
			<if test="loc != null">
				and loc = #{loc}
			</if>
		</trim>
</select>

mapper改进：where

<select id="getForExample" resultType="com.yy.domain.Dept">
		select * from dept
		<where>
			<if test="deptno != null">
				and deptno = #{deptno}
			</if>
			<if test="dname != null">
				and dname = #{dname}
			</if>
			<if test="loc != null">
				and loc = #{loc}
			</if>
		</where>
</select>