org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: xxx is null || xxx == ''
[org.apache.ibatis.ognl.ParseException: Encountered " "xxx is null || xxx == ''" at line 1, column 1.
Was expecting one of:
 ":" ...
 "not" ...
 "+" ...
 "-" ...
 "~" ...
 "!" ...
 "(" ...
 "true" ...
 "false" ...
 "null" ...
 "#this" ...
 "#root" ...
 "#" ...
 "[" ...
 "{" ...
 "@" ...
 "new" ...
 <IDENT> ...
 <DYNAMIC_SUBSCRIPT> ...
 "\'" ...
 "`" ...
 "\"" ...
 <INT_LITERAL> ...
 <FLT_LITERAL> ...
 ]] with root cause
org.apache.ibatis.ognl.ParseException: Encountered ""xxx is null || xxx == ''" at line 1, column 1.
Was expecting one of:
 ":" ...
 "not" ...
 "+" ...
 "-" ...
 "~" ...
 "!" ...
 "(" ...
 "true" ...
 "false" ...
 "null" ...
 "#this" ...
 "#root" ...
 "#" ...
 "[" ...
 "{" ...
 "@" ...
 "new" ...
 <IDENT> ...
 <DYNAMIC_SUBSCRIPT> ...
 "\'" ...
 "`" ...
 "\"" ...
 <INT_LITERAL> ...
 <FLT_LITERAL> ...

mybatis出現(xiàn)OGNL的問(wèn)題，原因是mybatis xml寫(xiě)法不滿(mǎn)足OGNL要求，修改即可解決。
部分語(yǔ)法對(duì)照表：

bor（字符|）的英文         
xor      字符^的英文       
and      字符&&     
band    字符&       
eq     字符==      
neq    字符！=     
lt      字符<    
gt      字符>    
lte       字符<=   
 gte    字符>=    
shl    字符 <<    
shr    字符>>     
ushr    字符>>>

當(dāng)然還有一種解決辦法，在合適的地方加入<![CDATA[ xxxxx ]]> 也可以。
栗子：

  <select id="list" resultType="map">
        select
        id as chatMsgId,
        ask,
        answer,
        generate_time as generateTime
        from aibox_chat_message acm
        where
        acm.user_id = #{userId}
        and
        acm.serial_number = #{serialNumber}
        <choose>
            <when test="chatMessageId eq null bor chatMessageId eq ''">
                order by acm.generate_time desc
            </when>
            <otherwise>
                <if test="upOrDown eq 'UP'">
                    <![CDATA[ and acm.id < #{chatMessageId} ]]>
                    order by acm.generate_time desc
                </if>
                <if test="upOrDown eq 'DOWN'">
                    <![CDATA[ and acm.id > #{chatMessageId} ]]>
                    order by acm.generate_time asc
                </if>
            </otherwise>
        </choose>
        limit #{count}
    </select>