GORM和XORM一直是我關(guān)注著的兩個(gè)Golang ORM框架,文檔也是非常詳細(xì),,關(guān)于他們的比較詳細(xì)地可以看文檔。
gorm http://gorm.book.jasperxu.com/
xorm https://www.kancloud.cn/kancloud/xorm-manual-zh-cn/56017
這里用gorm做個(gè)簡(jiǎn)單的demo 跑一下,數(shù)據(jù)庫(kù)用的是mysql5.7
package main
import (
_ "github.com/go-sql-driver/mysql"
"github.com/jinzhu/gorm"
)
var (
dbhostsip = "127.0.0.1:3306" //IP地址
dbusername = "root" //用戶名
dbpassword = "" //密碼
dbname = "Test" //表名
)
type Student struct {
gorm.Model
Name string
Address string
}
func main() {
db, err := gorm.Open("mysql", "root:@tcp(127.0.0.1:3306)/t?charset=utf8")
if err != nil {
panic(err)
}
defer db.Close()
// 自動(dòng)遷移模式
db.AutoMigrate(&Student{})
// 創(chuàng)建
db.Create(&Student{Name: "wyf", Address: "nj"})
// 讀取
var student Student
db.First(&student, 1) // 查詢id為1的product
}