本文实例讲述了 Java 获得 MySql 和 Oracle 链接的类。分享给大家供大家参考。具体如下:
importar java.sql.connection; importar java.sql.driverManager; importar java.sql.sqLexception; classe pública ConnectDB {private Static Final String mysql = "jdbc: mysql: //"; private Static Final String ORACLE = "JDBC: Oracle: : thin:@"; private ConnectDB () {} conexão estática pública GetInstance (string dbtype, string url) lança NosuchdBexception, sqLexception {if (" mysql ".equalsignorecase (dbtype)) retornar getMySQLConn (url) se (" Oracle " .EqualSignorecase (dbtype)) retornar getoracleConn (url); retornar nulo;} public static void closeconn (conexão conn) {if (conn! = null) {try {Conn.close ();} catch (sqLexception e) {e. PrintStackTrace ();}}} conexão estática privada getMysqlConn (String url) lança SqLexception {conexão Conn = null; Try {Class.ForName ("com.mysql.jdbc.driver");} catch (classNotFoundException E) {E.PrintStackTrace ();} Conn = DriverManager.getConnection (mySQL + url, "root", "root"); retorna conn;} conexão estática privada getoracleconn (string url) lança sqlexception {conexão conn = null; tente {class.forname (" oracle.jdbc.driver.oracledriver ");} catch (classNotfoundException e) {e.printStacktrace ();} Conn = driverManager.getConnection (oracle + url," scott "," tiger "); retornar conn;}}}}}}}}}}}希望本文所述对大家的 Java 程序设计有所帮助。