import java.sql.Connection;
public abstract class BaseConnect {
public BaseConnect(String driverClass, String url, String loginName,
String password) {
super();
this.driverClass = driverClass;
this.url = url;
this.loginName = loginName;
this.password = password;
}
protected String driverClass;
protected String url;
protected String loginName;
protected String password;
public abstract void initDriver();
public abstract Connection getConnect();
public abstract void closeConnect(Connection conn);
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class OraclConnect extends BaseConnect {
public OraclConnect(String driverClass, String url, String loginName,
String password) {
super(driverClass, url, loginName, password);
// TODO Auto-generated constructor stub
}
@Override
public void initDriver() {
try {
Class.forName(driverClass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
@Override
public Connection getConnect() {
try {
return DriverManager.getConnection(url, loginName, password);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public void closeConnect(Connection conn) {
try {
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
public abstract class BaseConnect {
public BaseConnect(String driverClass, String url, String loginName,
String password) {
super();
this.driverClass = driverClass;
this.url = url;
this.loginName = loginName;
this.password = password;
}
protected String driverClass;
protected String url;
protected String loginName;
protected String password;
public abstract void initDriver();
public abstract Connection getConnect();
public abstract void closeConnect(Connection conn);
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class OraclConnect extends BaseConnect {
public OraclConnect(String driverClass, String url, String loginName,
String password) {
super(driverClass, url, loginName, password);
// TODO Auto-generated constructor stub
}
@Override
public void initDriver() {
try {
Class.forName(driverClass);
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
@Override
public Connection getConnect() {
try {
return DriverManager.getConnection(url, loginName, password);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
@Override
public void closeConnect(Connection conn) {
try {
if (conn != null && !conn.isClosed()) {
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}