|
- //引入包
- const express = require("express");
- // 引入pool.js包
- const pool = require('../pool');
-
- // 创建路由器对象
- const router = express.Router();
-
- // 测试接口
- router.get("/test", (req, res) => {
- console.log("接收成功~");
- res.send("接口测试~");
- });
-
- // 练习:在页面中点击按钮可以将响应信息添加到div中
- // get /mytest
- router.get("/mytest", (req, res) => {
- console.log("success~")
- res.send("哈哈哈")
- });
-
- // 原生http的get登录,访问 http://127.0.0.1:8080/ajax/http_login?uname=lisi
- router.get("/http_login", (req, res) => {
- var $uname = req.query.uname;
- if (!$uname) {
- res.send('用户名不存在~');
- return;
- } else {
- res.send($uname);
- }
- });
-
- // 登录, 连接数据库, 访问http://127.0.0.1:8080/ajax/mylogin?uname=lisi&upwd=123456
- router.get("/mylogin", (req, res) => {
- var $uname = req.query.uname;
- var $upwd = req.query.upwd;
- // 如果用户名和密码为空,响应-1
- if (!$uname || !$upwd) {
- res.send("-1");
- return;
- }
- // 操作数据库
- var sql = "select * from xz_user where uname=? and upwd=?";
- pool.query(sql, [$uname, $upwd], (err, result) => {
- if (err) throw err;
- console.log(result);
- // 查询到数据,响应1
- if (result.length > 0) {
- res.send("1");
- } else {
- //查不到数据,响应0
- res.send("0");
- }
- })
- });
-
- // restful get登录, 连接数据库, 访问http://127.0.0.1:8080/ajax/restful_login/lisi&123456
- router.get("/restful_login/:uname&:upwd", (req, res) => {
- var $uname = req.params.uname;
- var $upwd = req.params.upwd;
- // restful要求在前台做非空验证
- // 操作数据库
- var sql = "select * from xz_user where uname=? and upwd=?";
- pool.query(sql, [$uname, $upwd], (err, result) => {
- if (err) throw err;
- console.log(result);
- // 查询到数据,响应1
- if (result.length > 0) {
- res.send("1");
- } else {
- //查不到数据,响应0
- res.send("0");
- }
- })
- });
- // restful 查询用户, 连接数据库, 访问http://127.0.0.1:8080/ajax/userlist
- router.get("/userlist", (req, res) => {
- var sql = "select * from xz_user";
- pool.query(sql, (err, result) => {
- if (err) throw err;
- // 响应查询结果
- res.send(result);
- })
- });
- //restful 根据id删除用户 delete不能在地址栏验证 访问 http://127.0.0.1:8080/08_restful_del.html
- router.delete("/restful_del/:uid", (req, res) => {
- var $uid = req.params.uid;
-
- var sql = "delete from xz_user where uid=?";
- pool.query(sql, [$uid], (err, result) => {
- console.log(result);
- if (err) throw err;
- if (result.affectedRows > 0) {
- res.send("1");
- } else {
- res.send("0");
- }
- })
- });
- // post登录,前台要传递请求主体 访问 http://127.0.0.1:8080/09_post_login.html
- router.post("/post_login", (req, res) => {
- var $uname = req.body.uname;
- var $upwd = req.body.upwd;
- if (!$uname || !$upwd) {
- res.send("-1");
- return;
- }
- var sql = "select * from xz_user where uname = ? and upwd = ?";
- pool.query(sql, [$uname, $upwd], (err, result) => {
- if (err) throw err;
- //查询到数据,响应1
- if (result.length > 0) {
- res.send("1");
- } else {
- res.send("0");
- }
- })
- });
-
- // restful post 注册 访问 http://127.0.0.1:8080/10_post_reg.html
- router.post("/post_reg", (req, res) => {
- var $uname = req.body.uname;
- var $upwd = req.body.upwd;
- var $email = req.body.email;
- var $phone = req.body.phone;
- var $user_name = req.body.user_name;
- var $gender = req.body.gender;
- //?要与实际字段顺序一致
- var sql = "insert into xz_user values(null,?,?,?,?,null,?,?)";
-
- pool.query(sql, [$uname, $upwd, $email, $phone, $user_name, $gender], (err, result) => {
- if (err) throw err;
- res.send("1");
- })
- });
-
- //resyful post修改 根据uid修改性别gender 访问 http://127.0.0.1:8080/11_restful_update.html
- router.post("/update", (req, res) => {
- var $uid = req.body.uid;
- var $gender = req.body.gender;
- //update 操作
- var sql = "update xz_user set gender=? where uid=?";
- //[]参数和?顺序一致
- pool.query(sql, [$gender, $uid], (err, result) => {
- if (err) throw err;
- res.send("1");
- })
- });
-
-
- //获取用户 xz_user json方式解析 连接数据库 访问 http://127.0.0.1:8080/ajax/userlist_get
- router.get("/userlist_get", (req, res) => {
- var sql = "select * from xz_user ";
- pool.query(sql, (err, result) => {
- if (err) throw err;
- res.send(result);
- })
- })
-
- // 导出路由器对象
- module.exports = router;
|