C# SQL帮助类

 

C# SQL帮助类

本人自己封装的SQLHelper类，执行sql server与Oracle数据的增删改查

vs自带的Oracle数据库引用需要安装Oracle客户端，如不想安装Oracle客户端，可以引用 Oracle.ManagedDataAccess.dll

下载链接: https://pan.baidu.com/s/1dzzTxL2fmUPrMy2Qc246jg 提取码: 16my 

public class SQLHelper
    {
        /// <summary>
        /// 执行查询语句
        /// </summary>
        /// <param name="ConnStr">连接字符串</param>
        /// <param name="Sql">sql语句</param>
        /// <param name="Param">查询的字段名</param>
        /// <returns>查询结果或错误信息</returns>
        public static string[] ExecuteReaderSql(string ConnStr,string Sql,string[] Param)
        {
            string[] info = new string[Param.Count()];
            SqlConnection conn = null;
            try
            {
                conn = new SqlConnection(ConnStr);
                conn.Open();
                SqlCommand cmd = new SqlCommand(Sql, conn);
                SqlDataReader sdr = cmd.ExecuteReader();
                sdr.Read();
                if (!sdr.HasRows) { info[0] = "null"; return info; }
                for (int i = 0; i <Param.Count(); i++)
                {
                    info[i] = sdr[Param[i]].ToString();
                }
            }
            catch(Exception ex)
            {
                info[0] = "sql查询错误信息：" + ex.Message;
                return info;
            }
            finally
            {
                conn.Close();
            }

            return info;
        }
        /// <summary>
        /// 执行增删改
        /// </summary>
        /// <param name="ConnStr">连接字符串</param>
        /// <param name="Sql">sql语句</param>
        /// <returns>受影响的行数或错误信息</returns>
        public static string ExecuteSql(string ConnStr,string Sql)
        {
            SqlConnection conn = null;
            int Row = 0;
            try
            {
                conn = new SqlConnection(ConnStr);
                conn.Open();
                SqlCommand cmd = new SqlCommand(Sql,conn);
                Row = cmd.ExecuteNonQuery();
            }
            catch(Exception ex)
            {
                return "sql执行错误信息：" + ex.Message;
            }
            finally
            {
                conn.Close();
            }
            return Row.ToString();
        }
        /// <summary>
        /// Oracle增删改
        /// </summary>
        /// <param name="ConnStr">连接字符串</param>
        /// <param name="orcl">Oracle语句</param>
        /// <returns>受影响行数或错误信息</returns>
        public static string ExecuteOrcl(string ConnStr, string orcl)
        {
            OracleConnection conn = null;
            int Row = 0;
            try
            {
                conn = new OracleConnection(ConnStr);
                conn.Open();
                OracleCommand cmd = new OracleCommand(orcl, conn);
                Row = cmd.ExecuteNonQuery();
            }
            catch (Exception ex)
            {
                return "orcl执行错误信息：" + ex.Message;
            }
            finally
            {
                conn.Close();
            }
            return Row.ToString();
        }
        /// <summary>
        /// Oracle查询
        /// </summary>
        /// <param name="ConnStr">连接字符串</param>
        /// <param name="orcl">Oracle语句</param>
        /// <param name="Param">查询字段名</param>
        /// <returns>查询结果或错误信息</returns>
        public static string[] ExecuteReaderOrcl(string ConnStr, string orcl, string[] Param)
        {
            OracleConnection conn = null;
            string[] info = new string[Param.Count()];
            try
            {
                conn = new OracleConnection(ConnStr);
                conn.Open();
                OracleCommand cmd = new OracleCommand(orcl, conn);
                OracleDataReader odr = cmd.ExecuteReader();
                odr.Read();
                if(!odr.HasRows) { info[0] = "null"; return info; }
                for (int i = 0; i < Param.Count(); i++)
                {
                    info[i] = odr[Param[i]].ToString();
                }
            }
            catch (Exception ex)
            {
                info[0] = "orcl查询错误信息：" + ex.Message;
                return info;
            }
            finally
            {
                conn.Close();
            }
            return info;
        }
    }