123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155 |
- package main
- import (
- "database/sql"
- "fmt"
- "log"
- _ "xugu_driver/xugu"
- )
- func main() {
- db, err := sql.Open("xugusql", "IP=10.28.20.101;DB=SYSTEM;User=SYSDBA;PWD=SYSDBA;Port=5190;AUTO_COMMIT=on;CHAR_SET=UTF8")
-
-
- if err != nil {
- log.Fatal(err)
- }
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- rows, err := db.Query("select b from goblob;")
- if err != nil {
- fmt.Println("error", 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
- }
- for rows.Next() {
- fmt.Println("rows.Next()")
- err = rows.Scan(pvals...)
- if err != nil {
- log.Fatal(err)
- }
- for _, v := range pvals {
- fmt.Printf("aa %s\t", string(*(v.(*[]byte))))
- }
- fmt.Printf("\n")
- }
- rows.Close()
- db.Close()
- }
|