monitor/db/userinfo.go

package db

import (
	"fmt"
	"github.com/jmoiron/sqlx"
)

type UserInfo struct {
	UserId   string `db:"user_id"`
	UserName string `db:"user_name"`
}

func (userInfo *UserInfo) SelectData(Db *sqlx.DB) ([]UserInfo, error) {

	var userInfos []UserInfo
	err := Db.Select(&userInfos, "select user_id, user_name from sys_user")
	if err != nil {
		fmt.Printf("query fail : [%v]", err)
		return nil, err
	}
	return userInfos, nil
}