Django路由访问及查询数据

1、在应用模块下，创建urls文件，用来存放访问路由

2、在项目总访问url内里注册路由

3、在view文件里，界说方法参数

2. from django.core import serializers
3. from django.db import connection
4. from django.http import HttpResponse, JsonResponse
5. # 分页
6. from django.core.paginator import Paginator, EmptyPage
7. import json
8. from django.core.serializers.json import DjangoJSONEncoder
9. from django.db.models import Q, F
10. from .models import Tests
12. def tests_list(request):
13.     page_number = int(request.GET.get('page', 1))
15.     search_term = request.GET.get('q', '')
17.     # 定义每页显示的条目数
18.     items_per_page = 10
20.     # 构建模糊查询的Q对象
21.     query = Q()
22.     if search_term:
23.         query &= (Q(name__icontains=search_term) | Q(password__icontains=search_term))
24.     # 添加状态等于1的条件
25.     #query &= Q(status=1)
26.     # 计算出从哪一条数据开始查询
27.     offset = (page_number - 1) * items_per_page
28.     # 应用模糊查询获取过滤后的数据
29.     filtered_users = Tests.objects.filter(query).order_by('-id')[offset:offset + items_per_page]
30.     # 获取过滤后的总条目数
31.     total_items = Tests.objects.filter(query).count()
32.     # 计算总页数
33.     total_pages = (total_items + items_per_page - 1) // items_per_page
34.     # 执行查询，只获取当前页的数据
35.     page_obj = filtered_users
37.     json_data = [user.to_dict() for user in page_obj]
38.     # print(user_data)
39.     # user_data = User.objects.all()
40.     # json_data = [ user.to_dict() for user in user_data]
42.     # 带上条件过滤数据
43.     # user_data = User.objects.filter(name='222333')
44.     # print(user_data)
46.     # list_of_dicts = list(user_data.values())
47.     # json_data = json.dumps(list_of_dicts, cls=DjangoJSONEncoder)
49.     return JsonResponse({'data': json_data, 'total': total_items, 'total_pages': total_pages}, safe=False)
51. def tests_add(request):
52.     pass
53. def tests_edit(request):
54.     pass
55. def tests_delete(request):
56.     pass

复制代码