搭建SpringBoot整合Mybatis框架

╰半橙微兮° 2023-02-21 11:46 22阅读 0赞

![format_png][]

每天叫醒你的不是闹钟，而是梦想

本章节主要搭建一个简单SpringBoot与Mybatis的框架,给大家复习复习,也给自己复习复习。

**● *新建一个Spring Initializr项目***

![format_png 1][]

**● *选择所需要的依赖***

![format_png 2][]

**● *创建配置文件***

***application.yml***

spring:
      profiles:
        active: dev

application-dev.yml

server:
      port: 8080
    spring:
      datasource:
        username: root
        password: 123456
        url: jdbc:mysql://localhost:3306/hyt?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC
        driver-class-name: com.mysql.jdbc.Driver
    
    mybatis:
      mapper-locations: classpath*:mapping/*Mapping.xml
      type-aliases-package: com.zero.appadmin.entity

这里根据自己需要可以分为dev、test、prod

**● *controller***

package com.zero.appadmin.controller;
    
    import com.zero.appadmin.entity.User;
    import com.zero.appadmin.service.IUserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.web.bind.annotation.RequestMapping;
    import org.springframework.web.bind.annotation.RestController;
    
    @RestController
    public class UserController {
    
        @Autowired
        private IUserService userService;
    
    
    
        @RequestMapping("/test")
        public String test (){
            User select = userService.select("1");
            System.out.println(select);
            return select.toString();
        }
    }

**● *service***

package com.zero.appadmin.service;
    
    import com.zero.appadmin.entity.User;
    
    public interface IUserService {
        User select();
    }

impl

package com.zero.appadmin.service.impl;
    
    import com.zero.appadmin.entity.User;
    import com.zero.appadmin.mapper.UserMapper;
    import com.zero.appadmin.service.IUserService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    @Service
    public class UserServiceImpl implements IUserService {
    
        @Autowired
        private UserMapper userMapper;
    
    
        @Override
        public User select() {
    
            return userMapper.selectid();
    
    
        }
    }

**● *mapper***

package com.zero.appadmin.mapper;
    
    import com.zero.appadmin.entity.User;
    import org.springframework.stereotype.Repository;
    
    @Repository
    public interface UserMapper {
    
        User selectid();
    }

**● *entity***

package com.zero.appadmin.entity;
    
    import java.io.Serializable;
    
    public class User implements Serializable {
        private Long id;
    
        private String username;
    
        private String password;
    
        private String address;
    
        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 getAddress() {
            return address;
        }
    
        public void setAddress(String address) {
            this.address = address;
        }
    
        @Override
        public String toString() {
            return "User{" +
                    "id=" + id +
                    ", username='" + username + '\'' +
                    ", password='" + password + '\'' +
                    ", address='" + address + '\'' +
                    '}';
        }
    }

**● 数据库**

![format_png 3][]

**● *数据库映射mapping文件***

<?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.zero.appadmin.mapper.UserMapper">
        <resultMap id="BaseResultMap" type="com.zero.appadmin.entity.User">
            <result column="id" property="id"></result>
            <result column="username" property="username"></result>
            <result column="password" property="password"></result>
            <result column="address" property="address"></result>
    
        </resultMap>
    
        <select id="selectid" resultType="com.zero.appadmin.entity.User">
            select * from t_user limit 10
        </select>
    </mapper>

**● *最后框架结构***

![format_png 4][]

**● *在启动类加上扫描的mapper文件的路径***

package com.zero.appadmin;
    
    import org.mybatis.spring.annotation.MapperScan;
    import org.springframework.boot.SpringApplication;
    import org.springframework.boot.autoconfigure.SpringBootApplication;
    
    @MapperScan("com.zero.appadmin.mapper")
    @SpringBootApplication
    public class AppAdminApplication {
    
        public static void main(String[] args) {
            System.out.println("hello world");
            SpringApplication.run(AppAdminApplication.class, args);
        }
    
    }

**● *启动访问***

![format_png 5][]

![format_png 6][]

我知道你**在看**哟

![format_png 7][]

[format_png]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X2dpZi9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenQ4dVh3VmtDY05VaWJPODc4bWxtTDBhMGVpYWRLOGZvTFRmRHFyRWpENmljUmx5RHVYbWFEQXppYkhBLzY0MA?x-oss-process=image/format,png
[format_png 1]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenRqUllBcktDcElYSWxXYWlhUUJCOURtRkVvSHhpY0dpYWx6ZlM2bUNWTThrSU1jOHN0MW80TzBRVUEvNjQw?x-oss-process=image/format,png
[format_png 2]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenRuQk1ReGhjMUtJOHlDalE5eHNpYUhNU2lhS2g3WDhpYkhGa3h5RUZYbzFRY3M4TGljUjBua3FxUnVnLzY0MA?x-oss-process=image/format,png
[format_png 3]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenRqSUdwaWJqNnBOVEt1UGxreDNGWEdETFB6WjJiRkNCaHpiRlZVOG5zd2sweWtyeXUxbEgxd3FBLzY0MA?x-oss-process=image/format,png
[format_png 4]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenRVQjU0cXZXZmpUM1FUQ093Rmp4aWN5c1BMUXpla242Y3FlNW9hY1dQM3A4dkI0OURETmJETVFBLzY0MA?x-oss-process=image/format,png
[format_png 5]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenQ1QnRYaWNjS2pSZUJiOEcxNElKRjNjaWJXaWN1UnI4VkZqZkdWaWJxSFVUOG5pYzhMWGNtZ0NYUkc1QS82NDA?x-oss-process=image/format,png
[format_png 6]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenRvdjFFaWN4M25DdXd3cUJrWmNNbHp5RUwzck5PRXRsV1pTRTlpY0hMRE81SkxlVHU1aFQ4TndrZy82NDA?x-oss-process=image/format,png
[format_png 7]: https://imgconvert.csdnimg.cn/aHR0cHM6Ly9tbWJpei5xcGljLmNuL21tYml6X3BuZy9PalpmWGtUTTYxN0gwZ1MxWVhIWmljc3NVNGJ4c3hGenRidkxCcVUzTVhoZEhVVDJrQndVNFBRVGpNbGljd3lFb2JqSTQ4aWJwVVg1VzZnM1RwbWszOWVXZy82NDA?x-oss-process=image/format,png