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程序设计有所帮助。
热门推荐
10 小红书平安祝福语简短
11 生日祝福语大全女孩简短
12 收生日红包祝福语 简短
13 领证幽默祝福语简短
14 法考面试祝福语简短
15 老哥出门祝福语简短语
16 送灯祝福语简短独特
17 幼儿狗年祝福语大全简短
18 好听的元旦简短祝福语