将带有axios的JSON数据插入MySQL

ltqd579y  于 2022-12-03  发布在  Mysql
关注(0)|答案(1)|浏览(146)

我正在用axios向api发出请求,我得到了响应。但是我无法将这些数据发送到mysql。我如何才能将json数据发送到mysql呢?
Axios公司

var axios = require('axios');
const { response } = require('express');
var data = JSON.stringify({
  //something
  }
});

var config = {
  method: 'get',
  url: 'api_url',
  headers: { 
    'Content-Type': 'application/json'
  },
  data : data
};
axios(config)
.then(function (response) {
 JSON.stringify(response.data);
 
})
.catch(function (error) {
  console.log(error);
});

和我的数据库连接(我知道我搞砸了我的SQL代码)

var con = mysql.createConnection({
  host: "localhost",
  user: "root",
  password: "",
  database: "test"
});

con.connect(function (err) {
  if (err) throw err;
  console.log("Connected!");

  var sql = "INSERT INTO CustomerCard (CustomerCode, CustomerName, CustomerKey) VALUES ?";

var values = [
[ response.data.customercode,
  response.data.customername,
  respomse.data.customerkey]

]

con.query(sql, [values], function (err, result) {
    if (err) throw err;
    console.log("Number of records inserted: " + result.affectedRows);
  });
});

你知道我该怎么做吗?

vuktfyat

vuktfyat1#

如果您的response.data正在获取数据,请按以下方式重新组织代码:

var sql = "INSERT INTO CustomerCard SET ?";
  
  // you have to make sure the variable name equal to column's name.
  var form_data = {
    CustomerCode : response.data.customercode,
    CustomerName : response.data.customername,
    CustomerKey : response.data.customerkey,
  };
  
  con.query(sql, form_data, function (err, result) {
    if (err) throw err;
    console.log("Number of records inserted: " + result.affectedRows);
  });

相关问题