实例2：采用Jade模板引擎实现用户注册登录功能.zip

/** * Created by linziyu on 2018/7/3. */ /** * express接收html传递的参数 */ var express=require('express'); var bodyParser = require('body-parser') var app=express(); var mysql=require('mysql'); app.set('view engine', 'jade'); app.set('views', __dirname); app.use(bodyParser.urlencoded({extended: false})) app.use(bodyParser.json()) /** * 配置MySQL */ var connection = mysql.createConnection({ host : '127.0.0.1', user : 'root', password : '123456', database : 'movierecommend', port:'3306' }); connection.connect(); /** * 跳转到网站首页，也就是用户登录页面 */ app.get('/',function (req,res) { res.render('index'); }) /** * 实现登录验证功能 */ app.post('/login',function (req,res) { var name=req.body.username.trim(); var pwd=req.body.pwd.trim(); console.log('username:'+name+'password:'+pwd); var selectSQL = "select * from user where username = '"+name+"' and password = '"+pwd+"'"; connection.query(selectSQL,function (err,rs) { if (err) throw err; console.log(rs); console.log('ok'); res.render('ok',{title:'Welcome User',message:name}); }) }) /** * 跳转到注册页面 */ app.get('/registerpage',function (req,res) { res.render('registerpage',{title:'注册'}); }) /** * 实现注册功能 */ app.post('/register',function (req,res) { var name=req.body.username.trim(); var pwd=req.body.pwd.trim(); var user={username:name,password:pwd}; connection.query('insert into user set ?',user,function (err,rs) { if (err) throw err; console.log('ok'); res.render('ok',{title:'Welcome User',message:name}); }) }) var server=app.listen(3000,function () { console.log("userloginjade server start......"); })