golang的gorm用法

一次性查出一个表所有数据

package main
import (
    "fmt"
    "github.com/jinzhu/gorm"
    _ "github.com/jinzhu/gorm/dialects/mysql"
)
type Student struct {
    //gorm.Model
    Id        int `gorm:"primary_key;auto_increment"`
    Telephone string
    First     string
    Last      string
}
var db *gorm.DB
func main() {
    var err error
    connArgs := fmt.Sprintf(
        "%s:%s@(%s:%d)/%s?charset=utf8&parseTime=True&loc=Local",
        "root", "root", "localhost", 3306, "default")
    db, err := gorm.Open("mysql", connArgs)
    //db, err := gorm.Open("mysql", "root:root@tcp(localhost:3306)/default")
    if err != nil {
        panic(err)
    }
    defer db.Close()
    db.LogMode(true)
    //db.SetLogger(log.New(os.Stdout, "\r\n", 0))
    //var per = Student{First: "akjdfkj", Last: "test", Telephone: "1111"}
    //err = db.Create(&per).Error
    //
    //if err != nil {
    //    fmt.Println(err)
    //}
    var users []Student
    db.Find(&users)
    for k, u := range users {
        fmt.Println(k, u.First)
    }
    //db.Save(&per)
}

golang的gorm用法

微信号：腾讯云折扣返现

技术讨论QQ群： 863102326

作者: catherine

搜索

标签