1. app.js
const express = require('express');
const app = express();
app.listen(3000);
//路由配置
const apiRouter = require('./routes/api');
app.use('/api', apiRouter);
2. api.js
const express = require('express');
const router = express.Router();
const mysql = require('mysql');
const connection = mysql.createConnection({
host: '192.168.0.38', //数据库地址
user: '******', //用户
password: '******', //密码
database: 'lj', //库名
});
connection.connect();
//设置跨域访问
router.all('*', function(req, res, next){
res.header("Access-Control-Allow-Origin", "*");
res.header("Access-Control-Allow-Headers", "X-Requested-With");
res.header("Access-Control-Allow-Methods","PUT,POST,GET,DELETE,OPTIONS");
res.header("X-Powered-By",' 3.2.1');
res.header("Content-Type", "application/json;charset=utf-8");
next();
});
//获取数据接口
router.get('/getData',(req,res) => {
connection.query(`SELECT * FROM test`, (err, data) => {
if (err) {
res.status(500).send('err').end();
}else{
res.json(data);
}
});
});
module.exports = router;
2.1数据库如下
3.创建一个html
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<title>test</title>
</head>
<body>
<script src="./jquery-1.9.1.min.js"></script>
<script>
$.ajax({
type: 'get',
url: 'http://127.0.0.1:3000/api/getData',
success: function (data) {
console.log(data);
}
})
</script>
</body>
</html>
4.