本文实例讲述了 Java a Mysql 和 Oracle 链接的类。分享给大家供大家参考。具体如下 :
import java.sql.connection; import java.sql.drivermanager; import java.sql.sqlexception; public class connectdb {private static final string mysql = "jdbc : mysql : //"; private static final string oracle = "jdbc : Oracle : thin :@"; private connectdb () {} public static connection getInstance (String dbtype, String URL)는 nosuchdbexception, sqlexception {if ("mysql ".equalsignorecase (dbtype))를 getmysqlconn (if); if ("Oracle "); .EqualSeignoreCase (dbtype)) return getoracleConn (url); return null;} public static void closeconn (Connection Conn) {if (conn! = null) {try {conn.close ();} catch (sqlexception e) {e. printStackTrace ();}}} 개인 정적 연결 getMysqlConn (String URL)은 sqlexception {connection conn = null; try {class.forname ( "com.mysql.jdbc.driver");} catch (classNotFoundException e) {e.printstacktrace ();} conn = driveManager.getConnection (mysql + url, "root", "root"); return conn;} private static connection getoracleConn (String URL)은 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 a