?? oracleoperation.java
字號(hào):
package console.oracle;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import console.AbstractOperation;
/**
* @author Allan(劉新福)
* @version 1.0
*/
public class OracleOperation extends AbstractOperation {
private Connection con;
public OracleOperation(String serverIP, String serverPort,
String databaseName, String userName, String password) {
super(serverIP, serverPort, databaseName, userName, password);
}
public OracleOperation(String serverIP, String serverPort,
String databaseName, String userName, String password,
int transactionIsolation) {
super(serverIP, serverPort, databaseName, userName, password,
transactionIsolation);
}
public Connection getConnection() throws Exception {
if (con == null) {
try {
Class.forName("oracle.jdbc.driver.OracleDriver");
String jdbcURL = "jdbc:oracle:thin:@" + serverIP + ":"
+ serverPort + ":" + databaseName;
con = DriverManager.getConnection(jdbcURL, userName, password);
} catch (ClassNotFoundException e) {
System.out
.println("Can not load oracle jdbc driver, please verify your CLASSPATH!");
throw e;
} catch (SQLException e) {
System.out
.println("Fail to get database connection, please verify your database information!");
throw e;
}
}
return con;
}
}
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -