Mybatis 基础 sql 片段使用

2019独角兽企业重金招聘Python工程师标准>>>

 mybatis 使用sql 片段

    经验：片段中不要使用 where,防止引用多个片段报错

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="user">
	
	<resultMap type="com.stones.mybatis.pojo.User" id="resultMapUser">
		<id property="id" column="id"/>
		<result property="username" column="uname"/>
	</resultMap>
	
	<sql id="queryUserWhere">
		<if test="username != null">
		    	AND username = #{username}
		  	</if>
		  	
		  	<if test="id != null">
		    	AND id = #{id}
		</if>		
	</sql>

	<select id="findUser" parameterType="com.stones.mybatis.pojo.User" resultMap="resultMapUser">
		SELECT id, username as uname, password FROM user
		
		<where> 
			<include refid="queryUserWhere" ></include>
	  	</where>
	  	
	</select>
	
</mapper>

 

转载于:https://my.oschina.net/famoustone/blog/780056