Various database default Port encyclopedia

One: Oracle

Drive: Oracle.jdbc.driver.OracleDriver

url:jdbc:oracle:thin:@<machine_name><:p ort>:d bname

Note: machine_name: The name of the machine where the database is located, if the machine is 127.0.0.1 or localhost, if it is a remote connection, it is a remote IP address;

Port: Port number, default is 1521

Two: SQL Server

Drive: Com.microsoft.jdbc.sqlserver.SQLServerDriver

url:jdbc:microsoft:sqlserver://<machine_name><:p ort>;D atabasename=<dbname>

Note: machine_name: The name of the machine where the database is located, if the machine is 127.0.0.1 or localhost, if it is a remote connection, it is a remote IP address;

Port: Port number, default is 1433

Third: MySQL

Drive: Org.gjt.mm.mysql.Driver

url:jdbc:mysql://<machine_name><:p Ort>/dbname

Note: machine_name: The name of the machine where the database is located, if the machine is 127.0.0.1 or localhost, if it is a remote connection, it is a remote IP address;

Port: Port number, default 3306

Four: Pointbase

Drive: Com.pointbase.jdbc.jdbcUniversalDriver

url:jdbc:pointbase:server://<machine_name><:p Ort>/dbname

Note: machine_name: The name of the machine where the database is located, if the machine is 127.0.0.1 or localhost, if it is a remote connection, it is a remote IP address;

Port: Port number, default is 9092

V: DB2

Drive: Com.ibm.db2.jdbc.app.DB2Driver

url:jdbc:db2://<machine_name><:p Ort>/dbname

Note: machine_name: The name of the machine where the database is located, if the machine is 127.0.0.1 or localhost, if it is a remote connection, it is a remote IP address;

Port: Port number, default is 5000

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/basis/