django之数据库mysql操作2

mysql已安装

https://blog.csdn.net/weixin_45305977/article/details/118999218

settings.py配置

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME':  'd1',
        'USER': 'u1',
        'PASSWORD': '123456',
        'HOST': 'localhost',
        'PORT': '3306',

    }
}

在app 的west配置models.py

配置表student

class Student(models.Model):

   name = models.CharField(max_length=30, primary_key=True)  # 设置为主键

   id_class = models.CharField(max_length=30)

   def __str__(self):
            return self.__doc__ + ":name->" + self.name

数据迁移

注意在迁移前要确保app应用在settings.py中已配置

makemigrations west
migrate west

migrations目录下生成迁移文件

Navicat查看数据库
出现了项目名_class类名表

操作west_student表

填数据

insert into student values(‘小明’,‘2021010208’)

在settings同级新建testdb.py

from django.http import  HttpResponse
from west.models import Student

def student(request):
    student1=Student(name='小明',id_class='2021010208')
    student1.save()
    return HttpResponse('<p>west_student表添加数据</p>')

配置settings同级urls.py文件（路径）

from django.contrib import admin
from django.urls import path
from django.conf.urls import  url
from .  import  testdb
urlpatterns = [
    path('admin/', admin.site.urls),
    url('^student$',testdb.student),
]

执行

runserver 8001(端口默认8000）

http://127.0.0.1:8001/student

查看west_student表

数据填入成功

查表

select * from student

testdb.py添加

def search(request):
    re=Student.objects.all().values('name','id_class')
    result=""

    for i in re:
        result+=str(i)
    return HttpResponse('<p>查询出：%s</p>' % result)

urls.py添加

url('^search$', testdb.search),

效果

http://127.0.0.1:8001/search