java获得mysql和oracle链接的类
本文实例讲述了java获得mysql和oracle链接的类。分享给大家供大家参考。具体如下:
importjava.sql.Connection; importjava.sql.DriverManager; importjava.sql.SQLException; publicclassConnectDB{ privatestaticfinalStringMYSQL="jdbc:mysql://"; privatestaticfinalStringORACLE="jdbc:oracle:thin:@"; privateConnectDB(){ } publicstaticConnectiongetInstance(StringDBType,Stringurl) throwsNoSuchDBException,SQLException { if("mysql".equalsIgnoreCase(DBType)) returngetMySqlConn(url); if("oracle".equalsIgnoreCase(DBType)) returngetOracleConn(url); returnnull; } publicstaticvoidcloseConn(Connectionconn){ if(conn!=null){ try{ conn.close(); }catch(SQLExceptione){ e.printStackTrace(); } } } privatestaticConnectiongetMySqlConn(Stringurl)throwsSQLException{ Connectionconn=null; try{ Class.forName("com.mysql.jdbc.Driver"); }catch(ClassNotFoundExceptione){ e.printStackTrace(); } conn=DriverManager.getConnection(MYSQL+url,"root","root"); returnconn; } privatestaticConnectiongetOracleConn(Stringurl)throwsSQLException{ Connectionconn=null; try{ Class.forName("oracle.jdbc.driver.OracleDriver"); }catch(ClassNotFoundExceptione){ e.printStackTrace(); } conn=DriverManager.getConnection(ORACLE+url,"scott","tiger"); returnconn; } }
希望本文所述对大家的java程序设计有所帮助。