go-sql-driver/mysql 学习

package main


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


var id int
var departname string
var leaderemail string
var token string


func main() {
db, err := sql.Open("mysql", "root:123@tcp(172.16.3.138:3306)/apply?charset=utf8")
defer db.Close()
if err != nil {
log.Fatal(err)
}


// 通过stmt执行
// stmt, err := db.Prepare("instert into department(departname,leaderemail,token) values (?,?,?)")
// if err != nil {
// log.Fatal(err)
// }
// stmt.Exec("1", "1", "1")


// 直接执行
// res, err := db.Exec("instert into department(departname,leaderemail,token) values ('1', '1', '1')")
// if err != nil {
// log.Fatal(err)
// }
// fmt.Println(res.LastInsertId())


// 通过queryrow查询
// db.QueryRow("select * from department where id =?", 1).Scan(&id, &departname, &leaderemail, &token)
// fmt.Println(id, departname, leaderemail, token)


// 通过query查询
// rows, err := db.Query("select * from department")
// for rows.Next() {
// rows.Scan(&id, &departname, &leaderemail, &token)
// fmt.Println(id, departname, leaderemail, token)
// }


// 事物
tx, err := db.Begin()
if err != nil {
log.Fatal(err)
}
// 演示不插入数据
rows, err := tx.Query("select * from department")
for rows.Next() {
rows.Scan(&id, &departname, &leaderemail, &token)
fmt.Println(id, departname, leaderemail, token)
}
tx.Commit()
}