C#操作Access数据库的DBHelper类

using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;

namespace InfoManger.MobDbHelper
{
    //本DBHelper适用于ACCESS
    //如果每次执行完后关闭conn,会导致程序卡顿，建议在程序使用期间不要关闭conn
    //每次使用都会执行try{} catch{},容错能力比较强
    class DbHelper
    {
        public static OleDbConnection conn = null;

        private static void InitConnection()
        {
            try
            {
                if (conn == null)
                    conn = new OleDbConnection(ConnectionString.StrCnn);

                if (conn.State == ConnectionState.Broken)
                {
                    conn.Close();
                    conn.Open();
                }

                if (conn.State == ConnectionState.Closed)
                {
                    conn.Open();
                }
            }
            catch (OleDbException Ex)
            {
                MessageBox.Show(Ex.Message);
                conn.Close();
            }
        }

        //获取DataReader
        public static OleDbDataReader GetOleDbDataReader(string str)
        {
            InitConnection();
            try
            {
                OleDbCommand cmd = new OleDbCommand(str, conn);
                return cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
            catch (OleDbException Ex)
            {
                MessageBox.Show(Ex.Message);
                return null;
            }

        }

        //查询，获取DataSet
        public static DataSet GetDataSet(string sqlStr)
        {
            InitConnection();

            try
            {
                DataSet ds = new DataSet();
                OleDbDataAdapter dap = new OleDbDataAdapter(sqlStr, conn);
                dap.Fill(ds);
                return ds;
            }
            catch (OleDbException Ex)
            {
                MessageBox.Show(Ex.Message);
                return null;
            }
            //conn.Close();
        }

        //查询，获取DataTable
        public static DataTable GetDataTable(string sqlStr)
        {
            try
            {
                return GetDataSet(sqlStr).Tables[0];
            }
            catch (OleDbException Ex)
            {
                MessageBox.Show(Ex.Message);
                return null;
            }
        }

        //增删改
        public static int ExecuteNonQuery(string sqlStr)
        {
            InitConnection();

            try
            {
                OleDbCommand cmd = new OleDbCommand(sqlStr, conn);
                int result = cmd.ExecuteNonQuery();
                //conn.Close();
                return result;
            }
            catch (OleDbException Ex)
            {
                MessageBox.Show(Ex.Message);
                return 0;
            }
        }

        //执行集合函数
        public static object ExecuteScalar(string sqlStr)
        {
            InitConnection();

            try
            {
                OleDbCommand cmd = new OleDbCommand(sqlStr, conn);
                object result = cmd.ExecuteScalar();
                //conn.Close();
                return result;
            }
            catch (OleDbException Ex)
            {
                MessageBox.Show(Ex.Message);
                return null;
            }
        }
    }
}