Express中:
Module : 确定表结构,且mongoose .model确定的必须为表的名字
const mongoose = require("mongoose");
const typeSchema = new mongoose.Schema({
"_id" : String,
"raw_data": Object,
"converted_data": Object,
"results": Object,
})
const Type = mongoose.model("data",typeSchema,"data");
module.exports = Type;
连接mongdb
let mongoose = require('mongoose');
let HULL = require('../module/users');
mongoose.connect('mongodb://121.40.230.24:27017/HULL');
mongoose.connection.on("connected", function() {
console.log("mongoose链接成功");
});
mongoose.connection.on("open", function() {
console.log("mongoose open");
});
mongoose.connection.on("error", function() {
console.log("mongoose error");
});
mongoose.connection.on("disconnected", function() {
console.log("mongoose disconnected");
});
接口查询: 根据逆序,只取一个
router.get('/list', function(req, res, next) {
HULL.find({},{},{sort:{_id: -1 },limit:1},function(err, doc) {
if(err) {
console.log(err.message)
}else{
res.send({
stauts: "200",
msg: "get成功返回",
data: doc
})
}
})
Express 跨域:
const cors = require('cors');
app.use(cors());
原生node 连接数据库
const MongoClient = require('mongodb').MongoClient;
const assert = require('assert');
const dbName = 'HULL';
exports.connectDB = function(card) {
let url = 'mongodb://121.40.230.24:27017/HULL';
MongoClient.connect(url, function(err, client) {
assert.equal(null, err);
console.log("Connected successfully to DB");
const db = client.db(dbName);
find_data(db,function(){
client.close();
})
});
}
var find_data = function( db, callback) {
var collection = db.collection('data');
查询语句
collection.find().sort("_id",-1).limit(1).toArray( function(err, result) {
console.log(result);
});
}