1. Select操作

  1. package main
  3. import (
  4.     "fmt"
  6.     _ "github.com/go-sql-driver/mysql"
  7.     "github.com/jmoiron/sqlx"
  8. )
  10. type Person struct {
  11.     UserId   int    `db:"user_id"`
  12.     Username string `db:"username"`
  13.     Sex      string `db:"sex"`
  14.     Email    string `db:"email"`
  15. }
  17. type Place struct {
  18.     Country string `db:"country"`
  19.     City    string `db:"city"`
  20.     TelCode int    `db:"telcode"`
  21. }
  23. var Db *sqlx.DB
  25. func init() {
  27.     database, err := sqlx.Open("mysql", "root:root@tcp(127.0.0.1:3306)/test")
  28.     if err != nil {
  29.         fmt.Println("open mysql failed,", err)
  30.         return
  31.     }
  33.     Db = database
  34. }
  36. func main() {
  38.     var person []Person
  39.     err := Db.Select(&person, "select user_id, username, sex, email from person where user_id=?", 1)
  40.     if err != nil {
  41.         fmt.Println("exec failed, ", err)
  42.         return
  43.     }
  45.     fmt.Println("select succ:", person)
  46. }

输出结果：

  1.     select succ: [{1 stu001 man stu01@qq.com}]