mysql连接 xorm_go xorm连接数据库

下载必要的库

go get github.com/go-xorm/xorm #安装xorm

go get -u github.com/go-sql-driver/mysql #安装MySQL驱动

package main

import (

_ "github.com/go-sql-driver/mysql"

"github.com/go-xorm/xorm"

"fmt"

)

/*

* @author: songjxin

* @author: 2018/10/9

* @description:

*/

//对应数据库表

type Token struct{

Id int64

Token string

Time string

}

func main() {

//连接到mysql

db, initErr := xorm.NewEngine("mysql", "root:passwd@(10.10.8.31:33060)/token")

if initErr != nil {

fmt.Println("error")

fmt.Println(initErr.Error())

return

}

//select

var tokens []Token

sql := "SELECT * FROM `token`"

//方式1