golang 从ms sql数据库获取数据

1.获取包

go get https://github.com/alexbrainman/odbc

 

Error:

unknown driver "mssql" (forgotten import?)"

 

2.根目录 go install 注册驱动

 

3.测试代码

 

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/alexbrainman/odbc"
)

func main() {
    connStr := fmt.Sprintf("driver={SQL Server};SERVER=192.168.1.1;UID=sa;PWD=db123;DATABASE=DBOne")
    conn, error := sql.Open("odbc", connStr)
    if error != nil {

    }
    defer conn.Close()

    stmt, err := conn.Prepare(`select [key] from [sys_config]`)
    if err != nil {
        fmt.Println(err.Error())
    }
    defer stmt.Close()

    rows, err2 := stmt.Query()
    if err2 != nil {
        fmt.Println(err2.Error())
    }
    if rows != nil {
        //fmt.Println(rows.RowsAffected())
        for rows.Next() {
            var key string
            if err := rows.Scan(&key); err == nil {
                fmt.Println(key)
            }
        }
    }
}