Go 数据库查询

Question

使用 github.com/go-sql-driver/mysql 库

package main 

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

type User struct {
	Id int `json:"id"`
	Username string `json:"username"`
	Email string `json:"email"`
}

func main() {
	db, err := sql.Open("mysql", "root:tangweinan@/gililove")
	if err != nil {
		panic(err.Error())
	}
	defer db.Close()

	err = db.Ping()
	if err != nil {
		panic(err.Error()) 
	}

	rows, err := db.Query("select id, username, email from users where id=18")
	if err != nil {
		panic(err.Error())
	}

	for rows.Next() {
		user := new(User)
		err := rows.Scan(&user.Id, &user.Username, &user.Email)
		if err != nil {
			panic(err.Error())
		}
		fmt.Println(user.Email)
		result, err := json.Marshal(user)
		fmt.Println(string(result))
	}
}