c#通用数据库连接，执行sql语句

最新推荐文章于 2023-03-22 16:33:47 发布

一不小心成了猴

最新推荐文章于 2023-03-22 16:33:47 发布

阅读量322

点赞数

分类专栏：学习笔记文章标签：数据库 sql

本文链接：https://blog.csdn.net/qq_33916344/article/details/114978216

版权

学习笔记专栏收录该内容

8 篇文章 0 订阅

订阅专栏

public static void ExecSQLNoQueryByTransaction(string[] sql, params IEnumerable<MySqlParameter>[] paras)
        {
            int result = sql.Count();
            DbConnection dbConnection = new SqlConnection("server=192.168.1.187;userid=root;pwd=\"zkzl1-1=0\";port=3306;database=dbhealth82;sslmode=none");
            try
            {
                dbConnection.Open();
                DbTransaction dbTransaction = dbConnection.BeginTransaction();
                DbCommand cmd = dbConnection.CreateCommand();
                cmd.Transaction = dbTransaction;
                for (int i = 0; i < sql.Count(); i++)
                {
                    cmd.CommandText = sql[i];
                    if (paras != null && paras[i] != null)
                        foreach (MySqlParameter para in paras[i])
                            cmd.Parameters.Add(para);
                    if (cmd.ExecuteNonQuery() > 0)
                        result--;
                    cmd.Parameters.Clear();
                }
                if (result == 0)
                    dbTransaction.Commit();
                else
                    dbTransaction.Rollback();
                cmd.Dispose();
                dbConnection.Close();
                dbConnection.Dispose();
            }
            catch (Exception ex)
            {
                LogerHelper.Error("执行sql异常===>" + ex.Message);
            }
        }