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程序设计有所帮助。