mybatis自写sql处理业务之mapper文件中传入参数与结果参数的各种数据类型处理

Mapper.xml文件

<mapper namespace="com.xxx.xxxAddMapper">

   //映射关系
    <resultMap id="MemberBaseInfo" type="com.whhim.flb.mapper.dto.flb.QrcodeUseDTO">
        <result column="nick_name" property="nickName" jdbcType="VARCHAR"/>
        <result column="qrcode" property="qrcode" jdbcType="VARCHAR"/>
        <result column="province" property="province" jdbcType="VARCHAR"/>
        <result column="city" property="city" jdbcType="VARCHAR"/>
        <result column="operate_time" property="operateTime" jdbcType="TIMESTAMP"/>
        <result column="card_name" property="cardName" jdbcType="VARCHAR"/>
        <result column="the_value" property="theValue" jdbcType="DECIMAL"/>
    </resultMap>


    <select id="queryQrCodeUseData" parameterType="java.lang.String" resultMap="MemberBaseInfo">
        select info.nick_name, use.qrcode,use.province,use.city,use.operate_time,card.card_name,round(cast(red.the_value as numeric)/100,2) as the_value
        from use_record use
        left join cust_info info
        on use.member_id = info.customer_no
        left join red_packet_record red
        on use.member_id = red.member_id
        left join lottery_card card
        on use.card_id = card.id
        where use.qrcode = #{qrcode}
    </select>
</mapper>

Mapper对应得接口

 List<QrcodeUseDTO> queryQrCodeUseData(@Param("qrcode") String qrcode);
//如果传入是对象，则如下
//xml中
parameterType="com.whhim.flb.common.pojos.dl.DlTaskReq"
//接口中
selectMemberTaskRecordByType(DlTaskReq req);
-----------------------------------------
//如果传入是list，则如下
//xml中
parameterType="java.util.ArrayList"
/**
 <foreach collection="list"  item="id" index="index" separator=",">   
             #{id}   
          </foreach>   
*/
//接口中
insertBatchMemberTask(List<DlMemberTaskInfo> memberTaskInfos);

---

未完待续