01.08 go語言操作數據庫

推薦使用庫 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/

閱讀更多 項目分享者 的文章

關鍵字: 語言 推薦 Go語言