let db = require('../db/index');
// nebula.js (修正字段别名)
exports.all = (req, res) => {
var sql = "SELECT * FROM nebula;"; // 表名改为 nebula
db.query(sql, (err, data) => {
if (err) {
return res.send("错误:" + err.message);
}
res.send(data);
});
};
exports.searchNebulaName = (req, res) => {
const keyword = req.query.nebulaNameInput || '';
const sql = `
SELECT
xingyunbianhao AS 编号,
nebulaname AS 名字,
photographer AS 摄影师,
capturedate AS 拍摄时间,
pic AS 图片
FROM nebula
WHERE nebulaname LIKE ?;
`;
db.query(sql, [`%${keyword}%`], (err, data) => {
if (err) {
console.error('查询错误:', err.message);
return res.status(500).send({ status: 500, message: '数据库查询失败', error: err.message });
}
if (data.length === 0) {
return res.send({ status: 404, message: '未找到相关星云' });
}
res.send({ status: 200, data });
});
};
exports.add = (req, res) => {
const sql = `INSERT INTO nebula SET ?`;
db.query(sql, req.body, (err, result) => {
if (err) {
if (err.code === 'ER_DUP_ENTRY') {
return res.send({ status: 409, message: '星云编号已存在' });
}
return res.status(500).send('错误:' + err.message);
}
res.send({ status: 200, message: '添加成功' });
});
};
// 更新星云 - 修复路由方法
exports.update = (req, res) => {
const sql = `UPDATE nebula SET ? WHERE xingyunbianhao = ?`;
db.query(sql, [req.body, req.body.xingyunbianhao], (err, result) => {
if (err) {
if (err.code === 'ER_DUP_ENTRY') {
return res.send({ status: 409, message: '星云编号冲突' });
}
console.error('更新错误:', err.message);
return res.status(500).send({ status: 500, message: '更新失败', error: err.message });
}
if (result.affectedRows > 0) {
res.send({ status: 200, message: '更新成功' });
} else {
res.send({ status: 404, message: '未找到星云记录' });
}
});
};
// 删除星云
exports.delete = (req, res) => {
const sql = "DELETE FROM nebula WHERE xingyunbianhao = ?";
db.query(sql, [req.query.xingyunbianhao], (err, data) => {
if (err) {
console.error('删除错误:', err.message);
return res.status(500).send({
status: 500,
message: '删除失败: ' + err.message
});
}
if (data.affectedRows > 0) {
res.send({
status: 200,
message: '删除成功'
});
} else {
res.send({
status: 404,
message: '未找到该星云'
});
}
});
};出现let db = require('../db/index');
// nebula.js (修正字段别名)
exports.all = (req, res) => {
var sql = "SELECT * FROM nebula;"; // 表名改为 nebula
db.query(sql, (err, data) => {
if (err) {
return res.send("错误:" + err.message);
}
res.send(data);
});
};
exports.searchNebulaName = (req, res) => {
const keyword = req.query.nebulaNameInput || '';
const sql = `
SELECT
xingyunbianhao AS 编号,
nebulaname AS 名字,
photographer AS 摄影师,
capturedate AS 拍摄时间,
pic AS 图片
FROM nebula
WHERE nebulaname LIKE ?;
`;
db.query(sql, [`%${keyword}%`], (err, data) => {
if (err) {
console.error('查询错误:', err.message);
return res.status(500).send({ status: 500, message: '数据库查询失败', error: err.message });
}
if (data.length === 0) {
return res.send({ status: 404, message: '未找到相关星云' });
}
res.send({ status: 200, data });
});
};
exports.add = (req, res) => {
const sql = `INSERT INTO nebula SET ?`;
db.query(sql, req.body, (err, result) => {
if (err) {
if (err.code === 'ER_DUP_ENTRY') {
return res.send({ status: 409, message: '星云编号已存在' });
}
return res.status(500).send('错误:' + err.message);
}
res.send({ status: 200, message: '添加成功' });
});
};
// 更新星云 - 修复路由方法
exports.update = (req, res) => {
const sql = `UPDATE nebula SET ? WHERE xingyunbianhao = ?`;
db.query(sql, [req.body, req.body.xingyunbianhao], (err, result) => {
if (err) {
if (err.code === 'ER_DUP_ENTRY') {
return res.send({ status: 409, message: '星云编号冲突' });
}
console.error('更新错误:', err.message);
return res.status(500).send({ status: 500, message: '更新失败', error: err.message });
}
if (result.affectedRows > 0) {
res.send({ status: 200, message: '更新成功' });
} else {
res.send({ status: 404, message: '未找到星云记录' });
}
});
};
// 删除星云
exports.delete = (req, res) => {
const sql = "DELETE FROM nebula WHERE xingyunbianhao = ?";
db.query(sql, [req.query.xingyunbianhao], (err, data) => {
if (err) {
console.error('删除错误:', err.message);
return res.status(500).send({
status: 500,
message: '删除失败: ' + err.message
});
}
if (data.affectedRows > 0) {
res.send({
status: 200,
message: '删除成功'
});
} else {
res.send({
status: 404,
message: '未找到该星云'
});
}
});
};let db = require('../db/index');
// nebula.js (修正字段别名)
exports.all = (req, res) => {
var sql = "SELECT * FROM nebula;"; // 表名改为 nebula
db.query(sql, (err, data) => {
if (err) {
return res.send("错误:" + err.message);
}
res.send(data);
});
};
exports.searchNebulaName = (req, res) => {
const keyword = req.query.nebulaNameInput || '';
const sql = `
SELECT
xingyunbianhao AS 编号,
nebulaname AS 名字,
photographer AS 摄影师,
capturedate AS 拍摄时间,
pic AS 图片
FROM nebula
WHERE nebulaname LIKE ?;
`;
db.query(sql, [`%${keyword}%`], (err, data) => {
if (err) {
console.error('查询错误:', err.message);
return res.status(500).send({ status: 500, message: '数据库查询失败', error: err.message });
}
if (data.length === 0) {
return res.send({ status: 404, message: '未找到相关星云' });
}
res.send({ status: 200, data });
});
};
exports.add = (req, res) => {
const sql = `INSERT INTO nebula SET ?`;
db.query(sql, req.body, (err, result) => {
if (err) {
if (err.code === 'ER_DUP_ENTRY') {
return res.send({ status: 409, message: '星云编号已存在' });
}
return res.status(500).send('错误:' + err.message);
}
res.send({ status: 200, message: '添加成功' });
});
};
// 更新星云 - 修复路由方法
exports.update = (req, res) => {
const sql = `UPDATE nebula SET ? WHERE xingyunbianhao = ?`;
db.query(sql, [req.body, req.body.xingyunbianhao], (err, result) => {
if (err) {
if (err.code === 'ER_DUP_ENTRY') {
return res.send({ status: 409, message: '星云编号冲突' });
}
console.error('更新错误:', err.message);
return res.status(500).send({ status: 500, message: '更新失败', error: err.message });
}
if (result.affectedRows > 0) {
res.send({ status: 200, message: '更新成功' });
} else {
res.send({ status: 404, message: '未找到星云记录' });
}
});
};
// 删除星云
exports.delete = (req, res) => {
const sql = "DELETE FROM nebula WHERE xingyunbianhao = ?";
db.query(sql, [req.query.xingyunbianhao], (err, data) => {
if (err) {
console.error('删除错误:', err.message);
return res.status(500).send({
status: 500,
message: '删除失败: ' + err.message
});
}
if (data.affectedRows > 0) {
res.send({
status: 200,
message: '删除成功'
});
} else {
res.send({
status: 404,
message: '未找到该星云'
});
}
});
};出现错误:ER_PARSE_ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1如何解决