db

README

数据库连接 支持Oracle/PostgreSQL/MySQL

配置文件示例：

"MainDB": {
	"Name": "核心库",
	"Protocol": "MySQL",   # 目前可选MySQL/Oracle/PostgreSQL/PGSQL
	"IP": "10.242.31.180", # 必填
	"Port": "3306",        # 必填
	"DBName": "hibss",     # 必填
	"Network": "tcp",      # tcp/udp...
	"UserName": "hibss",   # 
	"PassWord": "Hibss135!",
	"NLS_LANG": "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
}

Documentation

Index

• type DBCfg
• type DBConn
  • func NewDBConn(dbcfg DBCfg) *DBConn
  • func (conn *DBConn) Connect() error

Types

type DBCfg

type DBCfg struct {
	Name        string        `json:"Name"`
	Protocol    string        `json:"Protocol"`
	IP          string        `json:"IP"`
	Port        string        `json:"Port"`
	DBName      string        `json:"DBName"`
	Network     string        `json:"Network"`
	UserName    string        `json:"UserName"`
	PassWord    string        `json:"PassWord"`
	NlsLang     string        `json:"NlsLang"`
	LibDir      string        `json:"LibDir"`
	MaxOpen     int           `json:"MaxOpen"`
	MaxIdle     int           `json:"MaxIdle"`
	MaxLifetime time.Duration `json:"MaxLifetime"`
}

type DBConn

type DBConn struct {
	*sql.DB
	*DBCfg
}

func NewDBConn

func NewDBConn(dbcfg DBCfg) *DBConn

New

func (*DBConn) Connect

func (conn *DBConn) Connect() error