pom.xml
相关jar包
<properties>
<java.version>1.8</java.version>
<mybatis-plus.starter.version>2.1.5</mybatis-plus.starter.version>
<mybatis.starter.version>2.0.1</mybatis.starter.version>
<druid.starter.version>1.1.20</druid.starter.version>
</properties>
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>${mybatis.starter.version}</version>
</dependency>
<!-- 添加MP依赖-->
<dependency>
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.1.2</version>
</dependency>
</dependency>
<!-- lombok 工具包-->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</dependency>
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid-spring-boot-starter</artifactId>
<version>${druid.starter.version}</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
application.yml:
spring:
datasource:
type: com.alibaba.druid.pool.DruidDataSource
druid:
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: 123456
url: jdbc:mysql://localhost:3306/travel?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
# druid 配置
initial-size: 5
max-active: 50
min-idle: 3
# 配置监控统计拦截器 日志配置 Slf4j logback
# stat 监控数据库性能
# wall 用于防火墙
# 日志先关 slf4j logback log4j log4j2
filter: stat,wall,slf4j
web-stat-filter:
enabled: true
log-slow-sql: true
url-pattern: /*
# 排除不拦截的 请求
exclusions: "*.js,*.png,/druid/*"
stat-view-servlet:
enabled: true
url-pattern: /druid/*
# 是否可以使用重置功能
reset-enable: true
login-username: admin
login-password: admin
# 允许访问的id
allow: 127.0.0.1
# 和名单
deny: ""
# mybatis整合
mybatis:
# 别名
type-aliases-package: com.vip.example2.domain.entity
configuration:
map-underscore-to-camel-case: true
mybatis-plus:
mapper-locations: classpath:mappers/**/*.xml
global-config:
db-config:
id-type: auto
logging:
level:
com.vip.example2.mapper: debug
测试入口:
package com.vip.example2;
import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
@MapperScan("com.vip.example2.mapper")
public class Example2Application {
public static void main(String[] args) {
SpringApplication.run(Example2Application.class, args);
}
}
单元测试:
package com.vip.example2.service;
import com.vip.example2.domain.entity.User;
import com.vip.example2.mapper.UserMapper;
import lombok.extern.slf4j.Slf4j;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.boot.test.context.SpringBootTest;
import org.springframework.test.context.junit4.SpringRunner;
import javax.annotation.Resource;
/**
* @author LFZicoo
* @date 2019/9/17 0:23
*/
@RunWith(SpringRunner.class)
@SpringBootTest
@Slf4j
public class UserServiceTest {
@Resource
UserMapper userMapper;
@Test
public void findByName(){
User user = new User();
user.setUsername("暴暴");
User user1 = userMapper.findByName(user.getUsername());
log.error(user1.toString());
}
}