手动封装 resultMap_resultmap如何封装list-CSDN博客

如何手动封装resultMap?

需求：

查询所有的订单信息

数据库准备：

 CREATE DATABASE cyl DEFAULT CHARSET='UTF8';
 USE cyl;
 
#创建订单表
CREATE TABLE `order`(
	id INT PRIMARY KEY AUTO_INCREMENT,
	user_id INT NOT NULL ,
	number VARCHAR(50) NOT NULL,
	createtime DATETIME NOT NULL,
	note VARCHAR(100) DEFAULT NULL,
	CONSTRAINT FK_order_id  FOREIGN KEY (user_id) REFERENCES USER(id)
);

INSERT INTO `order` VALUES ('3', '12', '1000010', '2018-02-04 13:22:35', '备注3');
INSERT INTO `order` VALUES ('4', '10', '1000011', '2017-02-03 13:22:41', NULL);
INSERT INTO `order` VALUES ('5', '16', '1000012', '2019-02-12 16:13:23', NULL);
INSERT INTO `order` VALUES ('6', '22', '1000012', '2025-02-12 16:13:23', NULL);
INSERT INTO `order` VALUES ('7', '12', '1000012', '2020-02-12 16:13:23', NULL);

项目的目录结构（maven）：

注意修改成这样：

pom.xml:

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.itcast.mybatis_22</groupId>
    <artifactId>mybatis_22</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.2.8</version>
        </dependency>
        <dependency>
            <groupId>org.slf4j</groupId>
            <artifactId>slf4j-log4j12</artifactId>
            <version>1.7.10</version>
        </dependency>
        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.46</version>
        </dependency>

        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.16.0</version>
        </dependency>
    </dependencies>
</project>

resources:

OrderMapper.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">
<!--
1. namespace的名称为接口的完全路径名
2. sql语句的id值必须和接口中方法的名称一致
3. SQL语句的参数类型与接口方法中的参数类型一致
4. SQL语句的返回值类型与接口方法的返回值类型一致 (集合写的是泛型)
-->
<mapper namespace="com.itcast.mapper.OrderMapper">
    <!-- 1查询所有订单信息&ndash;&gt;-->
   <!-- <select id="findOrder" resultType="Order">
        select id,user_id as userId, number, createtime,note from `order`
    </select>-->


    <!--作用是将查询到数据库的字段和POJO对象的属性进行一个一一关联
        type:代表返回的数据类型,调用接口方法的时候的返回数据类型
    -->
    <resultMap id="OrderResultMap" type="order">
        <!--主键映射
            id代表的是主键
            property 代表的是pojo类中的字段名
            column 代表查询语句的字段
        -->
        <id property="id" column="id"></id>

        <!--非主键数据映射-->
        <result property="user_id" column="user_id"></result>
        <result property="number" column="number"></result>
        <result property="createtime" column="createtime"></result>
        <result property="note" column="note"></result>
    </resultMap>

    <select id="findOrder" resultMap="OrderResultMap">
        select id ,user_id,number,createtime,note from `order`
      /*   select id,user_id, number, createtime,note from `order`*/
    </select>
</mapper>

db.properties:

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/cyl?characterEncoding=utf-8
jdbc.username=root
jdbc.password=123456

log4j.properties:

# Global logging configuration
log4j.rootLogger=DEBUG, stdout
# Console output...
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

SqlMapConfig.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>
    <!--加载驱动配置-->
    <properties resource="db.properties"></properties>
    <!--起别名-->
    <typeAliases>
        <package name="com.itcast.pojo"></package>
    </typeAliases>
    <!-- 和spring整合后 environments配置将废除 -->
    <environments default="development">
        <environment id="development">
            <!-- 使用jdbc事务管理 -->
            <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.itcast.mapper"></package>
    </mappers>


</configuration>

JAVA代码：

OrderMapper：

package com.itcast.mapper;

import com.itcast.pojo.Order;

import java.util.List;

/**
 * @Version 1.0
 * @Author:cyl
 * @Date:2019/6/30 0030
 * @Content:
 */
public interface OrderMapper {
    public List<Order> findOrder();
}

Order：

package com.itcast.pojo;

import lombok.Data;

import java.util.Date;

/**
 * @Version 1.0
 * @Author:cyl
 * @Date:2019/6/29 0029
 * @Content:
 */
@Data
public class Order {
    private int id;
    private int user_id;
    private String number;
    private Date  createtime;
    private  String note;

    public Order() {
    }

    public Order(int id, int user_id, String number, Date createtime, String note) {
        this.id = id;
        this.user_id = user_id;
        this.number = number;
        this.createtime = createtime;
        this.note = note;
    }
}