Python3 + Django2 绑定实体生成数据脚本(MySQL)

第一步：创建项目（sutdentsite）

django-admin startproject sutdentsite

第二步：创建应用（student）

python manage.py startapp student

第三步: 在项目(sutdentsite)的settings.py中设置区时和语言版本：

LANGUAGE_CODE = 'zh-hans' 
 
TIME_ZONE = 'Asia/Shanghai' 
 
USE_I18N = True 
 
USE_L10N = True 
 
USE_TZ = True

第四步：在项目(sutdentsite)的settings.py中INSTALLED_APPS里添加应用(student)：

INSTALLED_APPS = [ 
    'django.contrib.admin', 
    'django.contrib.auth', 
    'django.contrib.contenttypes', 
    'django.contrib.sessions', 
    'django.contrib.messages', 
    'django.contrib.staticfiles', 
    'student', 
]

配置数据库连接

1、项目(sutdentsite)的settings.py文件中修改DATABASES：

DATABASES = { 
    'default': { 
        'ENGINE': 'django.db.backends.mysql', 
        'NAME': 'student', 
        'USER': 'root', 
        'PASSWORD': '123456', 
        'HOST': '127.0.0.1', 
        'PORT': '3306', 
        'OPTIONS': {'charset': 'utf8mb4'}, 
    } 
} 

2、应用（student）创建urls.py 文件

from django.conf.urls import url 
from . import views 
 
urlpatterns = [ 
] 

3、在应用(student)中创建models.py 实体对象：

from django.db import models 
 
# Create your models here. 
 
 
class UserInfo(models.Model): 
    username = models.CharField(max_length=50) 
    password = models.CharField(max_length=50) 
    address = models.CharField(max_length=200) 
    email = models.EmailField() 
    create_date = models.DateField() 
    age = models.CharField(max_length=20) 
    sex = models.CharField(max_length=20) 
 
 
class User(models.Model): 
    user_name = models.CharField(max_length=20) 
    user_password = models.CharField(max_length=20) 
    user_email = models.EmailField() 
    user_address = models.CharField(max_length=500) 
    user_cards = models.CharField(max_length=20) 
    user_numbers = models.CharField(max_length=20) 

4、基于models.py 实体对象定义，创建数据库脚本：

python manage.py makemigrations

python manage.py migrate

5、执行效果：