asp.net常用类--Access数据操作类

来源：互联网发布：马扎克编程入门编辑：程序博客网时间：2024/06/05 17:41

OleDbHelper.cs

using System;
using System.Web;
using System.Collections.Generic;
using System.Text;
using System.Collections;
using System.Data;
using System.Data.OleDb;
using System.Configuration;
using System.ComponentModel;

namespace OleDbHelper
{
    public class OleDbHelper
    {
        /// 连接数据源
        private OleDbConnection MyConn = null;
        private readonly string RETURNVALUE = "RETURNVALUE";

        /// <summary>
        /// 打开数据库连接.
        /// </summary>
        private void Open()
        {
            // 打开数据库连接
            if (MyConn == null)
            {
                MyConn = new OleDbConnection(ConfigurationManager.AppSettings["OLEDBCONNECTIONSTRING"].ToString() + System.Web.HttpContext.Current.Server.MapPath(ConfigurationManager.AppSettings["dbPath"]));
            }
            if (MyConn.State == ConnectionState.Closed)
            {
                try
                {
                    ///打开数据库连接
                    MyConn.Open();
                }
                catch (Exception ex)
                {
                    SystemError.CreateErrorLog(ex.Message);
                }
                finally
                {
                    ///关闭已经打开的数据库连接
                }
            }
        }

        /// <summary>
        /// 关闭数据库连接
        /// </summary>
        public void Close()
        {
            ///判断连接是否已经创建
            if (MyConn != null)
            {
                ///判断连接的状态是否打开
                if (MyConn.State == ConnectionState.Open)
                {
                    MyConn.Close();
                }
            }
        }

        /// <summary>
        /// 释放资源
        /// </summary>
        public void Dispose()
        {
            // 确认连接是否已经关闭
            if (MyConn != null)
            {
                MyConn.Dispose();
                MyConn = null;
            }
        }

        private OleDbCommand TrySqlCommand(string cmdText)
        {
            OleDbCommand cmd = new OleDbCommand(cmdText, MyConn);
            cmd.ExecuteNonQuery();
            return cmd;
        }
        private OleDbCommand CreateSQLCommand(string cmdText)
        {
            Open();
            OleDbCommand cmd = new OleDbCommand(cmdText, MyConn);
            return cmd;
        }
        public void TryCmd(string cmdText)
        {
            OleDbCommand cmd = TrySqlCommand(cmdText);
        }
        public void RunCmd(string cmdText, out OleDbDataReader dataReader)
        {
            ///创建Command
            OleDbCommand cmd = CreateSQLCommand(cmdText);

            try
            {
                ///读取数据
                dataReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            }
            catch (Exception ex)
            {
                dataReader = null;
                ///记录错误日志
                SystemError.CreateErrorLog(ex.Message);
            }
        }
        //创建ADAPTER
        private OleDbDataAdapter CreateProcDataAdapter(string cmdText)
        {
            ///打开数据库连接
            Open();
            ///设置SqlDataAdapter对象
            OleDbDataAdapter da = new OleDbDataAdapter(cmdText, MyConn);
            da.SelectCommand.CommandType = CommandType.Text;
            return da;
        }

}

}
SystemError.cs

using System;
using System.IO;
using System.Collections.Generic;
using System.Text;

namespace OleDbHelper
{
    /// <summary>
    /// 错误处理函数，用于记录错误日志
    /// </summary>
    public class SystemError
    {
        //记录错误日志位置
        private static string m_fileName = System.Web.HttpContext.Current.Server.MapPath("Systemlog.log");

        public static String FileName
        {
            get
            {
                return (m_fileName);
            }
            set
            {
                if (value != null || value != "")
                {
                    m_fileName = value;
                }
            }
        }

        /// <summary>
        /// 记录日志至文本文件
        /// </summary>
        /// <param name="message">记录的内容</param>
        public static void CreateErrorLog(string message)
        {
            if (File.Exists(m_fileName))
            {
                ///如果日志文件已经存在，则直接写入日志文件
                StreamWriter sr = File.AppendText(FileName);
                sr.WriteLine("/n");
                sr.WriteLine(DateTime.Now.ToString() + message);
                sr.Close();
            }
            else
            {
                ///创建日志文件
                StreamWriter sr = File.CreateText(FileName);
                sr.Close();
            }
        }
    }
}
SystemTools.cs

using System;
using System.Collections.Generic;
using System.Text;

namespace OleDbHelper
{
    public class SystemException : Exception
    {
        /// <summary>
        /// 包含系统Excepton
        /// </summary>
        public SystemException(string source, string message, Exception inner)
            : base(message, inner)
        {
            base.Source = source;
        }

        /// <summary>
        /// 不包含系统Excepton
        /// </summary>
        public SystemException(string source, string message)
            : base(message)
        {
            base.Source = source;
        }
    }

    /// <summary>
    /// 处理网页中的HTML代码，并消除危险字符
    /// </summary>
    public class SystemHTML
    {
        private static string HTMLEncode(string fString)
        {
            if (fString != string.Empty)
            {
                ///替换尖括号
                fString.Replace("<", "<");
                fString.Replace(">", "&rt;");
                ///替换引号
                fString.Replace(((char)34).ToString(), """);
                fString.Replace(((char)39).ToString(), "'");
                ///替换空格
                fString.Replace(((char)13).ToString(), "");
                ///替换换行符
                fString.Replace(((char)10).ToString(), "<BR> ");
            }
            return (fString);
        }
    }
}