Go中使用MYSQL数据库《插入》

安装：

安装mysql驱动：

go get github.com/go-sql-driver/mysql

安装sqlx驱动：

go get github.com/jmoiron/sqlx

插入：

第一种：

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

   "os"
)
//与数据库建立连接
var db *sql.DB
func init() {
db, _ = sql.Open("mysql", "fu:123@tcp(127.0.0.1:3306)/fileserver?charset=utf8")
db.SetMaxOpenConns(1000)
err := db.Ping()
if err != nil {
fmt.Println("Failed to connect mysql , err :" + err.Error())
os.Exit(1)
} else {
fmt.Println("连接成功")
}
}
func main() {
r ,err :=db.Exec("insert into tbl_file(file_sha1, file_name, file_size)values(?, ?, ?)", "stu001", "man", 1)

if err !=nil{
   fmt.Println("插入失败",err)
   return
}
id,err :=r.LastInsertId()
if err !=nil{
   fmt.Println("exec failed",err)
}
fmt.Println("插入成功",id)
}

```go
package db

import (
   "database/sql"
   "fmt"
   "github.com/jmoiron/sqlx"
   mydb "FBSyuncunchuxitong/db/mysql"
)
//OnFileUploadFinisged:文件上传完成，保存meta
func OnFileUploadFinished(filehash string,filename string,filesize int64,fileaddr string) bool  {
//Prepare：预处理，防止sql的注入攻击
   stmt, err := mydb.DBConn().Prepare(
      "insert ignore into tbl_file (`file_sha1`,`file_name`,`file_size`," +
         "`file_addr`,`status`) values (?,?,?,?,1)")
   if err !=nil {
      fmt.Println("Failed to prepare statement, err :"+err.Error())
      return false
   }
   defer stmt.Close()

   ret,err :=stmt.Exec(filehash,filename,filesize,fileaddr)
   if err !=nil {
      fmt.Println(err.Error())
      return false
   }
   //判断是否有新的记录被插入进去如果已经插入就被忽略掉
   if re,err :=ret.RowsAffected();nil == err{
      //如果er<=0说明sql执行成功但是并没有产生表的记录
      if re <=0 {
         fmt.Printf("File with hash:%s has been uploaded before",filehash)
      }
      return true
   }
   //返回false说明插入失败10:30
   return false
}

#### 第二种（包含事务操作）：

```go
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"`
}

var Db *sqlx.DB

func init() {
   //与数据库建立连接
   database, err := sqlx.Open("mysql", "fu:123@tcp(127.0.0.1:3306)/test")
   if err != nil {
      fmt.Println("open mysql failed,", err)
      return
   }
   Db = database
}

func main() {
   //事件操作
   conn, err := Db.Begin()
   if err != nil {
      fmt.Println(err)
      return
   }
   //插入数据库
   r, err := conn.Exec("insert into person(username, sex, email)values(?, ?, ?)", "stu001", "man", "stu01@qq.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()
}