### 查詢單條數據 ``` func (this *User)User(id int64)(User, error) { o := orm.NewOrm() var user User error := o.Raw("select * from user where id = ?", id).QueryRow(&user) return user,error } ``` #### 查詢多條數據 ``` func (this *User)UserList()([]User, int64, error) { o := orm.NewOrm() var users []User num, error := o.Raw("select * from user").QueryRows(&users) return users, num, error } ``` #### map ``` 返回結果集的 key => value 值 func (this *User)UserMap() { var maps []orm.Params o := orm.NewOrm() num, err := o.Raw("select * from user").Values(&maps) fmt.Println(num, err, maps) fmt.Println(maps[0]) fmt.Println(maps[0]["name"]) } ``` #### ValuesList ``` 返回結果集 slice func (this *User)UserLists() { var lists []orm.ParamsList o := orm.NewOrm() num, err := o.Raw("select * from user").ValuesList(&lists) fmt.Println(num, err, lists) fmt.Println(lists[0]) fmt.Println(lists[0][0]) } ```