Go database/sql and mymysql package usage

gistfile1.go

package main

import (
        "database/sql"
        "fmt"
        _ "github.com/ziutek/mymysql/godrv"
)

func OpenDB() *sql.DB {
        db, err := sql.Open("mymysql", fmt.Sprintf("tcp:%s*%s/%s/%s", DB_HOST, DB_NAME, DB_USER, DB_PASS))
        if err != nil {
                panic(err)
        }
        return db
}

func main() {
        db := OpenDB()
        defer db.Close()

        stmt, err := db.Prepare("SELECT title, content FROM memo WHERE id = ?")
        defer stmt.Close()

        id := 123

        rows, err := stmt.Query(id)
        defer rows.Close()
        if err != nil {
                panic(err)
        }
        if rows.Next() == false {
                return
        }

        var title, content string

        rows.Scan(&title)
        rows.Scan(&content)

        fmt.Printf("%s - %s\n", title, content)

        return
}