Go语言从入门到精通九——使用golang操作mysql、redis和RabbitMQ

最新推荐文章于 2024-09-05 17:18:58 发布

Dev-L

最新推荐文章于 2024-09-05 17:18:58 发布

阅读量683

点赞数

分类专栏： go

本文链接：https://blog.csdn.net/u010525694/article/details/88091932

版权

本文详细介绍了如何使用Go语言操作MySQL，包括增删改查和事务处理。接着讲解了Redis的安装、连接测试以及各种操作如set、get、hset等，并提到了Redis连接池和管道操作的概念。最后，探讨了RabbitMQ的使用，涵盖了生产者消费者模式、订阅模式和RPC应用。

摘要由CSDN通过智能技术生成

操作mysql

增

package main

import (
	"fmt"
	"github.com/jmoiron/sqlx"
	_ "github.com/go-sql-driver/mysql" //初始化一个mysql驱动，必须
)

type Person struct {
   
	UserId   int    `db:"user_id"`
	Username string `db:"username"`
	Sex      string `db:"sex"`
	Email    string `db:"email"`
}
type Place struct {
   
	Country string `db:"country"`
	City    string `db:"city"`
	TelCode int    `db:"telcode"`
}

var Db *sqlx.DB

func init() {
   
	//"mysql"指定数据库类型，  /test指定数据库  root:123 冒号隔开密码 root账号 123密码
	database, err := sqlx.Open("mysql", "root:930808@tcp(127.0.0.1:3306)/go_test")
	if err != nil {
   
		fmt.Println("open mysql failed,", err)
		return
	}
	fmt.Println("连接数据库成功！")
	Db = database
}
func main() {
   
	//插入数据入表
	r, err := Db.Exec("insert into person(username,sex,email)values(?,?,?)", "dave", "man", "dave@outlook.com")
	if err != nil {
   
		fmt.Println("exec failed,", err)
		return
	}
	id, err := r.LastInsertId()
	if err != nil {
   
		fmt.Println("exec failed,", err)
		return
	}
	fmt.Println("insert succ:", id)
}

删

package main

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

type Person struct {
   
	UserId   int    `db:"user_id"`
	Username string `db:"username"`
	Sex      string `db:"sex"`
	Email    string `db:"email"`
}

type Place struct {
   
	Country string `db:"country"`
	City    string `db:"city"`
	TelCode int    `db:"telcode"`
}

var Db *sqlx.DB

func init() {
   
	//初始化链接数据库
	database, err := sqlx.Open("mysql", "root:930808@tcp(127.0.0.1:3306)/go_test")
	if err != nil {
   
		fmt.Println("open mysql failed,", err)
		return
	}
	Db = database
}

func main() {
   
	_, err := Db.Exec("delete FROM person where username=?", "dave")
	if err != nil {
   
		fmt.Println("exec failed,", err)
		return
	}
	fmt.Println("delete succ")
}

改

package main

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

type Person struct {
   
	UserId   int    `db:"user_id"`
	Username string `db:"username"`
	Sex      string `db:"sex"`
	Email    string `db:"email"`
}
type Place struct {
   
	Country string `db:"country"`
	City    string `db:"city"`
	TelCode int    `db:"telcode"`
}

var Db *sqlx.DB

func init() {
   
	database, err := sqlx.Open("mysql", "root:930808@tcp(127.0.0.1:3306)/go_test")
	if err != nil {
   
		fmt.Println("open mysql failed,", err)
		return
	}
	Db = database
}
func main() {
   
	_, err := Db.Exec("update person set sex=? where username=?", "women", "dave")
	if err != nil {
   
		fmt.Println("exec failed,", err)
	}
}

查

package main

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

type Person struct {
   
	UserId   int    `db:"user_id"'`
	Username string `db:"username"`
	Sex      string `db:"sex"`
	Email    string `db:"email"`
}
type Place struct {
   
	Country string `db:"country"`
	City    string `db:"city"`
	TelCode int    `db:"telcode"`
}

var Db *sqlx.DB

func init() {
   
	//初始化链接数据库
	database, err := sqlx.Open("mysql", "root:930808@tcp(127.0.0.1:3306)/go_test")
	if err != nil {
   
		fmt.Println("open mysql failed", err)
		return
	}
	Db = database
}

func main() {
   
	var person []Person
	err := Db.Select(&person, "select username,sex,email from person where username=?", "dave")
	if err != nil {
   
		fmt.Println("exec failed,", err)
		return
	}
	fmt.Println("select succ:", person)

}

mysql事务

Db.Begin() 开始事务
Db.Submit() 提交事务
Db.Rollback() 回滚事务

示例：

package main

import (
	"fmt"
	_ "github.com/go-sql-driver/mysql" //初始化一个mysql驱动，必须
	"github.com/jmoiron/sqlx"
)

type Person struct {
   
	UserId   int    `db:"user_id"`
	Username string `db:"username"`
	Sex      string `db:"sex"`
	Email    string `db:"email"`
}
type Place struct {
   
	Country string `db:"country"`
	City    string `db:"city"`
	TelCode int    `db:"telcode"`
}

var Db *sqlx.DB

func init() {
   
	//"mysql"指定数据库类型，  /test指定打开的数据库  root:123 冒号隔开密码 root账号 123密码
	database, err := sqlx.Open("mysql", "root:930808@tcp(127.0.0.1:3306)/go_test")
	if err != nil {
   
		fmt.Println("open mysql failed,", err)
		return
	}
	Db = database
}
func main() {
   
	//事务操作
	conn, err := Db.Begin()
	if err != nil {
   
		return
	}

	//插入数据入表
	r, err := Db.Exec("insert into person(username,sex,email)values(?,?,?)", "lee", "man", "lee@outlook.com")
	if err != nil {
   
		fmt.Println("exec failed,", err)
		return
	}

	id, err := r.LastInsertId()
	if err != nil {
   
		fmt.Println("exec failed,", err)
		//回滚
		conn.Rollback()
		return
	}
	fmt.Println("insert succ:", id)
	   //提交事务
	conn.Commit()
}