本文实例讲述了java获得mysql和オラクル链接的类。分享给大家供大家参考。具体如下:
java.sql.connection; Import java.sql.drivermanager; Import java.sql.sqlexception; public final connectdb {private static final string mysql = "jdbc:mysql://"; private static final string oracle = "jdbc:oracle :shin:@"; private connectdb(){} public static connection getInstance(string dbtype、string url)throws nosuchdbexception、sqlexception {if(" mysql ".equalsignorecase(dbtype))return getmysqlconn(url); .equalsignorecase(dbtype))return getoracleconn(url); return null;} public static void closeconn(connection conn){if(conn!= null){try {conn.close();} catch(sqlexception e){e。 printstacktrace();}}} private static connection getmysqlconn(string url)throws sqlexception {connection conn = null; try {class.forname( "com.mysql.jdbc.driver");} catch(classnotfoundexception e){e.printstacktrace ();} conn = drivermanager.getConnection(mysql + url、 "root"、 "root"); return conn;} private static connection getoracleconn(string url)throws 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程序设计有所帮助。