django连接mysql指定用户_Django实例(3)-用户连数据库登入系统

fromdjango.shortcuts importrender,HttpResponse,redirect

fromapp01 importmodels

deform(reqbuest):

# 创建表# models.UserInfo.objects.create(username='root',password='123')# dic={'username':'eric','password':'666666'}# models.UserInfo.objects.create(**dic)# obj=models.UserInfo(username='root1',password='123456')# obj.save()# 查询表# result= models.UserInfo.objects.all()# result,QuerySet =>Django=>[]#[obj(id,username,password),obj(id,username,password),obj(id,username,password)]# result = models.UserInfo.objects.filter(username='root',password='123')# for row in result:#     print(row.id,row.username,row.password)#删除# models.UserInfo.objects.filter(id='2').delete()# 更改models.UserInfo.objects.filter(id='3').update(password='666666')

returnHttpResponse('orm')

deflogin(request):

ifrequest.method=="GET":

returnrender(request,'login.html')

elifrequest.method=="POST":

# 数据库中执行 select * from user where username='x' and password='x'u=request.POST.get('user')

p=request.POST.get('pwd')

obj= models.UserInfo.objects.filter(username=u,password=p).first()

# count = models.UserInfo.objects.filter(username=u, password=p).count()ifobj:

returnredirect('/cmdb/index/')

else:

returnrender(request,'login.html')

else:

returnredirect('/index/')

defindex(request):

returnrender(request,'index.html')

defuser_info(request):

ifrequest.method=="GET":

user_list= models.UserInfo.objects.all()

# print(user_list.query)# QuerySet [obj,obj]returnrender(request,'user_info.html',{'User_List':user_list})

elifrequest.method=="POST":

u=request.POST.get('user')

p=request.POST.get('pwd')

models.UserInfo.objects.create(username=u,password=p)

returnredirect('/cmdb/user_info/')

defuser_detail(request,nid):

obj=models.UserInfo.objects.filter(id=nid).first()

# models.UserInfo.objects.get(id=nid) 如果没有数据会报错returnrender(request,'user_detail.html',{'OBJ':obj})

defuser_del(request,nid):

models.UserInfo.objects.filter(id=nid).delete()

returnredirect('/cmdb/user_info/')

defuser_edit(request,nid):

ifrequest.method=="GET":

obj=models.UserInfo.objects.filter(id=nid).first()

returnrender(request,'user_edit.html',{'OBJ':obj})

elifrequest.method=="POST":

nid=request.POST.get('id')

u=request.POST.get('username')

p=request.POST.get('password')

models.UserInfo.objects.filter(id=nid).update(username=u,password=p)

returnredirect('/cmdb/user_info/')