06.06 Mybatis+logback的应用配置以及第一个查询demo的实现技术頭條網

06.06 Mybatis+logback的应用配置以及第一个查询demo的实现

为了方便理解各个配置文件里的路径，前面我先把目录结构贴出来

下面开始各个文件的配置：

1.pom文件配置

dependencies内引入以下所有库

 <properties>
 <swagger.version>2.6.1/<swagger.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-configuration-processor/<artifactid>
 /<dependency>
 <dependency>
 <groupid>org.springframework/<groupid>
 <artifactid>spring-test/<artifactid>
 /<dependency>
 <dependency>
 <groupid>io.springfox/<groupid>
 <artifactid>springfox-swagger2/<artifactid>
 <version>${swagger.version}/<version>
 /<dependency>
 <dependency>
 <groupid>io.springfox/<groupid>
 <artifactid>springfox-swagger-ui/<artifactid>
 <version>${swagger.version}/<version>
 /<dependency>
 <dependency>
 <groupid>org.projectlombok/<groupid>
 <artifactid>lombok/<artifactid>
 <version>1.16.12/<version>
 /<dependency>
 <dependency>
 <groupid>com.alibaba/<groupid>
 <artifactid>fastjson/<artifactid>
 <version>1.2.31/<version>
 /<dependency>
 <dependency>
 <groupid>org.mybatis.spring.boot/<groupid> 

 <artifactid>mybatis-spring-boot-starter/<artifactid>
 <version>1.3.0/<version>
 /<dependency>
 <dependency>
 <groupid>mysql/<groupid>
 <artifactid>mysql-connector-java/<artifactid>
 /<dependency>
 <dependency>
 <groupid>org.testng/<groupid>
 <artifactid>testng/<artifactid>
 <version>RELEASE/<version>
 /<dependency>
 
 <dependency>
 <groupid>org.jsoup/<groupid>
 <artifactid>jsoup/<artifactid>
 <version>1.11.2/<version>
 /<dependency>
 <dependency>
 <groupid>org.json/<groupid>
 <artifactid>json/<artifactid>
 <version>20180130/<version>
 /<dependency>
 <dependency>
 <groupid>org.apache.httpcomponents/<groupid>
 <artifactid>httpclient/<artifactid>
 <version>4.5.5/<version>
 /<dependency>
 <dependency>
 <groupid>org.apache.httpcomponents/<groupid>
 <artifactid>httpcore/<artifactid>
 <version>4.4.6/<version>
 /<dependency>
 /<dependencies>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 

16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65 

66
67
68
69
70
71
72
73

2.配置application.yml文件

resources目录下新建application.yml文件

server:
 port: 9528 //访问端口号
logging:
 path: logs
 file: mylog.log
spring:
 application:
 name: myTest
 datasource:
 driver-class-name: com.mysql.jdbc.Driver
 url: jdbc:mysql://localhost:3306/myBatisTest //提前准备好的mysql数据库地址
 username: root
 password: 123456
mybatis:
 type-aliases-package: com.course.model
 mapper-locations:
 - mapper/*
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15 

16
17
18
19
20

3.配置logback.xml文件

resources目录下新建logback.xml文件，文件内容为固定模板，也可自行在网上搜索模板文件。


<configuration>
 <include>
 <property>
 <property>
 <appender>
 <file>${LOG_PATH}/${LOG_FILE}/<file>
 <rollingpolicy>
 <filenamepattern>${LOG_PATH}/${LOG_FILE}.%d{yyyy-MM-dd}/<filenamepattern>
 /<rollingpolicy>
 <encoder>
 <pattern>${FILE_LOG_PATTERN}/<pattern>
 /<encoder>
 /<appender>
 <appender>
 <encoder>
 <pattern>${FILE_LOG_PATTERN}/<pattern>
 /<encoder>
 /<appender>
 <appender>
 <file>${LOG_PATH}/event.log/<file>
 <rollingpolicy>
 <filenamepattern>${LOG_PATH}/event.%d{yyyy-MM-dd}.log/<filenamepattern>
 <maxhistory>30/<maxhistory>
 /<rollingpolicy>
 <encoder>
 <pattern>%msg%n/<pattern>
 /<encoder>
 /<appender>
 <logger>
 <appender-ref>
 /<logger>
 <root> 

 <appender-ref>
 <appender-ref>
 /<root>
/<configuration>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46 

47

4.配置mybatis.xml文件

resources目录下新建mybatis.xml文件


br> PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
 <typealiases>
 <package>
 /<typealiases>
 <mappers>
 <mapper>
 /<mappers>
/<configuration>
1
2
3
4
5
6
7
8
9
10
11
12

5.配置mysql.xml文件

resources目录下新建mapper文件夹，再新建mysql.xml文件


br> PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
 "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper>
 <select>
 select count(*) from user; //这是最终要执行的sql语句 

 /<select>
/<mapper>
1
2
3
4
5
6
7
8
9
10

6.配置Application文件

main/java目录下新建com.course.controller文件，com.course目录下新建Application类

@EnableScheduling
@SpringBootApplication
public class Application {
 private static ConfigurableApplicationContext context;
 public static void main(String[] args){
 Application.context = SpringApplication.run(Application.class,args);
 }
 @PreDestroy
 public void close(){
 Application.context.close();
 }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

7.配置Demo文件

com.course.controller目录下新建Demo类

@RestController
@Api(value = "v1",description = "这是第一个版本的demo")
@RequestMapping("v1")
public class Demo {
 //首先获取一个执行sql语句的对象
 @Autowired
 private SqlSessionTemplate template;
 @RequestMapping(value = "/getUserCount",method = RequestMethod.GET)
 @ApiOperation(value = "可以获取到用户数",httpMethod = "GET")
 public int getUserCount(){
 return template.selectOne("getUserCount");
 }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17