go 连接到数据库

package main 

import (
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"github.com/jmoiron/sqlx"
)

var DB *sqlx.DB

type DbInfo struct {
	Engine string
	User   string
	Pass   string
	Ip     string
	Port   string
	Table  string
}

func init () {

	db1 := DbInfo{
		"mysql",
		"root",
		"root",
		"127.0.0.1",
		"3306",
		"test",
	}

	database, err := sqlx.Open(db1.Engine, fmt.Sprintf("%s:%s@tcp(%s:%s)/%s", db1.User, db1.Pass, db1.Ip, db1.Port, db1.Table))

	if err != nil {
		fmt.Println("mysql open failed, error:", err)
		return
	}

	DB = database
}

func main () {
	_, err := DB.Exec("insert into test (username, age) values (?, ?)", "lisi", "24")

	if err != nil {
		fmt.Println("mysql exec failed, error:", err)
		return
	}

}