如何使用sqlx更新多行？

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

db, err := sqlx.Connect("mysql", "username:password@tcp(host:port)/database")
if err != nil {
    // 处理连接错误
}
defer db.Close()

stmt, err := db.Preparex("UPDATE table_name SET column1 = ?, column2 = ? WHERE condition_column = ?")
if err != nil {
    // 处理语句错误
}
defer stmt.Close()

_, err = stmt.Exec(value1, value2, condition_value)
if err != nil {
    // 处理执行错误
}

package main

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

type User struct {
    ID    int    `db:"id"`
    Name  string `db:"name"`
    Email string `db:"email"`
}

func main() {
    db, err := sqlx.Connect("mysql", "username:password@tcp(host:port)/database")
    if err != nil {
        // 处理连接错误
    }
    defer db.Close()

    stmt, err := db.Preparex("UPDATE users SET name = ?, email = ? WHERE id = ?")
    if err != nil {
        // 处理语句错误
    }
    defer stmt.Close()

    _, err = stmt.Exec("John Doe", "johndoe@example.com", 1)
    if err != nil {
        // 处理执行错误
    }

    fmt.Println("更新成功！")
}