使用node实现简单接口

先在项目目录安装mysql和express包

1
2
npm install mysql
npm install express
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
var mysql = require('mysql')
//连接参数
var connection = mysql.createConnection({
    host: 'localhost',
    user: 'root',
    password: '123456',
    database: 'session1',
    port: '3306'

})

//开启连接
connection.connect((err) => {
    if (err) throw err;
    console.log("connected" + connection.threadId)
})



const express = require('express')
const app = express()

//url传入的get形参数会保存在req.query对象中
app.get('/login', (req, res) => {
    //不建议使用拼接的方式连接参数和sql语句，此处为简单示例
    var select = "select * from users where Email = '"+req.query.email+"' and Password = '"+req.query.password+"'"
    connection.query(select, (err, result) => {
        if (err) throw err;
        if(result.length > 0){
            res.send(result)
        }else{
            res.send("doesn't exist")
        }
        
        console.log(select)
    }) 
})

app.get('/getCityNames', (req, res) => {
    var select = "select CityName from city"
    connection.query(select, (err, result) => {
        if (err) throw err;
        res.send(result)
    })
    
})

app.listen(3000, () => console.log("Server running on port 3000"))