1.MySql服务
1.安装依赖
在终端执行如下脚本:
npm install mysql2
npm install cors
npm install express
2.连接数据库并创建获取数据Api
js文件:index.js
const express = require('express');
const mysql = require('mysql2');
const cors = require('cors');
const app = express();
const port = 3000;
// 允许跨域请求
app.use(cors());
// 创建MySQL连接
const connection = mysql.createConnection({
host: '127.0.0.1', // 远程数据库地址
user: 'sa',
password: '123',
database: 'mydatabase'
});
// 连接数据库
connection.connect(err => {
if (err) {
console.error('Database connection failed: ' + err.stack);
return;
}
console.log('Connected to database.');
});
// 创建API端点
app.get('/api/data', (req, res) => {
const query = 'SELECT * FROM userdata';
connection.query(query, (err, results) => {
if (err) {
res.status(500).send('Error querying database');
}
else {
res.json(results);
}
});
});
// 启动服务器
app.listen(port, () => {
console.log(`Server running on http://localhost:${port}`);
});
3.启动服务
终端执行脚本:
node .\index.js
2.客户端访问
1.安装依赖
在终端执行如下脚本:
npm install axios
2.访问MySql服务并获取数据
import axios from 'axios';
const apiClient = axios.create({
baseURL: 'http://localhost:3000/api', // 设置后端API的地址
headers: {
'Content-Type': 'application/json',
},
});
export default {
getData() {
return apiClient.get('/data');
},
};
标签:Node,npm,axios,const,err,express,js,MySql
From: https://www.cnblogs.com/zp1207/p/18491763