GO: 实例t_mysql.go

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "root:@tcp(192.168.9.242:3306)/HSS?charset=utf8")
    if err != nil {
        fmt.Println("failed to open database:", err.Error())
        return
    }

    defer db.Close()

    rows, err := db.Query("SELECT * FROM APN_SELECTION")
    if err != nil {
        fmt.Println("fetech data failed:", err.Error())
        return
    }

    defer rows.Close()

    for rows.Next() {
        var RID int
        var IMSI int
        var APN_PROFILE int
        var TYPE_OF_CONTEXT int
        var STATIC_PDN_ADDRESS_ALLOCATION string
        var SERVED_PARTY_IPV4_PRESENCE string
        var SERVED_PARTY_IPV4_ADDR string
        var SERVED_PARTY_IPV6_PRESENCE string
        var SERVED_PARTY_IPV6_ADDR string
        //rows.Columns()
        rows.Scan(&RID, &IMSI, &APN_PROFILE, &TYPE_OF_CONTEXT, &STATIC_PDN_ADDRESS_ALLOCATION, &SERVED_PARTY_IPV4_PRESENCE, &SERVED_PARTY_IPV4_ADDR, &SERVED_PARTY_IPV6_PRESENCE, &SERVED_PARTY_IPV6_ADDR)
        fmt.Println(RID, IMSI, APN_PROFILE, TYPE_OF_CONTEXT, STATIC_PDN_ADDRESS_ALLOCATION, SERVED_PARTY_IPV4_PRESENCE, SERVED_PARTY_IPV4_ADDR, SERVED_PARTY_IPV6_PRESENCE, SERVED_PARTY_IPV6_ADDR)
    }
    //fmt.Println(*rows)

}