Mybatis 碰到的一些问题

1. SQL语句参数无法获取：nested exception is org.apache.ibatis.reflection.ReflectionException: There is no getter for property named 'order_ids' in 'class java.lang.String'

XML映射文件配置：

 <select id="getTransferOrderListByOrderIds" parameterType="String" resultType="HashMap">
        select *
        from   wp_transfer_order
        WHERE  ORDER_SN IN (${order_ids})
  </select>

解决方法： 将parameterType="String"参数改为传一个自定义实体对象或者HashMap来封装这个id参数，就可以在自定义实体对象或者HashMap中找到这个id属性
参考地址：http://www.cnblogs.com/sishang/p/6555176.html


2. SQL语句参数错误：java.lang.RuntimeException: org.mybatis.spring.MyBatisSystemException: 
                    nested exception is org.apache.ibatis.builder.IncompleteElementException: 　
                    not find parameter map com.paycloud.interfaces.dao.AdminUserDao.AdminUserResultMap
(1) XML配置部分：

  <resultMap id="AdminUserResultMap" type="com.paycloud.interfaces.dto.AdminUserDto">
      <id column="MUID"           jdbcType="INTEGER"   property="muId" />
      <result column="ROLEID"     jdbcType="INTEGER"   property="roleId" />
      <result column="USERNAME"   jdbcType="VARCHAR"   property="userName" />
      <result column="PASSWORD"   jdbcType="VARCHAR"   property="passWord" />
      <result column="BINDIP"     jdbcType="VARCHAR"   property="bindIp" />
      <result column="LASTIP"     jdbcType="VARCHAR"   property="lastIp" />
      <result column="LASTLOGIN"  jdbcType="TIMESTAMP" property="lastLogin" />
      <result column="SALTS"      jdbcType="CHAR"      property="salts" />
      <result column="STATUS"     jdbcType="INTEGER"   property="status" />
      <result column="GOOGLECODE" jdbcType="VARCHAR"   property="googleCode" />
 </resultMap>

　　(2) SQL语句部分

　　错误案例:

 <!-- 添加用户 -->
  <insert id="addAdminUser"  parameterMap="AdminUserResultMap" >
      insert into sys_admin_user
          (ROLEID,USERNAME,PASSWORD,SALTS,STATUS,LASTLOGIN, GOOGLECODE)
      values
          (#{roleId},#{userName},#{passWord},#{salts},#{status},#{lastLogin}, #{googleCode})
  </insert>

　　修改后：

 <!-- 添加用户 -->
  <insert id="addAdminUser"  parameterType="com.paycloud.interfaces.dto.AdminUserDto" >
      insert into sys_admin_user
          (ROLEID,USERNAME,PASSWORD,SALTS,STATUS,LASTLOGIN, GOOGLECODE)
      values
          (#{roleId},#{userName},#{passWord},#{salts},#{status},#{lastLogin}, #{googleCode})
  </insert>

　

3. 注释搞的鬼：java.lang.RuntimeException: org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.type.TypeException:
Could not set parameters for mapping: ParameterMapping{property='pageIndex', mode=IN, javaType=class java.lang.Integer, jdbcType=null, numericScale=null, resultMapId='null', jdbcTypeName='null', expression='null'}. 
Cause: org.apache.ibatis.type.TypeException: Error setting non null for parameter #4 with JdbcType null . Try setting a different JdbcType for this parameter or a different configuration property. 
Cause: java.sql.SQLException: Parameter index out of range (4 > number of parameters, which is 3).

<!-- 交易统计报表 -->
 <select id="getTradeDayStatistics" resultType="Hashmap">
    SELECT SUM(t.ORDER_AMOUNT) as order_amount
    FROM wp_trade_order t
    WHERE t.ORDER_STATUS=1
          <if test="tranType != null and tranType != ''">         and t.TRAN_TYPE    = #{tranType}        </if>
          <if test="channelCode != null and channelCode != ''">   and t.CHANNEL_CODE = #{channelCode}     </if>
          <if test="startTime != null and startTime != ''">       and t.FINISH_TIME  >= #{startTime}    </if>
          <if test="endTime != null and endTime != ''">           and t.FINISH_TIME  <= #{endTime}      </if>
          <if test="minPayMoney != null and minPayMoney != ''">   and t.ORDER_AMOUNT >= #{minPayMoney} </if>
          <if test="maxPayMoney != null and maxPayMoney != ''">   and t.ORDER_AMOUNT <= #{maxPayMoney} </if>
   /*limit #{pageIndex}, #{pageSize}*/
 </select>

　有点粗心，没太在意注释的方式，因为颜色肯定是变灰了，所以出现这个错误。之后把注释去掉就好了。

 

  4.插入时间出现的问题 ： Error querying database.  Cause: java.lang.IllegalArgumentException: invalid comparison: java.util.Date and java.lang.String  

 <!-- 生成财务流水 -->
 <insert id="insertBillings" parameterType="com.paycloud.interfaces.dto.BillingsDto">
   INSERT INTO wp_billings
   <trim prefix="(" suffix=")" prefixOverrides=",">
      <if test="partnerId != null and partnerId != ''">,   PARTNER_ID         </if>
      <if test="tradeTime != null and tradeTime != ''">, TRADE_TIME         </if>
   </trim>
   <trim prefix="VALUES (" suffix=")" prefixOverrides=",">
      <if test="partnerId != null and partnerId != ''">,    #{partnerId}      </if>
      <if test="tradeTime != null and tradeTime != '' ">, #{tradeTime}      </if>
   </trim>
12  </insert>

   这是mybatis 3.3.0中对于时间参数进行比较时的一个bug. 如果拿传入的时间类型参数与空字符串''进行对比判断则会引发异常.

  所以  and tradeTime != ' ' 删除，只保留非空判断就正常了