如何在Golang中实现数据分页_Golang 数据分页实践

SELECT id, name, created_at FROM users ORDER BY created_at DESC LIMIT ? OFFSET ?

var users []User
offset := (page - 1) * pageSize
db.Limit(pageSize).Offset(offset).Order("created_at DESC").Find(&users)

type PaginatedResponse struct {
    Data       interface{} `json:"data"`
    Total      int64       `json:"total"`
    Page       int         `json:"page"`
    PageSize   int         `json:"page_size"`
    TotalPages int         `json:"total_pages"`
}

var total int64
db.Model(&User{}).Count(&total)
<p>var users []User
db.Limit(pageSize).Offset((page-1)*pageSize).Find(&users)</p><p>response := PaginatedResponse{
Data:       users,
Total:      total,
Page:       page,
PageSize:   pageSize,
TotalPages: int(math.Ceil(float64(total) / float64(pageSize))),
}

if page < 1 {
    page = 1
}
if pageSize < 1 {
    pageSize = 10
}
if pageSize > 100 {
    pageSize = 100 // 限制最大值防刷
}