数据库联接总结

来源：互联网发布：尖头平底鞋知乎编辑：程序博客网时间：2024/05/22 04:45

一数据库的连接配置信息大全
1 DATABASETYPE_ORACLE = oracle.jdbc.driver.OracleDriver；
url = "jdbc:oracle:thin:@" + serverName + ":" + port + ":" + dbName;
url = "jdbc:oracle:oci8:@"+dbName;
2 DATABASETYPE_SYBASE = com.sybase.jdbc2.jdbc.SybDriver；
url = "jdbc:sybase:Tds:" + serverName + ":" + port + "/" + dbName;
3 DATABASETYPE_SQLSERVER = com.microsoft.jdbc.sqlserver.SQLServerDriver；
url = "jdbc:jtds:sqlserver://" + serverName + ":" + port + "/" + dbName;
url = "jdbc:microsoft:sqlserver://" + serverName + ":" + port + ";DataBase=" + dbName;
url = "jdbc:AvenirDriver://" + serverName + ":" + port + "/" + dbName;
4 DATABASETYPE_DB2 = com.ibm.db2.jcc.DB2Driver；
url = "jdbc:db2://" + serverName + ":" + port + "/" + dbName;
5 DATABASETYPE_INFORMIX = com.informix.jdbc.IfxDriver；
url=jdbc:informix-sqli://serverName:8000/spdbnj:informixServer=spdbnj_tcp;NEWCODESET=GBK,8859-1,819;

二获取数据库连接
Connection conn = null;//定义连接对象
Class.forName(this.getDriverName());//加载驱动
conn = DriverManager.getConnection(this.getURL(), userName, password);//获取连接对象

0 0