• Go语言入门心法(十二): GORM映射框架

    Go语言入门心法(一): 基础语法

    Go语言入门心法(二): 结构体

    Go语言入门心法(三): 接口

    Go语言入门心法(四): 异常体系

     Go语言入门心法(五): 函数

    Go语言入门心法(六): HTTP面向客户端|服务端编程

    Go语言入门心法(七): 并发与通道

    Go语言入门心法(八): mysql驱动安装报错onnection failed

    Go语言入门心法(九): 引入三方依赖

    Go语言入门心法(十):Go语言操作MYSQL(CRUD)|事务处理

    Go语言入门心法(十一): 文件处理

    Go语言入门心法(十二): GORM映射框架

    Go语言入门心法(十三): 反射认知升维

     一: ORM映射框架认知 

    安装依赖：

    S D:\program_file\go_workspace> go get   gorm.io/gorm
    PS D:\program_file\go_workspace> go get  gorm.io/driver/sqlite
    PS D:\program_file\go_workspace> go get  gorm.io/driver/mysql

    PS D:\program_file\go_workspace> go get  github.com/jinzhu/gorm
     

    二: 检查数据连接情况

    1. package main
    2.  
    3. import (
    4. 	"github.com/jinzhu/gorm"
    5. 	_ "github.com/jinzhu/gorm/dialects/mysql"
    6. 	"log"
    7. )
    8.  
    9. func main() {
    10. 	db, err := gorm.Open("mysql", "root:123456@tcp(127.0.0.1:3306)/tope-pay-user?charset=utf8&parseTime=True&loc=Local")
    11. 	//延时关闭数据库连接
    12. 	defer db.Close()
    13. 	// 设置最大连接数
    14. 	db.DB().SetMaxOpenConns(100)
    15. 	// 设置最大闲置数据
    16. 	db.DB().SetMaxIdleConns(10)
    17. 	gormDatabaseLinkCheckErr(err)
    18. 	// 通过ping检查数量是否成功
    19. 	err = db.DB().Ping()
    20. 	gormDatabaseLinkCheckErr(err)
    21. 	log.Println("数据库连接成功! ")
    22.  
    23. }
    24.  
    25. // 定义结构体
    26. type gormUser struct {
    27. 	ID       uint   `json:"id"`
    28. 	Phone    string `json:"phone"`
    29. 	Name     string `json:"name"`
    30. 	Password string `json:"password"`
    31. }
    32.  
    33. func gormDatabaseLinkCheckErr(err error) {
    34. 	if err != nil {
    35. 		log.Fatal("系统异常: ", err.Error())
    36. 	}
    37. }

    运行效果：

    GOROOT=D:\program_file_worker\go1.20 #gosetup
    GOPATH=D:\program_file_worker\go1.20\bin;C:\Users\Administrator\go #gosetup
    D:\program_file_worker\go1.20\bin\go.exe build -o C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_OOPGormToDatabaseGrammar_go.exe D:\program_file\go_workspace\org.jd.data\gorm\OOPGormToDatabaseGrammar.go #gosetup
    C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_OOPGormToDatabaseGrammar_go.exe
    2023/10/22 14:15:46 数据库连接成功! 

    Process finished with the exit code 0
     

    三: GORM使用结构体创建表

    1. package main
    2.  
    3. /**
    4.   gorm对象关系映射建表：sys_gorm_user
    5. */
    6. import (
    7. 	"fmt"
    8. 	"gorm.io/driver/mysql"
    9. 	"gorm.io/gorm"
    10. 	"log"
    11. 	"time"
    12. )
    13.  
    14. func main() {
    15. 	db, err := gorm.Open(mysql.New(mysql.Config{
    16. 		DSN:                       "root:123456@tcp(127.0.0.1:3306)/tope-pay-user?charset=utf8&parseTime=True&loc=Local", // data source name
    17. 		DefaultStringSize:         256,                                                                                   // default size for string fields
    18. 		DisableDatetimePrecision:  true,                                                                                  // disable datetime precision, which not supported before MySQL 5.6
    19. 		DontSupportRenameIndex:    true,                                                                                  // drop & create when rename index, rename index not supported before MySQL 5.7, MariaDB
    20. 		DontSupportRenameColumn:   true,                                                                                  // `change` when rename column, rename column not supported before MySQL 8, MariaDB
    21. 		SkipInitializeWithVersion: false,
    22. 	}), &gorm.Config{
    23. 		DisableForeignKeyConstraintWhenMigrating: true,
    24. 	})
    25. 	sqlDB, err := db.DB()
    26. 	//延时关闭数据库连接
    27. 	defer sqlDB.Close()
    28. 	// 设置最大连接数
    29. 	// 设置最大闲置数据
    30. 	sqlDB.SetMaxIdleConns(10)
    31. 	sqlDB.SetConnMaxLifetime(time.Hour)
    32. 	gormDatabaseCreateTableCheckErr(err)
    33. 	// 通过ping检查数量是否成功
    34. 	err = sqlDB.Ping()
    35.  
    36. 	gormDatabaseCreateTableCheckErr(err)
    37. 	log.Println("数据库连接成功! ")
    38.  
    39. 	
    40. 	tx := db.Begin()
    41. 	// 如果表存在,则删除
    42. 	result := db.Migrator().HasTable(&GormUser{})
    43. 	if result {
    44. 		// 表存在先删除
    45. 		err = db.Migrator().DropTable(&GormUser{})
    46. 		if err != nil {
    47. 			log.Println("删除表异常: ", err.Error())
    48. 		} else {
    49. 			log.Println("\t表删除成功")
    50. 		}
    51. 	}
    52. 	// 创建表:gorm_users
    53. 	err = db.Set("gorm:table_options", "ENGINE=InnoDB").AutoMigrate(&GormUser{})
    54.  
    55. 	if err != nil {
    56. 		// 事务回滚
    57. 		tx.Rollback()
    58. 		fmt.Println("事务回滚：", err.Error())
    59. 	}
    60. 	// 重命名列
    61. 	db.Migrator().RenameColumn(&GormUser{}, "id", "deptId")
    62. 	db.Migrator().RenameColumn(&GormUser{}, "CreatedAt", "createTime")
    63. 	db.Migrator().RenameColumn(&GormUser{}, "UpdatedAt", "updateTime")
    64. 	db.Migrator().RenameColumn(&GormUser{}, "DeletedAt", "deleted")
    65.  
    66. 	db = tx.Commit()
    67. 	err = db.Error
    68. 	if err != nil {
    69. 		log.Println("系统异常：", err.Error())
    70. 		return
    71. 	}
    72. 	log.Println("\t执行建表成功")
    73.  
    74. }
    75.  
    76. // GormUser 定义结构体
    77. type GormUser struct { // 约定主键为ID才会自动创建,数据库的主键为id,二不是解析的deptId,但可用在创建之后通过重命名的方式修改列名
    78. 	gorm.Model
    79. 	ID       int64  `json:"deptId" gorm:"primaryKey;autoIncrement:true,unique"`
    80. 	Phone    string `json:"phone" gorm:"size:11,unique,index:idx_phone"`
    81. 	Name     string `json:"name" gorm:"size:50,index:idx_name"`
    82. 	Password string `json:"password" gorm:"size:100"`
    83. }
    84.  
    85. func gormDatabaseCreateTableCheckErr(err error) {
    86. 	if err != nil {
    87. 		log.Fatal("系统异常: ", err.Error())
    88. 		return
    89. 	}
    90. }

    运行效果：

    GOROOT=D:\program_file_worker\go1.20 #gosetup
    GOPATH=D:\program_file_worker\go1.20\bin;C:\Users\Administrator\go #gosetup
    D:\program_file_worker\go1.20\bin\go.exe build -o C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_org_jd_data_org_jd_data_gorm__1_.exe D:\program_file\go_workspace\org.jd.data\gorm\OOPGormToDatabaseGrammarCreateTable.go #gosetup
    C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_org_jd_data_org_jd_data_gorm__1_.exe
    2023/10/22 21:16:13 数据库连接成功!
    2023/10/22 21:16:13     表删除成功
    2023/10/22 21:16:13     执行建表成功

    Process finished with the exit code 0

    四: Gorm对象关系映射插入数据

    1. package main
    2.  
    3. import (
    4. 	"gorm.io/driver/mysql"
    5. 	"gorm.io/gorm"
    6. 	"log"
    7. 	"time"
    8. )
    9.  
    10. /*
    11. 插入单条数据
    12. */
    13. func main() {
    14.  
    15. 	db, err := gorm.Open(mysql.New(mysql.Config{
    16. 		DSN:                       "root:123456@tcp(127.0.0.1:3306)/tope-pay-user?charset=utf8&parseTime=True&loc=Local", // data source name
    17. 		DefaultStringSize:         256,                                                                                   // default size for string fields
    18. 		DisableDatetimePrecision:  true,                                                                                  // disable datetime precision, which not supported before MySQL 5.6
    19. 		DontSupportRenameIndex:    false,                                                                                 // drop & create when rename index, rename index not supported before MySQL 5.7, MariaDB
    20. 		DontSupportRenameColumn:   false,                                                                                 // `change` when rename column, rename column not supported before MySQL 8, MariaDB
    21. 		SkipInitializeWithVersion: false,
    22. 	}), &gorm.Config{
    23. 		DisableForeignKeyConstraintWhenMigrating: false,
    24. 	})
    25. 	sqlDB, err := db.DB()
    26. 	//延时关闭数据库连接
    27. 	defer sqlDB.Close()
    28. 	// 设置最大连接数
    29. 	// 设置最大闲置数据
    30. 	sqlDB.SetMaxIdleConns(10)
    31. 	// 最大连接数
    32. 	sqlDB.SetMaxOpenConns(100)
    33. 	sqlDB.SetConnMaxLifetime(time.Hour)
    34. 	gormDatabaseInsertCheckErr(err)
    35. 	// 通过ping检查数量是否成功
    36. 	err = sqlDB.Ping()
    37.  
    38. 	gormDatabaseInsertCheckErr(err)
    39. 	log.Println("数据库连接成功! ")
    40.  
    41. 	println()
    42. 	tx := db.Begin() // 开启事务
    43. 	user := &GormUser{Name: "张三", Phone: "15910771022", Password: "123456", CreateTime: time.Now(), UpdateTime: time.Now(), Deleted: time.Now()}
    44. 	result := db.Create(&user)
    45. 	err = result.Error
    46. 	if err != nil {
    47. 		tx.Rollback() // 回滚事务
    48. 		println("插入数据异常,已回滚事务.......")
    49. 	}
    50. 	result = tx.Commit() // 提交事务
    51. 	err = result.Error
    52. 	if err != nil {
    53. 		log.Fatal("系统异常: ", err.Error())
    54. 		return
    55. 	}
    56. 	println("============================插入数据成功=======================================")
    57.  
    58. }
    59.  
    60. type GormUser struct { 
    61. 	deptId     int64     `json:"deptId"`                              //
    62. 	Phone      string    `json:"phone"`                               //
    63. 	Name       string    `json:"name"`                                //
    64. 	Password   string    `json:"password"`                            //
    65. 	CreateTime time.Time `json:"createTime" gorm:"column:createTime"` // gorm 的column:映射数据库中对应列的字段为createTime
    66. 	UpdateTime time.Time `json:"updateTime" gorm:"column:updateTime"` //
    67. 	Deleted    time.Time `json:"deleted" gorm:"column:deleted"`       //
    68. }
    69.  
    70. func gormDatabaseInsertCheckErr(err error) {
    71. 	if err != nil {
    72. 		log.Fatal("系统异常: ", err.Error())
    73. 		return
    74. 	}
    75. }

    运行效果：

    GOROOT=D:\program_file_worker\go1.20 #gosetup
    GOPATH=D:\program_file_worker\go1.20\bin;C:\Users\Administrator\go #gosetup
    D:\program_file_worker\go1.20\bin\go.exe build -o C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_OOPGormToDatabaseGrammarInsert_go.exe D:\program_file\go_workspace\org.jd.data\gorm\insert\OOPGormToDatabaseGrammarInsert.go #gosetup
    C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_OOPGormToDatabaseGrammarInsert_go.exe
    2023/10/23 12:25:10 数据库连接成功!

    ============================插入数据成功=======================================

    五: Gorm批量插入数据

    1. package main
    2.  
    3. import (
    4. 	"gorm.io/driver/mysql"
    5. 	"gorm.io/gorm"
    6. 	"log"
    7. 	"time"
    8. )
    9.  
    10. func main() {
    11. 	db, err := gorm.Open(mysql.New(mysql.Config{
    12. 		DSN:                       "root:123456@tcp(127.0.0.1:3306)/tope-pay-user?charset=utf8&parseTime=True&loc=Local", // data source name
    13. 		DefaultStringSize:         256,                                                                                   // default size for string fields
    14. 		DisableDatetimePrecision:  true,                                                                                  // disable datetime precision, which not supported before MySQL 5.6
    15. 		DontSupportRenameIndex:    false,                                                                                 // drop & create when rename index, rename index not supported before MySQL 5.7, MariaDB
    16. 		DontSupportRenameColumn:   false,                                                                                 // `change` when rename column, rename column not supported before MySQL 8, MariaDB
    17. 		SkipInitializeWithVersion: false,
    18. 	}), &gorm.Config{
    19. 		DisableForeignKeyConstraintWhenMigrating: false,
    20. 	})
    21. 	sqlDB, err := db.DB()
    22. 	//延时关闭数据库连接
    23. 	defer sqlDB.Close()
    24. 	// 设置最大连接数
    25. 	// 设置最大闲置数据
    26. 	sqlDB.SetMaxIdleConns(10)
    27. 	// 最大连接数
    28. 	sqlDB.SetMaxOpenConns(100)
    29. 	sqlDB.SetConnMaxLifetime(time.Hour)
    30. 	gormDatabaseBatchInsertCheckErr(err)
    31. 	// 通过ping检查数量是否成功
    32. 	err = sqlDB.Ping()
    33.  
    34. 	gormDatabaseBatchInsertCheckErr(err)
    35. 	log.Println("数据库连接成功! ")
    36.  
    37. 	println()
    38. 	tx := db.Begin() // 开启事务
    39. 	var users = []GormUser{{Name: "张三", Phone: "15910771022", Password: "123456", CreateTime: time.Now(), UpdateTime: time.Now(), Deleted: time.Now()},
    40. 		{Name: "张三", Phone: "15910771022", Password: "123456", CreateTime: time.Now(), UpdateTime: time.Now(), Deleted: time.Now()},
    41. 		{Name: "李四", Phone: "15910771022", Password: "123456", CreateTime: time.Now(), UpdateTime: time.Now(), Deleted: time.Now()},
    42. 		{Name: "王五", Phone: "15910771022", Password: "123456", CreateTime: time.Now(), UpdateTime: time.Now(), Deleted: time.Now()},
    43. 		{Name: "赵四", Phone: "15910771022", Password: "123456", CreateTime: time.Now(), UpdateTime: time.Now(), Deleted: time.Now()},
    44. 		{Name: "王二麻子", Phone: "15910771022", Password: "123456", CreateTime: time.Now(), UpdateTime: time.Now(), Deleted: time.Now()}}
    45. 	result := db.CreateInBatches(users, 100)
    46. 	err = result.Error
    47. 	if err != nil {
    48. 		tx.Rollback() // 回滚事务
    49. 		println("插入数据异常,已回滚事务.......")
    50. 	}
    51. 	result = tx.Commit() // 提交事务
    52. 	err = result.Error
    53. 	if err != nil {
    54. 		log.Fatal("系统异常: ", err.Error())
    55. 		return
    56. 	}
    57. 	println("============================批量插入数据成功=======================================")
    58.  
    59. }
    60.  
    61. type GormUser struct {
    62. 	deptId     int64     `json:"deptId"`                              //
    63. 	Phone      string    `json:"phone"`                               //
    64. 	Name       string    `json:"name"`                                //
    65. 	Password   string    `json:"password"`                            //
    66. 	CreateTime time.Time `json:"createTime" gorm:"column:createTime"` // gorm 的column:映射数据库中对应列的字段为createTime
    67. 	UpdateTime time.Time `json:"updateTime" gorm:"column:updateTime"` //
    68. 	Deleted    time.Time `json:"deleted" gorm:"column:deleted"`       //
    69. }
    70.  
    71. func gormDatabaseBatchInsertCheckErr(err error) {
    72. 	if err != nil {
    73. 		log.Fatal("系统异常: ", err.Error())
    74. 		return
    75. 	}
    76. }

     运行效果：

    rogram_file_worker\go1.20 #gosetup
    GOPATH=D:\program_file_worker\go1.20\bin;C:\Users\Administrator\go #gosetup
    D:\program_file_worker\go1.20\bin\go.exe build -o C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_org_jd_data_org_jd_data_gorm_batch.exe org.jd.data/org.jd.data/gorm/batch #gosetup
    C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_org_jd_data_org_jd_data_gorm_batch.exe
    2023/10/23 12:45:15 数据库连接成功!

    ============================批量插入数据成功=======================================

    Process finished with the exit code 0

     

    六: Gorm查询数据

    1. package main
    2.  
    3. import (
    4. 	"fmt"
    5. 	"gorm.io/driver/mysql"
    6. 	"gorm.io/gorm"
    7. 	"log"
    8. 	"time"
    9. )
    10.  
    11. func main() {
    12. 	db, err := gorm.Open(mysql.New(mysql.Config{
    13. 		DSN:                       "root:123456@tcp(127.0.0.1:3306)/tope-pay-user?charset=utf8&parseTime=True&loc=Local", // data source name
    14. 		DefaultStringSize:         256,                                                                                   // default size for string fields
    15. 		DisableDatetimePrecision:  true,                                                                                  // disable datetime precision, which not supported before MySQL 5.6
    16. 		DontSupportRenameIndex:    false,                                                                                 // drop & create when rename index, rename index not supported before MySQL 5.7, MariaDB
    17. 		DontSupportRenameColumn:   false,                                                                                 // `change` when rename column, rename column not supported before MySQL 8, MariaDB
    18. 		SkipInitializeWithVersion: false,
    19. 	}), &gorm.Config{
    20. 		DisableForeignKeyConstraintWhenMigrating: false,
    21. 	})
    22. 	sqlDB, err := db.DB()
    23. 	//延时关闭数据库连接
    24. 	defer sqlDB.Close()
    25. 	// 设置最大连接数
    26. 	// 设置最大闲置数据
    27. 	sqlDB.SetMaxIdleConns(10)
    28. 	// 最大连接数
    29. 	sqlDB.SetMaxOpenConns(100)
    30. 	sqlDB.SetConnMaxLifetime(time.Hour)
    31. 	gormDatabaseInsertCheckErr(err)
    32. 	// 通过ping检查数量是否成功
    33. 	err = sqlDB.Ping()
    34.  
    35. 	gormDatabaseInsertCheckErr(err)
    36. 	log.Println("数据库连接成功! ")
    37.  
    38. 	println()
    39. 	var users []GormUser
    40. 	// Get all records  SELECT * FROM gorm_users ;
    41. 	doResult := db.Find(&users)
    42. 	err = doResult.Error // returns error
    43. 	gormDatabaseInsertCheckErr(err)
    44. 	rowCount := doResult.RowsAffected // returns found records count, equals `len(gorm_users)`
    45. 	fmt.Printf("获取多少 %d 条数据\n", rowCount)
    46. 	println("=============================条件查询====================================")
    47. 	// IN
    48. 	rowCountNum := db.Where("name IN ?", []string{"张三", "李四", "王五"}).Find(&users)
    49. 	// SELECT * FROM gorm_users WHERE name IN ('张三','李四', "王五");
    50. 	fmt.Printf("查找到 %d 条数据\n", rowCountNum.RowsAffected)
    51. 	println("=============================模糊查询====================================")
    52. 	// LIKE
    53. 	rowCountNum = db.Where("name LIKE ?", "%李%").Find(&users)
    54. 	// SELECT * FROM gorm_users WHERE name LIKE '%李%';
    55. 	fmt.Printf("查找到 %d 条数据\n", rowCountNum.RowsAffected)
    56. }
    57.  
    58. type GormUser struct {
    59. 	deptId     int64     `json:"deptId"`                              //
    60. 	Phone      string    `json:"phone"`                               //
    61. 	Name       string    `json:"name"`                                //
    62. 	Password   string    `json:"password"`                            //
    63. 	CreateTime time.Time `json:"createTime" gorm:"column:createTime"` // gorm 的column:映射数据库中对应列的字段为createTime
    64. 	UpdateTime time.Time `json:"updateTime" gorm:"column:updateTime"` //
    65. 	Deleted    time.Time `json:"deleted" gorm:"column:deleted"`       //
    66. }
    67.  
    68. func gormDatabaseInsertCheckErr(err error) {
    69. 	if err != nil {
    70. 		log.Fatal("系统异常: ", err.Error())
    71. 		return
    72. 	}
    73. }

    运行效果：

    GOROOT=D:\program_file_worker\go1.20 #gosetup
    GOPATH=D:\program_file_worker\go1.20\bin;C:\Users\Administrator\go #gosetup
    D:\program_file_worker\go1.20\bin\go.exe build -o C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_org_jd_data_org_jd_data_gorm_query.exe org.jd.data/org.jd.data/gorm/query #gosetup
    C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_org_jd_data_org_jd_data_gorm_query.exe
    2023/10/23 13:29:18 数据库连接成功!

    获取多少 39 条数据
    =============================条件查询====================================
    查找到 27 条数据
    =============================模糊查询====================================
    查找到 6 条数据

    Process finished with the exit code 0

    七: Gorm更新数据

    1. package main
    2.  
    3. import (
    4. 	"fmt"
    5. 	"gorm.io/driver/mysql"
    6. 	"gorm.io/gorm"
    7. 	"log"
    8. 	"time"
    9. )
    10.  
    11. func main() {
    12. 	db, err := gorm.Open(mysql.New(mysql.Config{
    13. 		DSN:                       "root:123456@tcp(127.0.0.1:3306)/tope-pay-user?charset=utf8&parseTime=True&loc=Local", // data source name
    14. 		DefaultStringSize:         256,                                                                                   // default size for string fields
    15. 		DisableDatetimePrecision:  true,                                                                                  // disable datetime precision, which not supported before MySQL 5.6
    16. 		DontSupportRenameIndex:    false,                                                                                 // drop & create when rename index, rename index not supported before MySQL 5.7, MariaDB
    17. 		DontSupportRenameColumn:   false,                                                                                 // `change` when rename column, rename column not supported before MySQL 8, MariaDB
    18. 		SkipInitializeWithVersion: false,
    19. 	}), &gorm.Config{
    20. 		DisableForeignKeyConstraintWhenMigrating: false,
    21. 	})
    22. 	sqlDB, err := db.DB()
    23. 	//延时关闭数据库连接
    24. 	defer sqlDB.Close()
    25. 	// 设置最大连接数
    26. 	// 设置最大闲置数据
    27. 	sqlDB.SetMaxIdleConns(10)
    28. 	// 最大连接数
    29. 	sqlDB.SetMaxOpenConns(100)
    30. 	sqlDB.SetConnMaxLifetime(time.Hour)
    31. 	gormDatabaseInsertCheckErr(err)
    32. 	// 通过ping检查数量是否成功
    33. 	err = sqlDB.Ping()
    34.  
    35. 	gormDatabaseInsertCheckErr(err)
    36. 	log.Println("数据库连接成功! ")
    37.  
    38. 	println()
    39. 	println("============================================开始更新数据===============================")
    40. 	tx := db.Begin() // 开启事务
    41. 	// Update with conditions 更新单列数据
    42. 	result := db.Model(&GormUser{}).Where("name = ?", "李四").Update("name", "老高")
    43.  
    44. 	rowCount := result.RowsAffected
    45. 	fmt.Printf("受影响的行数 %d 条\n", rowCount)
    46. 	err = result.Error
    47. 	if err != nil {
    48. 		tx.Rollback() // 回滚事务
    49. 		println("更新数据异常,已回滚事务.......")
    50. 	}
    51. 	result = tx.Commit() // 提交事务
    52. 	err = result.Error
    53. 	if err != nil {
    54. 		log.Fatal("系统异常: ", err.Error())
    55. 		return
    56. 	}
    57. 	println("=======================================数据更新成功=======================================")
    58. }
    59.  
    60. type GormUser struct {
    61. 	deptId     int64     `json:"deptId"`                              //
    62. 	Phone      string    `json:"phone"`                               //
    63. 	Name       string    `json:"name"`                                //
    64. 	Password   string    `json:"password"`                            //
    65. 	CreateTime time.Time `json:"createTime" gorm:"column:createTime"` // gorm 的column:映射数据库中对应列的字段为createTime
    66. 	UpdateTime time.Time `json:"updateTime" gorm:"column:updateTime"` //
    67. 	Deleted    time.Time `json:"deleted" gorm:"column:deleted"`       //
    68. }
    69.  
    70. func gormDatabaseInsertCheckErr(err error) {
    71. 	if err != nil {
    72. 		log.Fatal("系统异常: ", err.Error())
    73. 		return
    74. 	}
    75. }

    运行效果:

    GOROOT=D:\program_file_worker\go1.20 #gosetup
    GOPATH=D:\program_file_worker\go1.20\bin;C:\Users\Administrator\go #gosetup
    D:\program_file_worker\go1.20\bin\go.exe build -o C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_OOPGormToDatabaseGrammarUpdate_go.exe D:\program_file\go_workspace\org.jd.data\gorm\update\OOPGormToDatabaseGrammarUpdate.go #gosetup
    C:\Users\Administrator\AppData\Local\Temp\GoLand\___go_build_OOPGormToDatabaseGrammarUpdate_go.exe
    2023/10/23 13:42:11 数据库连接成功!

    ============================================开始更新数据===============================
    受影响的行数 6 条
    =======================================数据更新成功=======================================

    Process finished with the exit code 0

     更多详细操作查看官方文档：

    Gorm对象关系映射详细文档

  • 相关阅读:
    初级算法_字符串 --- 有效的字母异位词
    2022 IDEA （学生邮箱认证）安装使用教程以及基础配置教程
    高德地图JSAPI 2.0使用Java代码代替Nginx进行反向代理
    SAP中的BOPF（Business Object Processing Framework）
    红帽Linux的安装和部署
    服务器怎么关闭防火墙
    腾讯云 Cloud Studio 实战训练：快速构建React完成H5页面还原
    MyBatisPlus（十二）排序查询：orderBy
    labelme安装
    SpringCloudAliBaba(四)之Feign介绍及应用
  • 原文地址：https://blog.csdn.net/u014635374/article/details/133960243