java获得mysql和oracle链接的类
内容摘要
本文实例讲述了java获得mysql和oracle链接的类。分享给大家供大家参考。具体如下:
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLExce
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLExce
文章正文
本文实例讲述了java获得mysql和oracle链接的类。分享给大家供大家参考。具体如下:
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, "scott", "tiger"); return conn; } }
希望本文所述对大家的java程序设计有所帮助。
代码注释