解决属性名和字段名不一致的问题

1、问题

数据库中字段

 

 新建一个项目，拷贝之前的，测试实体类字段不一致的情况

package com.gt.pojo;


public class User {
    private int id;
    private String name;
    private String password;

    public User() {
    }

    public User(int id, String name, String password) {
        this.id = id;
        this.name = name;
        this.password = password;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public String getPassword() {
        return password;
    }

    public void setPassword(String password) {
        this.password = password;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", name='" + name + '\'' +
                ", password='" + password + '\'' +
                '}';
    }
}

测试出现问题

 

解决方法：  （1）起别名

    <select id="getUserById" parameterType="int" resultType="com.zyy.pojo.User">
        select id, name, pwd as `password` from `user` where id = #{id} limit 1
    </select>

输出结果：

 

（2）resultMap（结果集映射）

• id  name  pwd
• id  name  password

<?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">
<!--namespace=绑定一个对应的Dao/Mapper接口-->
<mapper namespace="com.gt.dao.UserMapper">

    <!--结果集映射-->
    <resultMap id="UserMap" type="com.gt.pojo.User">
        <!--        columns数据库中的字段，property实体类中的属性-->
        <result column="id" property="id"/>
        <result column="name" property="name"/>
        <result column="pwd" property="password"/>


    </resultMap>

    <select id="getUserById" parameterType="int" resultMap="UserMap">
    select * from mybatis.users where id = #{id}


    </select>


</mapper>

• resultMap 元素是 MyBatis 中最重要最强大的元素
• ResultMap 的设计思想是：对简单的语句做到零配置，对于复杂一点的语句，只需要描述语句之间的关系就行了。
• ResultMap 的优秀之处——你完全可以不用显式地配置它们

 扩展：

UserDaoTest

package com.gt.dao;

import com.gt.pojo.User;
import com.gt.utils.MybatisUtils;
import org.apache.ibatis.session.SqlSession;
import org.junit.Test;



public class UserDaoTest {

    @Test
    public void getUserLike() {
        SqlSession sqlSession = MybatisUtils.getSqlSession();

        UserMapper mapper = sqlSession.getMapper(UserMapper.class);

        User user = mapper.getUserById(1);
        System.out.println(user);


        sqlSession.close();

    }


}