简易入门示例¶
示例如下,演示如何导入go-aci包,并进行数据库连接和表的创建:
package main
import (
"database/sql"
"fmt"
_ "go-aci"
"log"
"context"
"time"
"runtime"
//"strings"
//"bytes"
)
func main() {
var db * sql.DB
var err error
db, err = sql.Open("aci", "sysdba/szoscar55@10.1.203.42:2003/OSRDB")
getError(err)
defer db.Close()
_, err = db.Exec("drop table testcase1")
_, err = db.Exec(`create table testcase1(col1 int, col2 varchar(256),
col3 bool, col4 INT8, col5 FLOAT8, col6 TIMESTAMP,
col7 clob, col8 blob)`)
getError(err)
//此处进行数据操作
//...
//...
//...
}
func getError(err error){
_, _, line, _ := runtime.Caller(1)
if err != nil{
//打印调用函数行号
fmt.Println(line)
//获取错误信息
log.Fatalln(err)
}
}