package main

import (
    "database/sql"
    "fmt"

    _ "github.com/godror/godror"
    //_ "github.com/wendal/go-oci8"
)

//数据库配置
const (
    host        = "localhost"
    port        = 1521
    user        = "username"
    sqlpassword = "password"
    dbname      = "orcl"
)

func main() {
    // 用户名/密码@IP:端口/实例名
    osqlInfo := fmt.Sprintf("%s/%s@%s:%d/%s", user, sqlpassword, host, port, dbname)
    fmt.Println(osqlInfo)
    db, err := sql.Open("godror", osqlInfo)
    if err != nil {
        fmt.Println("无法链接数据库")
        panic("无法链接数据库")
    }
    defer db.Close()
    err = db.Ping()
    if err != nil {
        panic("无法链接数据库")
    }
    fmt.Println("链接成功")
}