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);
    }
}