Go 笔记之使用gin实现查询数据Json输出 未封装

package mainimport ( "gopkg.in/gin-gonic/gin.v1" "net/http" "log" "database/sql" _ "github.com/go-sql-driver/mysql")type Person struct { Id        int    `json:"id" form:"id"` Module string `json:"module" form:"module"` Content  string `json:"content" form:"content"`}func main() { db, err := sql.Open("mysql", "root:@tcp(127.0.0.1:3306)/test?parseTime=true") defer db.Close() if err != nil{  log.Fatalln(err) } db.SetMaxIdleConns(20) db.SetMaxOpenConns(20) if err := db.Ping(); err != nil{  log.Fatalln(err) } r := gin.Default() r.GET("/seeinfo", func(c *gin.Context) {  rows, err := db.Query("SELECT id, module, content FROM lb_apppush_notices limit ?",10)  defer rows.Close()  if err != nil {   log.Fatalln(err)  }  persons := make([]Person, 0)  for rows.Next() {   var person Person   rows.Scan(&person.Id, &person.Module, &person.Content)   persons = append(persons, person)  }  if err = rows.Err(); err != nil {   log.Fatalln(err)  }  c.JSON(http.StatusOK, gin.H{  "status" :200,  "error": nil,   "data": persons,  }) }) r.Run(":8000")}