SpringBoot 工程目录整合mybatis-mysql(xml类型)

谁借莪１个温暖的怀抱￠ 2022-10-25 12:52 119阅读 0赞

# 工程结构 #

├─java
    │  └─com
    │      └─claroja
    │          │  App.java
    │          │
    │          ├─controller
    │          │      MybatisController.java
    │          │
    │          ├─dao
    │          │      UserMapper.java
    │          │
    │          └─model
    │                  User.java
    │
    └─resources
        │  application.yml
        │
        └─mapper
                UserMapper.xml

# 数据准备 #

CREATE DATABASE `test`;
    
    DROP TABLE IF EXISTS `user`;
    CREATE TABLE `user` (
      `id` int(11) NOT NULL AUTO_INCREMENT,
      `username` varchar(50) DEFAULT NULL,
      `password` varchar(50) DEFAULT NULL,
      `name` varchar(50) DEFAULT NULL,
      PRIMARY KEY (`id`)
    ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
     
    INSERT INTO `user` VALUES ('1', 'zhangsan', '123', '张三');
    INSERT INTO `user` VALUES ('2', 'lisi', '123', '李四');

# resources #

`resources/application.yml`

spring:
      datasource: # 配置数据路连接驱动
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.2.222:3306/test?useUnicode=true&characterEncoding=utf8
        username: root
        password: 123456
    
    mybatis: # 配置mybatis
      type-aliases-package: com.claroja.model # 模型所在目录,xml中的resultType就不用写全类名了
      mapper-locations: classpath:mapper/*Mapper.xml # mapper.xml所在目录

`resources/mapper/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.claroja.dao.UserMapper">
        <select id="queryUserList" resultType="user">
            select * from user
        </select>
    </mapper>

# java.com.claroja #

`java/com/claroja/App.java`

package com.claroja;
    
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @SpringBootApplication
    public class App { 
        public static void main(String[] args) { 
            SpringApplication.run(App.class, args);
        }
    }

`java/com/claroja/controller/MybatisController.java`

package com.claroja.controller;
    
    import com.claroja.dao.UserMapper;
    import com.claroja.model.User;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.ResponseBody;
    
    import java.util.List;
    
    @Controller
    public class MybatisController { 
    
        @Autowired
        private UserMapper userMapper;
    
        @RequestMapping("/query")
        @ResponseBody
        public List<User> queryUserList(){ 
            List<User> users = userMapper.queryUserList();
            return users;
        }
    }

`java/com/claroja/dao/UserMapper.java`

package com.claroja.dao;
    
    import com.claroja.model.User;
    import org.apache.ibatis.annotations.Mapper;
    
    import java.util.List;
    
    @Mapper
    public interface UserMapper { 
        public List<User> queryUserList();
    }

`java/com/claroja/model/User.java`

package com.claroja.model;
    
    public class User { 
    
        private Long id;
        private String username;
        private String password;
        private String name;
    
        public Long getId() { 
            return id;
        }
    
        public void setId(Long id) { 
            this.id = id;
        }
    
        public String getUsername() { 
            return username;
        }
    
        public void setUsername(String username) { 
            this.username = username;
        }
    
        public String getPassword() { 
            return password;
        }
    
        public void setPassword(String password) { 
            this.password = password;
        }
    
        public String getName() { 
            return name;
        }
    
        public void setName(String name) { 
            this.name = name;
        }
    
        @Override
        public String toString() { 
            return "User{" +
                    "id=" + id +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    ", name='" + name + '\'' +
                    '}';
        }
    }

# POM #

<?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 https://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.4.2</version>
            <relativePath/> 
        </parent>
        <groupId>com.claroja</groupId>
        <artifactId>springboot-mybatis</artifactId>
        <version>0.0.1-SNAPSHOT</version>
        <name>springboot-mybatis</name>
        <description>Demo project for Spring Boot</description>
        <properties>
            <java.version>1.8</java.version>
        </properties>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-web</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-devtools</artifactId>
            </dependency>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-starter-test</artifactId>
                <scope>test</scope>
            </dependency>
            <dependency>
                <groupId>org.mybatis.spring.boot</groupId>
                <artifactId>mybatis-spring-boot-starter</artifactId>
                <version>2.1.3</version>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>8.0.22</version>
            </dependency>
        </dependencies>
    
        <build>
            <plugins>
                <plugin>
                    <groupId>org.springframework.boot</groupId>
                    <artifactId>spring-boot-maven-plugin</artifactId>
                </plugin>
            </plugins>
        </build>
    
    </project>

# 测试编写 #

`com.claroja.controller.MybatisControllerTest.java`

package com.claroja.controller;
    
    import com.claroja.dao.UserMapper;
    import com.claroja.model.User;
    import org.junit.jupiter.api.Test;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.boot.test.context.SpringBootTest;
    
    import java.util.List;
    
    @SpringBootTest
    class MybatisControllerTest { 
        @Autowired
        private UserMapper userMapper;
        @Test
        void queryUserList() { 
            List<User> users = userMapper.queryUserList();
            System.out.println(users);
        }
    }