Web框架开发-web框架

1

2

3

4

5

6

7

8

9

10

11

12

13

from wsgiref.simple_server import make_server

def application(environ, start_response):

    start_response('200 OK', [('Content-Type', 'text/html')])

    return [b'<h1>Hello, Web!h1>']

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

import pymysql

# 连接数据库

conn = pymysql.connect(host='IP', port=3306, user='root', passwd='123', db='blog') #db：库名

#创建游标

cur = conn.cursor()

# sql='''

# create table userinfo(

#         id int primary key,

#         name varchar(32),

#         password varchar(32)

#         )'''

# cur.execute(sql)

# sql = "insert into userinfo values (%s,%s,%s)"

# var = [(1, 'mike', 123), (2, 'tom', 123)]

# cur.executemany(sql, var)

sql = ("select * from userinfo where name='mike'")

cur.execute(sql)

# 提交

conn.commit()

# 关闭指针对象

cur.close()

# 关闭连接对象

conn.close()

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

from wsgiref.simple_server import make_server

from urls import URLpattern

def applications(environ, start_response):

    # 当前请求路径

    path = environ.get("PATH_INFO")

    print(path)

    start_response('200 OK', [('Content-Type', 'text/html'), ("Charset", "utf8")])

    func = None

    for item in URLpattern:

        if path == item[0]:

            func = item[1]

            break

    if func:

        return [func(environ)]

    else:

        return [b"<h1>404!<h1>"]

if __name__ == '__main__':

    server = make_server("127.0.0.1", 8889, applications)

    print("服务器开始启动")

    server.serve_forever()

1

2

3

4

URLpattern = (

    ("/login", login),

    ("/favicon.ico", fav),

)

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

import datetime

import pymysql

from urllib.parse import parse_qs

def login(environ):

    with open("templates/login.html", "rb") as f:

        data = f.read()

    return data

def index(environ):

    with open("templates/index.html", "rb") as f:

        data = f.read()

    return data

def fav(environ):

    with open("templates/favicon.ico", "rb") as f:

        data = f.read()

    return data

def reg(environ):

    with open("templates/reg.html", "rb") as f:

        data = f.read()

    return data

def timer(environ):

    now = datetime.datetime.now().strftime("%y-%m-%d %x")

    return now.encode("utf8")

def auth(request):

    try:

        request_body_size = int(request.get('CONTENT_LENGTH', 0))

    except (ValueError):

        request_body_size = 0

    request_body = request['wsgi.input'].read(request_body_size)

    data = parse_qs(request_body)

    user = data.get(b"user")[0].decode("utf-8")

    pwd = data.get(b"pwd")[0].decode("utf-8")

    # 连接数据库

    conn = pymysql.connect(host='10.1.2.71', port=3306, user='root', passwd='testjfz', db='blog')

    # 创建游标

    cur = conn.cursor()

    SQL="select * from userinfo where name='%s' and password='%s'" %(user,pwd)

    cur.execute(SQL)

    if cur.fetchone():

        f = open("templates/backend.html", "rb")

        data = f.read()

        data = data.decode("utf8")

        return data.encode("utf8")

    else:

        print("OK456")

        return b"user or pwd is wrong"

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

DOCTYPE html>

1

2

3

4

5

6

7

8

9

10

11

DOCTYPE html>