• C# 事务处理


    /// <summary>
            /// 多SQL语句操作--事务处理
            /// </summary>
            /// <param name="sqlComm">SQL语句数组</param>
            /// <returns>事务,返回String事务结果</returns>
            public string DoTran(string[] sqlComm)
            {
                if (connection.State.ToString() == "Closed")
                    connection.Open();
                SqlTransaction myTran;
                myTran = connection.BeginTransaction();
                //string mess;
                
                SqlCommand command = new SqlCommand("",connection,myTran);
                //command.Connection = connection;
                try
                {
                    foreach (string comm in sqlComm)
                    {
                        command.CommandText = comm;
                        command.ExecuteNonQuery();
                    }
                    myTran.Commit();
                }
                catch (Exception e)
                {
                    //throw new ApplicationException("系统信息:" + e.Message);
                    return e.Message;
                }
                finally
                {
                    connection.Close();
                }
                return "事务操作成功!";
            }
  • 相关阅读:
    Nginx 部署多个 web 项目(虚拟主机)
    Nginx 配置文件
    Linux 安装 nginx
    Linux 安装 tomcat
    Linux 安装 Mysql 5.7.23
    Linux 安装 jdk8
    Linux 安装 lrzsz,使用 rz、sz 上传下载文件
    springMVC 拦截器
    spring 事务
    基于Aspectj 注解实现 spring AOP
  • 原文地址:https://www.cnblogs.com/chenbg2001/p/1677340.html
Copyright © 2020-2023  润新知