Druid与mybatis整合：
application.yaml 配置参数文件
spring:datasource:#driver-class-name: com.mysql.jdbc.Driverdriver-class-name: com.mysql.cj.jdbc.Driverurl: jdbc:mysql://localhost:3306/activiti10unit?characterEncoding=utf-8&serverTimezone=GMTusername: rootpassword: root#告知springboot 使用的链接池类型是druidtype: com.alibaba.druid.pool.DruidDataSourceinitialSize: 20maxActive: 30minIdle: 10userSSL: false
提示：
mysql的connecto 驱动jar 从5.1.33-5.1.37 的TimeUtil类存在bug；
在连接的url后加一个参数 serverTimezone=GMT ，这里的时区可以根据自己数据库的设定来设置，
mysql新的安全性设置要求SSL连接，此处可以加一个参数userSSL=false，或者自己设置SSL也可以
另外 6.0.2版本的driverClassName不再是原来的路径，改成com.mysql.cj.jdbc.Driver了；
否则会报以下错误：
WARNING: Unexpected exception resolving referencejava.sql.SQLException: The server timezone value '◇□' 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.mybatis.config.DruidConfig配置参数类，有些参数必须自己配置加载进容器：
package com.example.mybatis.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;@Configurationpublic class DruidConfig {@ConfigurationProperties(prefix = "spring.datasource")@Beanpublic DruidDataSource druidDataSource(){return new DruidDataSource();}}
使用mybatis持久层，写mapper接口
com.example.mybatis.mapper.UserMapper
主键版：
package com.example.mybatis.mapper;import com.example.mybatis.pojo.User;import org.apache.ibatis.annotations.*;import org.ponent;/*** 使用@Mapper主键 来标注这是一个Mapper接口*/@Mapperpublic interface UserMapper {@Select("select * from user where id = #{id}")User selectUserbyId(Long id);/*** 自增主键 select last_insert_id()* 非 自增主键 select uuid（） before：true* @param user* @return*///自增主键@SelectKey(keyProperty = "id",keyColumn = "id",statement = "select last_insert_id()" ,before=false,resultType = Long.class)@Insert("insert into user (USER_NAEM,USER_PASSWORD) values(#{USER_NAEM},#{USER_PASSWORD})")int insertUser(User user);@Delete("delete from user where id = #{id}")int deleteUserById(Long id);@Update("update user set USER_NAEM=#{USER_NAEM},USER_PASSWORD = #{USER_PASSWORD} where id = #{id}")int updateUser(User user);}
---------------------------------------------------------------------------------------------------------------
Druid与jdbc整合：
因为starter-jdbc中自带HikariCp连接池，需要剔除此链接池，后再加入Druid连接池依赖，后续配置参照上面与mybatis整合的配置一致；
剔除原有连接池依赖
加入Druid连接池依赖
后面配置参照与mybatis整合的配置
