mybatis中if test 可以使用== != null '' and or 和括号()

<if test="areaLevel != null and areaLevel != '' and (areaLevel == '4' or areaLevel == '5')"> mybatis这个可以用or语句吗

insert id="insertSupplierInvoice" parameterType="SupplierInvoice"> insert into supplier_invoice <trim prefix="(" suffix=")" suffixOverrides=","> <if test="comnum != null">comnum,</if> <if test="invoicetype != null">invoicetype,</if> <if test="invoicenum != null">invoicenum,</if> <if test="invoicecode != null">invoicecode,</if> <if test="invoicedate != null">invoicedate,</if> <if test="notaxamount != null">notaxamount,</if> <if test="taxamount != null">taxamount,</if> <if test="tax != null">tax,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="comnum != null">#{comnum},</if> <if test="invoicetype != null">#{invoicetype},</if> <if test="invoicenum != null">#{invoicenum},</if> <if test="invoicecode != null">#{invoicecode},</if> <if test="invoicedate != null">#{invoicedate},</if> <if test="notaxamount != null">#{notaxamount},</if> <if test="taxamount != null">#{taxamount},</if> <if test="tax != null">#{tax},</if> </trim> </insert>

<insert id="insertTWarning" parameterType="TWarning"> insert into t_warning <trim prefix="(" suffix=")" suffixOverrides=","> <if test="id != null">id,</if> <if test="warntop != null">warntop,</if> <if test="warnblow != null">warnblow,</if> <if test="warntype != null">warntype,</if> createtime, <if test="createid != null">createid,</if> <if test="updateid != null">updateid,</if> </trim> <trim prefix="values (" suffix=")" suffixOverrides=","> <if test="id != null">#{id},</if> <if test="warntop != null">#{warntop},</if> <if test="warnblow != null">#{warnblow},</if> <if test="warntype != null">#{warntype},</if> now(), <if test="createid != null">#{createid},</if> <if test="updateid != null">#{updateid},</if> </trim> </insert>

SELECT DISTINCT 'video' AS type, smv.video_id AS id, smv.video_title AS title, NULL AS channelId, '' AS channelType, '' AS channelName, '' AS channelCode, '' AS shortLink, '' AS longLink, smv.file_id AS fileId, smv.create_time FROM sys_media_video smv LEFT JOIN sys_file_info sfi ON smv.cut_file_id = sfi.file_id LEFT JOIN sys_label sl ON smv.label_id = sl.id LEFT JOIN sys_tag st ON smv.label_id = st.id <where> smv.del_flag = '0' and smv.push_home_page = '1' <if test="title != null and title != ''">AND smv.video_title like concat('%', #{title}, '%')</if> <if test="searchValue != null and searchValue != ''">and smv.video_title like concat('%', #{searchValue},'%')</if> <if test="channelType != null and channelType != ''">AND 1=2</if> <if test="channelName != null and channelName != ''">AND 1=2</if> <if test="channelCode != null and channelCode != ''">AND 1=2</if> <if test="params.beginTime != null and params.beginTime != ''"><!-- 开始时间检索 --> AND smv.create_time >= #{params.beginTime} </if> <if test="params.endTime != null and params.endTime != ''"><!-- 结束时间检索 --> AND smv.create_time <= #{params.endTime} </if> <if test="labelId != null and labelId != ''">and smv.label_id = #{labelId}</if> <if test="labelIds != null and labelIds.length > 0"> and (smv.label_id in <foreach collection="labelIds" item="labelId" open="(" separator="," close=")"> #{labelId} </foreach> ) </if> <if test="tagId != null and tagId != ''">and FIND_IN_SET( #{tagId} , smv.tag_id )</if> <if test="tagIds != null and tagIds.length > 0"> and <foreach collection="tagIds" item="tagId" open="(" separator="," close=")"> FIND_IN_SET( #{tagId} , smv.tag_id ) or </foreach> </if> </where> 修改

<if test="req.w3AccountList != null and req.w3AccountList.size > 0"> size 后面有没有括号