本文实例讲述了 Java 获得 MySql 和 Oracle : :
Importer java.sql.connection; import java.sql.DiverManager; import java.sql.sqlexception; classe publique connectDB {chaîne finale statique privée mysql = "jdbc: mysql: //" : Thin: @ "; private connectDB () {} public static connection getInstance (String dbType, String URL) lève NosuchDBException, Sqlexception {if (" mysql ".equalsignorecase (dbtype)) return getMysqlConn (url); if (" oracle " .EqualsIgnoreCase (dbType)) return getorAracleConn (url); return null;} public static void clarconn (connexion Conn) {if (conn! = null) {try {conn.close ();} catch (sqlexception e) {e. printStackTrace ();}}} connexion statique privée getMysQlConn (URL de chaîne) lève sqlexception {connexion conn = null; try {class.forname ("com.mysql.jdbc.driver");} catch (classnotfoundException e) {e.printStackTrace ();} conn = driverManager.getConnection (mysql + url, "root", "root"); return conn;} connexion statique privée getorAnConn (string url) lève 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 程序设计有所帮助。