Mybatis文件解析

[Sharkzeng]

1

<select id="OrderByOrderNo" resultMap="skMap"> select <include refid="Base_Column_List"/> from trans <if test="type==1"> where channel_trans_no=#{orderNo} </if> <if test="type==2"> where trans_no=#{orderNo} </if> limit 1 </select>

另外请支持下 和

<select id=" 想" resultMap=" o">
	SELECT
	p.*
	FROM
		product_info p left join c 
	ON
		p.channel_id = c.id
	<where>
	<if test="vo.productName != null and vo.productName != ''"> and p.product_name = #{vo.productName}</if>
	</where>
	order by p.create_time desc
</select>