package zenithdriver

import (
        "database/sql"
        "database/sql/driver"
        "fmt"
        "os"
        "reflect"
        "strconv"
        "testing"
        "time"
        "unsafe"
)

type (
        testValue struct {
                direction int
                data driver.Value
        }
)
//创建连接
db, err = sql.Open("zenith", "zenithdriver/Gauss_234@127.0.0.1:1611")
if err != nil {
   return err
}
//执行sql语句，创建表
_,err = db.Exec("create table tst_batchbind (id real, name varchar(20))")
 if err != nil {
   return err
}
// 创建statement
stmt, err = db.Prepare("insert into tst_batchbind values (:1,:2)")
   if err != nil {
       return err
}
// 批量绑定参数执行sql
var intput = [5][2]driver.Value {{1.2,"Golus"}, {2.3, "Bonus"}, {3.5, "Franj"}, {4.6, "Wliian"}, {5.7, "Dous"}}
for _,value := range intput {
   _, err = stmt.Exec(value[0], value[1])
   if err != nil {
      return err
   }
}
//关闭statement
stmt.Close()
//关闭连接
db.Close()