var express = require('express');
var router = express.Router();
var path = require('path');
var app = express();
var data = require('../mysql/mysql');




/*以下是页面*/

router.get('/',function(req,res){
    res.render('index',{
		titles:'登录'
	});
});


router.get('/about',function(req,res){
    res.render('about',{titles:'关于'});
});




router.post('/logininfo',function(req,res){ //请求 响应

   data.query("SELECT liuyan_username,liuyan_userpass FROM nodejs_user WHERE liuyan_username='"+req.body.username+"' AND liuyan_userpass='"+req.body.pass+"' LIMIT 0,1",function(err, rows, fields){
                        if( typeof rows[0]=='undefined' ){
							res.render('logininfo',{
								titles:'登录信息',
								user:'2',
								pass:'2'
							});
						}else{
							if(req.body.username==rows[0].liuyan_username && req.body.pass==rows[0].liuyan_userpass){
								res.render('logininfo',{
									titles:'登录信息',
									user:rows[0].liuyan_username,
									pass:rows[0].liuyan_userpass
								});	
							}
						}			
   });

});

/*以上是页面*/





/* GET home page. */
//router.get('/', function(req, res, next) {
//  
//	res.render('index', { 
//		title: '登录'
//	});
//
//});
//
//
//router.post('/logininfo',function(req, res, next){
//  res.render('logininfo');	  
//  res.send('11');
	
//	
//	
//	

	//      
//   if(  !!(req.body.username) && !!(req.body.pass) ){  //注册代码
//     data.query("INSERT INTO nodejs_user(liuyan_username,liuyan_userpass) VALUES ('"+req.body.username+"','"+req.body.pass+"')");
//   }
  // data.query("SELECT liuyan_username,liuyan_userpass FROM nodejs_user WHERE liuyan_username='"+req.body.username+"' AND liuyan_userpass='"+req.body.pass+"' LIMIT 0,1",function(err, rows, fields){
//        
//		   
//		   console.log('步骤44444');
//		    if(typeof rows=='object'){
//				console.log('步骤5555555');
//			    user.username=rows[0].liuyan_username;
//				user.pass=rows[0].liuyan_userpass;
//				
//			}else{
//				console.log('步骤666666');
//			    res.redirect("/"); //页面跳转
//			    
//			}
//			
//   });
//
//   data.query('SELECT * FROM nodejs_user',function(err, rows, fields){
//	   if(err){
//		   res.redirect('/');
//	   }
//	   res.render('logininfo',{
//		  title: '登录信息',
//		  username:rows[0].liuyan_username,
//		  pass:rows[0].liuyan_userpass,
//		  allusername:rows.length,  //数据有多少条
//          eachname:function(i){     //遍历用户名
//			  return rows[i].liuyan_username;
//		  }
//	   });    
//   });
   

//});




module.exports = router;