How to paginate database queries in Golang?

Answer: Yes, you can use the LIMIT and OFFSET keywords to paginate database queries in Golang. The steps are as follows: Determine the number of records to be displayed on each page (pageSize). Calculate offset (offset), starting from 0. Use fmt.Sprintf to dynamically build the query string, inserting pageSize and offset values. Use LIMIT to limit the number of records to fetch, and OFFSET to skip previous records. Use the rows object to iterate over the result set and use the Scan function to extract the value of each row.

How to paginate database queries in Golang

Paging is a common feature in web applications, which allows users to paginate by specifying Size View a portion of a large amount of data. In Golang, queries can be paginated using the LIMIT and OFFSET keywords.

package main

import (
    "database/sql"
    "fmt"
)

func main() {
    db, err := sql.Open("mysql", "user:password@tcp(localhost:3306)/dbname")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    // 每页显示 10 条记录
    pageSize := 10

    // 获取第 2 页的数据，OFFSET 从 0 开始
    offset := (2 - 1) * pageSize

    // 编写分页查询
    query := fmt.Sprintf(`
        SELECT id, name
        FROM users
        LIMIT %d OFFSET %d
    `, pageSize, offset)

    rows, err := db.Query(query)
    if err != nil {
        panic(err)
    }
    defer rows.Close()

    // 遍历结果集
    for rows.Next() {
        var id int
        var name string
        if err := rows.Scan(&id, &name); err != nil {
            panic(err)
        }
        fmt.Println(id, name)
    }
}

In this example:

• pageSize Specifies the number of records to display per page.
• offset Calculate the offset based on the current page number to skip previous records.
• query The string is dynamically constructed using fmt.Sprintf, inserting the pageSize and offset values.
• This query uses LIMIT to limit the number of records to be retrieved, and OFFSET to skip previous records. The
• rows object is used to traverse the result set, and the Scan function is used to extract the value of each row.

The above is the detailed content of How to paginate database queries in Golang?. For more information, please follow other related articles on the PHP Chinese website!