当前文件： mvcMemberShip/DBUtility/DBaccess.cs[5K，2009-6-12 11:48:02]，打开代码结构图

		            
  1using System;
  2using System.Collections;
  3using System.Web;
  4using System.Data;
  5using System.Data.OleDb;
  6using System.Configuration;
  7
  8namespace Tmw.DBUtility
  9...{
 10    /**//// <summary>
 11    /// Access数据库操作类
 12    /// 2007-04-19
 13    /// 作者:汤明伟
 14    /// </summary>
 15    public class DBaccess
 16    ...{
 17        //获取Web.Config数据库连接字符串
 18        private static readonly string OleDbConnectionString = "Provider = Microsoft.Jet.OleDb.4.0; Data Source = " + HttpContext.Current.Server.MapPath(ConfigurationManager.ConnectionStrings["fallstaraccessConnection"].ConnectionString);
 19            //ConfigurationManager.ConnectionStrings["fallstaraccessConnection"].ConnectionString;
 20
 21        private static OleDbConnection cn;        //创建SQL连接
 22        private static OleDbDataAdapter sda;        //创建SQL数据适配器
 23        private static OleDbDataReader sdr;        //创建SQL数据读取器
 24        private static OleDbCommand cmd;            //创建SQL命令对象
 25        // private OleDbParameter param;     //创建SQL参数
 26        private static DataSet ds;                //创建数据集
 27        private static DataView dv;            //创建视图        
 28
 29        /**//// <summary>
 30        /// 打开数据库连接
 31        /// </summary>
 32        public static void Open()
 33        ...{
 34            ...#region
 35            cn = new OleDbConnection(OleDbConnectionString);
 36            cn.Open();
 37            #endregion
 38        }
 39
 40
 41        /**//// <summary>
 42        /// 关闭数据库连接
 43        /// </summary>
 44        public static void Close()
 45        ...{
 46            ...#region
 47            if (cn != null)
 48            ...{
 49                cn.Close();
 50                cn.Dispose();
 51            }
 52            #endregion
 53        }
 54
 55
 56        /**//// <summary>
 57        /// 返回DataSet数据集
 58        /// </summary>
 59        /// <param name="strSql">SQL语句</param>
 60        public static DataSet GetDs(string strSql)
 61        ...{
 62            ...#region
 63            Open();
 64            sda = new OleDbDataAdapter(strSql, cn);
 65            ds = new DataSet();
 66            sda.Fill(ds);
 67            Close();
 68            return ds;
 69            #endregion
 70        }
 71
 72        /**//// <summary>
 73        /// 添加DataSet表
 74        /// </summary>
 75        /// <param name="ds">DataSet对象</param>
 76        /// <param name="strSql">Sql语句</param>
 77        /// <param name="strTableName">表名</param>
 78        public static void GetDs(DataSet ds, string strSql, string strTableName)
 79        ...{
 80            ...#region
 81            Open();
 82            sda = new OleDbDataAdapter(strSql, cn);
 83            sda.Fill(ds, strTableName);
 84            Close();
 85            #endregion
 86        }
 87
 88
 89        /**//// <summary>
 90        /// 返回DataView数据视图
 91        /// </summary>
 92        /// <param name="strSql">Sql语句</param>
 93        public static DataView GetDv(string strSql)
 94        ...{
 95            ...#region
 96            dv = GetDs(strSql).Tables[0].DefaultView;
 97            return dv;
 98            #endregion
 99        }
100
101
102        /**//// <summary>
103        /// 获得DataTable对象
104        /// </summary>
105        /// <param name="strSql">SQL语句</param>
106        /// <returns></returns>
107        public static DataTable GetTable(string strSql)
108        ...{
109            ...#region
110            return GetDs(strSql).Tables[0];
111            #endregion
112        }
113
114
115        /**//// <summary>
116        /// 获得OleDbDataReader对象 使用完须关闭DataReader,关闭数据库连接
117        /// </summary>
118        /// <param name="strSql">sql语句</param>
119        /// <returns></returns>
120        public static OleDbDataReader GetDataReader(string strSql)
121        ...{
122            ...#region
123            Open();
124            cmd = new OleDbCommand(strSql, cn);
125            sdr = cmd.ExecuteReader(System.Data.CommandBehavior.CloseConnection);
126            return sdr;
127            #endregion
128        }
129
130
131
132        /**//// <summary>
133        /// 执行Sql语句
134        /// </summary>
135        /// <param name="strSql"></param>
136        public static int RunSql(string strSql)
137        ...{
138            ...#region
139            int rows = 0;
140            Open();
141            cmd = new OleDbCommand(strSql, cn);
142            rows= cmd.ExecuteNonQuery();
143            Close();
144            return rows;
145            #endregion
146        }
147
148
149
150        /**//// <summary>
151        /// 执行SQL语句，并返回第一行第一列结果
152        /// </summary>
153        /// <param name="strSql">SQL语句</param>
154        /// <returns></returns>
155        public static string RunSqlReturn(string strSql)
156        ...{
157            ...#region
158            string strReturn = "";
159            Open();
160            try
161            ...{
162                cmd = new OleDbCommand(strSql, cn);
163                strReturn = cmd.ExecuteScalar().ToString();
164            }
165            catch ...{ }
166            Close();
167            return strReturn;
168            #endregion
169        }
170        public static bool Exists(string strSql)
171        ...{
172            DataTable dt = GetTable(strSql);
173            return (dt.Rows.Count > 0) ? true : false;
174        }
175         /**//// <summary>
176        /// 执行多条SQL语句，实现数据库事务。
177        /// </summary>
178        /// <param name="SQLStringList">多条SQL语句</param>        
179        public static void ExecuteSqlTran(ArrayList SQLStringList)
180        ...{
181            for (int i = 0; i < SQLStringList.Count; i++)
182            ...{
183                string strsql = SQLStringList[i].ToString();
184                RunSql(strsql);
185            }
186        }
187    }
188}
189