MyBatis的ORM映射

目录截图:

 RoleMapper接口:

public interface RoleMapper {
    List<Role> findAll();

    List<Role> findAll2();
}

  RoleMapper.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.by.mapper.RoleMapper">
    <select id="findAll" resultType="com.by.pojo.Role">
        select id, role_name as roleName, role_desc as roleDesc from role
    </select>

    <!--
        结果映射
            id="findAll2ResultMap" ：resultMap标签的id，，必须唯一
            type="com.by.pojo.Role"：等价于resultType
    -->
    <resultMap id="findAll2ResultMap" type="com.by.pojo.Role">
        <!--主键字段和属性的映射关系-->
        <id column="id" property="id"></id>
        <!--非主键字段和属性的映射关系-->
        <result column="role_name" property="roleName"></result>
        <result column="role_desc" property="roleDesc"></result>
    </resultMap>
    <!--
        resultMap：resultMap标签的id
    -->
    <select id="findAll2" resultMap="findAll2ResultMap">
        select * from role
    </select>
</mapper>

UserMapper接口:

public interface UserMapper {
    List<User> findAll();
}

 UserMapper.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.by.mapper.UserMapper">
    <!--
        id：和接口的方法名保持一致
        resultType：返回值类型
    -->
    <select id="findAll" parameterType="com.by.pojo.User" resultType="com.by.pojo.User">
        select * from user where id=#{id} and name=#{name}
    </select>
</mapper>

pojo类代码:

Role类:

public class Role {
    private Integer id;
    private String roleName;
    private String roleDesc;

    public Integer getId() {
        return id;
    }

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

    public String getRoleName() {
        return roleName;
    }

    public void setRoleName(String roleName) {
        this.roleName = roleName;
    }

    public String getRoleDesc() {
        return roleDesc;
    }

    public void setRoleDesc(String roleDesc) {
        this.roleDesc = roleDesc;
    }

    @Override
    public String toString() {
        return "Role{" +
                "id=" + id +
                ", roleName='" + roleName + '\'' +
                ", roleDesc='" + roleDesc + '\'' +
                '}';
    }
}

User类: 

public class User implements Serializable {
    private Integer id;
    private String username;
    private Date birthday;
    private String sex;
    private String address;

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

    public void setUsername(String username) {
        this.username = username;
    }

    public Date getBirthday() {
        return birthday;
    }

    public void setBirthday(Date birthday) {
        this.birthday = birthday;
    }

    public String getSex() {
        return sex;
    }

    public void setSex(String sex) {
        this.sex = sex;
    }

    public String getAddress() {
        return address;
    }

    public void setAddress(String address) {
        this.address = address;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", username='" + username + '\'' +
                ", birthday=" + birthday +
                ", sex='" + sex + '\'' +
                ", address='" + address + '\'' +
                '}';
    }
}

mybatis-config.xml配置文件代码:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <!--使用dev环境-->
    <environments default="dev">
        <environment id="dev">
            <!--事务-->
            <transactionManager type="JDBC"></transactionManager>
            <!--
                type="POOLED"：连接池
            -->
            <dataSource type="POOLED">
                <!--mysql8-->
                <!--
                    <property name="driver" value="com.mysql.cj.jdbc.Driver"/>
                    <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis?useSSL=false&amp;serverTimezone=Asia/Shanghai"/>
                -->
                <property name="driver" value="com.mysql.jdbc.Driver"/>
                <property name="url" value="jdbc:mysql://127.0.0.1:3306/mybatis?characterEncoding=UTF-8"/>
                <property name="username" value="root"/>
                <property name="password" value="1111"/>
            </dataSource>
        </environment>
    </environments>
    <!--加载mapper映射文件-->
    <mappers>
        <mapper resource="com/by/mapper/UserMapper.xml"></mapper>
        <mapper resource="com/by/mapper/RoleMapper.xml"></mapper>
    </mappers>
</configuration>

测试类代码:

public class MyBatisTest {
    private SqlSession sqlSession;
    private InputStream inputStream;

    @Before
    public void init() throws IOException {
        //加载mybatis-config.xml
        String resource = "mybatis-config.xml";
        inputStream = Resources.getResourceAsStream(resource);

        //创建sqlSessionFactory
        SqlSessionFactory sessionFactory = new SqlSessionFactoryBuilder().build(inputStream);

        //创建sqlSession
        sqlSession = sessionFactory.openSession();
    }

    @Test
    public void testFindAll(){
        RoleMapper roleMapper = sqlSession.getMapper(RoleMapper.class);
        List<Role> roleList = roleMapper.findAll();
        for (Role role : roleList) {
            System.out.println(role);
        }
    }

    @Test
    public void testFindAll2(){
        RoleMapper roleMapper = sqlSession.getMapper(RoleMapper.class);
        List<Role> roleList = roleMapper.findAll2();
        for (Role role : roleList) {
            System.out.println(role);
        }
    }

    @After
    public void close() throws IOException {
        sqlSession.close();
        inputStream.close();
    }
}