nodejs_100个实例（1）
nodejs_100个实例（1）
0、初始工作：
1.所需模块：
npm install -g cnpm --registry=https://registry.npm.taobao.org
cnpm install express --save
cnpm install mysql
2.数据库:
(1)show databases;
(node_password)
(2)select * from password;
(user1,password1)
一、本文目标：
使用express，做一个简单的登录界面，nodejs+express+mysql
二、源码（1.index.html 2.server.js）
1.登录界面(http://127.0.0.1:8081/indes.html)
1 <html> 2 <body> 3 4 <form action="http://127.0.0.1:8081/process_get" method="GET"> 5 user: <input type="text" name="first_name"> <br> 6 7 pasw: <input type="password" name="last_name"> 8 <br> 9 <input type="submit" value="Submit"> 10 </form> 11 12 </body> 13 </html>
2.服务器源码
1 var express = require('express'); 2 var mysql = require('mysql'); 3 4 var app = express(); 5 6 var response={}; 7 var Result=''; 8 app.use(express.static('public')); 9 10 app.get('/index.html', function (req, res) { 11 res.sendFile( __dirname + "/" + "index.html" ); 12 }) 13 14 app.get('/process_get', function (req, res) { 15 16 // 输出 JSON 格式 17 response = { 18 "first_name":req.query.first_name, 19 "last_name":req.query.last_name 20 }; 21 22 var connection = mysql.createConnection({ 23 host : 'localhost', 24 user : 'root', 25 password : '123456', 26 port: '3306', 27 database: 'node_password', 28 }); 29 30 connection.connect(); 31 32 var sql = 'SELECT * FROM password where name="'+response.first_name+'"&&number='+response.last_name; 33 //查 34 console.log(sql); 35 connection.query(sql,function (err, result) { 36 if(err){ 37 console.log('[SELECT ERROR] - ',err.message); 38 return; 39 } 40 41 console.log('--------------------------SELECT----------------------------'); 42 console.log(result); 43 Result=result; 44 console.log('------------------------------------------------------------\n\n'); 45 }); 46 47 connection.end(); 48 if(Result.length!=0){res.end("success!");} 49 else res.end("fail...."); 50 //res.end(JSON.stringify(response)); 51 }) 52 53 var server = app.listen(8081, function () { 54 55 var host = server.address().address 56 var port = server.address().port 57 58 console.log("应用实例，访问地址为 http://%s:%s", host, port) 59 60 })
