構造查詢 ~~~ Select(fields ...string) QueryBuilder From(tables ...string) QueryBuilder InnerJoin(table string) QueryBuilder LeftJoin(table string) QueryBuilder RightJoin(table string) QueryBuilder On(cond string) QueryBuilder Where(cond string) QueryBuilder And(cond string) QueryBuilder Or(cond string) QueryBuilder In(vals ...string) QueryBuilder OrderBy(fields ...string) QueryBuilder Asc() QueryBuilder Desc() QueryBuilder Limit(limit int) QueryBuilder Offset(offset int) QueryBuilder GroupBy(fields ...string) QueryBuilder Having(cond string) QueryBuilder Subquery(sub string, alias string) string String() string ~~~ ~~~ package main import ( "fmt" "github.com/astaxie/beego/orm" _ "github.com/go-sql-driver/mysql" ) // struct 字段，首字母必須大寫 type Person struct { User_id int `orm:"pk"` Username string Sex string Email string } func init() { maxIdle := 30 maxConn := 30 // 創建連接池 err := orm.RegisterDataBase("default", "mysql", "root:root@tcp(127.0.0.1:3306)/test?charset=utf8", maxIdle, maxConn) if err != nil { fmt.Println("connect mysql err : ", err) } // 需要在init中注冊定義的model orm.RegisterModel(new(Person)) } func main() { var p0 []Person // 獲取 QueryBuilder 對象. 需要指定數據庫驅動參數。 // 第二個返回值是錯誤對象，在這里略過 DB, _ := orm.NewQueryBuilder("mysql") // 構建查詢對象 DB.Select("*"). From("person"). Where("user_id > 1"). OrderBy("user_id").Desc(). Limit(10) // 導出 SQL 語句 sql := DB.String() fmt.Println(sql) // 執行 SQL 語句 o := orm.NewOrm() o.Raw(sql).QueryRows(&p0) fmt.Println(p0) } ~~~