python整合Django简单crud

谁践踏了优雅 2023-07-04 14:19 15阅读 0赞

## 记录下初学Django做的小demo ##

先附上效果图(分页查看所有)  
![分页查看所有][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzg5MzU0_size_16_color_FFFFFF_t_70]

## 开发环境 ##

*  系统 win10
 *  python 3.7
 *  mysql 5.7.20
 *  PyCharm 2019.3.2

## 项目整体结构 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzg5MzU0_size_16_color_FFFFFF_t_70 1]

## 贴出核心代码 ##

/app/views.py

from django.core import serializers
    from django.shortcuts import render, redirect
    from .model.User import User
    from django.core.paginator import Paginator, EmptyPage
    import json
    
    
    def index(request):
        return render(request, "index.html")
    
    
    def to_add(request):
        """ 跳转至添加用户页面 :param request: :return: """
        return render(request, "add.html")
    
    
    def show_all(request):
        """ 显示数据 :param request: :return: """
        page_num = int(request.GET.get("pageNum", default=1))
        page_size = int(request.GET.get("pageSize", default=10))
        page_num = page_num if page_num > 1 else 1
        page_size = page_size if page_size > 1 else 10
        res = { }
        rs = User.objects.all()
    
        ptr = Paginator(rs, page_size)
    
        res['total'] = ptr.count
    
        try:
            masters = ptr.page(page_num)
            res['list'] = json.loads(serializers.serialize("json", masters))
        except EmptyPage:
            res['list'] = { }
    
        res['up'] = page_num - 1
        res['next'] = page_num + 1
        res['total_page'] = int(ptr.count / page_size if ptr.count % page_size == 0 else ptr.count / page_size + 1)
        res['page_size'] = page_size
        res['curr_page'] = page_num
        # 返回json (rest api)
        # return JsonResponse(res)
        return render(request, "showAll.html", { "res_data": res})
    
    
    def add_user(request):
        """ 添加一个新用户 :param request: :return: """
        gender = request.GET.get("gender", default="F")
        age = int(request.GET.get("age", default=18))
        occupation = int(request.GET.get("occupation", default=1))
        zip_code = request.GET.get("zip_code", default="10000")
    
        new_user = User(gender=gender, age=age, occupation=occupation, zip_code=zip_code)
        new_user.save()
        print("添加成功")
        return redirect('/app/showAll/')
    
    
    def to_modify(request):
        """ 跳转至修改页面 :param request: :return: """
        id = int(request.GET.get("id"))
        user = User.objects.get(id=id)
        return render(request, "modify.html", { "res_data": user})
    
    
    def modify_user(request):
        """ 修改用户 :param request: :return: """
        id = int(request.POST.get("id"))
        gender = request.POST.get("gender")
        age = int(request.POST.get("age"))
        occupation = int(request.POST.get("occupation"))
        zip_code = request.POST.get("zip_code")
    
        old_user = User.objects.get(id=id)
        print("找到旧数据%s" % old_user)
        old_user.gender = gender
        old_user.age = age
        old_user.occupation = occupation
        old_user.zip_code = zip_code
        old_user.save()
    
        return redirect('/app/showAll/')
    
    
    def del_user(request):
        """ 删除用户 :param request: :return: """
        id = int(request.GET.get("id"))
        User.objects.get(id=id).delete()
        return redirect('/app/showAll/')

代码传送门:[https://github.com/NiuXiangQian/djangosite][https_github.com_NiuXiangQian_djangosite]

## 启动访问 ##

启动，在项目路径下执行命令

#0.0.0.0:8000 ip:端口 不写默认是这
    python manage.py runserver 0.0.0.0:8000

访问, 浏览器输入 127.0.0.1:8000/app/  
![在这里插入图片描述][20200211230556517.png]

## 注意 ##

注意修改 /djangosite/settings.py 文件里的数据库配置

DATABASES = { 
        'default': { 
            # 注册我们自己使用的数据库连接
            'ENGINE': 'django.db.backends.mysql',  # 数据库引擎
            'NAME': 'mahout',  # 数据库名称
            'USER': 'root',  # 连接数据库的用户名称
            'PASSWORD': 'root',  # 用户密码
            'HOST': '127.0.0.1',  # 访问的数据库的主机的ip地址
            'PORT': '3306',  # 默认mysql访问端口
        }
    }

我是菜鸡入门，不喜勿喷，如果有兴趣可以一块学习交流

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzg5MzU0_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200211224336924.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzg5MzU0,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzg5MzU0_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/2020021122582762.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzQxMzg5MzU0,size_16,color_FFFFFF,t_70
[https_github.com_NiuXiangQian_djangosite]: https://github.com/NiuXiangQian/djangosite
[20200211230556517.png]: https://img-blog.csdnimg.cn/20200211230556517.png