gorm.io/zh_CN/docs/…

SQL

获取连接

Open

// 获取连接 数据库类型 用户名:密码@tcp(127.0.0.1:3306)/库名
open, err := sql.Open("mysql", "root:Swl980806@tcp(127.0.0.1:3306)/my_db?")

执行语句

Query

// 执行语句
query, err1 := open.Query("select * from account where id = 1")

defer query.Close()

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/go-sql-driver/mysql"
)

type Account struct {
	id    uint8
	name  string
	money int
}

// mysql 的连接
func main() {
	// 获取连接 数据库类型 用户名:密码@tcp(127.0.0.1:3306)/库名
	open, err := sql.Open("mysql", "root:Swl980806@tcp(127.0.0.1:3306)/my_db?")
	if err != nil {
		fmt.Println(err)
	}

	// 执行语句
	query, err1 := open.Query("select * from account where id = 1")
	if err1 != nil {
		fmt.Println(err1)
	}
	defer query.Close()

	// 遍历请求体
	var accounts []Account
	for query.Next() {
		var account Account
		if err := query.Scan(&account.id, &account.name, &account.money); err != nil {
			accounts = append(accounts, account)
		}
		fmt.Println(account)
		accounts = append(accounts, account)
	}
	if query.Err() != nil {
		fmt.Println("错误")
	}
}

GORM

安装

go get -u gorm.io/gormgo get -u gorm.io/driver/sqlite

约定结构体Model

type Model struct {
   ID        uint `gorm:"primarykey"`
   CreatedAt time.Time
   UpdatedAt time.Time
   DeletedAt DeletedAt `gorm:"index"`
}

CRUD

Create(&Product{Code: "D42", Price: 100})

// Read
var product Product
db.First(&product, 1)                 // 根据整型主键查找
db.First(&product, "code = ?", "D42") // 查找 code 字段值为 D42 的记录

// Update - 将 product 的 price 更新为 200
db.Model(&product).Update("Price", 200)
// Update - 更新多个字段
db.Model(&product).Updates(Product{Price: 200, Code: "F42"}) // 仅更新非零值字段
db.Model(&product).Updates(map[string]interface{}{"Price": 200, "Code": "F42"})

// Delete - 删除 product
db.Delete(&product, 1)