沒有與資料庫或表相關的錯誤，但它沒有看到列。這是錯誤：節點服務器正在運行.. SQLITE_ERROR：沒有這樣的列：場景
這是表格：
CREATE TABLE animalStream (
id INTEGER PRIMARY KEY AUTOINCREMENT,
cascade_name TEXT NOT NULL,
enclosre_name TEXT NOT NULL,
scene TEXT NOT NULL,
sensorCamAddress TEXT NOT NULL,
streamerCamAddress TEXT NOT NULL,
duration INTEGER NOT NULL
);
下面的 Nodejs 代碼允許我從 HTML 表單接收資料
const path=require('path');
const sqlite3 = require("sqlite3").verbose();
const db_name = path.join(__dirname, "wildlife.db");
const db = new sqlite3.Database(db_name);
var express = require('express');
var app = express();
var bodyParser = require("body-parser");
app.use(bodyParser.urlencoded({ extended: false }));
app.get('/', function (req, res) {
res.sendFile('/home/harry/interface/in9.html');
});
app.post('/submit-student-data', function (req, res) {
var scene = req.body.scene
var cascade_name = req.body.cascade_name;
var enclosre_name = req.body.enclosre_name;
var sensorCamAddress = req.body.sensorCamAddress
var streamerCamAddress = req.body.streamerCamAddress
var duration = req.body.duration;
db.run(`INSERT INTO animalStream(scene) VALUES(scene)`, ['C'], function(err) {
if (err) {
return console.log(err.message);
}
// get the last insert id
console.log(`A row has been inserted with rowid ${this.lastID}`);
});
});/////////////////
var server = app.listen(3000, function () {
console.log('Node server is running..');
});
<!DOCTYPE html>
<html><body style="background-color:black;"><blockquote><blockquote>
<form action="/submit-student-data" method="post">
<p style="color:white;">Cascade file name:<br>
<input type = "text" name = "cascade_name" /></p>
<p style="color:white;">Enclosure name:<br>
<input type = "text" name = "enclosre_name" /></p>
<p style="color:white;">Scene number:<br>
<input type = "text" name = "scene" /></p>
<p style="color:white;">Sensor Camera IP address:
<br> <input type = "text" name = "sensorCamAddress" /></p>
>
<p style="color:white;">Streamer Camera IP address:
<br> <input type = "text" name = "streamerCamAddress" /></p>
<p style="color:white;">Scene duration:
<br><input type = "text" name = "duration" /></p>
<br>
<center> <INPUT type="submit" value="Send"> <INPUT type="reset"></center>
</form>
</blockquote></blockquote>
</body></html>
正如我所提到的，它似乎可以很好地獲取資料庫和表。由于某種原因，它只是看不到這些列。我會很感激任何意見。
uj5u.com熱心網友回復：
我認為您必須像這樣撰寫查詢：
`INSERT INTO animalStream (scene) VALUES("${scene}")`
而且您沒有為設定的其他列設定任何值 NOT NULL
轉載請註明出處，本文鏈接：https://www.uj5u.com/qiye/406248.html
標籤：
上一篇：Express.js-Multer檔案過濾器不起作用
下一篇：無法在發布請求中發送物件