简单的django项目

from datetime import datetime import requests from django.shortcuts import render, redirect, reverse from django.views.decorators.csrf import * from . import models from .models import User, Menu import time from .public.MySql_connection import * def index(request): # print("====", reverse("polls:login")) return render(request, "index_front.html") @csrf_exempt def register(request): context = { "msg": "" } if request.method == "GET": return render(request, "err.html") elif request.method == "POST": # 获取前端输入的信息 name = request.POST.get("name") pwd = request.POST.get("pwd") phone = request.POST.get("phone") email = request.POST.get("email") print(name, pwd, phone) # 通过输入的name在数据库中查询是否存在 infoobj = User.objects.filter(phone=phone) if infoobj: context["msg"] = "手机号：{} 已存在".format(phone) return render(request, "register.html", context=context) else: # 若不存在，则插入数据 info = User() info.name = name info.pwd = pwd info.phone = phone info.email = email # 格式化成2016-03-20 11:45:39形式 info.create_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) info.modify_time = time.strftime("%Y-%m-%d %H:%M:%S", time.localtime()) info.save() obj = User.objects.filter(phone=phone) context = {"objects": obj} return redirect("/register_all/") else: return render(request, "err.html", context) # 查询用户信息 def register_all(request): obj = User.objects.all() context = {"objects": obj} return render(request, "register_all.html", context=context) def login(request): # print("====", reverse("polls:login")) return render(request, "login.html") def register_lik(request): return render(request, "register.html") def search(request): return render(request, "search.html") def company(request): context = {'title': "公司title", 'content': "公司的内容"} return render(request, 'company_front.html', context) def school(request): sql = """ SELECT a.id,b.id, a.`name` as Cname,b.`name` Bname FROM userdb.polls_menu AS a JOIN polls_menu AS b ON a.id=b.parent_id; """ cc = ObjRaw(Menu, sql) context = {"obj": cc, 'title': "首页的title", 'content': "首页的内容"} return render(request, 'school_front.html', context) def index2(request): # context = {} query = """ SELECT DISTINCT(a.id), a.`name` as Cname,b.`name` as Bname FROM userdb.polls_menu AS a JOIN polls_menu AS b ON a.id=b.parent_id; """ tt = query_all_dict(query) print(tt) context = {"obj": tt, 'title': "首页的title", 'content': "首页的内容"} return render(request, 'index1.html', context) def register_del(request): pk = request.GET.get("id") print("1111", pk) User.objects.filter(pk=pk).delete() return redirect("/register_all/") def register_edit(request): if request.method == "POST": pk = request.POST.get('id') name = request.POST.get('name') pwd = request.POST.get('pwd') phone = request.POST.get('phone') email = request.POST.get('email') User.objects.filter(pk=pk).update(name=name, pwd=pwd, phone=phone, email=email, modify_time=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())) return redirect("/register_all/") else: pk = request.GET.get('id') obj = User.objects.filter(pk=pk) context = {"context": obj} return render(request, "register_edit.html", context=context) # # @csrf_exempt # def register_add(request): # if request.method == "POST": # pk = request.POST.get('id') # name = request.POST.get('name') # pwd = request.POST.get('pwd') # phone = request.POST.get('phone') # email = request.POST.get('email') # User.objects.filter(pk=pk).update(name=name, pwd=pwd, phone=phone, email=email, # modify_time=time.strftime("%Y-%m-%d %H:%M:%S", time.localtime())) # return redirect("/register_all/") # # context = {"context": "失败"} # return render(request, "register_edit.html", context=context)