/// <summary> /// 測試連接Oracle資料庫 /// </summary> public static void TestYuantaOracle() { OracleDataBase db = new OracleDataBase("User Id=bpi;Password=yuantacps;Data Source=TS03"); PTTradingUnitOperator opr = new PTTradingUnitOperator(db); //int totalRecords = opr.Select(null); //foreach (PTTradingUnitRecord record in opr.RecordList) //{ // Console.WriteLine( record.PTCorpID + "," + record.PTCostCenter + "," + record.PTCustID + "," + record.PTDeptID + // "," + record.PTTradeGoal + "," + record.PTUserID ); //} foreach (PTTradingUnitRecord record in opr.SelectIterator(null)) { Console.WriteLine(record.PTCorpID + "," + record.PTCostCenter + "," + record.PTCustID + "," + record.PTDeptID + "," + record.PTTradeGoal + "," + record.PTUserID); } string[] corpID = opr.SelectFields <string>("ptCorpID", false, 10, null, AbstractOperator <PTTradingUnitRecord> .ConvertFirstColumn <string>); foreach (string cid in corpID) { Console.WriteLine(cid); } int totalCount = opr.SelectCount(null); Console.WriteLine("TotalCount " + totalCount); db.Close(); }
static void TestOracleRaw() { //byte b = Convert.ToByte("01", 16); OracleDataBase db = new OracleDataBase("User Id=bpi;Password=yuantacps;Data Source=TS02G"); DataTable dt = db.QueryCommand("SELECT * FROM ptDeptRiskCtrl"); if (dt != null && dt.Rows.Count > 0) { DataRow row = dt.Rows[0]; byte[] rawData = (byte[])(row["PTDeptAuthID"]); string strRaw = AbstractDataBase.RawToString(rawData); byte[] raw2 = AbstractDataBase.StringToRaw(strRaw); System.Diagnostics.Debug.Assert(rawData.Length == raw2.Length); for (int index = 0; index < raw2.Length; ++index) { System.Diagnostics.Debug.Assert(rawData[index] == raw2[index]); } string tmps = db.FieldToSQL(new OracleRowID(strRaw)); } db.Close(); }
public static void TestConcurrentOracle() { conDB = new OracleDataBase("User Id=bpi;Password=yuantacps;Data Source=TS03"); List <Thread> listThread = new List <Thread>(); for (int i = 0; i < 3; i++) { Thread t = new Thread(OracelAccessThread); t.IsBackground = true; t.Start(); listThread.Add(t); } foreach (Thread t in listThread) { t.Join(); } conDB.Close(); }