針對(duì)如下表,做一個(gè)模糊查詢
#以下查詢條件實(shí)際應(yīng)用中用前端獲取就是,這里為了書寫方便,就直接定義值了 name = '貓' sex = '' hobby = '' blood = 'B' # 定義一個(gè)字典用于保存前端發(fā)送過來的查詢條件 search_dict = dict() # 如果有這個(gè)值 就寫入到字典中去 if sex: search_dict['sex'] = sex #精確查詢 if blood: search_dict['blood'] = blood if hobby: search_dict['hobby__icontains'] = hobby # 字典前面一定要加上兩個(gè)星號(hào) list = Student2.objects.filter(**search_dict) for v in list: print(v.name)