DBUtility/OleDbHelper.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace ClothesShop.DBUtility
{
    public class OleDbHelper
    {
        public OleDbHelper(){ }

    /// <summary>
    /// 返回数据库连接字符串
    /// </summary>
    /// <returns></returns>
    public static String GetSqlConnection()
    {
        System.Web.UI.Page page = new System.Web.UI.Page();
        String conn = ConfigurationSettings.AppSettings["OleDbConnectionString"].ToString() + page.Server.MapPath("~/" + ConfigurationSettings.AppSettings["AccessDbPath"].ToString());
        return conn;
    }

    /// <summary>
    ///  获得参数对象 
    /// </summary>
    /// <param name="paramName">参数名称</param>
    /// <param name="paramType">数据类型</param>
    /// <param name="paramSize">长度</param>
    /// <param name="ColName">源列名称</param>
    /// <param name="paramValue">参数实值</param>
    /// <returns></returns>
    public static OleDbParameter GetParameter(String paramName, OleDbType paramType, Int32 paramSize, String ColName, Object paramValue)
    {
        OleDbParameter param = new OleDbParameter(paramName, paramType, paramSize, ColName);
        param.Value = paramValue;
        return param;
    }

    /// <summary>
    /// 获得参数对象
    /// </summary>
    /// <param name="paramName">参数名称</param>
    /// <param name="paramType">数据类型</param>
    /// <param name="paramSize">长度</param>
    /// <param name="ColName">源列名称</param>
    /// <returns></returns>
    public static OleDbParameter GetParameter(String paramName, OleDbType paramType, Int32 paramSize, String ColName)
    {
        OleDbParameter param = new OleDbParameter(paramName, paramType, paramSize, ColName);
        return param;
    }

    /// <summary>
    /// 获得参数对象
    /// </summary>
    /// <param name="paramName">参数名称</param>
    /// <param name="paramType">数据类型</param>