win7访问mysql数据库_03.go连接mysql数据库(win7)

1.打开命令行

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

2.输入go env查看一下gopath的路径，我们的驱动就在那里

3.创建数据库 test,创建表player,创建字段 age、name,如图(建议使用可视化工具)

5.在我们ide中添加如下代码

package main

import (

"database/sql"

"fmt"

_ "github.com/go-sql-driver/mysql"

)

func main() {

db, err := sql.Open("mysql", "root:root@tcp(127.0.0.1:3306)/test?charset=utf8")

if err != nil {

fmt.Println(err)

return

}

defer db.Close()

var result sql.Result

result, err = db.Exec("insert into palyer(age, name) values(?,?)", 16, "tom")

if err != nil {

fmt.Println(err)

return

}

lastId, _ := result.LastInsertId()

fmt.Println("新插入记录的ID为", lastId)

var row *sql.Row

row = db.QueryRow("select * from t_test")

var name string

var id, age int

err = row.Scan(&id, &age, &name)

if err != nil {

fmt.Println(err)

return

}

fmt.Println(id, "\t", name, "\t", age)

result, err = db.Exec("insert into t_test(age, name) values(?,?)", 24, "black")

var rows *sql.Rows

rows, err = db.Query("select * from t_test")

if err != nil {

fmt.Println(err)

return

}

for rows.Next() {

var name string

var id, age int

rows.Scan(&id, &age, &name)

fmt.Println(id, "\t", name, "\t", age)

}

rows.Close()

db.Exec("truncate table t_test")

}

6.运行代码，刷新一下可视化工具，看看数据库有没有新增内容

7.66666666666666666666666的起飞了。开发速度快的吓人~~~~~~~~~~