java获得mysql和oracle链接的类

java获得mysql和oracle链接的类

本文实例讲述了java获得mysql和oracle链接的类。分享给大家供大家参考。具体如下：

import java.sql.Connection;

ihttp://mport 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();

}lrsQdj

}

}

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程序设计有所帮助lrsQdj。

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。