java使用jdbc连接各种数据库驱动预览

最新推荐文章于 2024-08-22 17:05:52 发布

麻花2013

最新推荐文章于 2024-08-22 17:05:52 发布

阅读量1.6k

点赞数 1

分类专栏： java技术数据库

本文链接：https://blog.csdn.net/u012269637/article/details/102977936

版权

java技术同时被 2 个专栏收录

59 篇文章 0 订阅

订阅专栏

数据库

25 篇文章 1 订阅

订阅专栏

  
Unknown(DatabaseType.Unknown, "Unknown", "Unknown", 0),
   OracleThinServiceName(DatabaseType.Oracle, "oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@//${host}:${port}/${name}", 1521),
   OracleThinSID(DatabaseType.Oracle, "oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@${host}:${port}:${name}", 1521),
   OracleThinTNSName(DatabaseType.Oracle, "oracle.jdbc.driver.OracleDriver", "jdbc:oracle:thin:@${name}", 1521),
   OracleOCI(DatabaseType.Oracle, "oracle.jdbc.OracleDriver", "jdbc:oracle:oci:@${host}:${port}:${name}", 1521),
   OracleOCI8(DatabaseType.Oracle, "oracle.jdbc.OracleDriver", "jdbc:oracle:oci8:@${host}:${port}:${name}", 1521),
   SQLServer(DatabaseType.SQLServer, "com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:sqlserver://${host}:${port};DatabaseName=${name}", 1433),
   SQLServer2000(DatabaseType.SQLServer2000, "com.microsoft.sqlserver.jdbc.SQLServerDriver", "jdbc:microsoft:sqlserver://${host}:${port};DatabaseName=${name}", 1433),
   MySQL(DatabaseType.MySQL, "com.mysql.jdbc.Driver", "jdbc:mysql://${host}:${port}/${name}", 3306),
   DB2(DatabaseType.DB2, "com.ibm.db2.jcc.DB2Driver", "jdbc:db2://${host}:${port}/${name}", 50000),
   PostgreSQL(DatabaseType.PostgreSQL, "org.postgresql.Driver", "jdbc:postgresql://${host}:${port}/${name}", 5432),
   HWMPPDB(DatabaseType.HWMPPDB, "org.postgresql.Driver", "jdbc:postgresql://${host}:${port}/${name}", 5432),
   GaussDB200(DatabaseType.GaussDB200, "org.postgresql.Driver", "jdbc:postgresql://${host}:${port}/${name}", 5432),
   GaussDB100(DatabaseType.GaussDB100, "com.huawei.gauss.jdbc.ZenithDriver", "jdbc:zenith:@${host}:${port}", 40000),
   SQLiteFile(DatabaseType.SQLite, "org.sqlite.JDBC", "jdbc:sqlite:${name}", 0),
   SQLiteMemory(DatabaseType.SQLite, "org.sqlite.JDBC", "jdbc:sqlite:", 0),
   BDBFile(DatabaseType.BDB, "SQLite.JDBCDriver", "jdbc:sqlite:/${name}", 0),
   BDBMemory(DatabaseType.BDB, "SQLite.JDBCDriver", "jdbc:sqlite:/", 0),
   SybaseASE(DatabaseType.Sybase, "com.sybase.jdbc4.jdbc.SybDriver", "jdbc:sybase:Tds:${host}:${port}/${name}", 5000),
   SybaseAnywhere(DatabaseType.Sybase, "com.sybase.jdbc4.jdbc.SybDriver", "jdbc:sybase:Tds:${host}:${port}?ServiceName=${name}", 2638),
   Hive(DatabaseType.Hive, "org.apache.hadoop.hive.jdbc.HiveDriver", "jdbc:hive://${host}:${port}/${name}", 10000),
   Teradata(DatabaseType.Teradata, "com.teradata.jdbc.TeraDriver", "jdbc:teradata://${host}/${name}", 0),
GreenPlum(DatabaseType.GreenPlum, "org.postgresql.Driver", "jdbc:postgresql://${host}:${port}/${name}", 5432),
GBase(DatabaseType.GBase, "com.gbase.jdbc.Driver", "jdbc:gbase://${host}:${port}/${name}", 5258);