Mybatis - 集成

application.properties

更新如下，添加mybatis配置与数据源配置。

#thymeleaf
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html
spring.thymeleaf.cache=false
spring.thymeleaf.content-type=text/html
spring.thymeleaf.enabled=true
spring.thymeleaf.encoding=UTF-8
spring.thymeleaf.mode=HTML5
# mybatis
mybatis.type-aliases-package=com.fengqiuhua.pro.entity
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.default-fetch-size=100
mybatis.configuration.default-statement-timeout=3000
mybatis.mapperLocations = classpath:com/fengqiuhua/pro/mapper/xml/*.xml
# druid
spring.datasource.url=jdbc:mysql://mysql-test.agilenaas.net:3307/company?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=ags@2020
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat
spring.datasource.maxActive=1000
spring.datasource.initialSize=100
spring.datasource.maxWait=60000
spring.datasource.minIdle=500
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=select 'x'
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxOpenPreparedStatements=20

mysql 新建 user表

CREATE TABLE `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
)
INSERT INTO `company`.`user` (`id`, `name`) VALUES ('1', '张三');

entity包下建实体类user

package com.fengqiuhua.pro.entity;
public class User {
    private int id;
    private String name;
    public int getId() {
        return id;
    }
    public void setId(int id) {
        this.id = id;
    }
    public String getName() {
        return name;
    }
    public void setName(String name) {
        this.name = name;
    }
}

新建UserDao

@Mapper
public interface UserDao {
    @Select("select * from user where id = #{id}")
    public User getById(@Param("id")int id    );
}

新建UserService

@Service
public class UserService {
    @Autowired
    UserDao userDao;
    public User getById(int id) {
        return userDao.getById(id);
    }
}

测试是否可访问数据库

修改如下：查出id为1的数据。

@Controller
public class TestController {
    @Autowired
    UserService userService;
    @GetMapping("/hello")
    @ResponseBody
    public Result<User> thymeleafTest(){
        User byId = userService.getById(1);
        return Result.success(byId);
    }
}