mysql驱动类_mysql的驱动类com.mysql.jdbc.Driver过时了,需要用com.mysql.cj.jdbc.Driver代替...

springboot项目整合mybatis,配置文件如下:

server:

port: 8081

mybatis:

config-location: classpath:mybatis/mybatis-config.xml #mybatis配置文件所在路径

type-aliases-package: com.yuanqiao.entities #所有entity别名类所在包

mapper-locations: classpath:mybatis/mapper/*.xml

spring:

application:

name: swaggerdemo

datasource:

type: com.alibaba.druid.pool.DruidDataSource

driver-class-name: com.mysql.jdbc.Driver

url: jdbc:mysql://localhost:3306/springboot?useUnicode=true&characterEncoding=UTF-8&useJDBCCompliantTimezoneShift=true&useLegacyDatetimeCode=false&serverTimezone=UTC

username: root

password: 123456

dbcp2:

min-idle: 5 #数据库连接池的最小维持连接数

initial-size: 5 #初始化连接数

max-total: 5 #最大连接数

max-wait-millis: 200 #等待连接获取的最大超时时间

做sql查询的时候,提示com.mysql.jdbc.Driver已经弃用了。

Creating a new SqlSession

SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5540e55e] was not registered for synchronization because synchronization is not active

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

2019-07-20 16:16:42.533 INFO 59084 --- [nio-8081-exec-2] com.alibaba.druid.pool.DruidDataSource : {dataSource-1} inited

JDBC Connection [com.mysql.cj.jdbc.ConnectionImpl@366b8e6b] will not be managed by Spring

==> Preparing: select * from user where id = ?

==> Parameters: 1(Integer)

<== Columns: id, name, sex, age

<== Row: 1, zhangsan, male, 22

<== Total: 1

Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@5540e55e]

cb99ff4392194defd7749c5d67afc1b4.png

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值