Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package main
- import (
- "database/sql"
- "flag"
- "fmt"
- "log"
- _ "github.com/denisenkom/go-mssqldb"
- )
- var (
- debug = flag.Bool("debug", false, "enable debugging")
- password = flag.String("password", "", "the database password")
- port *int = flag.Int("port", 1433, "the database port")
- server = flag.String("server", "", "the database server")
- user = flag.String("user", "", "the database user")
- )
- func main() {
- flag.Parse()
- if *debug {
- fmt.Printf(" password:%s\n", *password)
- fmt.Printf(" port:%d\n", *port)
- fmt.Printf(" server:%s\n", *server)
- fmt.Printf(" user:%s\n", *user)
- }
- connString := fmt.Sprintf("server=%s;user id=%s;password=%s;port=%d", *server, *user, *password, *port)
- if *debug {
- fmt.Printf(" connString:%s\n", connString)
- }
- conn, err := sql.Open("mssql", connString)
- if err != nil {
- log.Fatal("Open connection failed:", err.Error())
- }
- defer conn.Close()
- stmt, err := conn.Prepare("select 1, 'abc'")
- if err != nil {
- log.Fatal("Prepare failed:", err.Error())
- }
- defer stmt.Close()
- row := stmt.QueryRow()
- var somenumber int64
- var somechars string
- err = row.Scan(&somenumber, &somechars)
- if err != nil {
- log.Fatal("Scan failed:", err.Error())
- }
- fmt.Printf("somenumber:%d\n", somenumber)
- fmt.Printf("somechars:%s\n", somechars)
- fmt.Printf("bye\n")
- }
Add Comment
Please, Sign In to add comment