You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
33 lines
746 B
33 lines
746 B
// server.js
|
|
const express = require('express');
|
|
const mysql = require('mysql2/promise');
|
|
const cors = require('cors');
|
|
const multer = require('multer');
|
|
const xlsx = require('xlsx');
|
|
const app = express();
|
|
|
|
// 数据库配置
|
|
const dbConfig = {
|
|
host: 'your_host',
|
|
user: 'your_user',
|
|
password: 'your_password',
|
|
database: 'attendance_system'
|
|
};
|
|
|
|
// 中间件
|
|
app.use(cors());
|
|
app.use(express.json());
|
|
const upload = multer({ dest: 'uploads/' }); // 用于处理Excel上传
|
|
|
|
// 连接数据库
|
|
let db;
|
|
async function connectDB() {
|
|
db = await mysql.createConnection(dbConfig);
|
|
console.log('数据库连接成功');
|
|
}
|
|
connectDB();
|
|
|
|
// 启动服务
|
|
app.listen(3000, () => {
|
|
console.log('后端服务运行在 http://localhost:3000');
|
|
}); |