Golang数据库jinzhu框架使用

文档地址

数据模型

//Account 储存数据结构
type Account struct {
	ID               int    `gorm:"primary_key"`
	AccountIP        string `gorm:"type:varchar(100);not null"`
	AccountNum       int32  `gorm:"type:int;not null"`
	AccountDateFirst time.Time
	AccountDate      time.Time
}

1. 引入 github.com/go-sql-driver/mysql

Gopkg.toml 中添加：

[[constraint]]
name = “github.com/go-sql-driver/mysql”
version = “1.0.0”

下载依赖包

dep ensure -update

2. 创建数据库连接

package db

import (
	"fmt"
	"github.com/jinzhu/gorm"
	"time"
)

var (
	dbhostsip    string