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 入住酒店文案祝福语简短