本博文中使用的mysql与redis都是安装在阿里云服务器上的,本博文redis仅用来做缓存
使用的开发环境及其工具
1.开发环境:idea,jdk-9.0.4,apache-tomcat-9.0.24,apache-maven-3.6.0
2.msyql可视化工具:SQLyog
3.数据库连接池:druid
4.redis可视化工具:RedisClient
博文目录
- 创建StringBoot,修改pom,yml
- 编写实体类、redis配置类、mapper层(dao)、service层、controller层
- 运行启动类进行测试
- 集成时注意
一、创建StringBoot,修改pom,yml
添加依赖
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<!-- 引入MySQL数据库依赖 -->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.47</version>
</dependency>
<!-- 引入druid数据库连接 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.1.12</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>5.3.4</version>
</dependency>
<!--springboot2的需要导这个包,springboot1不需要-->
<dependency>
<groupId>org.apache.commons</groupId>
<artifactId>commons-pool2</artifactId>
<version>2.4.2</version>
</dependency>
<!-- redis-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-redis</artifactId>
</dependency>
<!-- https://mvnrepository.com/artifact/org.projectlombok/lombok -->
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<version>1.18.18</version>
<scope>provided</scope>
</dependency>
<!-- mybatis -->
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.0</version>
</dependency>
</dependencies>
修改yml文件
server:
port: 8090
spring:
datasource:
# 驱动配置信息
url: jdbc:mysql://8.*****.155:3306/spring_boot_redis?useUnicode=true&characterEncoding=utf8
username: root
password: ******
type: com.alibaba.druid.pool.DruidDataSource
driver-class-name: com.mysql.jdbc.Driver
redis:
host: 8.******.155
port: 6