快速入手-基于Django的mysql操作（四）

1、数据的增删改查

def add(request):

    UserInfo.objects.create(username="admin", password="1234561", age=18)
    UserInfo.objects.create(username="admin2", password="1234562", age=19)
    UserInfo.objects.create(username="admin3", password="1234563", age=20)
    return HttpResponse("新建成功")


def delete(request):
    UserInfo.objects.filter(username="admin").delete()
    UserInfo.objects.filter(id=2).delete()
    # UserInfo.objects.all().delete()
    UserInfo.objects.create(username="admin10", password="1234510", age=10)
    return HttpResponse("删除成功")


def list(request):
    data_list = UserInfo.objects.all()
    for data in data_list:
        print(data.username, data.password, data.age)
    return HttpResponse("列表查询")


def update(request):
    UserInfo.objects.all().update(password="2025")
    UserInfo.objects.filter(username="admin10").update(age=2030)
    return HttpResponse("更新成功")

 2、urls.py配置

urlpatterns = [
    # path('admin/', admin.site.urls),
    path("index/", views.index),
    path("maker01/list/", views.maker01_list),
    path("home/", views.home),
    path("add/", views.add),
    path("delete/", views.delete),
    path("update/", views.update),
    path("list/", views.list),
]

3、运行测试

python manage.py runserver