golang开发oracle利器godror
godror是golang中连接oracle进行程序开发的一个驱动库,解决了长期以来go对oracle支持不友好的问题。github项目地址
简单查询示例:
将查询结果转换为json字符串输出
package main
import (
"database/sql"
"encoding/json"
"fmt"
_ "github.com/godror/godror"
)
func main() {
db, err := sql.Open("godror", `user="testq" password="123456" connectString="192.169.123.72:1521/orcl"`)
if err != nil {
panic(err)
}
err = db.Ping()
if err != nil {
panic(err)
}
//查询
sqlStatement := "SELECT * FROM BAJG where ID = :1"
stm