How can I use data binding in Go with SQL packages?

How can I use data binding in Go with SQL packages?

You can use the database/sql package in Go for data binding. It allows you to execute SQL queries and scan results into Go structs.

Can you show me a code example of how to bind data to a struct?

Sure! Here's a simple example:

type User struct {
    ID   int
    Name string
}

var user User
err := db.QueryRow("SELECT id, name FROM users WHERE id = ?", 1).Scan(&user.ID, &user.Name)
if err != nil {
    log.Fatal(err)
}

What if I want to bind multiple rows of data?

You can use db.Query to retrieve multiple rows and then use a loop to scan each row into a slice of structs. Here's an example:

rows, err := db.Query("SELECT id, name FROM users")
if err != nil {
    log.Fatal(err)
}
defer rows.Close()

var users []User
for rows.Next() {
    var user User
    if err := rows.Scan(&user.ID, &user.Name); err != nil {
        log.Fatal(err)
    }
    users = append(users, user)
}