MySQL数据库之django+mysql用户登录系统，遇到问题及解决-职坐标

MySQL数据库之django+mysql用户登录系统，遇到问题及解决

小标 2018-09-12 来源：阅读 2190 评论 0

摘要：本文主要向大家介绍了MySQL数据库之django+mysql用户登录系统，遇到问题及解决，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。

本文主要向大家介绍了MySQL数据库之django+mysql用户登录系统，遇到问题及解决，通过具体的内容向大家展现，希望对大家学习MySQL数据库有所帮助。

添加：

ProgrammingError: (1146, "Table ‘test.app_name_testmodel‘ doesn‘t exist")    解决：

1. 创建更改的文件python manage.py makemigrations

2. 将生成的py文件应用到数据库 python manage.py migrate
django  __init__() takes exactly 1 argument (2 given)   有两个参数值调到一个  未解决

django常用命令：

1. 新建一个 django project：django-admin.py startproject project_name

2. 新建 app：python manage.py startapp app_name

3. 创建数据库表或更改数据库表或字段：python manage.py makemigrations

python manage.py migrate

4. 使用开发服务器：python manage.py runserver 0.0.0.0:8000

5. 清空数据库：python manage.py flush
6. 创建超级管理员：python manage.py createsuperuser
修改用户密码：python manage.py changepassword username
7. 导出数据导入数据：
python manage.py dumpdata appname > appname.json
python manage.py loaddata appname.json
8. Django 项目环境终端：python manage.py shell
新建一个django项目技术分享图片

或者亦可:django-admin.py startproject mysqllogin

新建APP:python manage.py startapp app01

app01>models.py

# -*- coding: utf-8 -*-
from __future__ import unicode_literals

from django.db import models

# Create your models here.
class User(models.Model):
    username=models.CharField(max_length=32)
    password=models.CharField(max_length=32)
    def __unicode__(self):
        return self.username

app01>views.py

#coding=utf-8
from django.shortcuts import render,render_to_response
from django.http import HttpResponse,HttpResponseRedirect
from django.template import RequestContext
from django import forms
from models import User

#表单
class UserForm(forms.Form):
    username = forms.CharField(label=‘用户名‘,max_length=100)
    password = forms.CharField(label=‘密码‘,widget=forms.PasswordInput())

#注册
def regist(req):
    if req.method == ‘POST‘:
        uf = UserForm(req.POST)
        if uf.is_valid():
            #获得表单数据
            username = uf.cleaned_data[‘username‘]
            password = uf.cleaned_data[‘password‘]
            #添加到数据库
            User.objects.create(username= username,password=password)
            return HttpResponse(‘regist success!!‘)
    else:
        uf = UserForm()
    return render_to_response(‘regist.html‘,{‘uf‘:uf})

#登陆
def login(req):
    if req.method == ‘POST‘:
        uf = UserForm(req.POST)
        if uf.is_valid():
            #获取表单用户密码
            username = uf.cleaned_data[‘username‘]
            password = uf.cleaned_data[‘password‘]
            #获取的表单数据与数据库进行比较
            user = User.objects.filter(username__exact = username,password__exact = password)
            if user:
                #比较成功，跳转index
                response = HttpResponseRedirect(‘index.html‘)
                #将username写入浏览器cookie,失效时间为3600
                response.set_cookie(‘username‘,username,3600)
                return response
            else:
                #比较失败，还在login
                return HttpResponseRedirect(‘login.html‘)
    else:
        uf = UserForm()
    return render_to_response(‘login.html‘,{‘uf‘:uf})

#登陆成功
def index(req):
    username = req.COOKIES.get(‘username‘,‘‘)
    return render_to_response(‘index.html‘ ,{‘username‘:username})

#退出
def logout(req):
    response = HttpResponse(‘logout !!‘)
    #清理cookie里保存username
    response.delete_cookie(‘username‘)
    return response
mysqllogin>setting.py

from django.conf.urls import url
from django.contrib import admin
from app01 import views
urlpatterns = [
    # url(r‘^admin/‘, admin.site.urls),
    url(r‘^index/‘, views.index),
    url(r‘^login/‘, views.login),
    url(r‘^regist/‘, views.regist),
    url(r‘^logout/‘, views.logout),
    url(r‘^$‘, views.login),
]
templates>index.html

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "//www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="//www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title></title>
</head>

<body>
<h1>welcome {{username}} !</h1>
<br>
<a href="//127.0.0.1:8000/login/">退出</a>
</body>
</html>
templates>login.html

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "//www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="//www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>登陆</title>
</head>

<body>
<h1 style="background-color: aqua">登陆页面：</h1>
<form method = ‘post‘ enctype="multipart/form-data">
    {% csrf_token %}
    {{uf.as_p}}
    <input type="submit" value = "ok" />
</form>
<br>
<a href="//127.0.0.1:8000/regist/">注册</a>
</body>
</html>
templates>regist.html

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "//www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="//www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
    <title>注册</title>
</head>

<body>
<h1>注册页面：</h1>
<form method = ‘post‘ enctype="multipart/form-data">
    {% csrf_token %}
    {{uf.as_p}}
    <input type="submit" value = "ok" />
</form>
<br>
<a href="//127.0.0.1:8000/login/">登陆</a>
</body>
</html>
python manage.py shell

from app01.models import User

查询全部用户:User.objects.all()

新增用户:User.objects.create(username=‘xxx‘,password=‘xxx‘)