本文实例讲述了 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: //"; string final estática privada oracle = "jdbc: oracle oracle : Thin:@"; private ConnectDB () {} Public Static Connection getInstance (String dbtype, string url) arroja nosuchdbexception, sqlexception {if (" mysql ".equalsignorecase (dbtype)) return getMysqlconn (url); if (" oracle " .equalSignorecase (dbtype)) return getoracleconn (url); return null;} public static void closeConn (Connection Conn) {if (conn! = null) {try {conn.close ();} captura (sqlexception e) {e. printStackTrace ();}}} Conexión estática privada getMysqlconn (string url) lanza sqlexception {conexión conn = null; try {class.forname ("com.mysql.jdbc.driver");} Catch (classnotFoundException e) {E.PrintStackTrace ();} conn = drivermanager.getConnection (mysql + url, "root", "root"); return conn;} Conexión estática privada getoracleconn (string url) lanza sqlexception {Connection conn = null; try {class.forname (" oracle.jdbc.driver.oracledriver ");} catch (ClassNotFoundException e) {E.PrintStackTrace ();} Conn = Drivermanager.getConnection (Oracle + URL," Scott "," Tiger "); return Conn;}}希望本文所述对大家的 java 程序设计有所帮助。