pymysql实现web多条件组合查询

最新推荐文章于 2023-11-22 11:44:27 发布

dituirenwu

最新推荐文章于 2023-11-22 11:44:27 发布

阅读量310

点赞数

分类专栏：地推

本文链接：https://blog.csdn.net/dituirenwu/article/details/129336279

版权

本文介绍如何利用pymysql在web应用中实现多条件组合查询。通过获取GET请求参数，构建动态SQL语句，并使用DictCursor执行查询，返回查询结果。

摘要由CSDN通过智能技术生成

代码：

import pymysql
from rest_framework.views import APIView
from rest_framework.response import Response

Create your views here.

'''利用pymysql实现多条件查询'''
class SqlWeb(APIView):
def get(self, request):
name = request.GET.get('name')
gender = request.GET.get('gender')
class_id = request.GET.get('class_id')
request_data_dic = {}
if name is not None:
request_data_dic['sname'] = name
if gender is not None:
request_data_dic['gender'] = gender
if class_id is not None:
request_data_dic['class_id'] = class_id
print('request_data_dic:{}'.format(request_data_dic))
conn = pymysql.connect(
user='root',
password='123456',
host='127.0.0.1',
database='sql_