`
xiangkun
  • 浏览: 99649 次
  • 性别: Icon_minigender_1
  • 来自: 马尔代夫
社区版块
存档分类
最新评论

动态链接mysql数据库

阅读更多
import java.sql.Connection;   
import java.sql.DriverManager;   
import java.sql.SQLException;   
    
public class ConnectDB {   
private static final String MYSQL = "jdbc:mysql://";   
    
private static final String ORACLE = "jdbc:oracle:thin:@";   
    
private ConnectDB() {   
}   
    
public static Connection getInstance(String DBType, String url)   
throws NoSuchDBException, SQLException {   
if ("mysql".equalsIgnoreCase(DBType))   
return getMySqlConn(url);   
if ("oracle".equalsIgnoreCase(DBType))   
return getOracleConn(url);   
return null;   
}   
    
public static void closeConn(Connection conn) {   
if (conn != null) {   
try {   
conn.close();   
} catch (SQLException e) {   
e.printStackTrace();   
}   
}   
}   
    
private static Connection getMySqlConn(String url) throws SQLException {   
Connection conn = null;   
try {   
Class.forName("com.mysql.jdbc.Driver");   
} catch (ClassNotFoundException e) {   
e.printStackTrace();   
}   
conn = DriverManager.getConnection(MYSQL + url, "root", "root");   
    
return conn;   
}   
    
private static Connection getOracleConn(String url) throws SQLException {   
Connection conn = null;   
try {   
Class.forName("oracle.jdbc.driver.OracleDriver");   
} catch (ClassNotFoundException e) {   
e.printStackTrace();   
}   
conn = DriverManager.getConnection(ORACLE + url, "daimami.com", "daimami.com");   
    
return conn;   
}   
} 

 

 

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics