1.
//GET请求 db操作,按id查询数据
r.GET("/getByIdDb", controller.GetUserById)
//GET请求 db操作,查询数据
r.GET("/getByUserList", controller.GetByUserList)
2.//getByUserId
func GetUserById(context *gin.Context) {
user := &User{}
context.BindJSON(&user)
viewUser := dao.GetUserById(user.UserId)
ReturnSucess(context, 200, "查询成功", viewUser, 1)
}
func GetByUserList(context *gin.Context) {
list := dao.GetUserByList()
i := len(list)
fmt.Print(i)
ReturnSucess(context, 200, "查询成功", list, int64(len(list)))
}
3.
func GetUserById(id int) User {
var user User
err := config.DB.Where("user_id = ?", id).First(&user).Error
if err != nil {
log.Println("查询用户失败,原因:", err)
}
return user
}
func GetUserByList() []User {
//申明一个数组
var userList []User
err := config.DB.Find(&userList).Error
//err := config.DB.Where("1 = ?", 1).Statement.Error
if err != nil {
log.Println("查询用户失败,原因:", err)
}
return userList
}
4.测试