mybatis 数值类型的参数！=‘‘ 会怎样

org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.builder.BuilderException: Error evaluating expression 'paramType_Gr8re1Ee != null and paramType_Gr8re1Ee and ew.from != null and ew.from != '''. Cause: org.apache.ibatis.ognl

@Select({"<script> ", "SELECT mbl.id,mbl.battery_id,mbl.battery_kind,mbl.create_time,mbl.battery_work_mode,mbl.battery_soc", ",mbl.sn,mbl.longitude_direction,mbl.longitude,mbl.latitude_direction,mbl.latitude", ",mbl.province_id,mbl.city_id,mbl.district_id,mt.project_id" , ",mbl.battery_soft_version,mbl.battery_error_code,mbl.upload_time " , " FROM my_battery_info_lastest mbl " , " LEFT JOIN mqtt_triad mt ON mt.client_id = mbl.battery_id " , " WHERE 1=1 " , "<when test='hwid!=null and hwid!=\"\"'> ", // "AND mbl.battery_id = #{hwid} " , " <![CDATA[ AND mbl.battery_id LIKE CONCAT('%',#{hwid},'%') ]]> ", "</when> ", " <when test='batteryKind != null'> ", " and mbl.battery_kind=#{batteryKind} ", " </when> ", "<when test='sn!=null and sn!=\"\"'> ", " <![CDATA[ AND mbl.sn LIKE CONCAT('%',#{sn},'%') ]]> ", "</when> ", "<when test='workModes!=null and workModes!=\"\"'> ", "<![CDATA[ AND mbl.battery_work_mode in ${workModes} ]]> ", "</when> ", "<when test='errCodeMin!=null'> ", // "<![CDATA[ AND mbl.batteryErrorCode >= ${errCodeMin} ]]> ", " AND <![CDATA[ CONVERT(mbl.battery_error_code,signed) >= #{errCodeMin,jdbcType=INTEGER} ]]>", "</when> ", "<when test='errCodeMax!=null'> ", // "<![CDATA[ AND mbl.batteryErrorCode <= ${errCodeMax} ]]> ", " AND <![CDATA[ CONVERT(mbl.battery_error_code,signed) <= #{errCodeMax,jdbcType=INTEGER} ]]>", "</when> ", "<when test='projectId!=null and projectId!=\"\"'> ", "AND mt.project_id = #{projectId} " , "</when> ", "<when test='projects!=null and projects!=\"\"'> ", " AND mt.project_id in (${projects}) " , "</when> ", "<when test='onlineStartTime!=null and onlineStartTime!=\"\"'> ", "<![CDATA[ AND DATE_FORMAT(mbl.upload_time,'%Y-%m-%d %H:%i:%s') >= #{onlineStartTime} ]]> " , "</when> ", "<when test='onlineEndTime!=null and onlineEndTime!=\"\"'> ", "<![CDATA[ AND DATE_FORMAT(mbl.upload_time,'%Y-%m-%d %H:%i:%s') < #{onlineEndTime} ]]> " , "</when> ", "<when test='startTime!=null and startTime!=\"\"'> ", "<![CDATA[ AND DATE_FORMAT(mbl.create_time,'%Y-%m-%d') >= #{startTime} ]]> " , "</when> ", "<when test='endTime!=null and endTime!=\"\"'> ", "<![CDATA[ AND DATE_FORMAT(mbl.create_time,'%Y-%m-%d') < #{endTime} ]]> " , "</when> ", "<when test='proviceId!=null and proviceId!=\"\"'> ", "AND mbl.province_id = #{proviceId} " , "</when> ", "<when test='cityId!=null and cityId!=\"\"'> ", "AND mbl.city_id = #{cityId} " , "</when> ", "<when test='districtId!=null and districtId!=\"\"'> ", "AND mbl.district_id = #{districtId} ", "</when> ", "<when test='sort!=null and sort!=\"\"'> ", "ORDER BY mbl.upload_time DESC ", "</when> ", "<when test='limit!=null and limit!=\"\"'> ", " ${limit} ", "</when> ", "</script>"})改成按照battery_work_mode =16、17、1、33、48、49、255 排序分页

<if test="params.examquestionId != null and params.examquestionId != ''"> and ( a.examquestion_id = #{params.examquestionId} ) </if> <if test="params.exampapertopicNumberStart != null and params.exampapertopicNumberStart != ''"> <![CDATA[ and a.exampapertopic_number >= #{params.exampapertopicNumberStart} ]]> </if> <if test="params.exampapertopicNumberEnd != null and params.exampapertopicNumberEnd != ''"> <![CDATA[ and a.exampapertopic_number <= #{params.exampapertopicNumberEnd} ]]> </if>这段sql语句有语法问题吗

<select id="selectCardKeyInfoList" parameterType="CardKeyInfo" resultMap="CardKeyInfoResult"> <include refid="selectCardKeyInfoVo"/> <where> <if test="cardKey != null and cardKey != ''"> and card_key = #{cardKey}</if> <if test="cardType != null "> and card_type = #{cardType}</if> <if test="deviceId != null and deviceId != ''"> and device_id = #{deviceId}</if> <if test="cardActivationTime != null "> and card_activation_time = #{cardActivationTime}</if> <if test="cardExpireTime != null "> and card_expire_time = #{cardExpireTime}</if> <if test="cardGenerateTime != null "> and card_generate_time = #{cardGenerateTime}</if> <if test="cardUpdater != null "> and card_updater = #{cardUpdater}</if> <if test="cardUpdateTime != null "> and card_update_time = #{cardUpdateTime}</if> <if test="cardCreator != null "> and card_creator = #{cardCreator}</if> </where> </select> Error attempting to get column 'card_key' from result set. Cause: java.sql.SQLDataException: Cannot determine value type from string 'IddCBY' ; Cannot determine value type from string 'IddCBY'; nested exception is java.sql.SQLDataException: Cannot determine value type from string 'IddCBY'

if (flag){ abc_flag = (id != null ? id : 1) if(id == null){ cd = 1 } } 如果用mybatis 表达要怎么写