本文实例讲述了 java 获得 mysql 和 Oracle 链接的类。分享给大家供大家参考。具体如下 :
Импорт java.sql.connection; import java.sql.drivermanager; import java.sql.sqlexception; public class connectdb {частная статическая конечная строка mysql = "jdbc: mysql: //"; : thin:@"; private connectdb () {} public Static Connection getInstance (String dbtype, String url) Throws nosuchdbexception, sqlexception {if (" mysql ".EqualsIgnoreCase (dbtype)) return getMysqlconn (url); if (" oracle " . EqualsIgnoreCase (dbtype)) return getoracleconn (url); return null;} public static void closeconn (connect conn) {if (conn! = null) {try {conn.close ();} catch (sqlexception e) {e. printStackTrace ();}}} частное статическое соединение 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;} частное статическое соединение 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 程序设计有所帮助。