Golang如何实现简单的API分页_Golang分页查询与返回处理实践

<strong>type PaginationRequest struct {
    Page  int `form:"page" binding:"gte=1"`
    Limit int `form:"limit" binding:"gte=1,lte=100"`
}
<p>type PaginatedResponse struct {
Data       interface{} <code>json:"data"</code>
Total      int64       <code>json:"total"</code>
Page       int         <code>json:"page"</code>
Limit      int         <code>json:"limit"</code>
TotalPages int         <code>json:"total_pages"</code>
}

<strong>func GetUsers(c *gin.Context) {
    var req PaginationRequest
    if err := c.ShouldBindQuery(&req); err != nil {
        c.JSON(400, gin.H{"error": err.Error()})
        return
    }
<pre class='brush:php;toolbar:false;'>// 设置默认值
if req.Page == 0 {
    req.Page = 1
}
if req.Limit == 0 {
    req.Limit = 10
}

var users []User
var total int64

db := c.MustGet("db").(*gorm.DB)
db.Model(&User{}).Count(&total)
db.Limit(req.Limit).Offset((req.Page - 1) * req.Limit).Find(&users)

totalPages := int((total + int64(req.Limit) - 1) / int64(req.Limit))

c.JSON(200, PaginatedResponse{
    Data:       users,
    Total:      total,
    Page:       req.Page,
    Limit:      req.Limit,
    TotalPages: totalPages,
})

<strong>func Paginate(db *gorm.DB, page, limit int, data interface{}) *PaginatedResponse {
    if page <= 0 {
        page = 1
    }
    if limit <= 0 {
        limit = 10
    }
<pre class='brush:php;toolbar:false;'>offset := (page - 1) * limit
var total int64

db.Model(data).Count(&total)
db.Limit(limit).Offset(offset).Find(data)

totalPages := int((total + int64(limit) - 1) / int64(limit))

return &PaginatedResponse{
    Data:       data,
    Total:      total,
    Page:       page,
    Limit:      limit,
    TotalPages: totalPages,
}