摘要：模糊查詢并分頁建立數據庫代碼如下頁面布局這里只需要搜索框和搜索按鈕，再點擊按鈕時，執行方法并發送請求代碼如下請輸入項目名稱搜索設置每頁顯示頁碼設置當前頁碼為獲取查找條件為模糊查詢固定語法，為參數刷新頁面查找內容查找個數重新分頁改變頁碼

mongodb模糊查詢并分頁

1.建立數據庫

代碼如下：

var mongoose = require("mongoose");
var shortid = require("shortid");
var Schema = mongoose.Schema;

var IndexDataSchema = new Schema({
    _id: {
        type: String,
        unique: true,
        "default": shortid.generate
    },
    type: String,
    city: String,
    name:string,
    value: [{name: String, value: String}],
    create: {type: Date, default: Date.now},
    expand: String
});

IndexDataSchema.statics = {
    defaultSort: {"create": 1},
    defaultOptions: {"pageSize": 0}

};


var IndexData = mongoose.model("IndexData", IndexDataSchema);

module.exports = IndexData;

頁面布局
這里只需要搜索框和搜索按鈕，再點擊按鈕時，執行search()方法并發送請求

代碼如下：

  

                    
                    搜索
                
                

到數據庫查找并返回相應內容

 var formidable = require("formidable");
    var common = require("./common");
    var path = require("path");
    var fs = require("fs");
    var path = require("path");
    var guid = require("guid");
    var shortid = require("shortid");
    
    var AuctionHouse = require("./db/IndexData");


  var funs = {
    getList: function (collectionName, req, res, next) {
        var mainObj = transformCollctionName(collectionName);
        if (!mainObj) {
            next();
        }
        var options = req.query;
        var sort = options.sort || mainObj.defaultSort;
        var pageSize = options.pageSize || mainObj.defaultOptions.pageSize;
        var currentPage = options.currentPage || 1;
        var condition = options.condition || {}
        
        //此部分為查找條件
        mainObj.find(condition).sort(sort).skip((currentPage - 1) * pageSize).limit(pageSize).exec(function (err, docs) {
            if (err) {
                next(err);
            }
            return res.json(common.returnData(true, docs));
        })
    },
    countList: function (collectionName, req, res, next) {
        var mainObj = transformCollctionName(collectionName);
        if (!mainObj) {
            next();
        }
        var condition = req.query.condition || {}
        mainObj.find(condition).count().exec(function (err, docs) {
            if (err) {
                next(err);
            }
            return res.json({"count": docs});
        })
    },
    HandleEvent: function (collectionName, actionsName, req, res, next) {
        var mainFuns = getCollctionFuns(collectionName)
        if (!mainFuns) {
            next();
        }
        var fun = mainFuns[actionsName];
        if (!fun) {
            next();
        }
        fun(req, res, next);
    }