public TFlightTime Search(string f_id)
{
DBConnectionPool pool = new DBConnectionPool(10);
OracleConnection conn = pool.fetchConnection();
string sql = "select * from FLIGHTIME where F_ID='" + f_id + "'";
TFlightTime flight = new TFlightTime();
OracleCommand cmd = new OracleCommand();
OracleHelper.PrepareCommand(cmd, conn, null, sql, null);
OracleDataReader objReader = null;
objReader = cmd.ExecuteReader();
while (objReader.Read())
{
flight.f_id = objReader[0].ToString();
flight.t_airport = objReader[1].ToString();
flight.t_terminal = objReader["t_terminal"].ToString();
flight.ex_takeoff_time = objReader["ex_takeoff_time"].ToString();
flight.ex_land_time = objReader["ex_land_time"].ToString();
flight.re_land_time = null;
flight.re_takeoff_time = null;
flight.l_airport = objReader["l_airport"].ToString();
flight.l_termnal = objReader["l_termnal"].ToString();
}
return(flight);
}
static DBConnectionPool()
{
factory = new ConnectionFactory();
ConnectionMaxSize = 50;
pool = new List <OracleConnection>();
sington = new DBConnectionPool();
locker = new object();
event_0 = new AutoResetEvent(false);
}
static DataBaseAccess()
{
pool = DBConnectionPool.getInstance();
}