golang 执行sql语句_xorm执行sql语句

package main

import (

"fmt"

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

"github.com/go-xorm/xorm"

)

var (

engine *xorm.Engine

)

func main() {

//数据库连接参数

params := fmt.Sprintf("%s:%s@tcp(%s)/%s?charset=utf8&parseTime=true", "root", "root", "localhost:3306", "go")

var err error

//连接数据库

engine, err = xorm.NewEngine("mysql", params)

if err != nil {

panic(err)

}

//执行sql查询，返回数据格式：[]map[string][]byte

gsql := "SELECT `member_id`, `member_name` FROM `go_member`"

gres, gerr := engine.Query(gsql)

if gerr != nil {

panic(gerr)

}

for _, v := range gres {

fmt.Print