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()
}