GORM是中国人写的一个go语言的ORM,全世界都在用,下面我们用一段代码演示一下怎么用
文档地址:http://doc.gorm.io/crud.html
安装:
go get -u github.com/go-sql-driver/mysql
go get -u github.com/jinzhu/gorm
package main
import (
"github.com/jinzhu/gorm"
"fmt"
_ "github.com/jinzhu/gorm/dialects/mysql"
)
type Test struct {
Id int
Num int
}
func createTables(db *gorm.DB) {
db.CreateTable(&Test{})
}
func main() {
db, err := gorm.Open("mysql", "用户名:密码@(主机地址:端口)/数据库名称?charset=utf8&parseTime=True&loc=Local")
if err == nil {
fmt.Println("open db sucess")
} else {
fmt.Println("open db error ", err)
return
}
if !db.HasTable("tests") {
createTables(db)
}
test := Test{Num:123456}
db.Create(&test);
fmt.Println("test.id is ", test.Id)
var tests []Test
db.Find(&tests)
fmt.Println(tests)
for index, line := range tests {
fmt.Println("index", index, " line ", line)
}
defer db.Close()
}