java数据库操作的Driver（驱动）与URL

来源：互联网发布：基佬大乱斗mac 编辑：程序博客网时间：2024/06/04 18:44

--------------------------------------------------oracle--------------------------------------------------
驱动：oracle.jdbc.driver.OracleDriver
URL：jdbc:oracle:thin:@<mathine_name><:port>:dbname
port 默认是1521

--------------------------------------------------mysql--------------------------------------------------
驱动：com.mysql.jdbc.Driver
URL：jdbc:mysql://<mathine_name><:port>/dbname
port 默认是3306

--------------------------------------------------pointbase--------------------------------------------------
驱动：com.pointbase.jdbc.jdbcUniversalDriver
URL：jdbc:pointbase:server://<mathine_name><:port>/dbname
port 默认是9092

--------------------------------------------------SQL Server--------------------------------------------------
驱动：com.microsoft.jdbc.sqlserver.SQLServerDriver
URL：jdbc:microsoft:sqlserver://<mathine_name><:port>;DatabaseName=<dbname>
port 默认是1433

--------------------------------------------------DB2--------------------------------------------------
驱动：com.ibm.db2.jdbc.app.DB2Driver
URL：jdbc:db2://<mathine_name><:port>/dbname
port 默认是5000