基于tornado mysql简易制作一个超市购物系统

最新推荐文章于 2021-08-19 22:52:03 发布

艾伦·麦席森·图灵

最新推荐文章于 2021-08-19 22:52:03 发布

阅读量402

点赞数

文章标签： mysql python

本文链接：https://blog.csdn.net/yq5201314520/article/details/104738096

版权

本文档介绍了如何使用Tornado框架和MySQL数据库创建一个简单的超市购物系统。内容涵盖从数据库设计、Excel数据导入，到前端登录界面、主界面的实现，以及登录验证和商品选择功能的详细步骤。购物系统的功能包括用户登录、商品选择和购买记录的存储。

摘要由CSDN通过智能技术生成

（1）前端《--------》后端《-----------》数据库

（1.1）数据库：

（1.2）将excel数据写入MySQL当中：

import xlrd
import pymysql
conn = pymysql.connect(host='localhost',user='root',password='123',charset='utf8')
cursor = conn.cursor()
sql_one = 'use user_management;'
cursor.execute(sql_one)
conn.commit()
"""
将xlrd数据传入MySQL当中
注意中文字：---》alter table 表名 convert to character set utf8mb4;
"""
data = xlrd.open_workbook(r'super.xlsx')
table = data.sheets()[0]
ncols = table.ncols#行
nrows = table.nrows#列
ac = []#姓名
for x in  range(ncols):
    ac.append(table.cell_value(0,x))
for y in range(1,nrows):
    #print(table.cell_value(y,0))
    sql = 'insert into super (name,subject,number,price,lunch_date) values (%s,%s,%s,%s,%s);'
    cursor.execute(sql, (table.cell_value(y,0),table.cell_value(y,1),table.cell_value(y,2),table.cell_value(y,3),table.cell_value(y,4)))
    conn.commit()

(1,3)后台

import time
import tornado.httpserver
import tornado.ioloop
import tornado.options
import tornado.web

from tornado import gen
from setting import settings
from tornado.options import define, options
import os.path


import pymysql
conn = pymysql.connect(host='localhost',user='root',password = '123',charset='utf8')
cursor = conn.cursor()
sql = 'use user_management;'
cursor.execute(sql)
conn.commit()
define('port', default=8000, help='run port', type=int)#端口定义
sql_two = 'select * from super;'
cursor.execute(sql_two)
conn.commit()
ac_one = cursor.fetchall()
ac = []
for x in ac_one:
    ac.append(list(x))
    """
    return ac from mysql for using 
        """
mysql_all = ac
i = 0
class AuthError(Exception):  # 自定义异常，返回相应结果
    def __init__(self, msg):
        super(AuthError, self).__init__(msg)
class LoginHandler(tornado.web.RequestHandler):#登录界面
    def get(self):#当点击这个页面时
        self.render('login.html',username= 'welcome')
    def post(self):
        username = self.get_argument('username','')
        password = self.get_argument('password','')
        sql_one = 'select * from user;'
        cursor.execute(sql_one)
        conn.commit()
        ab  =  cursor.fetchall()
        ac  =  []
        for x in ab:
            ac.append(list(x))
        sql_third = 'select name,number from count;'
        cursor.execute(sql_third)
        conn.commit()
        ac_two = []
        for x in cursor.fetchall():
            ac_two.append(list(x))
        if username and password:
            for x in ac:
                if username in x and password in x:
                    mysql_all_sub = []  # 科目
                    mysql_all_name = []  # 名字
                    mysql_all_price = []  # 价格
                    mysql_name = []
                    for x in mysql_all:
                        mysql_all_name.append(x[0])
                        mysql_all_sub.append(x[1])
                        mysql_all_price.append(x[3])
                        mysql_name.append(x[5])
                    mysql_all_name_len = len(mysql_all_name)  # 总共数量
                    #print(list(set(mysql_all_sub)))
                    #print(mysql_all_price)
                    #print(mysql_all_name)
                    ac_third = []
                    cursor.execute('select * from count;')
                    conn.commit()
                    for x in cursor.fetchall():
                        ac_third.append(list(x))
                    for x in range(mysql_all_name_len - len(ac_third)):
                        ac_third.append("")