SpringBoot配置Druid数据源，持久层分别mybatis，jdbc

Druid与mybatis整合&＃xff1a;

application.yaml 配置参数文件

spring:datasource:#driver-class-name: com.mysql.jdbc.Driverdriver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/activiti10unit?characterEncoding&＃61;utf-8&serverTimezone&＃61;GMTusername: rootpassword: root#告知springboot 使用的链接池类型是druidtype: com.alibaba.druid.pool.DruidDataSourceinitialSize: 20maxActive: 30minIdle: 10userSSL: false

提示&＃xff1a;

mysql的connecto 驱动 jar 从5.1.33-5.1.37 的TimeUtil类存在bug&＃xff1b;

在连接的url后加一个参数 serverTimezone&＃61;GMT &＃xff0c;这里的时区可以根据自己数据库的设定来设置&＃xff0c;

mysql新的安全性设置要求SSL连接&＃xff0c;此处可以加一个参数userSSL&＃61;false&＃xff0c;或者自己设置SSL也可以

另外 6.0.2版本的driverClassName不再是原来的路径&＃xff0c;改成com.mysql.cj.jdbc.Driver了&＃xff1b;

否则会报以下错误&＃xff1a;

WARNING: Unexpected exception resolving reference
java.sql.SQLException: The server timezone value &＃39;◇□&＃39; is unrecognized or represents more than one timezone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc timezone value if you want to utilize timezone support.


com.example.mybatis2018.config.DruidConfig 配置参数类&＃xff0c;有些参数必须自己配置加载进容器&＃xff1a;

package com.example.mybatis2018.config;import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;&＃64;Configuration
public class DruidConfig {&＃64;ConfigurationProperties(prefix &＃61; "spring.datasource")&＃64;Beanpublic DruidDataSource druidDataSource(){return new DruidDataSource();}
}


使用mybatis持久层&＃xff0c;写mapper接口

com.example.mybatis2018.mapper.UserMapper

主键版&＃xff1a;

package com.example.mybatis2018.mapper;import com.example.mybatis2018.pojo.User;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Component;/*** 使用&＃64;Mapper主键 来标注这是一个Mapper接口*/
&＃64;Mapper
public interface UserMapper {&＃64;Select("select * from user where id &＃61; #{id}")User selectUserbyId(Long id);/*** 自增主键 select last_insert_id()* 非 自增主键 select uuid&＃xff08;&＃xff09; before&＃xff1a;true* &＃64;param user* &＃64;return*///自增主键&＃64;SelectKey(keyProperty &＃61; "id",keyColumn &＃61; "id",statement &＃61; "select last_insert_id()" ,before&＃61;false,resultType &＃61; Long.class)&＃64;Insert("insert into user (USER_NAEM,USER_PASSWORD) values(#{USER_NAEM},#{USER_PASSWORD})")int insertUser(User user);&＃64;Delete("delete from user where id &＃61; #{id}")int deleteUserById(Long id);&＃64;Update("update user set USER_NAEM&＃61;#{USER_NAEM},USER_PASSWORD &＃61; #{USER_PASSWORD} where id &＃61; #{id}")int updateUser(User user);
}

---------------------------------------------------------------------------------------------------------------

Druid与jdbc整合&＃xff1a;

因为starter-jdbc中自带HikariCp连接池&＃xff0c;需要剔除此链接池&＃xff0c;后再加入Druid连接池依赖&＃xff0c;后续配置参照上面与mybatis整合的配置一致&＃xff1b;

剔除原有连接池依赖

加入Druid连接池依赖

后面配置参照与mybatis整合的配置