using?System;
using?System.Collections.Generic;
using?System.Text;
using?System.Data.OracleClient;
using?System.Data;

namespace?CS1
{
????public?class?DBHelper
????{
????????public?static?OracleConnection?conn?=?null;
????????public?static?OracleCommand?cmd?=?null;
????????public?static?string?cstr?=?“Data?source=ORCL_local;user?id=scott;password=tiger;“;

????????public?DBHelper（）
????????{?}

????????#region?建立數(shù)據(jù)庫連接對象
????????///?

????????///?建立數(shù)據(jù)庫連接
????????///?

????????///?返回一個數(shù)據(jù)庫的連接OracleConnection對象
????????public?static?OracleConnection?init（）
????????{
????????????try
????????????{
????????????????conn?=?new?OracleConnection（cstr）;
????????????????if?（conn.State!=ConnectionState.Open）
????????????????{
????????????????????conn.Open（）;
????????????????}
????????????}
????????????catch?（Exception?e）
????????????{
????????????????throw?new?Exception（e.Message.ToString（））;
????????????}
????????????return?conn;
????????}
????????#endregion


????????#region?設(shè)置OracleCommand對象
????????///?

????????///?設(shè)置OracleCommand對象???????
????????///?

????????///?OracleCommand對象?
????????///?命令文本
????????///?命令類型
????????///?參數(shù)集合
????????private?static?void?SetCommand（OracleCommand?cmd?string?cmdText?CommandType?cmdType?OracleParameter[]?cmdParms）
????????{
????????????cmd.Connection?=?conn;
????????????cmd.CommandText?=?cmdText;
????????????cmd.CommandType?=?cmdType;
????????????if?（cmdParms?!=?null）
????????????{
????????????????cmd.Parameters.AddRange（cmdParms）;
????????????}
????????}
????????#endregion


????????#region?執(zhí)行相應的sql語句，返回相應的DataSet對象
????????///?

????????///?執(zhí)行相應的sql語句，返回相應的DataSet對象
????????///?

????????///?sql語句
????????///?返回相應的DataSet對象
????????public?static?DataSet?GetDataSet（string?sqlstr）
????????{
????????????DataSet?set?=?new?DataSet（）;
????????????try
????????????{
????????????????init（）;
????????????????OracleDataAdapter?adp?=?new?OracleDataAdapter（sqlstr?conn）;
????????????????adp.Fill（set）;
????????????????conn.Close（）;
????????????}
????????????catch?（Exception?e）
????????????{
????????????????throw?new?Exception（e.Message.ToString（））;
????????????}
????????????return?set;
????????}
????????#endregion


????????#region?執(zhí)行相應的sql語句，返回相應的DataSet對象
????????///?

????????///?執(zhí)行相應的sql語句，返回相應的DataSet對象
????????///?

????????///?sql語句
????????///?表名
????????///?返回相應的DataSet對象
????????public?static?DataSet?GetDataSet（string?sqlstr?string?tableName）
????????{
????????????DataSet?set?=?new?DataSet（）;
????????????try
????????????{
????????????????init（）;
????????????????OracleDataAdapter?adp?=?new?Oracl

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----
?????目錄???????????0??2013-04-28?16:20??CS1\
?????目錄???????????0??2013-04-28?16:20??CS1\CS1\
?????文件?????????898??2012-12-17?09:42??CS1\CS1.sln
?????文件???????21504??2013-04-07?17:31??CS1\CS1.suo
?????文件?????????830??2012-12-21?11:53??CS1\CS1\app.config
?????目錄???????????0??2013-04-28?16:20??CS1\CS1\bin\
?????目錄???????????0??2013-04-28?16:20??CS1\CS1\bin\Debug\
?????文件???????45056??2012-12-27?11:22??CS1\CS1\bin\Debug\CS1.exe
?????文件?????????830??2012-12-21?11:53??CS1\CS1\bin\Debug\CS1.exe.config
?????文件???????62976??2012-12-27?11:22??CS1\CS1\bin\Debug\CS1.pdb
?????文件????????5632??2005-11-11?22:25??CS1\CS1\bin\Debug\CS1.vshost.exe
?????文件?????????830??2012-12-21?11:53??CS1\CS1\bin\Debug\CS1.vshost.exe.config
?????目錄???????????0??2013-04-28?16:20??CS1\CS1\bin\Release\
?????文件???????40960??2012-12-27?11:23??CS1\CS1\bin\Release\CS1.exe
?????文件?????????830??2012-12-21?11:53??CS1\CS1\bin\Release\CS1.exe.config
?????文件???????56832??2012-12-27?11:23??CS1\CS1\bin\Release\CS1.pdb
?????文件????????5632??2005-11-11?22:25??CS1\CS1\bin\Release\CS1.vshost.exe
?????文件?????????830??2012-12-21?11:53??CS1\CS1\bin\Release\CS1.vshost.exe.config
?????文件????????8192??2012-12-27?11:23??CS1\CS1\bin\Release\CS1.xmlSerializers.dll
?????文件????????5378??2012-12-21?11:54??CS1\CS1\CS1.csproj
?????文件????????8937??2012-12-21?17:01??CS1\CS1\DBHelper.cs
?????文件????????5521??2012-12-21?17:04??CS1\CS1\frm_add.cs
?????文件???????16688??2012-12-17?18:14??CS1\CS1\frm_add.Designer.cs
?????文件????????5814??2012-12-17?18:14??CS1\CS1\frm_add.resx
?????文件????????4098??2012-12-27?11:22??CS1\CS1\frm_main.cs
?????文件????????9558??2012-12-21?11:54??CS1\CS1\frm_main.Designer.cs
?????文件????????6019??2012-12-21?11:54??CS1\CS1\frm_main.resx
?????文件????????3386??2012-12-17?14:59??CS1\CS1\frm_up.cs
?????文件???????14154??2012-12-17?14:30??CS1\CS1\frm_up.Designer.cs
?????文件????????5814??2012-12-17?14:30??CS1\CS1\frm_up.resx
?????文件?????????481??2012-12-17?10:40??CS1\CS1\gg.cs
............此處省略37個文件信息