go 连接mssql

go 连接mssql

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37

package main   import (     "database/sql"     "fmt"     "log"       _ "github.com/denisenkom/go-mssqldb" )   func main() {     connectString := "server=127.0.0.1;database=yndb;user id=sa;password=sql;port=8829;encrypt=disable"     println("Connection string=", connectString)       db, err := sql.Open("mssql", connectString)     defer db.Close()     println("Open Error:", err)     if err != nil {         log.Fatal(err)     }       // 执行SQL语句     rows, err := db.Query("select * from tunit")     if err != nil {         fmt.Println("query: ", err)         return     }     for rows.Next() {         var id string         var name int         rows.Scan(&id, &name)         fmt.Printf("id: %s \t name: %d\n", id, name)     }       println("closing connection")     db.Close() }