saas-export项目-项目搭建-解决字段名与变量名不一致

• export_dao
  解决数字库表字段与类的成员变量不一致
  方式1：sql语句 使用 as
  方式2：mybatis里面使用resultMap标签
  

方式1：sql别名

ICompanyDao.xml

<mapper namespace="com.lfy.dao.company.ICompanyDao">
    <select id="findAll" resultType="company">
        select
           id,
           name,
           expiration_date as expirationDate,
           address,
           license_id as licenseId,
           representative,
           phone,
           company_size as companySize,
           industry,
           remarks,
           state,
           balance,
           city
        from ss_company
    </select>
</mapper>

方式2： resultMap标签

<mapper namespace="com.lfy.dao.company.ICompanyDao">
    <resultMap id="companyMap" type="company">
        <result property="id" column="id"/>
        <result property="expirationDate" column="expiration_date"/>
        <result property="licenseId" column="license_id"/>
        <result property="companySize" column="company_size"/>
    </resultMap>
    <select id="findAll" resultMap="companyMap">
        select
            *
        from ss_company
    </select>
</mapper>