mybatis关于resultMap的简单使用

CREATE TABLE today_task (
  id INT PRIMARY KEY AUTO_INCREMENT COMMENT '主键',
  task_name VARCHAR (20) COMMENT '任务名称',
  task_owner VARCHAR (20) COMMENT '任务属主',
  task_content VARCHAR(255) COMMENT '任务内容',
  sex CHAR(1) COMMENT '任务性别',
  birth DATETIME COMMENT '任务创建时间'
)

INSERT INTO today_task(task_name,task_owner,task_content,sex,birth) VALUE
('学习mybatis','admin','','男',NOW()),
('学习spring','admin','','男',NOW()),
('学习springmvc','admin','','男',NOW()),
('学习linux','admin','','男',NOW()),
('学习消息中间件','admin','','男',NOW())

<resultMap id="getTodayTaskList" type="com.java.bean.TodayTask">
        <id property="taskId" column="id"/>
        <result property="taskName" column="task_name"/>
        <result property="taskOwner" column="task_owner"/>
        <result property="taskContent" column="task_content"/>
    </resultMap>
 
   <select id="getTaskList" resultMap="getTodayTaskList">
       SELECT  id,task_name,task_owner,task_content
           FROM  today_task  ORDER BY birth  DESC
   </select>

id元素，用于设置主键字段与领域模型属性的映射关系

result元素，用于设置普通字段与领域模型属性的映射关系

package com.java.mapper;
 
import com.java.bean.TodayTask;
 
import java.util.List;
 
public interface TodayTaskMapper {
 
    List<TodayTask> getTaskList();
}

package com.java;
 
import com.java.bean.TodayTask;
import com.java.mapper.TodayTaskMapper;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
 
import java.util.List;
 
/**
 * @author yourheart
 * @Description
 * @create 2022-05-15 22:21
 */
@RunWith(SpringRunner.class)
@SpringBootTest
@Slf4j
public class TodayTaskTests {
 
    @Autowired
    private TodayTaskMapper todayTaskMapper;
 
    @Test
    public void test(){
 
        List<TodayTask> taskList = todayTaskMapper.getTaskList();
 
        taskList.forEach(a->{
            log.info(a.toString());
        });
 
    }
}

package com.java.bean;
 
import lombok.Data;
 
import java.util.Date;
 
/**
 * @author yourheart
 * @Description
 * @create 2022-05-15 22:17
 */
@Data
public class TodayTask {
    /**
     * 主键id
     */
    private  Integer taskId;
 
    /**
     * 任务名称
     */
    private String taskName;
 
    /**
     * 任务属主
     */
    private String taskOwner;
 
    /**
     * 任务内容
     */
    private String taskContent;
 
    /**
     * 任务性别
     */
    private String sex;
 
    /**
     * 任务创建时间
     */
    private Date birth;
}

<?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>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.2.1.RELEASE</version>
        <relativePath/>
    </parent>
 
    <groupId>com.mysql</groupId>
    <artifactId>mysql-service</artifactId>
    <version>1.0-SNAPSHOT</version>
 
    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.49</version>
        </dependency>
        <!--lombok依赖-->
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <version>1.18.16</version>
        </dependency>
 
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
        </dependency>
 
    </dependencies>
 
 
</project>

server.port=3307
 
 
logging.level.com.java=debug
logging.level.web=debug
spring.devtools.add-properties=false
 
 
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/yourheart-dev?useUnicode=true&characterEncoding=utf-8&useSSL=false&allowMultiQueries=true
spring.datasource.username=root
spring.datasource.password=root
mybatis.mapper-locations=classpath:mapping/*.xml

package com.java;
 
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
 
/**
 * @author yourheart
 * @Description
 * @create 2022-05-14 23:53
 */
@SpringBootApplication
@MapperScan(basePackages = "com.java.mapper")
public class MysqlApplication {
    public static void main(String[] args) {
        SpringApplication.run(MysqlApplication.class, args);
    }
}