我正在看这个例子如何发送或发布多个Json对象。我想传递一个实体类型模型,但不确定如何使用。
src-> modelfile
``` const groupid = req.body.groupid;
``` const device_id = req.body.device_id;
``` const nearbytime = req.body.nearbytime;
``` const distance = req.body.distance;
``` const lat = req.body.lat;
const lon = req.body.lon;
const user_id = req.body.user_id;
const sql = 'INSERT INTO tb_token SET device_id=?, user_id=?, groupid=?, nearbytime=?, distance=?, lat=?, lon=?';
return new Promise ((resolve, reject) => {
connection.query (sql, [device_id,user_id,groupid,nearbytime,distance,lat,lon], (err, response) => {
if (!err) {
resolve (response);
} else {
reject (err);
}
}
);
});
},
```
可以同时输入多条记录。例子插入Tb_token (device_id, user_id, groupid, nearbytime, distance, lat, lon)值(1.10,11, 2020-10-10, 50, -24.6, -35),(1.10,11, 2020-10-10, 50, -24.6, -35),(1.10,11, 2020-10-10, 50, -24.6, -35),(1.10, 11, 2020-10-10, 50, -24.6, -35),
值是您想要插入到表中的记录,您只需要正确地组织它们