Express(Node.js) + Mysql (2) Rest API Get Method


Express(Node.js)+Mysql(2)REST API Getメソッドの呼び出し
Testという名前の任意のDBから「User」Tableデータを呼び出す
User
user_iduser_emailuser_nameuser_password1111
server.js
+ code add
app.get("/uesr", (req, res) => {
  var queryString = "SELECT * FROM user";
  db.query(queryString, (err, results, fields) => {
    if (err) throw err;
    //console.log("results: ", results);
    res.json(results); // json
  });
});
Get Method呼び出し結果
[{"user_id":1,"user_email":"1","user_name":"1","user_password":"1"}]