go执行基本数据库操作

go执行基本数据库操作

[文件] db.go
package main
 
import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)
 
func main() {
    //打开连接
    db, _ := sql.Open("mysql", "root:123456@/test?charset=utf8")
    //执行查询
    rows, _ := db.Query("select ename from emp")
    //处理结果集
    for rows.Next() {
        var ename string
        rows.Scan(&ename)
        fmt.Println(ename)
    }
    //关闭连接
    db.Close()
}