saas-export项目之字段名与变量名不一致

超、凢脫俗 2022-12-17 07:27 181阅读 0赞

export\_dao

*  （1）数字库 表字段 与类的成员变量 不一致
    
    ![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTM2MjEzOTg_size_16_color_FFFFFF_t_70_pic_center]

## 解决方法 ##

1.  sql语句 使用 `as`
2.  mybatis里面使用 resultMap

## 方法 1：sql别名 ##

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

## 方法2： resultMap标签 ##

![在这里插入图片描述][20201022152100937.png_pic_center]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTM2MjEzOTg_size_16_color_FFFFFF_t_70_pic_center 1]

<?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.lbl.dao.company.ICompanyDao">
    
        <resultMap id="companyMap" type="company" autoMapping="true">
            <id property="id" column="id"></id>
            <result property="expirationDate" column="expiration_date"></result>
            <result property="licenseId" column="license_id"></result>
            <result property="companySize" column="company_size"></result>
        </resultMap>
    
        <select id="findAll" resultMap="companyMap">
            select * from ss_company
        </select>
    </mapper>

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTM2MjEzOTg_size_16_color_FFFFFF_t_70_pic_center]: /images/20221123/3be063ac61da4dd28563fc37a0f96dd6.png
[20201022152100937.png_pic_center]: /images/20221123/171438077e0c4218900d645bc69a43ae.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3UwMTM2MjEzOTg_size_16_color_FFFFFF_t_70_pic_center 1]: /images/20221123/f6189c207ffe4185b6a234cc31a563a1.png