golang各类数据库连接方式

常用数据库驱动列表

    //odbc
    _ "github.com/alexbrainman/odbc"
    //mssql
    _ "github.com/denisenkom/go-mssqldb"
    //mysql
    _ "github.com/go-sql-driver/mysql"
    //oracle
    _ "github.com/godror/godror"

    // _ "github.com/ibmdb/go_ibm_db"
    //pgsql
    _ "github.com/jackc/pgx/v4/stdlib"

常用数据库驱动连接例子列表

switch conf.DbType {
    case Mysql:
         url:="userName:password@tcp(127.0.0.1:3306)/test?charset=utf8"
         db, err = sql.Open("mysql", url)
    case Oracle:
        url := `user="a" password="b" connectString="127.0.0.1:1521/test"`
        db, err = sql.Open("godror", url)
    case Mssql:
        url := `sqlserver://name:pwd@127.0.0.1:1433?database=test`
        db, err = sql.Open("sqlserver", url)
    case Pgsql:
        url := `postgres://name:pwd@127.0.0.1:5432/test?sslmode=disable`
        db, err = sql.Open("pgx", url)
    case Db2:
        url := `DSN=133DB2;uid=userName;pwd=passwd`
        db, err = sql.Open("odbc", url)
    }