注意:如果配置文本是直接写在xml文件中,需要将& 符号换成 &
MySQL8:
URL:jdbc:mysql://localhost:3306/数据库名?useSSL=false&useUnicode=true&characterEncoding=UTF8&serverTimezone=GMT
Driver:com.mysql.cj.jdbc.Driver
PostgreSQL:
URL:jdbc:postgresql://localhost:5432/数据库名
Driver:org.postgresql.Driver
Oracle:
URL:jdbc:oracle:thin:@localhost:1521:orcl
Driver:oracle.jdbc.driver.OracleDriver
SQLServer2000:
URL:jdbc:microsoft:sqlserver://localhost:1433;DatabaseName=tempdb
Driver:com.microsoft.jdbc.sqlserver.SQLServerDriver
SQLServer2005:
URL:jdbc:sqlserver://localhost:1433;DatabaseName=tempdb
Driver:com.microsoft.sqlserver.jdbc.SQLServerDriver
DB2:
URL:jdbc:db2://localhost:50000/testdb
Driver:com.ibm.db2.jcc.DB2Driver
JDBC驱动Jar包:
DB2 Microsoft SQL Server MySQL Oracle PostgreSQL SQLite MySQL-ODBC MongoDB