SpringBoot连接mysql及sqlserver扩展配置格式对比

it2025-10-18  6

mysql

driverClassName: com.mysql.jdbc.Driver url: jdbc:mysql://host:port/数据库名字?allowMultiQueries=true&useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai username: root password: 123

数据库名字紧跟URL,扩展配置之间用&隔开

sqlserver

driverClassName: com.microsoft.sqlserver.jdbc.SQLServerDriver url: jdbc:sqlserver://host:port;DatabaseName=数据库名字;serverTimezone=Asia/Shanghai;characterEncoding=UTF-8; username: root password: 123

数据库名字在扩展配置中,更多扩展配置用分号(;)隔开,以分号结尾

最新回复(0)