当前位置: 代码迷 >> J2EE >> 动态链接mysql数据库
  详细解决方案

动态链接mysql数据库

热度:896   发布时间:2013-11-10 21:22:56.0
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;  
}  
}

  相关解决方案