简易入门示例

示例如下,演示如何导入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)
                    }
            }