本文实例讲述了 Java 获得 mysql 和 oracle : :
impor java.sql.connection; import java.sql.driverManager; import java.sql.sqlexception; kelas publik ConnectDb {private static final string mysql = "jdbc: mysql: //"; Private Static Final String oracle = "jdbc: oracle : tipis:@"; private connectDb () {} koneksi statis publik getInstance (string dBType, string url) melempar nosuchdbexception, sqlexception {if (" mysql ".equalsignorecase (dBType)) mengembalikan getMySqlConn (url); if (" oracle " .equalSignorecase (dBType)) return getoracleconn (url); return null;} public static void closeConn (koneksi conn) {if (conn! = null) {coba {conn.close ();} catch (sqlexception e) {e. printStackTrace ();}}} koneksi statis privat getMySqlconn (string url) melempar sqlexception {koneksi conn = null; coba {class.forname ("com.mysql.jdbc.driver");} catch (classnotfoundexception e) {e.printStackTrace "); ();} conn = driverManager.getConnection (mysql + url, "root", "root"); return conn;} koneksi statis pribadi getoracleconn (string url) melempar sqlexception {koneksi conn = null; coba {class.forname (" oracle.jdbc.driver.oracledriver ");} catch (classnotfoundException e) {e.printstacktrace ();} conn = driverManager.getConnection (oracle + url," scott "," harimau "); return conn;}}
希望本文所述对大家的 Java 程序设计有所帮助。