如何使用ReactJS插入SQL Server

Question

我试图用下面的代码插入SQL Server，但它不工作。如果我手动给出值，而不是?那就没问题了。

app.post("/outwrkwip/insert",(req,res)=>{
sql.connect(config,function(err){
if(err){
console.log(err);
}
var request = new sql.Request();
var values = ["MTRT421PV42FOG","11-MAY-22","4249.1","MTBI","16954073"];
var sqlqry = `INSERT INTO dbo.outworkwip_Tb_KK (Order_Number,prod_Target_Date,Line_No,Order_Type,Batch_Number)  VALUES (?,?,?,?,?);`                        
request.query(sqlqry, [values], (err,recordset)=>{           

if(err){                
console.log(err)
} else{
res.send({message : "Successfully Data Inserted"});
}
});
});
});

Answer 1

下面表示代码运行正常…

app.post("/outwrkwip/insert",(req,res)=>{
sql.connect(config,function(err){
if(err){
console.log(err);
}
var request = new sql.Request();       


request.input('Order_Number', sql.VarChar, 'MTRT421PV42FOG');
request.input('prod_Target_Date', sql.VarChar, '11-MAY-22');
request.input('Line_No', sql.VarChar, '4249.1');
request.input('Order_Type', sql.VarChar, 'MTBI');
request.input('Batch_Number', sql.VarChar, '16954073');
let stmt1 =  `INSERT INTO dbo.outworkwip_Tb_KK(Order_Number,prod_Target_Date,Line_No,Order_Type,Batch_Number)  
VALUES (@Order_Number,@prod_Target_Date,@Line_No,@Order_Type,@Batch_Number);`

request.query(stmt1, (err, results) => {
if (err) {
return console.error(err.message);
}
res.send({ message : "Successfully Registered"}); 
});
});
});