sql语句问题

[qq_36341622]

[自由自在_Yu]

去掉中间两个单引号试试

[podd]

当条件不成立时就会变成 select * from tab where 这样写条件 <where> <if test=""> <if> </where>

[xwn_2016]

<where>
			<if test="userPhone != null and userPhone != ''">
				AND wu.user_phone LIKE CONCAT(#{userPhone}, '%')
			</if>
			<if test="userName != null and userName != ''">
				AND wu.user_account LIKE CONCAT(#{userName}, '%')
			</if>
			<if test="provinceId != null and provinceId != ''">
				AND uoi.province_id = ${provinceId}
			</if>
			<if test="cityId != null and cityId != ''">
				AND uoi.city_id = ${cityId}
			</if>
			<if test="companyInfo != null and companyInfo != ''">
				AND uoi.company_info = '${companyInfo}'
			</if>
		</where>

用CONCAT函数

[PrettyTutu]

select count(menu_id) num from menu where menu_del=0 <when test='menuName!=""&&menuName!=null'> and menu_name like '%${menuName}%' </when> <when test='menuFather!=""&&menuFather!=null'> and menu_father=#{menuFather} </when>