推薦使用庫 gorm
地址
github.com/jinzhu/gorm
安裝
<code>go get -u github.com/jinzhu/gorm/<code>
代碼示例
<code>package main
import (
"github.com/jinzhu/gorm"
_ "github.com/jinzhu/gorm/dialects/sqlite"
)
type Product struct {
gorm.Model
Code string
Price uint
}
func main() {
db, err := gorm.Open("sqlite3", "test.db")
if err != nil {
panic("failed to connect database")
}
defer db.Close()
// Migrate the schema
db.AutoMigrate(&Product{})
// Create
db.Create(&Product{Code: "L1212", Price: 1000})
// Read
var product Product
db.First(&product, 1) // find product with id 1
db.First(&product, "code = ?", "L1212") // find product with code l1212
// Update - update product's price to 2000
db.Model(&product).Update("Price", 2000)
// Delete - delete product
db.Delete(&product)
}/<code>
鏈接遠端
<code>...
import "github.com/jinzhu/gorm/dialects/mysql"
...
db, err = gorm.Open("mysql", "user:passwd@tcp(127.0.0.1:3306)/dbname?charset=utf8&parseTime=True&loc=Local&timeout=30s")
defer db.Close()
.../<code>
文檔及示例地址
http://gorm.book.jasperxu.com/
閱讀更多 項目分享者 的文章