【MyBatis字段名属性名不一致的方法2、3】全局配置、ResultMap

2.核心配置文件mybati-config添加settings

mapUnderscoreToCamelCase，是否开启驼峰命名自动映射，即从经典数据库列名 A_COLUMN 映射到经典 Java 属性名 aColumn。

mybati-config

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="jdbc.properties"/>
<!--设置mybatis的全局配置-->
<settings>
    <setting name="mapUnderscoreToCamelCase" value="true"/>
</settings>

    <typeAliases>
        <package name="com.zy.mybatis.pojo"/>
    </typeAliases>

    <environments default="development">
        <environment id="development">
            <transactionManager type="JDBC"/>
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driver}"/>
                <property name="url" value="${jdbc.url}"/>
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>

    <mappers>
        <package name="com.zy.mybatis.mapper"/>
    </mappers>
</configuration>

EmpMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.mybatis.mapper.EmpMapper">

<!--List<Emp> getAllEmp();-->
 <!--起别名的形式-->
        <!--select eid,emp_name empName,age,sex,email from t_emp -->
<!--全局配置-->
    <select id="getAllEmp" resultType="Emp">
    
        select * from t_emp

    </select>
</mapper>

3 ResultMap

<resultMap id="empResultMap" type="Emp">

resultMap：设置自定义映射关系

id：唯一标识，不能重复

type：设置映射关系中的实体类类型

       <id property="eid" column="eid"></id>
        <result property="empName" column="emp_name"></result>
        <result property="age" column="age"></result>
        <result property="sex" column="sex"></result>
        <result property="email" column="email"></result>

id：设置主键的映射关系

result：设置普通字段的映射关系

属性：

property：设置映射关系中的属性名，必须是type属性设置的实体类类型中的属性名

column：设置映射关系中的字段名，必须是sql语句查询出的字段名

EmpMapper.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.mybatis.mapper.EmpMapper">
    <!--List<Emp> getAllEmp();-->

<!--1起别名的形式-->
    <!--select eid,emp_name empName,age,sex,email from t_emp -->

<!--2全局配置-->
    <!--<select id="getAllEmp" resultType="Emp">
        select * from t_emp
    </select>-->

<!--3 ResultMap-->
    <resultMap id="empResultMap" type="Emp">
        <id property="eid" column="eid"></id>
        <result property="empName" column="emp_name"></result>
        <result property="age" column="age"></result>
        <result property="sex" column="sex"></result>
        <result property="email" column="email"></result>
    </resultMap>

    <select id="getAllEmp" resultMap="empResultMap">
        select * from t_emp
    </select>



</mapper>