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 }