MyBitas 多个参数

方法一：

DAO层的接口：
/*根据方用例名称查询数据-判断用例名称是否存在*/

/*根据方用例名称查询数据-判断用例名称是否存在*/
int SelectByUseCaseName(@Param("Id") Integer Id,@Param("AutomationPlanId") Integer AutomationPlanId,@Param("UseCaseName") String UseCaseName);

DAO层的Mapper.xml：

<select id="SelectByUseCaseName" resultType="java.lang.Integer">
	select Count(*) from AUTOMATION_USECASE
	where 1=1
	<if test="Id != null">
		And ID != #{Id,jdbcType=DECIMAL}
	</if>
	<if test="AutomationPlanId != null">
		And AUTOMATION_PLAN_ID = #{AutomationPlanId,jdbcType=DECIMAL}
	</if>
	<if test="UseCaseName != null">
		And USECASENAME = #{UseCaseName,jdbcType=VARCHAR}
	</if>
</select>

方法二：

<select id="selectAuthor" resultType="Author" parameterType="java.util.HashMap">
	SELECT * FROM AUTHOR WHERE 1=1 
	<if test="id != null and id != '' ">
		and ID = #{id} 
	</if>

	<if test="likename != null and likename != '' ">
		and name like CONCAT('%',#{likename},'%')
	</if>
</select>

方法三：
方法四：

转载于:https://my.oschina.net/xueyueziyan/blog/607878