<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.alibaba.我的项目.mapper.XXXXXMapper">
</mapper>
<resultMap id="BaseResultMap001" type="com.alibaba.项目名.pojo.XXX">
<!--@mbg.generated-->
<!--@Table 这里是注释 你可以不写,这里是表明映射的字段-->
<id column="wallet_id" jdbcType="INTEGER" property="walletId"/>
<result column="user_account" jdbcType="VARCHAR" property="userAccount"/>
<result column="green_num" jdbcType="INTEGER" property="greenNum"/>
<result column="purple_num" jdbcType="INTEGER" property="purpleNum"/>
<result column="yuanbao_num" jdbcType="INTEGER" property="yuanbaoNum"/>
<result column="zhendou_num" jdbcType="INTEGER" property="zhendouNum"/>
</resultMap>
使用方式
<select id="findOneInfo" resultMap="BaseResultMap001">
</select>
<sql id="mysqlList">
<!--@mbg.generated-->
wallet_id, user_account, green_num, purple_num, yuanbao_num, zhendou_num
</sql>
使用:
<select id="findOneInfo">
select <include refid="mysqlList"/> from
</select>
特殊说明: 解决问题的光鲜,藏着磕Bug的痛苦。 万物皆入轮回,谁也躲不掉! 以上文章,均是我实际操作,写出来的笔记资料,不会出现全文盗用别人文章!烦请各位,请勿直接盗用!