TDesign中后台管理系统-访问后端服务

VITE_BASE_URL = /VITE_IS_REQUEST_PROXY = trueVITE_API_URL = http://localhost:3000VITE_API_URL_PREFIX = /api

npm install cors --save

const express = require('express');const app = express();const cors = require('cors');// 定义路由app.get('/', (req, res) => {  res.send('Hello, World!');});app.use(cors({  origin: 'http://localhost:3002',  credentials: true}));// 启动服务器app.listen(3000, () => {  console.log('Server is running on port 3000');});

CREATE TABLE `menu`  (  `id` int(0) NOT NULL AUTO_INCREMENT,  `path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,  `redirect` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,  `parent_id` int(0) NULL DEFAULT NULL,  PRIMARY KEY (`id`) USING BTREE,  INDEX `parent_id`(`parent_id`) USING BTREE,  CONSTRAINT `menu_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `menu` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;

npm install mysql --save

const mysql = require('mysql');

// 创建数据库连接池const pool = mysql.createPool({  host: 'localhost',  user: 'root',  password: '******',  database: 'diancan',});

module.exports = pool;

const express = require('express');const router = express.Router();const pool = require('./database');

function fetchMenuItems(parentId = null) {    console.log('parentid', parentId)    return new Promise((resolve, reject) => {        if (parentId == null) {            pool.query('SELECT * FROM menu WHERE parent_id is null ', [parentId], (error, results) => {                if (error) {                    reject(error);                } else {                    resolve(results);                }            });        } else {            pool.query('SELECT * FROM menu WHERE parent_id = ?', [parentId], (error, results) => {                if (error) {                    reject(error);                } else {                    resolve(results);                }            });        }

    });}

async function buildMenuTree(parentId = null) {    const menuItems = await fetchMenuItems(parentId);    console.log('menuItems', menuItems)    const menuTree = [];    for (const item of menuItems) {        const children = await buildMenuTree(item.id);        const menuItem = {            id: item.id,            path: item.path,            name: item.name,            component: item.component,            redirect: item.redirect,            title: item.title,            icon: item.icon,        };        if (children.length > 0) {            menuItem.children = children;        }        menuTree.push(menuItem);    }    console.log("menuTree", menuTree)    return menuTree;}



router.get('/', async (req, res) => {    try {        const menuTree = await buildMenuTree();        res.json({code:0,data:{list:menuTree}});    } catch (error) {        console.error('Database query error:', error);        res.status(500).json({ error: 'Internal server error' });    }});

module.exports = router;

const express = require('express');const app = express();const cors = require('cors');const menuROuter = require('./menu')// 定义路由app.get('/', (req, res) => {  res.send('Hello, World!');});app.use(cors({  origin: 'http://localhost:3002',  credentials: true}));app.use('/api/get-menu-list',menuROuter);// 启动服务器app.listen(3000, () => {  console.log('Server is running on port 3000');});