c# 数据库的 sql 参数封装类的编写

概述数据库的 sql 参数封装类的编写复制代码代码如下:using System;using System.Data;using System.Configuration;using System.Web;using System.Web.Security;using System.

数据库的 sql 参数封装类的编写
复制代码 代码如下:
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.sqlClIEnt;
using System.Text;
namespace ChinaSite.classes
{
    public class dbaccess
    {
        sqlConnection conn = null;
        sqlCommand cmd = null;
        public dbaccess()
        {
            //
            // Todo: 在此处添加构造函数逻辑
            //
            conn = new sqlConnection();
            //conn.ConnectionString = "initial catalog=pubs;data source=.;user ID=sa;password=";
            //conn.ConnectionString = Convert.ToString(System.Configuration.ConfigurationSettings.AppSettings["datasource"]);
            conn.ConnectionString = Convert.ToString(System.Configuration.ConfigurationManager.AppSettings["datasource"]);
            cmd = new sqlCommand();
            cmd.Connection = conn;
        }
        /// <summary>
        /// 获取数据根据SQL语句 
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public Datatable Gettable(string sql)
        {
            DataSet ds = new DataSet();

            try
            {
                cmd.CommandText = sql;
                sqlDataAdapter da = new sqlDataAdapter();
                da.SelectCommand = cmd;

                da.Fill(ds);
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return null;

            }
            return ds.tables[0] ?? new Datatable();
        }

        /// <summary>
        /// 获取数据根据SQL语句 带参数 的 
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="pas"></param>
        /// <returns></returns>
        public Datatable Gettable(string sql, params sqlParameter[] pas)
        {
            DataSet ds = new DataSet();
            try
            {
                cmd.CommandText = sql;
                sqlDataAdapter da = new sqlDataAdapter();
                da.SelectCommand = cmd;
                cmd.Parameters.Clear();

                foreach (sqlParameter temppa in pas)
                {
                    cmd.Parameters.Add(temppa);
                }


                da.Fill(ds);
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return null;
            }
            return ds.tables[0] ?? new Datatable();
        }
        /// <summary>
        /// 根据SQL语句返回跟新状态
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public bool GetState(string sql)
        {
            bool succ = false;
            try
            {
                cmd.CommandText = sql;
                conn.open();
                succ = cmd.ExecuteNonquery() > 0 ? (true) : (false);
                conn.Close();
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return false;
            }
            return succ;

        }
        /// <summary>
        /// 根据SQL语句返回跟新状态带参数的 
        /// </summary>
        /// <param name="sql">SQL语句</param>
        /// <param name="pas">参数的集合</param>
        /// <returns></returns>
        public bool GetState(string sql, params sqlParameter[] pas)
        {
            bool succ = false;
            try
            {
                cmd.CommandText = sql;
                cmd.Parameters.Clear();

                foreach (sqlParameter temppa in pas)
                {
                    cmd.Parameters.Add(temppa);
                }
                conn.open();
                succ = cmd.ExecuteNonquery() > 0 ? (true) : (false);
                conn.Close();
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return false;
            }
            return succ;

        }
        /// <summary>
        /// 根据SQL语句返回第一个单元格的数据
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public string Getone(string sql)
        {
            string res = "";
            try
            {
                cmd.CommandText = sql;
                conn.open();
                res = cmd.ExecuteScalar() == null ? ("") : (Convert.ToString(cmd.ExecuteScalar()));
                conn.Close();
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return null;
            }
            return res;
        }
        /// <summary>
        ///  根据SQL语句返回第一个单元格的数据带参数的 
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="pas"></param>
        /// <returns></returns>
        public string Getone(string sql, params sqlParameter[] pas)
        {
            string res = "";
            try
            {
                cmd.CommandText = sql;
                cmd.Parameters.Clear();

                foreach (sqlParameter temppa in pas)
                {
                    cmd.Parameters.Add(temppa);
                }
                conn.open();
                res = cmd.ExecuteScalar() == null ? ("") : (Convert.ToString(cmd.ExecuteScalar()));
                conn.Close();
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return null;
            }
            return res;
        }
        /// <summary>
        /// 返回数据的DataReader
        /// </summary>
        /// <param name="sql"></param>
        /// <returns></returns>
        public sqlDataReader GetDataReader(string sql)
        {
            sqlDataReader dr = null;
            try
            {
                conn.open();
                cmd.CommandText = sql;
                dr = cmd.ExecuteReader();
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return null;
            }
            return dr;
        }
        /// <summary>
        /// 返回数据的DataReader带参数的 
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="pas"></param>
        /// <returns></returns>
        public sqlDataReader GetDataReader(string sql, params sqlParameter[] pas)
        {
            sqlDataReader dr = null;
            try
            {
                conn.open();
                cmd.Parameters.Clear();

                foreach (sqlParameter temppa in pas)
                {
                    cmd.Parameters.Add(temppa);
                }

                cmd.CommandText = sql;
                dr = cmd.ExecuteReader();
            }
            catch (Exception ex)
            {

                this.ShowError(ex.Message);
                return null;
            }
            return dr;
        }
        /// <summary>
        /// 打开连接
        /// </summary>
        public voID OpenConn()
        {
            if (conn.State != ConnectionState.Open)
            {
                try
                {
                    conn.open();
                }
                catch (Exception ex)
                {

                    this.ShowError(ex.Message);
                    return;
                }
            }
        }
        /// <summary>
        /// 关闭连接
        /// </summary>
        public voID CloseConn()
        {
            if (conn.State != ConnectionState.Closed)
            {
                try
                {
                    conn.Close();
                    cmd = null;
                    conn = null;
                }
                catch (Exception ex)
                {

                    this.ShowError(ex.Message);
                    return;
                }
            }
        }
        /// <summary>
        /// d出错误的信息 
        /// </summary>
        /// <param name="err"></param>
        public voID ShowError(string err)
        {
            System.Web.httpContext.Current.Response.Write(Script(err, ""));
        }
        /// <summary>
        /// 显示信息 
        /// </summary>
        /// <param name="err"></param>
        public voID ShowMessage(string mes, string loc)
        {
            System.Web.httpContext.Current.Response.Write(Script(mes, loc));
        }
        /// <summary>
        /// JavaScript脚本
        /// </summary>
        /// <param name="mess"></param>
        /// <param name="loc"></param>
        /// <returns></returns>
        public string Script(string mess, string loc)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append("<script language='JavaScript'>");
            sb.Append("alter('");
            sb.Append(mess);
            sb.Append("');");
            sb.Append(loc);
            sb.Append("</script>");
            return sb.ToString();

        }

    }
}

总结

以上是内存溢出为你收集整理的c# 数据库的 sql 参数封装类的编写全部内容，希望文章能够帮你解决c# 数据库的 sql 参数封装类的编写所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。