Node http和express和mysql
const http = require("http");
const express = require("express");
const mysql = require("mysql");
var pool = mysql.createPool({
host:'127.0.0.1',
user:'root',
password:'',
database:'jd',
connectionLimit:5
});
var app = express();
var server = http.createServer(app);
server.listen(80);
app.get("/",(req,res)=>{
res.sendFile(__dirname+"/public/users.html");
});
app.get("/jquery",(req,res)=>{
res.sendFile(__dirname+"/public/jquery-1.11.3.js");
});
app.get("/list.do",(req,res)=>{
pool.getConnection((err,conn)=>{
conn.query("select * from jd_user",(err,result)=>{
res.json(result);
});
});
});
app.get("/add",(req,res)=>{
res.sendFile(__dirname+"/public/user_add.html");
});
app.get("/add.do",(req,res)=>{
var u = req.query.uname;
var p = req.query.upwd;
pool.getConnection((err,conn)=>{
conn.query("insert into jd_user values(null,?,?)",[u,p],(err,result)=>{
res.json(result);
});
});
});
相关文章
- Error connecting to database [Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)]
- node+express+mysql 实现登陆注册
- 【MySQL】常见的mysql 进程state
- linux - mysql 异常:Ignoring query to other database
- Mysql: 强制走索引:mysql between 日期索引 索引问题-日期索引使用
- MySQL给一个字段递增赋值
- MySQL高可用性之Keepalived+Mysql(双主热备)
- 使用mysql-connector-python操作MYSQL数据库
- mysql索引
- [Node.js] Add node.js command line to global
- mysql 必知必会整理—数据插入和更新还有删除[十]
- 连接Mysql提示Can’t connect to local MySQL server through socket的解决方法
- MySql中json类型的使用___mybatis存取mysql中的json
- MySQL 是如何实现四大隔离级别的?
- MySQL等关系型数据库概述
- MySQL数据库加密和解密~认证登陆密码(mysql.user)和MySQL不区分大小写
- Mysql连接报错:1130-host ... is not allowed to connect to this MySql server如何处理
- mysql学习之二:mysql基本使用方法
- 【MySQL笔记】mysql来源安装/配置步骤和支持中国gbk/gb2312编码配置
- mysql select into outfile默认文件保存路径是C:ProgramDataMySQLMySQL Server 8.0Data
- Linux MySQl 5.7.17 MySQL ERROR 1366(HY000):Incorrect string value 解决方法
- Node.js(二)node 核心模块 fs、HTTP模块、express框架
- MySQL数据库篇之mysql的快速启动和停止