项目实训第二周（3）

sql = "select username, food_name, food_infor, url  from USER_VIEW"
cur.execute(sql)
result = cur.fetchall()  # 读数据库并传到变量result内
con_lenth = len(result)
user_s = list(range(con_lenth))
food_s = list(range(con_lenth))
user = []
food = []
food_infor = []
food_img = []
for i in range(con_lenth):
    user_s[i] = result[i][0]
    food_s[i] = result[i][1]
    if user_s[i] not in user:
        user.append((user_s[i]))
    if food_s[i] not in food:
        food.append(food_s[i])
        food_infor.append(result[i][2])
        food_img.append(result[i][3])
user_lenth=len(user)
food_lenth=len(food)
conn.commit()
conn.close()
return render_template('demo3.html', con_lenth=con_lenth, user_lenth=user_lenth, food_lenth=food_lenth,
                       user_s=user_s, food_s=food_s, user=user, food=food, food_infor=food_infor, food_img=food_img)

 将获取到的数据进行分类存储，得到用户表、食谱表、用户食谱关系表、食物照片以及食物的原料，并将这些数据通过render_template（）函数传递到demo3.html中