JDBC CONNECT STRING

zhaozj2021-02-16  51

Most of the programmers will inevitably connect to the database, so they summarize the JDBC's connection string for different databases while summing up, and there are also many people summed up. I have written this thing here for my memory and consultation. If the second, if you can give you some help, I am also very happy.

Let's talk about ODBC: JDBC: ODBC:

, For example: JDBC: ODBC: ODBC1

Again M $ SQL Server, JDBC: Microsoft: SQLServer: // ip: port; DatabaseName =

, For example: JDBC: Microsoft: SQLServer // localhost: 1433; DatabaseName = Northwind

This is a fond of it, Microsoft is Microsoft. :)

IBM boss DB2, JDBC: DB2: DBNAME

OR JDBC: DB2: // ip: port / dbname

,

For example: JDBC: DB2: Sample, or JDBC: DB2 / Localhost: 5000 / Sample

Oracle: th: @ip: port: dbname, for example: JDBC: Oracle: Thin: @localhost: 1521: ORADB

Free mysql, jdbc: mysql: // ip: port / dbname and db2 are almost, for example,: JDBC: MySQL: // localhost: 3306 / TESTDB

Sybase, now there is not much to use, JDBC: Sybase: TDS: IP: Port / DBNAME, for example: JDBC: Sybase: TDS: localhost: 2638 / TESTDB

转载请注明原文地址:https://www.9cbs.com/read-18139.html

New Post(0)