QueryContext

QueryContext 方法执行返回行的查询，通常为 select 语句。

函数语法

func (db *DB) QueryContext (ctx context.Context, query string, args...interface{}) (*Rows, error)

示例

package main

import (
   _ "./go-driver-xugusql"
   "database/sql"
   “log”
   “context.Context”
)

func main() {
   db, _ := sql.Open("xugusql", "IP=192.168.78.130;DB=SYSTEM;User=SYSDBA;"
       + "PWD=SYSDBA;Port=5138;AUTO_COMMIT=on;CHAR_SET=UTF8")

   rows, err := db.QueryContext(context.Background(),
       “select c1, c2 from go_test”)
   if err != nil {
       log.Fatal(err)
   }

   var cols []string 
   cols, err = rows.Columns()
   if err != nil {
       log.Fatal(err)
   }
   pvals := make([]interface{}, len(cols))
   for key, _ := range pvals {
       dest := make([]byte, 216)
       Pvals[key] = &dest
   }  /* end for */

   for rows.Next() {
       err = rows.Scan(pvals...)
       if err != nil {
           log.Fatal(err)
       }

       for _, v := range pvals {

           fmt.Printf(“%s\t”, string(*(v.(*[]byte))))
       }
       fmt.Printf("\n")
   }

   rows.Close()
}