using?System;
using?System.Data;
using?System.Data.Odbc;
using?System.Data.OracleClient;

namespace?gzdemo
{
??///?

??///?訪問oracle數據庫
??///?

??public?class?OraDb
??{
????//字段
????private??OracleConnection?Connection;
????private?string?connectionString;
	public???OracleCommand?command?;

????//構造函數
????public?OraDb（?string?newConnectionString?）
????{
????????connectionString?=?newConnectionString;
????????Connection?=?new?OracleConnection（connectionString）;
????????command?=?new?OracleCommand（““?Connection）;????
????}

????//屬性
????public?string?ConnectionString
????{
????????get
????????{
????????????return?connectionString;
????????}
????}

????public?OracleConnection?connection
????{
	????get
????????{
????????????if?（Connection.State?==?ConnectionState.Closed）
????????????{
????????????????Connection.Open（）;
????????????}				????
		????return?Connection;
	????}
????}

????//方法
????public?OracleConnection?GetConnection（）
????{
????????return?Connection;
????}

????public?OracleDataReader?RunQuery（?string?sqlQuery?）
????{
????????OracleDataReader?result?=?null;
????????if?（Connection.State?==?ConnectionState.Closed）
????????{
????????????Connection.Open（）;
????????}
??????????
????????command.CommandText?=?sqlQuery;
????????//???result?=?command.ExecuteReader（CommandBehavior.CloseConnection）;?//?ww?061102
????????result?=?command.ExecuteReader（）;
????????Connection.Close（）;
????????return?result;
????}

????public?int?RunNonQuery（?string?sqlNonQuery?）
????{
????????int?result?=?-1;
????????if?（Connection.State?==?ConnectionState.Closed）
????????{
????????????Connection.Open（）;
????????}

????????command.CommandText?=?sqlNonQuery;
????????result?=?command.ExecuteNonQuery（）;
????????Connection.Close（）;
????????return?result;
????}

????public?DataSet?RunQuery（?string?sqlQuery?string?tableName?）
????{
????????DataSet?ds?=?new?DataSet（）;
????????if?（Connection.State?==?ConnectionState.Closed）
????????{
????????????Connection.Open（）;
????????}
??????????
????????command.CommandText?=?sqlQuery;
????????OracleDataAdapter?oraDA?=?new?OracleDataAdapter（）;
????????oraDA.SelectCommand?=?command;
????????oraDA.Fill（?ds?tableName?）;
????????Connection.Close（）;
????????return?ds;
????}

????public?void?RunQuery（string?sqlQuery?DataSet?dataSet?string?tableName?）
????{
????????if?（Connection.State?==?ConnectionState.Closed）
????????{
????????????Connection.Open（）;
????????}

????????command.CommandText?=?sqlQuery;
????????OracleDataAdapter?oraDA?=?new?OracleDataAdapter（）;
????????oraDA.SelectCommand?=?command;
????????oraDA.Fill（dataSet?tableName）;
????????Connection.Close（）;			
????}

????public?void?ExeFunc（OracleCommand?myCmd）
????{?
????????//int?result?=?-1;
????????myCmd.Connection?=?this.Connection;
????????if?（Connection.State?==?ConnectionState.Closed）
????????{
????????????Connection.Open（）;
????????}
???????

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件????????446??2012-08-16?13:03??gzdemo\gzdemo\app.config

?????文件???????4593??2012-08-21?16:50??gzdemo\gzdemo\Datalayer.cs

?????文件???????1389??2012-08-21?10:19??gzdemo\gzdemo\FormLogin.cs

?????文件???????7513??2012-08-21?10:19??gzdemo\gzdemo\FormLogin.Designer.cs

?????文件???????5817??2012-08-21?10:19??gzdemo\gzdemo\FormLogin.resx

?????文件??????12356??2012-08-21?10:27??gzdemo\gzdemo\FormMain.cs

?????文件??????30421??2012-08-21?10:27??gzdemo\gzdemo\FormMain.Designer.cs

?????文件??????14890??2012-08-21?10:27??gzdemo\gzdemo\FormMain.resx

?????文件???????4176??2012-08-21?16:54??gzdemo\gzdemo\gzdemo.csproj

?????文件???????1406??2009-08-30?20:35??gzdemo\gzdemo\Images\BLD.ico

?????文件????????612??2009-08-30?20:35??gzdemo\gzdemo\Images\copy.Image.png

?????文件????????521??2009-08-30?20:35??gzdemo\gzdemo\Images\cut.Image.png

?????文件???????1406??2009-08-30?20:35??gzdemo\gzdemo\Images\ITL.ICO

?????文件????????401??2009-08-30?20:35??gzdemo\gzdemo\Images\new.Image.png

?????文件????????732??2009-08-30?20:35??gzdemo\gzdemo\Images\open.Image.png

?????文件????????722??2009-08-30?20:35??gzdemo\gzdemo\Images\paste.Image.png

?????文件????????687??2009-08-30?20:35??gzdemo\gzdemo\Images\print.Image.png

?????文件????????528??2009-08-30?20:35??gzdemo\gzdemo\Images\printPreview.Image.png

?????文件????????686??2009-08-30?20:35??gzdemo\gzdemo\Images\save.Image.png

?????文件???????1406??2009-08-30?20:35??gzdemo\gzdemo\Images\UNDRLN.ICO

?????文件????????501??2012-08-16?09:58??gzdemo\gzdemo\Program.cs

?????文件???????1424??2012-08-16?09:35??gzdemo\gzdemo\Properties\AssemblyInfo.cs

?????文件???????2838??2012-08-16?09:40??gzdemo\gzdemo\Properties\Resources.Designer.cs

?????文件???????5612??2012-08-16?09:35??gzdemo\gzdemo\Properties\Resources.resx

?????文件???????1697??2012-08-16?13:03??gzdemo\gzdemo\Properties\Settings.Designer.cs

?????文件???????1016??2012-08-16?13:03??gzdemo\gzdemo\Properties\Settings.settings

?????文件????????860??2012-08-16?09:35??gzdemo\gzdemo.sln

????..A..H.?????36352??2012-08-21?16:55??gzdemo\gzdemo.suo

?????目錄??????????0??2012-08-21?16:55??gzdemo\gzdemo\bin

?????目錄??????????0??2012-08-21?16:52??gzdemo\gzdemo\Images

............此處省略7個文件信息