expression: number != null and number ! = ‘‘

在编写xml代码if语句时注意不要加额外的空格,如! =之间不能加空格会导致报错:
Caused by: org.apache.ibatis.builder.BuilderException: Error evaluating expression 'number != null and number ! = '''. Cause: org.apache.ibatis.ognl.ExpressionSyntaxException: Malformed OGNL expression: number != null and number ! = '' [org.apache.ibatis.ognl.ParseException: Encountered " "!" "! "" at line 1, column 27.

<sql id="selectIotMainboardUpgradeRecordVo"> SELECT ur.record_id, ur.upgrade_id, ur.gateway_id, ur.upgrade_time, ur.status, g.gateway_id as sub_gateway_id, g.board_id as sub_board_id, g.gateway_number as sub_gateway_number, g.gateway_name as sub_gateway_name, g.lng as sub_lng, g.lat as sub_lat, g.address as sub_address, g.remark as sub_remark, g.status as sub_status, g.rssi as sub_rssi, g.version as sub_version, g.firmware_version as sub_firmware_version, g.online_time as sub_online_time, g.offline_time as sub_offline_time, g.update_time as sub_update_time, g.register_time as sub_register_time, g.enable as sub_enable, g.configured as sub_configured FROM iot_mainboard_upgrade_record ur LEFT JOIN iot_gateway g ON ur.gateway_id = g.gateway_id </sql> <select id="selectIotMainboardUpgradeRecordList" parameterType="IotMainboardUpgradeRecord" resultMap="IotMainboardUpgradeRecordResult"> <include refid="selectIotMainboardUpgradeRecordVo"/> <where> <if test="upgradeId != null "> and ur.upgrade_id = #{upgradeId}</if> <if test="gatewayId != null "> and ur.gateway_id = #{gatewayId}</if> <if test="params.beginUpgradeTime != null and params.beginUpgradeTime != '' and params.endUpgradeTime != null and params.endUpgradeTime != ''"> and ur.upgrade_time between #{params.beginUpgradeTime} and #{params.endUpgradeTime}</if> <if test="status != null "> and ur.status = #{status}</if> <if test="iotGateway.gatewayNumber != null and iotGateway.gatewayNumber != ''"> and g.gateway_number like concat('%', #{gatewayNumber}, '%')</if> <if test="iotGateway.gatewayName != null and iotGateway.gatewayName != ''"> and g.gateway_name like concat('%', #{gatewayName}, '%')</if> </where> ORDER BY ur.record_id desc </select>其中<if test="iotGateway.gatewayNumber != null and iotGateway.gatewayNumber != ''">要怎么修改才不会报nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'iotGateway.gatewayNumber != null and iotGateway.gatewayNumber != '''. Cause: org.apache.ibatis.ognl.OgnlException: source is null for getProperty(null, "gatewayNumber错误
07-31
评论
成就一亿技术人!
拼手气红包6.0元
还能输入1000个字符
 
红包 添加红包
表情包 插入表情
 条评论被折叠 查看
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值