首先go get github.com/go-sql-driver/mysql 下载golang mysql数据库的驱动程序
再次go get github.com/jmoiron/sqlx sql语句执行程序
如果gopath在编辑器中设置的不对，会出现即使已经下载了这两个包，但是执行失败提示无法导入这两个包
注意点：接收从数据库返回的数据的结构体，属性的首字母须大写，即可以使sql包访问新建的结构体属性。
package main
import (
"fmt"
_ "github.com/go-sql-driver/mysql"
"github.com/jmoiron/sqlx"
)
func main() {
db, err := sqlx.Open("mysql", "root:warrior@tcp(127.0.0.1)/mydb")
if err != nil {
fmt.Println(err)
}
defer db.Close()
//一次添加一条记录
//result, err := db.Exec("insert into person (name,age,money,job) values(?,?,?,?)", "warrior", 28, 999999, "it")
//一次增加多条记录
//result, err := db.Exec("insert into person (name,age,money,job) values(?,?,?,?),(?,?,?,?),(?,?,?,?)", "warrior1", 29, 888888, "it", "warrior2", 27, 77777, "it", "warrior3", 26, 77766, "it")
//删除数据库记录
//result, err := db.Exec("delete from person where age=?", 26)
//修改数据库记录
//result, err := db.Exec("update person set money=? where name=?", 99999999, "warrior")
type Person struct {
Name string
Age int
Money int
Job string
}
persons := make([]Person, 0)
if err != nil {
fmt.Println(err)
}
//查询数据库记录
err = db.Select(&persons, "select name, age, money, job from person")
//fmt.Println(result.RowsAffected())
if err != nil {
fmt.Println(err)
}
fmt.Println(persons)
}