apache mysql go_go操作mysql

package main

import (

"database/sql"

"fmt"

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

)

func main() {

db, _ := sql.Open("mysql", "root:root@(127.0.0.1:3306)/itcast")

defer db.Close()

err := db.Ping()

if err != nil {

fmt.Println("数据库连接错误")

}

//新增数据

sql := "insert into stu value(1,'张三')"

result, _ := db.Exec(sql)

fmt.Printf("%t", result)

//预处理

stuStr := [2][2]string{{"2", "张三"}, {"3", "李四"}}

stmt, _ := db.Prepare("insert into stu value (?,?)")

for _, s := range stuStr {

stmt.Exec(s[0], s[1])

}

//当行查询

var id, name string

row := db.QueryRow("select * from stu where id=3")

row.Scan(&id, &name)

fmt.Println("id:=", id, "name:=", name)

//多行查询

var ids, names string

rows, _ := db.Query("select * from stu")

for rows.Next() {

rows.Scan(&ids, &names)

fmt.Println("----------------")

fmt.Println("ids:=", ids, "names:=", names)

}

}