C# mysql 事务处理

try

            {

                using (MySqlConnection conn = new MySqlConnection( "Database=pay2017;Data Source=127.0.0.1;User Id=root;Password=123456;pooling=false;CharSet=utf8" ))

                {

                    conn.Open();

                    MySqlTransaction transaction = conn.BeginTransaction();

                    MySqlCommand cmd = conn.CreateCommand();

                    cmd.Transaction = transaction;

                    try

                    {

                        cmd.CommandText = "INSERT INTO people(name,age,sex) VALUES('哈哈','22','1')" ;

                        int x = cmd.ExecuteNonQuery();

                        cmd.CommandText = "INSERT INTO address(address) VALUES('地球')" ;

                        int y = cmd.ExecuteNonQuery();

                        transaction.Commit();

                    }

                    catch (Exception ex)

                    {

                        try

                        {

                            transaction.Rollback();

                        }

                        catch (Exception en)

                        {

                            throw ;

                        }

                    }

                }

            }

            catch (Exception)

            {

                throw ;

            }