node写接口（处理跨域）,再调接口

最新推荐文章于 2024-05-07 00:00:00 发布

lj_qmzhnT_T

最新推荐文章于 2024-05-07 00:00:00 发布

阅读量801

点赞数 2

分类专栏： node

本文链接：https://blog.csdn.net/lj_qmzhnT_T/article/details/82454685

版权

node 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

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.

lj_qmzhnT_T

关注

2
点赞
踩
1

收藏

觉得还不错? 一键收藏
1
评论
node写接口（处理跨域）,再调接口

1. app.jsconst express = require('express');const app = express();app.listen(3000);//路由配置const apiRouter = require('./routes/api');app.use('/api', apiRouter);2. api.jsconst express = re...
复制链接

扫一扫