Mybatis xml快速编写

<?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>