1. window 下 cmd 打开 命令窗口
① 运行如下命令:
go get github.com/jinzhu/gorm // 核心库
go get github.com/go-sql-driver/mysql //运行驱动包
② 数据库链接
db, err := gorm.Open("mysql", "db_username:db_password@/db_name?charset=utf8&parseTime=True&loc=Local")
defer db.Close()
if err != nil {
panic(err)
}
defer db.Close()
➂ 连接数据库,并创建表,插入一条数据的示例
package main
import (
"fmt"
"github.com/jinzhu/gorm"
_ "github.com/jinzhu/gorm/dialects/mysql"
)
type User struct {
gorm.Model
Name string `gorm:"varchar(20); not null"`
Price int `gorm:" not null"`
}
func main() {
db, err := gorm.Open("mysql", "root:root@/gormdb?charset=utf8&parseTime=True&loc=Local")
defe