一、概念
SpringBoot 2.0
开始推 HikariCP
,将默认的数据库连接池从 tomcat jdbc pool
改为了 hikari
, HikariCP
在性能和并发方面确实表现不俗(号称最快的连接池)。
如果你使用 spring-boot-starter-jdbc
或 spring-boot-starter-data-jpa
,会自动添加对 HikariCP
的依赖,也就是说此时使用 HikariCP
。当然你也可以强制使用其它的连接池技术,可以通过在 application.properties
或 application.yml
中配置 spring.datasource.type
指定。
二、各连接池对比
可以看一下这位朋友对几大主流数据库连接池的测试报告,结论是:hikariCP在并发较高的情况下,性能基本上没有下降。我自己也测试过,循环查询500次,13秒多
三、在项目中集成 Hikari 与Spring Data JPA,做个数据展示demo,实际项目中使用的 mybatis,后面会专文介绍
- 请在pom.xml中添加Maven依赖:HikariCP 、mysql-connector-java 、spring-boot-starter-data-jpa
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-data-jpa</artifactId>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>com.zaxxer</groupId>
<artifactId>HikariCP</artifactId>
<version>2.5.1</version>
</dependency>
<!-- 序列化与反序列化 -->
<dependency>
<groupId>com.alibaba</groupId>
<artifactId>fastjson</artifactId>
<version>1.2.47</version>
</dependency>
- 在application.properties中添加数据库配置,可在正式环境中加大maximum-pool-size值
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&maxReconnects=15000&allowMultiQueries=true&useSSL=false
spring.datasource.username=root
spring.datasource.password=root
# Hikari will use the above plus the following to setup connection pooling
spring.datasource.type=com.zaxxer.hikari.HikariDataSource
spring.datasource.hikari.minimum-idle=10
spring.datasource.hikari.maximum-pool-size=25
spring.datasource.hikari.auto-commit=true
spring.datasource.hikari.idle-timeout=30000
spring.datasource.hikari.pool-name=ExpendHikariCP
spring.datasource.hikari.max-lifetime=1800000
spring.datasource.hikari.connection-timeout=30000
spring.datasource.hikari.connection-test-query=SELECT 1
- 接下来需要在项目中添加entity、repository 架包,在entity架包下,添加 User.java文件,与数据库表字段对应,本文使用spring-data-jpa,后面会分享mybatis
@Entity
public class User {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY) //id自动增长
private int id;
@Column(nullable = false)
private String name;
@Column(nullable = false)
private int age;
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public int getAge() {
return age;
}
public void setAge(int age) {
this.age = age;
}
}
在repository架包下,新建UserRepository.java文件,继承 CrudRepository
@Repository
@Transactional
public interface UserRepository extends CrudRepository<User , Integer> {
/**
* 由JPA自动根据方法名生成查询sql
* @param id
* @return
*/
User findById(int id);
User findByName(String name);
void deleteById(int id);
//自定义sql
@Modifying
@Query(value = "select * from user",nativeQuery = true)
List<User> findAll();
}
再创建service架包,在其下添加inf、impl架包,分别在其下添加接口与实现
public interface IUserService {
void add(User user);
void edit(User user);
void delete(int id);
User findById(int id);
User findByName(String name);
List<User> findAll();
}
@Service
public class UserServiceImpl implements IUserService{
@Autowired private UserRepository userRepository;
@Override
public void add(User user) {
userRepository.save(user);
}
@Override
public void edit(User user) {
userRepository.save(user);
}
@Override
public void delete(int id) {
userRepository.deleteById(id);
}
@Override
public User findById(int id) {
return userRepository.findById(id);
}
@Override
public User findByName(String name) {
return userRepository.findByName(name);
}
@Override
public List<User> findAll() {
return userRepository.findAll();
}
}
最后,对写的代码进行测试,新建一个测试类,内容如下,右键测试方法点击运行一一测试,下面有测试图片,其中项目结构也在图片中,把user对象打印成字符串,就需要用到fastjson进行序列化
@RunWith(SpringRunner.class)
@SpringBootTest
public class UserTest {
@Autowired private IUserService userService;
@Test
public void add(){
User user = new User();
user.setName("zy");
user.setAge(26);
userService.add(user);
}
@Test
public void edit(){
User user = new User();
user.setId(1);
user.setName("zy1");
user.setAge(22);
userService.edit(user);
}
@Test
public void delete(){
userService.delete(1);
}
@Test
public void findById(){
User user = userService.findById(1);
System.out.println("user content :" + JSON.toJSONString(user));
}
@Test
public void findByName(){
User user = userService.findByName("zy1");
System.out.println("user content :" + JSON.toJSONString(user));
}
@Test
public void findAll(){
List<User> list = userService.findAll();
System.out.println("user content :" + JSON.toJSONString(list));
}
}