ACCESS数据库重复 DBHelper类

View Code

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data;
using System.Data.OleDb;
/// <summary>
/// DBHelper 的摘要说明
/// </summary>
public static class DBHelper
{
  

    private static readonly string conStr = System.Configuration.ConfigurationManager.ConnectionStrings["WebSiteConnectionString"].ConnectionString;

    public static OleDbConnection GetConnection
    {
        get
        {
            return new OleDbConnection(conStr)
        }
    }

    //增、删、改
    public static int ExcuteCommand(String safeSql)
    {
        int result = 0;
        using (OleDbConnection conn = GetConnection)
        {
            conn.Open();
            OleDbCommand cmd = new  OleDbCommand(safeSql, conn);
            result = cmd.ExecuteNonQuery();
        }
        return result;
    }
    
    //重载(增、删、改)带参数
    public static int ExcuteCommand(String safeSql, params OleDbParameter[] param)
    {
        int result = 0;
        using (OleDbConnection conn = GetConnection)
        {
            conn.Open();
            OleDbCommand cmd = new OleDbCommand(safeSql, conn);
            cmd.Parameters.AddRange(param);
            result = cmd.ExecuteNonQuery();
        }
        return result;
    }

    public static Object GetScalar(String safeSql)
    {
        Object obj = null;
        using (OleDbConnection conn = GetConnection)
        {
            conn.Open();
            OleDbCommand cmd = new OleDbCommand(safeSql, conn);
            obj = cmd.ExecuteScalar();
        }
        return obj;
    }

    public static Object GetScalar(String safeSql, params OleDbParameter[] param)
    {
        Object obj = null;
        using (OleDbConnection conn = GetConnection)
        {
            conn.Open();
            OleDbCommand cmd = new OleDbCommand(safeSql, conn);
            cmd.Parameters.AddRange(param);
            obj = cmd.ExecuteScalar();
        }
        return obj;
    }

    public static OleDbDataReader GetDataReader(String safeSql)
    {
        OleDbConnection conn = GetConnection;
        conn.Open();
        OleDbCommand cmd = new OleDbCommand(safeSql, conn);
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
    }

    public static OleDbDataReader GetDataReader
        (String safeSql, params OleDbParameter[] param)
    {
        OleDbConnection conn = GetConnection;
        conn.Open();
        OleDbCommand cmd = new OleDbCommand(safeSql, conn);
        cmd.Parameters.AddRange(param);
        return cmd.ExecuteReader(CommandBehavior.CloseConnection);
    }

    public static DataTable GetDataTable(String safeSql)
    {
        DataTable dt = new DataTable();
        OleDbDataAdapter sda = new OleDbDataAdapter(safeSql, GetConnection);
        sda.Fill(dt);
        return dt;
    }

    public static DataTable GetDataTable(String safeSql, params OleDbParameter[] param)
    {
        DataTable dt = new DataTable();
        OleDbDataAdapter sda = new OleDbDataAdapter(safeSql, GetConnection);
        sda.SelectCommand.Parameters.AddRange(param);
        sda.Fill(dt);
        return dt;
    }
}

 

转载于:https://www.cnblogs.com/lijie007jh/archive/2012/06/24/2560043.html