java连接mysql5和mysql8的区别
mysql5
驱动:com.mysql.jdbc.Driver
数据库连接:
如果是普通java文件用:jdbc:mysql://localhost:3306/foodservers?useUnicode=true&characterEncoding=utf-8
如果是xml之类的配置文件用:jdbc:mysql://127.0.0.1:3306/hello?useUnicode=true&characterEncoding=UTF-8
hibernate方言:org.hibernate.dialect.MySQLDialect
hibernate自动创建表配置:<prop key="hibernate.hbm2ddl.auto">update</prop>
mysql8
jar包:mysql-connector-java-8.0.15.jar
驱动:com.mysql.cj.jdbc.Driver
数据库连接:
如果是普通java文件用:jdbc:mysql://localhost:3306/student?serverTimezone=UTC&useSSL=false
如果是xml之类的配置文件用:jdbc:mysql://localhost:3306/ds?characterEncoding=utf-8&serverTimezone=GMT%2B8&useSSL=false
hibernate方言:org.hibernate.dialect.MySQLDialect
hibernate自动创建表配置:<prop key="hibernate.hbm2ddl.auto">update</prop>