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程序设计有所帮助。
热门推荐
3 祝福语简短的微信
10 幼儿祝福语大全简短贺卡
11 感谢教官文案祝福语简短
12 鼠年同事祝福语简短创意
13 元旦祝福语 简短独特群发
14 妈咪跟我生日祝福语简短
15 给儿子新婚祝福语简短
16 伴娘祝福语长文案简短
17 恭喜高考完祝福语简短
18 生日祝福语送老公简短