用户登录功能实现（web登录、App【vue】登录）

1
2
3
4
@app.route("/")
def login():
    return render_template('login.html')

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
@app.route("/dologin",methods=["post"])
def dologin():
   sch_num= request.form['sch_num']
   password= request.form['password']
   sql="select a.name,a.sch_num,a.password,a.status,b.role_id from viewer a left join user_link b on a.sch_num=b.sch_num where a.sch_num='{}'"
   sql=sql.format(sch_num)
   db = pymysql.connect(hostName, userName, userPassword, dbName)
   _cursor = db.cursor()
   user=None
   try:
      _cursor.execute(sql)
      user = _cursor.fetchone()
   except:
      print('出错啦')
   _cursor.close()
   db.close()

   # 处理数据
   # A、判断用户名是否存在

   if (user == None):
      return render_template('login.html', msg="用户名不存在")

   # B、判断密码是否正确

   if (user[2]!=password):
      return render_template('login.html', msg="密码不正确")

   # C、判断状态是否可用

   if (user[3]!= 1):
      return render_template('login.html', msg="账号已被锁定，请联系管理员")

   # D、登录信息写入session

   session['isLogin'] = 'Y'
   session['userInfo'] = user
   return redirect(url_for("index")) 

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<template>

<div id="page">

<van-nav-bar title="用户登录"/>

<van-cell-group>
    <van-field
      v-model="my.sch_num"
      required
      clearable
	  type="number"
      label="用户名"
      placeholder="请输入用户名"
    />

    <van-field
      v-model="my.password"
	  required
      type="password"
      label="密码"
      placeholder="请输入密码"
/>
</van-cell-group>

<div class="btns">
<van-button class="jumpBtn" type="primary" @click.native="handleClick" size="large">登录</van-button>
</div>

<div class="tabarTop90px"></div>

</div>

</template>

<script>
import {getStore,setStore} from '@/store'        //取、写数据到本地
import axios from 'axios'
import Config from '../config'

import {Button, Field ,Cell, CellGroup, NavBar, Dialog} from 'vant';

export default {
  name: 'Login',
//data接收提交的数据：学号&密码
  data () {
    return {
      isShowx:false,
      my:{sch_num:"",password:""}
    }
  },
//componemts定义组件的名字
  components: {  
	[Field.name]: Field,
	[Cell.name]: Cell,
	[CellGroup.name]: CellGroup,
	[NavBar.name]: NavBar,
	[Button.name]: Button,
	[Dialog.name]: Dialog
  },
//methods对应登录按钮的click事件：判空&登录（记录用户信息、授权token、跳转）（失败）
  methods:{
	  handleClick(){
		  //1判空
		  if(this.my.sch_num==""){
			  Dialog.alert({
				  title:'系统提示',
				  message:'请输入用户名'
			  }).then(()=>{
				  //on close
				})
			  return;
		  }
		  if(this.my.password==""){
			  Dialog.alert({
				  title:'系统提示',
				  message:'请输入密码'
			  }).then(()=>{
				//on close
				})
			return;
		  }
		  //2登录
		  let config = {};
		  //axios.post(Config.baseUrl+'/gsp/api/member/login',this.my, config)  //这是测试
		  axios.post('http://127.0.0.1:5000/doLoginJson' , this.my , config)   //发送请求，传递对象my包含的数据：		  .then(response => {                                       //返回后台函数的结果
		  	console.log(response); 
		  	if (response.data.status == "Y") {
				                         //提示登陆成功
				Dialog.alert({
					title:'系统提示',
					message:'登陆成功'
				}).then(()=>{
					//on close
				  })
				//3、记录用户信息
				setStore({name:'loginInfo',content:this.my})  //将my的信息存到name为loginInf的对象里去，取：getStore.name
				setStore({name:'userInfo',content:response.data.data})  
				//4、授权token(类似网页的session,给登陆的人授权一个序列号)
				
				//5、跳转
				this.$router.push('/lectureList')
				
			}else{                         //提示登陆失败
				Dialog.alert({
					title:'系统提示',
					message:response.data.msg
				}).then(()=>{
					//on close
				  })
			}
		  })
	  }
  },
  created () {
  }
}
</script>

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
@app.route("/doLoginJson",methods=['post'])
def doLoginJson():
   #获取参数
   data = request.get_data()
   json_data = json.loads(data.decode('utf-8'))  #json转化为对象
   sch_num = json_data.get('sch_num')
   password = json_data.get('password')
   sql="select a.name,a.sch_num,a.password,a.status,b.role_id from viewer a left join user_link b on a.sch_num=b.sch_num where a.sch_num='{}'"
   sql=sql.format(sch_num)
   db = pymysql.connect(hostName, userName, userPassword, dbName)
   _cursor = db.cursor()
   user=None
   try:
      print(sql)
      print(sch_num)
      print(password)
      _cursor.execute(sql)
      user = _cursor.fetchone()
      print(user[2])
   except:
      print('出错啦')
   _cursor.close()
   db.close()
   # 处理数据
   # A、判断用户名是否存在
   if (user == None):
      d = { "status":"N","msg":"用户名不存在" }
      return json.dumps(d,ensure_ascii=False)
   # B、判断密码是否正确
   if (user[2]!=password):
      d = { "status": "N", "msg": "密码错误" }
      return json.dumps(d, ensure_ascii=False)
   # C、判断状态是否可用
   if (user[3]!= 1):
      d = { "status": "N", "msg": "账号已被锁定，请联系管理员" }
      return json.dumps(d, ensure_ascii=False)
   # D、登录信息写入session
   d = { "status":"Y","msg": "登陆成功","data":user }
   return json.dumps(d,ensure_ascii=False)