Mybatis的sql语法

1.if和where的使用。

<select id="findUserList" parameterType="user" resultType="user">
		select * from user 
		<where>
		<if test="id!=null and id!=''">
		and id=#{id}
		</if>
		<if test="username!=null and username!=''">
		and username like '%${username}%'
		</if>
		</where>
</select>

2.foreach的使用

<if test="ids!=null and ids.size>0">
	 <foreach collection="ids" open=" and id in(" close=")" item="id" separator="," >
	    #{id}
	 </foreach>
</if>

3.sql片段

<sql id="query_user_where">
	<if test="id!=null and id!=''">
		and id=#{id}
	</if>
	<if test="username!=null and username!=''">
		and username like '%${username}%'
	</if>
</sql>
<select id="findUserList" parameterType="user" resultType="user">
	 select * from user 
	 <where>
	 <include refid="query_user_where"/>
	 </where>
</select>

如果引用其它mapper.xml的sql片段，则在引用时需要加上namespace，如下：

<include refid="namespace.sql片段”/>

4.resultMap做关联查询（一对一，用户订单表）

<resultMap type="Orders" id="orderUserResultMap">
		<id column="id" property="id"/>
		<result column="user_id" property="userId"/>
		<result column="number" property="number"/>
		<result column="createtime" property="createtime"/>
		<result column="note" property="note"/>
		<!-- 一对一关联映射 -->
		<!-- property:Orders对象的user属性，javaType：user属性对应 的类型 -->
		<association property="user" javaType="cn.itcast.po.User">
			<!-- column:user表的主键对应的列  property：user对象中id属性-->
			<id column="user_id" property="id"/>
			<result column="username" property="username"/>
			<result column="address" property="address"/>
		</association>
</resultMap>

5，