package com.ximple.io.dgn7;
|
|
//~--- JDK imports ------------------------------------------------------------
|
|
import java.sql.DriverManager;
|
import java.sql.SQLException;
|
import java.util.Properties;
|
|
import org.apache.log4j.Logger;
|
|
import com.vividsolutions.jts.util.Assert;
|
import oracle.jdbc.OracleConnection;
|
|
/**
|
* OracleTarget
|
* User: Ulysses
|
* Date: 2007/6/15
|
* Time: ?U?? 03:12:43
|
* To change this template use File | Settings | File Templates.
|
*/
|
public class OracleTarget
|
{
|
private static final Logger logger = Logger.getLogger(OracleTarget.class);
|
private static OracleTarget _instance = null;
|
private static final String ORACLE_URL = "jdbc:oracle:thin:@";
|
private static final String _propUsrKey = "user";
|
private static final String _propPassKey = "password";
|
private static String _oracleHost = "192.168.11.200";
|
private static String _oracleInstance = "NNTPC";
|
private static String _oraclePort = "1521";
|
|
static
|
{
|
try
|
{
|
DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver());
|
} catch (SQLException e)
|
{
|
Assert.shouldNeverReachHere(e.getMessage());
|
}
|
}
|
|
private OracleConnection oracleConnection = null;
|
private Properties properties;
|
|
private OracleTarget()
|
{
|
properties = new Properties();
|
properties.put(_propUsrKey, "SPATIALDB");
|
properties.put(_propPassKey, "SPATIALDB000");
|
}
|
|
public static String getOracleHost()
|
{
|
return _oracleHost;
|
}
|
|
public static void setOracleHost(String oracleHost)
|
{
|
OracleTarget._oracleHost = oracleHost;
|
}
|
|
public static String getOracleInstance()
|
{
|
return _oracleInstance;
|
}
|
|
public static void setOracleInstance(String oracleInstance)
|
{
|
OracleTarget._oracleInstance = oracleInstance;
|
}
|
|
public static String getOraclePort()
|
{
|
return _oraclePort;
|
}
|
|
public static void setOraclePort(String oraclePort)
|
{
|
OracleTarget._oraclePort = oraclePort;
|
}
|
|
public static String getCurrentURL()
|
{
|
StringBuilder builder = new StringBuilder();
|
|
builder.append(ORACLE_URL);
|
builder.append(_oracleHost);
|
builder.append(":");
|
builder.append(_oraclePort);
|
builder.append(":");
|
builder.append(_oracleInstance);
|
|
return builder.toString();
|
}
|
|
public String getLoginPass()
|
{
|
return (String) properties.get(_propPassKey);
|
}
|
|
public void setLoginPass(String loginPass)
|
{
|
properties.put(_propPassKey, loginPass);
|
}
|
|
public String getLoginUsr()
|
{
|
return (String) properties.get(_propUsrKey);
|
}
|
|
public void setLoginUsr(String loginUsr)
|
{
|
properties.put(_propUsrKey, loginUsr);
|
}
|
|
public static OracleTarget getInstance()
|
{
|
if (_instance == null)
|
{
|
_instance = new OracleTarget();
|
}
|
|
return _instance;
|
}
|
|
public OracleConnection getOracleConnection()
|
{
|
try
|
{
|
if (oracleConnection == null)
|
{
|
oracleConnection = (OracleConnection) DriverManager.getConnection(getCurrentURL(), properties);
|
}
|
|
return oracleConnection;
|
} catch (SQLException e)
|
{
|
logger.warn(e.getMessage(), e);
|
}
|
|
oracleConnection = null;
|
|
return null;
|
}
|
|
public void closeConnection()
|
{
|
try
|
{
|
if (oracleConnection != null)
|
{
|
oracleConnection.close();
|
oracleConnection = null;
|
}
|
} catch (SQLException e)
|
{
|
logger.warn(e.getMessage(), e);
|
}
|
}
|
}
|
