go 连接mssql

发布时间：2023-05-09 13:09:54 所属栏目：MsSql教程来源：

导读：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;pa

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()
}

（编辑：汽车网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!