jwtkey="12345678"

{
"sqltype":"mssql","connstring":"server=.;port=1433;user id=sa;password=123;database=table1"
}

package mssqlhelper
 
import (
	"fmt"
 
	"github.com/akkuman/parseConfig"
	_ "github.com/denisenkom/go-mssqldb"
	"github.com/go-xorm/core"
	"github.com/go-xorm/xorm"
)
 
// 创建 XORM 客户端
func CreateClient() *xorm.Engine {
	var config = parseConfig.New("config.json")
	sqltype := config.Get("sqltype")
	fmt.Println(sqltype)
	connstring := config.Get("connstring")
	fmt.Println(connstring)
	engine,err := xorm.NewEngine(sqltype.(string),connstring.(string))
	if err != nil {
		println("open error:",&err)
	}
	engine.SetMapper(core.SameMapper{})      //表示Struct的类的名称和数据库中相同
	engine.Showsql(true)                     //显示sql语句
	engine.Logger().SetLevel(core.LOG_DEBUG) //打印sql语句
 
	return engine
}

AuthorizeController.go实现用户登录、获取用户信息接口

package controller
 
import (
	"GoApi/DAL"
	"GoApi/Model"
	"encoding/json"
	"fmt"
	"net/http"
	"strconv"
	"strings"
	"time"
 
	"github.com/astaxie/beego/context"
 
	"github.com/astaxie/beego"
	jwt "github.com/dgrijalva/jwt-go"
	"github.com/go-xorm/xorm"
)
 
var engine *xorm.Engine
 
type AuthorizeController struct {
	beego.Controller
}
 
var filterUser = func(ctx *context.Context) {
	token := ctx.Input.Header("Authorization")
 
	b,_ := CheckToken(token)
 
	//验证Token是否合法
	if !b {
		http.Error(ctx.ResponseWriter,"Token verification not pass",http.StatusBadRequest)
		return
	}
	fmt.Println("Request token:",token)
}
 
func init() {
	engine = mssqlhelper.CreateClient()
    //访问接口前验证token
	beego.InsertFilter("/Authorize/Userinfo",beego.BeforeRouter,filterUser)
}
 
type Token struct {
	Token string `json:"token"`
}
 
func fatal(err error) {
	if err != nil {
		beego.Error(err)
	}
}
 
//登录
func (this *AuthorizeController) Login() {
	var user Model.LoginModel
    // url?username=111&password=222 这种形式
	user.UserName = this.GetString("username")
	user.PassWord = this.GetString("password")
 
    //err := this.ParseForm(&user) //接收application/x-www-form-urlencoded形式POST传递数据,如Username=111&Password=2222
    // err := json.NewDecoder(this.Ctx.Request.Body).Decode(&user) //接收json形式Post的数据
 
	loginuser := &Model.Usertable{Userloginname: user.UserName}
	has,err := engine.Get(loginuser)
	if err != nil {
		fatal(err)
	}
	if !has {
		fatal(err)
		http.Error(this.Ctx.ResponseWriter,"User Not Exist",http.StatusBadRequest)
		return
	}
 
	if user.PassWord != loginuser.Userloginpwd {
		this.Ctx.Output.Header("SetStatus",strconv.Itoa(http.StatusBadRequest))
 
		http.Error(this.Ctx.ResponseWriter,"Password Wrong",http.StatusBadRequest)
		return
	}
 
	claims := make(jwt.MapClaims)
	claims["exp"] = time.Now().Add(time.Hour * time.Duration(1)).Unix()
	claims["iat"] = time.Now().Unix()
	claims["nameid"] = loginuser.Userloginname
	claims["User"] = "true"
	token := jwt.NewWithClaims(jwt.SigningMethodHS256,claims)
 
	tokenString,err := token.SignedString([]byte(beego.AppConfig.String("jwtkey")))
	if err != nil {
		this.Ctx.Output.Header("SetStatus",strconv.Itoa(http.StatusInternalServerError))
		fatal(err)
		http.Error(this.Ctx.ResponseWriter,"Server is Wrong",http.StatusInternalServerError)
		return
	}
 
	fmt.Println("Token:",tokenString)
	this.Ctx.WriteString(fmt.Sprintf("{\"Token\":\"%s\"}",tokenString))
}
 
 
func (this *AuthorizeController) Userinfo() {
	token := this.Ctx.Input.Header("Authorization")
 
	b,t := CheckToken(token)
	if !b {
		this.Ctx.WriteString(fmt.Sprintf("Error:%s",token))
		return
	}
	loginuser := &Model.Usertable{Userloginname: claims["nameid"].(string)}
	has,http.StatusBadRequest)
		return
	}
	data,err := json.Marshal(loginuser)
	if err != nil {
		fmt.Println(err)
	}
	this.Ctx.WriteString(fmt.Sprintf("{\"Token\":\"%s\",\"User\":%s}",token,string(data)))
}
 
// 校验token是否有效
func CheckToken(token string) (b bool,t *jwt.Token) {
	kv := strings.Split(token," ")
	if len(kv) != 2 || kv[0] != "Bearer" {
		beego.Error("AuthString invalid:",token)
		return false,nil
	}
	t,err := jwt.Parse(kv[1],func(*jwt.Token) (interface{},error) {
		return []byte(beego.AppConfig.String("jwtkey")),nil
	})
	fmt.Println(t)
	if err != nil {
		fmt.Println("转换为jwt claims失败.",err)
		return false,nil
	}
	return true,t
}