Skip to content

PingContext

PingContext 方法用于验证当前到数据库的连接是否仍然有效,并在必要时建立连接。

函数语法

func (db *DB) PingContext(ctx context.Context) error

示例

package main

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

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

   err = db.PingContext(context.Background())
   if err != nil {
       fmt.Printf("connect xugu dbms ... failed\n")
   } else {

       fmt.Printf("connect xugu dbms ... ok\n")
   }

   err = db.Close()

}