.net 简易数据库操作框架1.1

来源：互联网发布：云计算日语编辑：程序博客网时间：2024/05/17 07:42

作为一名软件菜鸟，开始我数据库操作框架的编写。从事编程时间不长，所以可能有些地方描述的不准确，方法用的不够精准，望各位批评指正，谢谢！既然是数据库操作，那首先就要搭建数据库操作接口。

 public interface DBHelpercs    {        /// <summary>        /// 获取数据库连接        /// </summary>        /// <returns></returns>        DbConnection getConnection();        /// <summary>        /// 释放数据库连接资源        /// </summary>        /// <param name="conn"></param>        /// <param name="comm"></param>        void ReleaseResource(DbConnection conn,DbCommand comm,DbDataReader reader);        /// <summary>        /// 执行增删改操作        /// </summary>        /// <param name="par">参数</param>        /// <param name="sql">执行语句</param>        /// <returns></returns>        int exectue(DbParameter[] par,string sql);        /// <summary>        /// 执行查询操作        /// </summary>        /// <param name="par">参数</param>        /// <param name="sql">执行语句</param>        /// <returns></returns>        DbDataReader Query(DbParameter[] par, string sql);        /// <summary>        /// 获取单行单列        /// </summary>        /// <param name="par">参数</param>        /// <param name="sql">执行语句</param>        /// <returns></returns>        object SingleLine(DbParameter[] par, string sql);    }

然后我实现了SqlServer的操作方法

     public class SqlHelper : DBHelpercs    {        public string conSql;        /// <summary>        /// 实例化数据库操作对象        /// </summary>        /// <param name="conSql"></param>        public SqlHelper(string conSql){            this.conSql = conSql;        }        public SqlHelper()        {        }        SqlCommand comm = null;        SqlConnection conn = null;        public int exectue(DbParameter[] par, string sql)        {            conn = getConnection() as SqlConnection;            conn.Open();            comm = new SqlCommand(sql,conn);            comm.Parameters.AddRange(par);            int row = comm.ExecuteNonQuery();            ReleaseResource(conn,comm,null);            return row;        }        public DbConnection getConnection()        {            if (conSql != null)            {                return new SqlConnection(conSql);            }            else            {                throw new ArgumentNullException();            }        }        public DbDataReader Query(DbParameter[] par, string sql)        {            conn = getConnection() as SqlConnection;            conn.Open();            comm = new SqlCommand(sql, conn);            comm.Parameters.AddRange(par);            return comm.ExecuteReader(CommandBehavior.CloseConnection);        }        public void ReleaseResource(DbConnection conn, DbCommand comm, DbDataReader reader)        {            if (conn != null) conn.Close();            if (comm != null) comm.Dispose();            if (reader != null) reader.Close();        }        public object SingleLine(DbParameter[] par, string sql)        {            conn = getConnection() as SqlConnection;            conn.Open();            comm = new SqlCommand(sql, conn);            foreach (var item in par)            {                SqlParameter pp = (SqlParameter)((ICloneable)item).Clone();                comm.Parameters.Add(pp);            }            object row = comm.ExecuteScalar();            ReleaseResource(conn, comm, null);            return row;        }    }

以上就实现了就数据库简易操作的方法     第一次写博客，很多地方不懂，欢迎大家批评指正，谢谢！

阅读全文

0 0