1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54
| const express = require('express'); const path = require('path') const app = express(); const mysql = require('mysql')
var bodyParser = require('body-parser')
var bodyParser = require('body-parser') app.use(bodyParser.urlencoded({ extended: false }))
app.use(bodyParser.json())
const conn = mysql.createConnection({ user: 'boLuo', password: '802328', host: '81.70.27.253', database: 'map', timezone:"SYSTEM" }) conn.connect(err => { console.log(err, '连接成功'); })
app.use(express.static(path.join(__dirname, 'public')))
app.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') if (req.method == 'OPTIONS') { res.sendStatus(200); } else { next(); } });
app.get('/findEnterpriseAll', (req, res) => { let sql = `SELECT * FROM enterprise`; conn.query(sql, (err, results) => { res.send(results) }) })
app.get('/', (req, res) => res.send('hello world!'));
app.listen(3000, () => console.log('服务器在3000端口开启........'));
|