本文實例講述了java獲得mysql和oracle鏈接的類。分享給大家供大家參考。具體如下：
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
|
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程序設計有所幫助。
