com.huawei.dataconvert.db

public class OracleDataBase extends DataBase
{

public Connection getConn(String userName, String password)
{
Connection conn = this.connMap.get(userName);
if (null != conn)
{
try
{
if (!conn.isClosed())
{
return conn;
}
} catch (SQLException e)
{
e.printStackTrace();
}
}

String url = "jdbc:oracle:thin:@" + add + ":" + port + ":" + dbName;
// jdbc:oracle:thin:@10.52.128.203:1521:base
// url="";
// userName="scott";password="tiger";
System.out.println("连接数据库:" + url);
System.out.println("user:" + userName);
System.out.println("pasw:" + password);
try
{
// 初始化Oracle数据库
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
conn = DriverManager.getConnection(url, userName, password);
} catch (Exception e)
{
e.printStackTrace();
}
this.connMap.put(userName, conn);
return conn;
}

@Override
public boolean checkSecurity()
{

String sql = "select * from Security_Table";
Connection conn = getConn(userName, password);
PreparedStatement pstmt;
String result = "";
boolean flag = false;
result = SecurityUtil.getSecurityValue(this.getAdd());
String retrieveKey = "";
try
{
pstmt = conn.prepareStatement(sql);
ResultSet rs = pstmt.executeQuery(sql);

while (rs.next())
{
retrieveKey = rs.getString(1);
}
rs.close();
pstmt.close();
} catch (SQLException e)
{
e.printStackTrace();
return false;
}
flag = result.equals(retrieveKey)? true : false;
return flag;
}

@Override
public Connection getConn()
{
Connection conn = this.connMap.get("dbdefaultconn");
if (null != conn)
{
try
{
if (!conn.isClosed())
{
return conn;
}
} catch (SQLException e)
{
e.printStackTrace();
}
}
String url = "jdbc:oracle:thin:@" + add + ":" + port + ":" + dbName;
// jdbc:oracle:thin:@10.52.128.203:1521:base
// url="";
// userName="scott";password="tiger";
System.out.println("连接数据库:" + url);
System.out.println("user:" + userName);
System.out.println("pasw:" + password);
try
{
// 初始化Oracle数据库
DriverManager.registerDriver(new oracle.jdbc.OracleDriver());
conn = DriverManager.getConnection(url, userName, password);
} catch (Exception e)
{
e.printStackTrace();
}
this.connMap.put("dbdefaultconn", conn);
return conn;
}