MyBatis中if和choose的嵌套

上代码：

	<!-- public List<VadtaxShow> findList(VadtaxShow vadtaxShow); -->
	<select id="findList" parameterType="com.cdqyzj_WC.Backstage.vaddedtax.domain.VaddeTax" resultType="com.cdqyzj_WC.Backstage.vaddedtax.domain.VaddeTax">
    SELECT t.addedId,t.taxType,t.totalSales,t.outputTax,t.inputTax,t.entryAmount, t.amountTax,t.retentionTax,
    t.createTime, t.taxTime,t.comId,c.comName,c.comType
    FROM t_g_vaddedtax AS t JOIN t_ucompany AS c ON c.comId = t.comId
	<where>
	1=1
			<if test="comType != '' and comType != null"> and c.comType = #{comType}</if>
			<if test="taxTime != null and taxTime != ''"> and t.taxTime =#{taxTime} </if>	
			<if test="taxType != null and taxType != '' "> and t.taxType =#{taxType} </if>
			<if test="comId != null and comId != '' and comId != 0 "> and t.comId =#{comId} </if>	
			<if test="start_times != null and end_times != null">
				<choose>
					<when test="middle_times != null">
						and t.createTime in ('${start_times}','${middle_times}', '${end_times}' )
					</when>
					<otherwise>
						and t.createTime in ('${start_times}','${end_times}' )
					</otherwise>
				</choose>
			</if>
			<if test="orderBy != null and orderType != '' ">
				 	order by ${orderBy}  ${orderType}
			</if>
			<if test="pageSize != 0 ">
					limit ${startRows},${pageSize}
			</if>
	</where>
	</select>

功能实现之后反思：要不我不对“middle_times”判空？这样不就不用嵌套了吗？

	<!-- public List<VadtaxShow> findList(VadtaxShow vadtaxShow); -->
	<select id="findList" parameterType="com.cdqyzj_WC.Backstage.vaddedtax.domain.VaddeTax" resultType="com.cdqyzj_WC.Backstage.vaddedtax.domain.VaddeTax">
    SELECT t.addedId,t.taxType,t.totalSales,t.outputTax,t.inputTax,t.entryAmount, t.amountTax,t.retentionTax,
    t.createTime, t.taxTime,t.comId,c.comName,c.comType
    FROM t_g_vaddedtax AS t JOIN t_ucompany AS c ON c.comId = t.comId
	<where>
	1=1
			<if test="comType != '' and comType != null"> and c.comType = #{comType}</if>
			<if test="taxTime != null and taxTime != ''"> and t.taxTime =#{taxTime} </if>	
			<if test="taxType != null and taxType != '' "> and t.taxType =#{taxType} </if>
			<if test="comId != null and comId != '' and comId != 0 "> and t.comId =#{comId} </if>	
			<if test="start_times != null and end_times != null">
				and t.createTime in ('${start_times}','${middle_times}', '${end_times}' )
			</if>
			<if test="orderBy != null and orderType != '' ">
				 	order by ${orderBy}  ${orderType}
			</if>
			<if test="pageSize != 0 ">
					limit ${startRows},${pageSize}
			</if>
	</where>
	</select>