通过SpringBoot配置整合Mybatis、Redis
学习SpringBoot框架,实操下整合配置Mybatis、redis
SpringBoot配置
步骤:
- 首先创建Maven项目后在pom.xml文件配置Springboot依赖包(可在Springboot官方查询相关入门教程:入口)
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.example</groupId>
<artifactId>myproject</artifactId>
<version>0.0.1-SNAPSHOT</version>
<!-- Inherit defaults from Spring Boot -->
<parent>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-parent</artifactId>
<version>2.1.4.RELEASE</version>
</parent>
<!-- Add typical dependencies for a web application -->
<dependencies>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-web</artifactId>
</dependency>
</dependencies>
</project>
- 主函数注解配置
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
@SpringBootApplication
public class MainApplication {
public static void main(String[] args){
SpringApplication.run(MainApplication.class, args);
}
}
- controller层注解配置
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
@Controller
@RequestMapping("/")
public class helloController {
@RequestMapping("/hello")
public String home() {
return "Hello World!";
}
}
总结:通过这样简单的配置,就能实现web项目的访问,不需要手动部署Tomcat等配置,及其方便
配置MyBatis
步骤:
- 首先,要用Maven将Mybatis所依赖的包导进来
<dependency>
<groupId>org.mybatis.spring.boot</groupId>
<artifactId>mybatis-spring-boot-starter</artifactId>
<version>1.3.1</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
</dependency>
<!-- 这里使用了druid来进行链接池配置-->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>druid</artifactId>
<version>1.0.5</version>
</dependency>
- 在springboot的配置文件(application.properties)中进行相关信息的配置
# mybatis
mybatis.type-aliases-package=com.imooc.miaosha.domain #封装类包的位置
mybatis.configuration.map-underscore-to-camel-case=true
mybatis.configuration.default-fetch-size=100
mybatis.configuration.default-statement-timeout=3000
mybatis.mapperLocations = classpath:com/imooc/miaosha/dao/*.xml #方法接口sql实现文件位置
# druid
#数据库链接池配置
spring.datasource.url=jdbc:mysql://XXX.XXX.XXXX.XXXX:3306/miaosha?useUnicode=true&characterEncoding=utf-8&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.filters=stat
spring.datasource.maxActive=2
spring.datasource.initialSize=1
spring.datasource.maxWait=60000
spring.datasource.minIdle=1
spring.datasource.timeBetweenEvictionRunsMillis=60000
spring.datasource.minEvictableIdleTimeMillis=300000
spring.datasource.validationQuery=select 'x'
spring.datasource.testWhileIdle=true
spring.datasource.testOnBorrow=false
spring.datasource.testOnReturn=false
spring.datasource.poolPreparedStatements=true
spring.datasource.maxOpenPreparedStatements=20
- 用注解实现数据库接口方法的实现(@Mapper)
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import com.imooc.miaosha.domain.User;
@Mapper
public interface UserDao {
@Select("select * from user where id = #{id}")
public User getById(@Param("id")int id );
@Insert("insert into user(id, name)values(#{id}, #{name})")
public int insert(User user);
}
总结:配置简单,这次使用Mybatis不是通过配置相应的mapper.XML文件来对接口方法的实现,而是使用@Mapper注解来完成。
配置Redis
步骤:
- 将redis所依赖包导入
<dependency>
<groupId>redis.clients</groupId>
<artifactId>jedis</artifactId>
</dependency>
- application.xml配置redis的相关属性
#redis
redis.host=XXX.XXX.XXX.XXX
redis.port=6379
redis.timeout=3
redis.password=123456
redis.poolMaxTotal=10
redis.poolMaxIdle=10
redis.poolMaxWait=3
- 注解方式redis对应的属性从配置文件读取导入到单例的 RedisConfig对象 中(
@ConfigurationProperties
),同时使用@Component
将该对象导入IOC容器
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.stereotype.Component;
@Component
@ConfigurationProperties(prefix="redis") //表示properties文件中的前缀所对应的属性
public class RedisConfig {
private String host;
private int port;
private int timeout;//秒
private String password;
private int poolMaxTotal;
private int poolMaxIdle;
private int poolMaxWait;//秒
//后续的get、set方法
}
- 注意:在进行jedis链接池配置获取连接时可能出现循环依赖问题,我的另一篇博客有相关解决方案(链接)
总结:@ConfigurationProperties
很好用很强大,不用再在对于dao.xml配置文件中配置对于的redis属性,可以同数据库等一同在properties文件中配置
结语:SpringBoot大大简化了很多配置,连服务器部署配置都帮你完成,及其方便,get到了几个常用注解的使用:
@SpringBootApplication、@RequestMapping、@Mapper、@ConfigurationProperties(prefix="")