node利用express获取数据库展示在页面demo

 1.app.js

const express = require('express');
const http=require('http');
var mysql = require('mysql');
var pool = mysql.createPool({
    connectionLimit: 10,
    host: '127.0.0.1',
    user: 'root',
    password: '',
    database: 'blog'
});
var app=express();
http.createServer(app).listen(3002,"127.0.0.1");

app.use(express.static("public"));
app.get("/", function (req,res) {
    res.sendFile(__dirname+"/public/index.html")
});
app.get("/getUser", function (req,res) {
    pool.getConnection(function (err, connection) {
        // Use the connection
        connection.query('SELECT * FROM user', function (error, results, fields) {
            // And done with the connection.
            res.json(results);
            connection.release();
            // Handle error after the release.
            if (error) throw error;
            // Don't use the connection here, it has been returned to the pool.
        });
    });
});

2.index.js

$.ajax({
    url:"/getUser",
    type:"get",
    data:{user:"jack",age:24},
    success: function (data,xhr) {
        var tbody="";
        $.each(data, function (i,ele) {
            tbody+=`
                <tr>
                    <td>${ele.username}</td>
                    <td>${ele.password}</td>
                    <td>${ele.nickName}</td>
                </tr>
            `;
        });
        $("tbody").append(tbody);
    }
});

3.demo