Advertisement
Guest User

Untitled

a guest
Jul 18th, 2016
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.69 KB | None | 0 0
  1. package main
  2.  
  3. import (
  4. "database/sql"
  5. "fmt"
  6. "log"
  7.  
  8. _ "github.com/denisenkom/go-mssqldb"
  9. )
  10.  
  11. func main() {
  12.  
  13. connString := fmt.Sprintf("server=%s;user id=%s;password=%s;database=%s;encrypt=disable",
  14. "xx.xx.xx.xx", "xxx", "xxx", "xxxxx")
  15.  
  16. conn, err := sql.Open("mssql", connString)
  17. if err != nil {
  18. log.Fatal("Open connection failed:", err.Error())
  19. }
  20.  
  21. stmt, err := conn.Prepare(`select top 1 * from Users where UserName = 'xxx'`)
  22. if err != nil {
  23. log.Printf("\nPrepare failed:%T %+v\n", err, err)
  24.  
  25. }
  26. //defer stmt.Close()
  27.  
  28. row := stmt.QueryRow()
  29. var somenumber int64
  30. var somechars string
  31. err = row.Scan(&somenumber, &somechars)
  32. if err != nil {
  33. log.Fatal("Scan failed:", err.Error())
  34. }
  35. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement