本文实例讲述了 Java 获得 mysql 和 oracle 链接的类。分享给大家供大家参考。具体如下 :
import java.sql.Connection;import java.sql.DriverManager;import java.sql.SQLException;public class ConnectDB {private static final String MYSQL = "jdbc:mysql://";private static final String ORACLE = "jdbc:oracle : dünn:@"; private ConnectDB () {} öffentliche statische Verbindung getInstance (String dBTYPE, String url) löst NoSuchDBexception, SQLEXception {if (" mysql ".equalSignoreCase (dbType)) return getMysqlconn (url) aus; .EqualSignoreCase (dbType)) return getoracleconn (url); return null;} public static void Closeconn (Verbindung conn) {if (conn! = null) {try {conn.close ();} catch ( printStackTrace ();}}} private statische Verbindung getMysqlConn (String url) löst SQLEXception {Verbindung conn = null; try {class.Forname ("com.mysql.jdbc.driver");} catch (classNotFoundException E) {E.printStacktrace ") aus. . oracle.jdbc.driver.oracledriver ");} catch (classNotFoundException e) {e.printstacktrace ();} conn = driverManager.getConnection (Oracle + url," Scott "," Tiger ");
希望本文所述对大家的 Java 程序设计有所帮助。