如何在sqlx中构建和提交多查询事务？

import (
    "fmt"
    "github.com/jmoiron/sqlx"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    // 创建数据库连接
    db, err := sqlx.Open("mysql", "user:password@tcp(127.0.0.1:3306)/database")
    if err != nil {
        fmt.Println("数据库连接失败：", err)
        return
    }
    defer db.Close()

    // 开启事务
    tx, err := db.Beginx()
    if err != nil {
        fmt.Println("事务开启失败：", err)
        return
    }

    // 构建和执行查询语句
    queries := []string{
        "INSERT INTO table1 (col1, col2) VALUES (?, ?)",
        "UPDATE table2 SET col1 = ? WHERE col2 = ?",
        "DELETE FROM table3 WHERE col1 = ?",
    }

    for _, query := range queries {
        _, err := tx.Exec(query, args...)
        if err != nil {
            // 查询失败，回滚事务
            tx.Rollback()
            fmt.Println("查询执行失败：", err)
            return
        }
    }

    // 提交事务
    err = tx.Commit()
    if err != nil {
        fmt.Println("事务提交失败：", err)
        return
    }

    fmt.Println("事务提交成功")
}