Flask Mysql Connect

[TOC]

---

# Flask Mysql

> 要求

- 支持多用户
- 修改用户名密码也比较方便，无需改变密码

---

### mysql connect

```python
import tool_db
from flask import request
from flask import redirect

# mysql connect
@user.route('/login', methods = ['get', 'post'])
def login():
    username = request.form.get('username')
    password = request.form.get('password')
    sql = "select * from user where username = %s and password = %s"
    result = tool_db.selectByParameters(sql, ( username, password ))
    if result:
        session['username'] = username
        return redirect('/servers/index')
    else:
        return redirect("/static/login.html")
```
---

### login

login

![](/media/202112/2021-12-21_082617_861879.png)
---

mysql

![](/media/202112/2021-12-21_082631_076059.png)

---

result

![](/media/202112/2021-12-21_082637_690833.png)

---

## MD5

> mysql

```mysql
insert into user (username,password) values ('tester', md5('tester'));
insert into user (username,password) values ('bobby', md5('bobby'));
```

> tool_pass.py

```python
import hashlib
def md5encrypt( str ):
    hl = hashlib.md5()
    hl.update( str.encode(encoding='utf-8') )
    return hl.hexdigest()
```
> login

```python
import tool_pass
def login():
	username = request.form.get('username')
	password = request.form.get('password')
	password = tool_pass.md5encrypt(password)
	sql = "select * from user where username = %s and password = %s"
```

---

done