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(); }