go，gin全局封装使用sqlx

1、主

package mainimport ("fmt""github.com/gin-gonic/gin""net/http""wbGo/configs"
)type dades struct {Id   intName string
}func main() {router := gin.Default()router.GET("/", func(c *gin.Context) {var dades []dadesconfigs.Db.Select(&dades, "select * from dade")fmt.Println("打印结果:", dades)fmt.Printf("%+v", dades)c.JSON(http.StatusOK, dades)})router.Run("0.0.0.0:8000")
}

2、封装

package configsimport ("fmt"_ "github.com/go-sql-driver/mysql""github.com/jmoiron/sqlx"
)var Db *sqlx.DBfunc init() {database, err := sqlx.Open("mysql", "root:root@tcp(localhost:3306)/wbrj_sample")if err != nil {fmt.Println("连接失败", err)return}fmt.Println("连接成功")Db = database
}