jdbc:mysql语法

jdbc:mysql://

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-url-format.html

连接参数

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html

例子说明

• autoReconnect 自动重连。默认false
• failOverReadOnly 自动重连后设为只读。默认 true
• allowMultiQueries 批量执行SQL。默认false

jdbc.driverClassName&＃61;com.mysql.jdbc.Driver
jdbc.url&＃61;jdbc:mysql://localhost:3306/jerry?autoReconnect&＃61;true&failOverReadOnly&＃61;false&useUnicode&＃61;true&characterEncoding&＃61;utf-8
jdbc.username&＃61;root
jdbc.password&＃61;root


有坑

在xml文件里url中的&要转义成& 如果哪天又拆出来配置到 jdbc.properties 中记得改回 &。&＃xff08;被这个坑过&＃xff09;

• xxx.xml


<bean id&＃61;"dataSource" class&＃61;"com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method&＃61;"close"><property name&＃61;"driverClass" value&＃61;"com.mysql.jdbc.Driver" /><property name&＃61;"jdbcUrl" value&＃61;"jdbc:mysql://localhost:3306/jerry?useUnicode&＃61;true&characterEncoding&＃61;utf-8" /><property name&＃61;"user" value&＃61;"root" /><property name&＃61;"password" value&＃61;"root" />
bean>


• jdbc.properties
  GMT%2B8 &＃61;&＃61; GMT&＃43;8

jdbc_driver&＃61;com.mysql.jdbc.Driver
jdbc_url&＃61;jdbc:mysql://localhost:3306/jerry?serverTimezone&＃61;GMT%2B8&useUnicode&＃61;true&characterEncoding&＃61;UTF-8&useSSL&＃61;false
jdbc_user&＃61;root
jdbc_password&＃61;root


https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-jdbc-url-format.html