go语言操作mysql多行查询

func queryMultiDemo() {
    var user User
    sqlStr := "select id, name, age from user where id > ?"
    rows, err := DB.Query(sqlStr, 0)
    if err != nil {
        fmt.Printf("query failed, err:%v\n", err)
        return
    }
    defer func() {
        rows.Close() // 会释放数据库连接
    }()

    // 循环读取数据
    for rows.Next() {
        err := rows.Scan(&user.id, &user.name, &user.age)
        if err != nil {
            fmt.Printf("scan failed, err:%v\n", err)
            return
        }
        fmt.Printf("user:%#v\n", user)
    }
}

go语言操作mysql多行查询 - 简书