记录一下，以备后用
Settings = require '../../settings.js' exports.register = (req, res) -> nick_name = req.body.nick_name
email = req.body.email
password = req.body.password # 配置变量
table_name = 'user_info'
database = Settings.mysql.database # 获取当前时间
dateObj = new Date() year = dateObj.getFullYear()
month = dateObj.getMonth() + 1
day = dateObj.getDate()
hour = dateObj.getHours()
min = dateObj.getMinutes()
sec = dateObj.getSeconds() console.log month.length
date_str = year + '-' + month + '-' + day + ' ' + hour + ':' + min + ':' + sec
#console.log date_str # 选择使用的数据库
mysqldb.query('USE ' + database) # 判断邮箱，进行注册
sql = "select * from " + table_name + " where email = '" + email + "'"
console.log sql
mysqldb.query(sql, (err, data) ->
if (err)
return res.jsonp({"status":-1, "message":"数据库出错"})
else
if (data.length > 0)
return res.jsonp({"status":-2, "message":"邮箱已经存在"})
else
sql = "select * from " + table_name + " where nick_name = '" + nick_name + "'"
mysqldb.query(sql, (err, data) ->
if (data.length > 0)
return res.jsonp({"status":-3, "message":"昵称已存在"})
else
mysqldb.query(
'INSERT INTO ' + table_name + ' SET nick_name = ?, email = ?, ctime = ?, password = ?',
[nick_name, email, date_str, password])
return res.jsonp({"status":0, "message":"注册成功"})
)
) exports.login = (req, res) -> email = req.body.email
password = req.body.password # 配置变量
table_name = 'user_info'
database = Settings.mysql.database # 选择使用的数据库
mysqldb.query('USE ' + database) # 判断邮箱，进行注册
sql = "select * from " + table_name + " where email = '" + email + "'"
console.log sql
mysqldb.query(sql, (err, data) ->
if (err)
return res.jsonp({"status":-1, "message":"数据库出错"})
else
if (data.length == 0)
return res.jsonp({"status":-2, "message":"用户不存在"})
else
if (data[0].password == password)
return res.jsonp({"status":0, "message":"登陆成功"})
else
return res.jsonp({"status":-3, "message":"用户名或密码错误"})
)