package main
import (
_ "context"
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
uuid "github.com/satori/go.uuid"
)
/*
CREATE TABLE `t_user_info` (
`uuid` varchar(32) NOT NULL COMMENT '主键UUID',
`user_name` varchar(40) DEFAULT NULL DEFAULT '' COMMENT '用户名称',
PRIMARY KEY (`uuid`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC COMMENT='用户信息';
*/
func main() {
db,err := sql.Open("mysql","用户名:密码@tcp(ip:3306)/库名?charset=utf8")
if err != nil {
fmt.Printf("connect mysql fail [%s]",err)
}else {
fmt.Println("connect to mysql succes.")
}
//查询
rows,err := db.Query("select uuid,user_name from t_user_info")
if err != nil {
fmt.Printf("select fail [%s]",err)
return
}
for rows.Next() {
var uuid string
var user_name string
rows.Columns()
err := rows.Scan(&uuid, &user_name)
if err != nil {
fmt.Printf("get user info error [%s]", err)
} else {
fmt.Println(uuid, user_name)
}
}
//开启事务
conn,err := db.Begin()
if err != nil {
fmt.Printf("open transaction error [%s]",err)
return
}
//添加
stmt,err :=db.Prepare("insert into t_user_info values(?,?)")
//stmt,err :=db.Prepare("insert t_user_info set uuid = ?,user_name = ?")
if err != nil {
fmt.Printf("Pretreatment fail [%]")
return
}
//生成uuid开始
id,err := uuid.NewV4()
if err != nil {
fmt.Printf("get uuid error [%s]",err)
}
fmt.Printf("github.com/satori/go.uuid: %s\n", id)
//生成uuid结束
res,err := stmt.Exec(id,"test3")
//res,err := stmt.Exec("2d2e4ebfcb864213a0b6a71d400f1cd9","test2")
if err != nil {
fmt.Printf("Pretreatment fail [%]")
//事务回滚
conn.Rollback()
return
}
num,err := res.RowsAffected()
if err != nil {
fmt.Printf("insert fail [%s]",err)
}
fmt.Printf(" Number of rows affected [%v]",num)
//提交事务
conn.Commit()
//删除
//stmt,err :=db.Prepare("delete from t_user_info where uuid = ?")
//if err != nil {
//fmt.Printf("Pretreatment fail [%s]",err)
//return
//}
//res,err := stmt.Exec("2d2e4ebfcb864213a0b6a71d400f1cd9")
//if err != nil {
//fmt.Printf("Pretreatment fail [%s]",err)
//return
//}
//num,err := res.RowsAffected()
//if err != nil {
//fmt.Printf("delete fail [%s]",err)
//}
//fmt.Printf(" Number of rows affected [%v]",num)
//修改
//stmt,err :=db.Prepare("update t_user_info set user_name = 'golang' where uuid = ?")
//if err != nil {
//fmt.Printf("Pretreatment fail [%s]",err)
//return
//}
//res,err := stmt.Exec("7a84e9e5163d4861b341b12a536a6a0d")
//if err != nil {
//fmt.Printf("Pretreatment fail [%s]",err)
//return
//}
//num,err := res.RowsAffected()
//if err != nil {
//fmt.Printf("update fail [%s]",err)
//}
//fmt.Printf(" Number of rows affected [%v]",num)
}