var Language= Bmob.Object.extend("language"); var query = new Bmob.Query(Language); // 查詢所有數據 query.find({ success: function(results) { console.log("總數:"+results.length); }, error: function(error) { console.log("查詢出錯"); } });注意:默認情況下,并不會返回所有數據,只是查出前10條數據。可以通過setLimit來設置返回數據條數。2.查詢第一條數據
var Language= Bmob.Object.extend("language"); var query = new Bmob.Query(Language); // 查詢所有數據 query.first({ success: function(object) { console.log(object.name); }, error: function(error) { console.log("查詢出錯"); } });3.根據id查詢
var Language= Bmob.Object.extend("language"); var query = new Bmob.Query(Language); // 根據id獲取對象 query.get('3453453453fdsdf', { success: function(result) { //do something }, error: function(object, error) { console.log("查詢出錯"); } });4.條件查詢
query.equalTo(列名, 值); //等于query.notEqualTo(列名, 值); //不等于query.lessThan(列名, 值); //小于query.lessThanOrEqualTo(列名, 值); //小于等于query.greaterThan(列名, 值); //大于query.greaterThanOrEqualTo(列名, 值); //大于等于query.containedIn(列名, [值1, 值2, 值3,...]);//查詢列值為數組中包含的值的集合query.exists(列名); //查詢存在指定的列屬性的對象query.doesNotExist(列名); //查詢不存在指定的列屬性的對象query.select(列名); //查詢指定列query.startsWith(列名, 字符串); //查詢指定列名的值以字符串開頭的集合query.ascending(列名稱); //對指定列升序排序query.descending(列名稱); //對指定列降序排序and查詢,將2個查詢條件寫在一起即可,例如:query.notEqualTo("name", "bmob");query.greaterThan("num", 50); //查詢name!=bmob且num>50的數據or查詢var query1 = new Bmob.Query(Diary);query1.greaterThan("isLike", 150);var query2 = new Bmob.Query(Diary);query2.lessThan("isLike", 5);var mainQuery = Bmob.Query.or(query1, query2);mainQuery.find({ success: function(results) { // 返回 isLike > 150 or isLike < 5 的值 }, error: function(error) { // 返回失敗 }});復合查詢var Lanugage= Bmob.Object.extend("Lanugage");var LanQuery = new Bmob.Query(Language);LanQuery.greaterThan("count",5);var Question = Bmob.Object.extend("Lanugage");var questionQuery = new Bmob.Query(Question );questionQuery.matchesKeyInQuery("name", "content", DiaryQuery); //查詢language對象count>5的question對象集合questionQuery.find({ success: function(results) { // do something }});注意:與之相對的是:doesNotMatchKeyInQuery獲取屬性不在子查詢結果中的對象query.limit(10); //分頁查詢,每次查詢10條query.skip(10); //跳過前10 條再開始查詢6.查詢指定字段
var Diary = Bmob.Object.extend("diary");var query = new Bmob.Query(Diary);// 只返回score和playerName字段值query.select("title");query.find().then(function(results) { // 返回成功});