nodejs创建网络连接、数据库连接以及get/post请求的接收

1.创建网络连接

const http = require('http')
const server = http.createServer((req,res) => {
    // ...
    res.end()
})
res.listen(8080,() => {})

2.数据库连接

npm install mysql -S

const mysql = require('mysql')
let username = 'xxx'
const connection = mysql.createConnection({
    host:
    user:
    password:
    database:
    port:
})

connection.connect()

connection.query("select * from tablename where username=?",[username],(err,results,fields) => {
    console.log(results[0].username)
})

connection.end()

3.get请求的接收

const http = require('http')
const url = require('url')
const server = http.createServer((req,res) => {
    const reqUrl = req.url
    // 使用url模块解析URL
    const parseUrl = url.parse(reqUrl,true)
    // 解析后的URL对象包含query属性，其中包含了查询参数
    const queryParams = parseUrl.query
    // 输出查询参数  
    console.log('查询参数:', queryParams);  
  
    // 设置响应头内容类型为JSON  
    res.setHeader('Content-Type', 'application/json');  

    // 将查询参数作为JSON响应发送回客户端  
    res.end(JSON.stringify(queryParams));
    
})
res.listen(8080,() => {})

4.post请求的接收

const http = require('http')
const querstring = require('querystring')

const server = http.createServer((req,res) => {
    let reqtext = ''
    let reqobj = null
    req.on('data',chuck => {
        reqtext += chuck
    })
    req.on('end',() => {
        reqobj = querystring.parse(querystring)
    })
    
    res.end()
})
res.listen(8080,() => {})

欢迎指正！