参考文档
- 官方文档 https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-overview.html
- 官方文档(PDF版)下载地址:https://downloads.mysql.com/docs/refman-8.0-en.a4.pdf
Connector/J API 变化
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-api-changes.html
驱动类变化使用 com.mysql.cj.jdbc.Driver
- 驱动类 java.sql.Driver变为 com.mysql.cj.jdbc.Driver
URL 语法
protocol//[hosts][/database][?properties]
protocol
jdbc:mysql: is for ordinary and basic JDBC failover connections.
jdbc:mysql:loadbalance: is for load-balancing JDBC connections. See Section 9.3, “Configuring Load Balancing with Connector/J” for details.
jdbc:mysql:replication: is for JDBC replication connections. See Section 9.4, “Configuring Source/Replica Replication with Connector/J” for details.
mysqlx: is for X DevAPI connections.
jdbc:mysql+srv: is for ordinary and basic failover JDBC connections that make use of DNS SRV records.
jdbc:mysql+srv:loadbalance: is for load-balancing JDBC connections that make use of DNS SRV records.
jdbc:mysql+srv:replication: is for replication JDBC connections that make use of DNS SRV records.
mysqlx+srv: is for X DevAPI connections that make use of DNS SRV records.
多主机配置:
jdbc:mysql://myhost1:1111,myhost2:2222/db
jdbc:mysql://address=(host=myhost1)(port=1111)(key1=value1),address=(host=myhost2)(port=2222)(key2=value2)/db
jdbc:mysql://(host=myhost1,port=1111,key1=value1),(host=myhost2,port=2222,key2=value2)/db
jdbc:mysql://myhost1:1111,(host=myhost2,port=2222,key2=value2)/db
mysqlx://(address=host1:1111,priority=1,key1=value1),(address=host2:2222,priority=2,key2=value2)/db
数据库链接配置属性:
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html
设置时区
java.time.ZoneId 中 zoneId 与时区的映射关系
- EST - -05:00
- HST - -10:00
- MST - -07:00
- ACT - Australia/Darwin
- AET - Australia/Sydney
- AGT - America/Argentina/Buenos_Aires
- ART - Africa/Cairo
- AST - America/Anchorage
- BET - America/Sao_Paulo
- BST - Asia/Dhaka
- CAT - Africa/Harare
- CNT - America/St_Johns
- CST - America/Chicago
- CTT - Asia/Shanghai
- EAT - Africa/Addis_Ababa
- ECT - Europe/Paris
- IET - America/Indiana/Indianapolis
- IST - Asia/Kolkata
- JST - Asia/Tokyo
- MIT - Pacific/Apia
- NET - Asia/Yerevan
- NST - Pacific/Auckland
- PLT - Asia/Karachi
- PNT - America/Phoenix
- PRT - America/Puerto_Rico
- PST - America/Los_Angeles
- SST - Pacific/Guadalcanal
- VST - Asia/Ho_Chi_Minh
字符集设置:
https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-charsets.html
数据源配置:
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/hdmap?characterEncoding=UTF8&connectTimeout=6000&socketTimeout=6000&connectionTimeZone=Asia/Shanghai
本文来自博客园,作者:不安分的黑娃,转载请注明原文链接:https://www.cnblogs.com/lihw-study/p/15618032.html