github.com/qiuhoude/go-web@v0.0.0-20220223060959-ab545e78f20d/blogweb_gin/models/user_model.go (about)

     1  package models
     2  
     3  import (
     4  	"fmt"
     5  	"github.com/qiuhoude/go-web/blogweb_gin/database"
     6  	"github.com/qiuhoude/go-web/blogweb_gin/logs"
     7  )
     8  
     9  type User struct {
    10  	Id         int
    11  	Username   string
    12  	Password   string
    13  	Status     int // 0 正常状态, 1删除
    14  	Createtime int64
    15  }
    16  
    17  //插入
    18  func InsertUser(user User) (int64, error) {
    19  	return database.ModifyDB("insert into users(username,password,status,createtime) values (?,?,?,?)",
    20  		user.Username, user.Password, user.Status, user.Createtime)
    21  }
    22  
    23  //按条件查询
    24  func QueryUserWightCon(con string) int {
    25  	sql := fmt.Sprintf("select id from users %s", con)
    26  	logs.Info.Println(sql)
    27  	row := database.QueryRowDb(sql)
    28  	id := 0
    29  	row.Scan(&id)
    30  	return id
    31  }
    32  
    33  //根据用户名查询id
    34  func QueryUserWithUsername(username string) int {
    35  	sql := fmt.Sprintf("where username='%s'", username)
    36  	return QueryUserWightCon(sql)
    37  }
    38  
    39  //根据用户名和密码,查询id
    40  func QueryUserWithParam(username, password string) int {
    41  	sql := fmt.Sprintf("where username='%s' and password='%s'", username, password)
    42  	return QueryUserWightCon(sql)
    43  }