一站式做网站开发,二级网站怎么做,seo服务公司深圳,源码网站模板Nodejs Web应用基础演示实例
Web数据库应用
一、服务器端
var express require(express);
var app express();
var mysql require(mysql);//设置静态资源目录public
app.use(express.static(__dirname /public));//创建mysql数据库访问连接（数据库主机地址&a…
Nodejs Web应用基础演示实例
Web数据库应用
一、服务器端
var express =require('express');var app =express();var mysql =require('mysql');//设置静态资源目录public
app.use(express.static(__dirname +'/public'));//创建mysql数据库访问连接（数据库主机地址，用户名和密码，数据库名称根据情况自行修改）var connection = mysql.createConnection({host:'localhost',user:'root',password:'123456',database:'test'});connection.connect();//允许跨域访问，可以从不同主机进行调用
app.all('*',function(req, res, next){res.header('Access-Control-Allow-Origin','*');res.header('Access-Control-Allow-Headers','Accept,Content-Type,Content-Length, Authorization,X-Requested-With ');res.header('Access-Control-Allow-Methods','POST,GET,PUT,DELETE,OPTIONS');if('OPTIONS'== req.method){res.send(200);//让options请求快速返回}else{next();}});//查询全部记录的API
app.get('/all',function(req, res){connection.query('SELECT * from stu',function(error, results, fields){//var list = '';if(error)throw error;//console.log('The solution is: ', results);//list = JSON.stringify(results);//res.send(list);res.send(results);});});//按用户名进行查询的API//前端发来的用户请求应该为“主机名:端口号/list?username=*** ”
app.get('/list',function(req, res){var username=req.query.username;connection.query('SELECT * from stu where username= "'+username+'"',function(error, results, fields){//var list = '';if(error)throw error;//console.log('The solution is: ', results);//list = JSON.stringify(results);//res.send(list);res.send(results);});});//用户注册API//前端发来的请求应该为“主机名:端口号/add?username=***&pwd=***&name=***&age=*** ”
app.get('/add',function(req, res){var username=req.query.username.trim();var pwd=req.query.pwd;var name=req.query.name;var age=parseInt(req.query.age);if(username==''){res.send({success:0,insertid:0,msg:'用户名不能为空'});return;}//查询是否存在同名用户connection.query('SELECT * from stu where username= "'+username+'"',function(error, results, fields){//查询出错则返回if(error){console.log('[QUERY ERROR] - ',err.message);res.send({success:0,insertid:0,msg:'操作异常'});return;}//if(results.length==0){var addSql='INSERT INTO stu(username,password,name,age) VALUES(?,?,?,?)';var addSqlParams =[username, pwd, name, age];connection.query(addSql,addSqlParams,function(err, result){if(err){console.log('[INSERT ERROR] - ',err.message);res.send({success:0,insertid:0,msg:'操作异常'});return;} console.log('--------------------------INSERT----------------------------');console.log('INSERT ID:',result.insertId); console.log('-----------------------------------------------------------------\n\n'); res.send({success:1,insertid:result.insertId,msg:'操作成功'});});}else{res.send({success:0,insertid:0,msg:'用户名已存在，请重新注册！'});}});});var server = app.listen(8080,'localhost',function(){var host = server.address().address;var port = server.address().port;console.log("应用实例，访问地址为 http://%s:%s", host, port);})
