SSM整合(一)

SSM整合之简单使用通用mapper

1.准备工作

1.1 在java文件夹下面创建所需要的目录

1.2 导入SSM整合时所需要的所有依赖

<properties>
        
        <spring.version>5.3.22spring.version>
    properties>
    
    <dependencies>
        
        <dependency>
            <groupId>org.springframework.datagroupId>
            <artifactId>spring-data-redisartifactId>
            <version>2.4.1version>
        dependency>
        
        <dependency>
            <groupId>redis.clientsgroupId>
            <artifactId>jedisartifactId>
            <version>3.3.0version>
        dependency>
        
        <dependency>
            <groupId>com.alibabagroupId>
            <artifactId>fastjsonartifactId>
            <version>1.2.75version>
        dependency>

        
        <dependency>
            <groupId>junitgroupId>
            <artifactId>junitartifactId>
            <version>4.13version>
            
            <scope>testscope>
        dependency>
        
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-coreartifactId>
            <version>${spring.version}version>
        dependency>
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-webartifactId>
            <version>${spring.version}version>
        dependency>
        
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-jdbcartifactId>
            <version>${spring.version}version>
        dependency>
        
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-txartifactId>
            <version>${spring.version}version>
        dependency>
        
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-webmvcartifactId>
            <version>${spring.version}version>
        dependency>
        
        <dependency>
            <groupId>com.fasterxml.jackson.coregroupId>
            <artifactId>jackson-databindartifactId>
            <version>2.11.3version>
        dependency>
        
        <dependency>
            <groupId>javax.servlet.jspgroupId>
            <artifactId>javax.servlet.jsp-apiartifactId>
            <version>2.3.1version>
        dependency>
        <dependency>
            <groupId>javax.servletgroupId>
            <artifactId>javax.servlet-apiartifactId>
            <version>3.0.1version>
        dependency>
        <dependency>
            <groupId>javax.servletgroupId>
            <artifactId>jstlartifactId>
            <version>1.2version>
        dependency>

        
        <dependency>
            <groupId>mysqlgroupId>
            <artifactId>mysql-connector-javaartifactId>
            <version>8.0.29version>
        dependency>
        
        <dependency>
            <groupId>commons-fileuploadgroupId>
            <artifactId>commons-fileuploadartifactId>
            <version>1.4version>
        dependency>
        
        <dependency>
            <groupId>log4jgroupId>
            <artifactId>log4jartifactId>
            <version>1.2.17version>
        dependency>
        
        <dependency>
            <groupId>org.slf4jgroupId>
            <artifactId>slf4j-apiartifactId>
            <version>1.7.25version>
        dependency>
        
        <dependency>
            <groupId>org.slf4jgroupId>
            <artifactId>slf4j-log4j12artifactId>
            <version>1.7.25version>
        dependency>
        
        <dependency>
            <groupId>org.springframeworkgroupId>
            <artifactId>spring-testartifactId>
            <version>${spring.version}version>
            <scope>testscope>
        dependency>
        
        <dependency>
            <groupId>org.aspectjgroupId>
            <artifactId>aspectjweaverartifactId>
            <version>1.9.1version>
        dependency>
        
        <dependency>
            <groupId>com.alibabagroupId>
            <artifactId>druidartifactId>
            <version>1.1.23version>
        dependency>
        
        <dependency>
            <groupId>com.github.pagehelpergroupId>
            <artifactId>pagehelperartifactId>
            <version>5.2.0version>
        dependency>
        
        <dependency>
            <groupId>tk.mybatisgroupId>
            <artifactId>mapperartifactId>
            <version>4.2.1version>
        dependency>
        
        <dependency>
            <groupId>org.mybatisgroupId>
            <artifactId>mybatisartifactId>
            <version>3.5.6version>
        dependency>
        
        <dependency>
            <groupId>org.mybatisgroupId>
            <artifactId>mybatis-springartifactId>
            <version>2.0.6version>
        dependency>
        
        <dependency>
            <groupId>org.projectlombokgroupId>
            <artifactId>lombokartifactId>
            <version>1.18.18version>
        dependency>
    dependencies>

    
    <build>
        <resources>
            <resource>
                <directory>src/main/javadirectory>
                <includes>
                    <include>**/**include>
                includes>
            resource>
            <resource>
                <directory>src/main/resourcesdirectory>
                <includes>
                    <include>**/**include>
                includes>
            resource>
        resources>
    build>
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
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192

2 mybatis部分

2.1 resource文件夹下创建jdbc.properties文件,并书写以下内容

2.1.1 jdbc文件内容

2# key-value 形式的文件
jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://127.0.0.1:3305/db0618
jdbc.username=root
jdbc.password=root
1
2
3
4
5

2.1.2 创建后的目录结构

2.2 配置spring-db.properties文件

2.2.1 组件扫描

<context:component-scan base-package="com">
    
    <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    <context:exclude-filter type="annotation" expression="org.springframework.web.bind.annotation.RestController"/>
context:component-scan>
1
2
3
4
5
6

2.2.2 开启注解模式

<context:annotation-config/>
1
2

2.2.3 引入资源文件

<context:property-placeholder location="classpath:/jdbc.properties"/>
1
2

2.2.4 配置数据库连接池druid

<bean id="dataSource"
      class="com.alibaba.druid.pool.DruidDataSource" init-method="init"
      destroy-method="close">
    
    
    <property name="driverClassName" value="${jdbc.driver}" />
    
    <property name="url" value="${jdbc.url}" />
    <property name="username" value="${jdbc.username}" />
    <property name="password" value="${jdbc.password}" />
    
    <property name="initialSize" value="5" />
    <property name="minIdle" value="1" />
    <property name="maxActive" value="20" />
    
    <property name="maxWait" value="60000" />
    
    <property name="timeBetweenEvictionRunsMillis" value="60000" />
    
    <property name="minEvictableIdleTimeMillis" value="300000" />
    
    <property name="validationQuery" value="select 1" />
    
    <property name="testWhileIdle" value="true" />
    
    <property name="testOnBorrow" value="false" />
    
    <property name="testOnReturn" value="false" />
bean>
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

2.3 测试连接池是否配置成功

2.3.1 在resource文件夹下创建log4j.properties文件,并书写以下内容

#\u4EE3\u8868root\u8282\u70B9\u6574\u4E2A\u5DE5\u7A0B\u4E0B\u6240\u6709\u8F93\u51FA\u65E5\u5FD7\u7684\u5730\u65B9\u914D\u7F6E\u7684\u8F93\u51FA\u7684\u7EA7\u522B\u548C\u8F93\u51FA\u7684\u4F4D\u7F6E\u3002
log4j.rootLogger=DEBUG,Console,D
#\u4EE3\u8868\u914D\u7F6E\u63A7\u5236\u53F0\u7684\u7C7B\u3002
log4j.appender.Console=org.apache.log4j.ConsoleAppender
log4j.appender.Console.layout=org.apache.log4j.PatternLayout
log4j.appender.Console.layout.ConversionPattern=%d [%t] %-5p [%c] - %m%n
log4j.logger.org.apache=INFO

log4j.logger.java.sql.ResultSet=INFO
log4j.logger.java.sql.Connection=DEBUG  
log4j.logger.java.sql.Statement=DEBUG  
log4j.logger.java.sql.PreparedStatement=DEBUG
### \u8F93\u51FA\u5230\u65E5\u5FD7\u6587\u4EF6 ###
log4j.appender.D = org.apache.log4j.DailyRollingFileAppender
log4j.appender.D.File = log/ssm.log
log4j.appender.D.Append = true
log4j.appender.D.Threshold = DEBUG
log4j.appender.D.layout = org.apache.log4j.PatternLayout
log4j.appender.D.layout.ConversionPattern =%-d{yyyy-MM-dd HH\:mm\:ss}  [ %t\:%r ] - [ %p ]  %m%n
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

2.3.2 测试代码

import com.alibaba.druid.pool.DruidDataSource;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringRunner;

import javax.annotation.Resource;

@RunWith(SpringRunner.class)
/*classpath表示类路径 里面写的是xml文件的路径*/
@ContextConfiguration({
        "classpath:/spring-db.xml"
})
public class MyTest {
    /*查看数据眼是否正确*/
    @Resource
    DruidDataSource bbs;
    @Test
    public void a(){
        System.out.println(bbs);
    }
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

2.3.4 测试运行截图

2.4 创建spring-mybatis.xml文件

2.4.1 通用mapper扫描

<bean class="tk.mybatis.spring.mapper.MapperScannerConfigurer">
    <property name="basePackage" value="com.mapper">property>
bean>
1
2
3
4

2.4.2 sqlSessionFactoryBean配置数据源引用(jdbc.properties)

a 代码部分

<bean class="org.mybatis.spring.SqlSessionFactoryBean">
    
    <property name="dataSource" ref="dataSource">property>
bean>
1
2
3
4
5

b 出现的小问题

配置是出现如下红色(不进行修改,程序也是可以正常运行的)

c 小问题解决方案

c.1 点击file—>project Structure

c.2 facets➡选择你的项目➡点击+号

c.3 点击单选➡点击ok按钮

c.4 再点击ok按钮

c.5 配置后的结果(未出现红色)

2.4.3 sqlSessionFactoryBean中配置实体类别名(相当于之前的typeAliases)

<property name="typeAliasesPackage" value="com.entity">property>
1
2

2.4.4 mapper.xml文件扫描

 
<property name="mapperLocations" value="classpath:/mapper/*.xml">property>
1
2

2.4.5 加载mybatis主配置文件

<property name="configLocation" value="classpath:/mybatis-config.xml">property>
1
2

2.4.6 配置分页插件

<property name="plugins">
    <array>
        <bean class="com.github.pagehelper.PageInterceptor">
            <property name="properties">
                
                <value>
                    helperDialect=mysql
                    reasonable=true
                value>
            property>
        bean>
    array>
property>
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18

2.5 测试通用mapper是否能用

2.5.1 创建实体类Songs

package com.entity;
import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;
import org.springframework.data.annotation.Id;
import tk.mybatis.mapper.annotation.KeySql;
import java.io.Serializable;
@AllArgsConstructor
@NoArgsConstructor
@Data
public class Songs implements Serializable {
    @Id
    @KeySql(useGeneratedKeys = true) //主键回填
    private Integer id;
    private String singerName;
    private String album;
    private String albumImg;
    private String name;
    private String releaseDate;
    private static final long serialVersionUID=1L;
}
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

2.5.2 在com/mapper文件夹下面创建SongsMapper接口,并写如下语句

package com.mapper;
/*继承tk这个包*/
import com.entity.Songs;
import tk.mybatis.mapper.common.Mapper;

public interface SongsMapper extends Mapper<Songs> {
}
1
2
3
4
5
6
7

2.5.3 在测试代码里面配置spring-mybatis.xml文件

@ContextConfiguration({
        "classpath:/spring-db.xml",
        "classpath:/spring-mybatis.xml"
})
1
2
3
4

2.5.4 测试代码

public class MyTest {
    @Resource
    SongsMapper songsMapper;
    @Test
    public void a(){
        PageHelper.startPage(1,10);
        songsMapper.selectAll().forEach(System.out::println);
    }
1
2
3
4
5
6
7
8

2.5.5 测试代码运行截图