从零开发区块链应用(三)--mysql初始化及gorm框架使用

一、mysql初始化

1.1 导入依赖包

import (
	"database/sql"
	_ "github.com/go-sql-driver/mysql"
	"github.com/moba/moba/config"
	"github.com/moba/moba/pkg/go-logger"
	"time"
)

1.2 连接数据库

var err error
// 创建连接池
//DB, err = sql.Open("mysql", config.Conf.Mysql.SourceName)
user := config.Conf.Mysql.User
password := config.Conf.Mysql.Password
host := config.Conf.Mysql.Host
port := config.Conf.Mysql.Port
database := config.Conf.Mysql.Database
DB, err = sql.Open("mysql", user+":"+password+"@tcp("+host+":"+port+")/"+database+"?parseTime=true&charset=utf8&loc=Local")
if err != nil {
	logger.Error(err.Error())
}