本文实例讲述了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程序设计有所帮助。