# springboot-demo02

**Repository Path**: MarkPolaris/springboot-demo02

## Basic Information

- **Project Name**: springboot-demo02
- **Description**: springboot练习
- **Primary Language**: Unknown
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: None
- **GVP Project**: No

## Statistics

- **Stars**: 0
- **Forks**: 0
- **Created**: 2019-08-17
- **Last Updated**: 2020-12-19

## Categories & Tags

**Categories**: Uncategorized

**Tags**: None

## README

### springboot配置mybatis

1.依赖配置
```xml
<dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.0</version>
        </dependency>
<!--jdbc 数据源-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-jdbc</artifactId>
        </dependency>
<dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <scope>runtime</scope>
        </dependency>
```
2. 配置配置文件application.yml

> 这里没有用.propertites用的.yml，这种格式层次感更强，看起来更简洁清晰

```yaml
# 配置端口
server:
  port: 8888
# JDBC连接数据库
spring:
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://127.0.0.1:3306/bootshop?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false&serverTimezone=Asia/Shanghai
    username: root
    password: root

#数据库连接池
#有默认配置，可以不用配置

# mybatis配置
mybatis:
  mapper-locations: classpath*:/mapper/*.xml
  type-aliases-package: com.mark.springboot.entity
```

3. 项目结构

![D5cv2bdmxWKHNRV](https://images.gitee.com/uploads/images/2019/0819/203720_03838219_1775424.png)

4. 单元测试中测试

> 注意继承主测试类

```java
@Slf4j
public class AdminMapperTest extends SpringbootApplicationTests {
    @Resource
    private AdminMapper adminMapper;

    @Test
    public void findList(){
        List<Admin> lists = adminMapper.findList();
        log.info(lists+"");
    }

}
```

5. 运行结构

```textile
2019-08-17 17:49:06.619  INFO 14684 --- [           main] c.m.springboot.mapper.AdminMapperTest    : [Admin(id=1, username=mark, password=123)]

```

6. 参考

> [https://www.jianshu.com/p/d01ad165dd02](https://www.jianshu.com/p/d01ad165dd02)