Detailed explanation and summary of the URL for database connection

Detailed explanation and summary of the URL for database connection

JDBC URL = protocol name + sub-protocol name + data source name.

a. The protocol name is always "jdbc".
b. The subprotocol name is determined by the writer of the JDBC driver.
c. The data source name may also contain user and password information; this information can also be provided separately.

Several common database connections

1 —oracle—

Driver: Oracle.jdbc.driver.OracleDriver
URL: jdbc:oracle:thin:@machine_name:port:dbname
Note: machine_name: the name of the machine where the database is located;
port: port number, the default is 1521

2 —mysql—

Driver: com.MySQL.jdbc.Driver
URL: jdbc:mysql://machine_name:port/dbname
Note: machine_name: the name of the machine where the database is located;
port: port number, default is 3306

3 —SQL Server—

Driver: com.microsoft.jdbc.sqlserver.SQLServerDriver
URL: jdbc:microsoft:sqlserver://<machine_name><:port>;DatabaseName=<dbname>
Note: machine_name: the name of the machine where the database is located;
port: port number, the default is 1433

4 —DB2—

Driver: com.ibm.db2.jdbc.app.DB2Driver
URL: jdbc:db2://<machine_name><:port>/dbname
Note: machine_name: the name of the machine where the database is located;
port: port number, the default is 5000

The above is a detailed explanation of how to write the URL for database connection and a summary. If you have any questions, you can leave a message or discuss in the community of this site. Thank you for reading and I hope it can help you. Thank you for your support of this site!