一个SqlHealper方法 进行数据库交互集成

第一次尝试写技术类的文章，请大家多多指教！

这次主要写的是一个SqlHealper类，用于与数据库交互操作（select、update、delete）；

代码如下：

public class SqlHealper
    {
        private bool successFlag;
        public bool SuccessFlag
        {
            get { return successFlag; }
        }

        private string strErrMessage;
        public string StrErrMessage
        {
            get { return strErrMessage; }
        }

        private SqlConnection comConn;
        private SqlCommand comCmd;
        private SqlDataAdapter comDa;
        private DataTable comDt;
        private DataSet comDs;

        /// <summary>
        /// 获取默认的连接字符串
        /// </summary>
        /// <returns></returns>
        private string GetDefaultConnString()
        {
            //return System.Configuration.ConfigurationManager.AppSettings["UserConnectionString"].ToString();
            return "server=(local);database=UserDB;uid=sa;pwd=sa";
        }

       
        private void PrepareCommand(SqlCommand cmd, SqlConnection conn, CommandType cmdType, string cmdText, SqlParameter[] cmdParms)
        {
            cmd.Connection = conn;
            cmd.CommandText = cmdText;
            cmd.CommandType = cmdType;
            if (cmdParms != null)
            {
                foreach (SqlParameter objCmdPara in cmdParms)
                {
                    cmd.Parameters.Add(objCmdPara);
                }
            }
        }

        public DataTable Execute_Return_DataTable(string strSP, SqlParameter[] pms)
        {
            try
            {
                comConn = new SqlConnection(GetDefaultConnString());
                comDt = new DataTable();
                if (comConn.State == ConnectionState.Closed)
                {
                    comConn.Open();
                }
                comCmd = new SqlCommand();
                PrepareCommand(comCmd, comConn, CommandType.StoredProcedure, strSP, pms);
                comDa = new SqlDataAdapter(comCmd);
                comDa.Fill(comDt);
                successFlag = true;

                return comDt;
            }
            catch (System.Exception ex)
            {
                successFlag = false;
                strErrMessage = ex.Message; 
                return comDt;
            }
            finally
            {
                comCmd.Dispose();
                comConn.Close();
                comConn.Dispose();
            }
        }

        public void Execute_Non_Query(string strSP, SqlParameter[] pms)
        {
            try
            {
                comConn = new SqlConnection(GetDefaultConnString());
                if (comConn.State == ConnectionState.Closed)
                {
                    comConn.Open();
                }
                comCmd = new SqlCommand();
                PrepareCommand(comCmd, comConn, CommandType.StoredProcedure, strSP, pms);
                comCmd.ExecuteNonQuery();
                successFlag = true;
            }
            catch (System.Exception ex)
            {
                successFlag = false;
                strErrMessage = ex.Message;
            }
            finally
            {
                
                comCmd.Dispose();
                comConn.Close();
                comConn.Dispose();
            }
        }

    }

 

 

 

　　

 

转载于:https://www.cnblogs.com/yuxian2002/archive/2013/05/17/3084027.html