JDBC 定义信息
db2
依赖:
<!-- https://mvnrepository.com/artifact/com.ibm.db2/db2jcc4 -->
<dependency>
<groupId>com.ibm.db2</groupId>
<artifactId>db2jcc4</artifactId>
<version>3.64</version>
</dependency>
格式:
jdbc:db2://localhost:60000/brandmob
配置:
# DB2
driverClassName=com.ibm.db2.jcc.DB2Driver
url=jdbc:db2://localhost:60000/brandmob
username=mwiz2
password={enc}XXX
validationQuery=select 1 from sysibm.sysdummy1
sqlite
依赖:
格式:
jdbc:sqlite:C:/sqlite/db/chinook.db
jdbc:sqlite::memory:
Driver Class:
org.sqlite.JDBC
PostgreSQL
依赖:
<dependency>
<groupId>org.postgresql</groupId>
<artifactId>postgresql</artifactId>
<version>42.2.18</version>
</dependency>
格式:
jdbc:postgresql://host:port/database?properties
Driver Class:
org.postgresql.jdbc3.Jdbc3ConnectionPool
SQL Server
依赖:
<dependency>
<groupId>com.microsoft.sqlserver</groupId>
<artifactId>mssql-jdbc</artifactId>
<version>8.4.1.jre11</version>
</dependency>
格式:
jdbc:sqlserver://[serverName[\instanceName][:portNumber]][;property=value[;property=value]]
Driver Class:
MySQL
依赖:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.22</version>
</dependency>
格式:
jdbc:mysql://myhost1:3306,myhost2:3307/db_name
jdbc:mysql://[myhost1:3306,myhost2:3307]/db_name
jdbc:mysql:loadbalance://myhost1:3306,myhost2:3307/db_name?user=dbUser&password=1234567&loadBalanceConnectionGroup=group_name&ha.enableJMX=true
Driver Class:
com.mysql.jdbc.Driver
tdsql
h2
Oracle
依赖:
<dependency>
<groupId>com.oracle.database.jdbc</groupId>
<artifactId>ojdbc8</artifactId>
<version>21.1.0.0</version>
</dependency>
格式:
jdbc:oracle:thin:[<user>/<password>]@<host>[:<port>]:<SID>
jdbc:oracle:thin:[<user>/<password>]@//<host>[:<port>]/<service>
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<host>)(PORT=<port>))(CONNECT_DATA=(SERVICE_NAME=<service>)))
spring boot
方式一
代码:
@Bean
@ConfigurationProperties("app.datasource")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}
配置:
app.datasource.url=jdbc:mysql://localhost/test
app.datasource.username=dbuser
app.datasource.password=dbpass
app.datasource.pool-size=30
方式一
@Bean
@ConfigurationProperties("app.datasource")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}
方式一
@Bean
@ConfigurationProperties("app.datasource")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}
方式一
@Bean
@ConfigurationProperties("app.datasource")
public DataSource dataSource() {
return DataSourceBuilder.create().build();
}