颜色码对照表颜色英文代码形象描述十六进制RGB　LightPink浅粉红#FFB6C1255,182,193　Pink粉红#FFC0CB255,192,203　Crimson猩红#DC143C220,20,60　LavenderBlush脸红的淡紫色#FFF0F5255,240,245　PaleVioletRed苍白的紫罗兰红色#DB7093219,112,147　HotPink热情的粉红#FF69B4255,105,180　DeepPink深粉色#FF1493255,20,147　MediumVioletRed适中的紫罗兰红色#C71585199,21,133　Orchid兰花的紫色#DA70D6218,112,214　Thistle蓟#D8BFD8216,191,216　plum李子#DDA0DD221,160,221　Violet紫罗兰#EE82EE238,130,238　Magenta洋红#FF00FF255,0,255　Fuchsia灯笼海棠(紫红色)#FF00FF255,0,255　DarkMagenta深洋红色#8B008B139,0,139　Purple紫色#800080128,0,128　MediumOrchid适中的兰花紫#BA55D3186,85,211　DarkVoilet深紫罗兰色#9400D3148,0,211　DarkOrchid深兰花紫#9932CC153,50,204　Indigo靛青#4B008275,0,130　BlueViolet深紫罗兰的蓝色#8A2BE2138,43,226　MediumPurple适中的紫色#9370DB147,112,219　MediumSlateBlue适中的板岩暗蓝灰色#7B68EE123,104,238　SlateBlue板岩暗蓝灰色#6A5ACD106,90,205　DarkSlateBlue深岩暗蓝灰色#483D8B72,61,139　Lavender熏衣草花的淡紫色#E6E6FA230,230,250　GhostWhite幽灵的白色#F8F8FF248,248,255　Blue纯蓝#0000FF0,0,255　MediumBlue适中的蓝色#0000CD0,0,205　MidnightBlue午夜的蓝色#19197025,25,112　DarkBlue深蓝色#00008B0,0,139　Navy海军蓝#0000800,0,128　RoyalBlue皇家蓝#4169E165,105,225　CornflowerBlue矢车菊的蓝色#6495ED100,149,237　LightSteelBlue淡钢蓝#B0C4DE176,196,222　LightSlateGray浅石板灰#778899119,136,153　SlateGray石板灰#708090112,128,144　DoderBlue道奇蓝#1E90FF30,144,255　AliceBlue爱丽丝蓝#F0F8FF240,248,255　SteelBlue钢蓝#4682B470,130,180　LightSkyBlue淡蓝色#87CEFA135,206,250　SkyBlue天蓝色#87CEEB135,206,235　DeepSkyBlue深天蓝#00BFFF0,191,255　LightBLue淡蓝#ADD8E6173,216,230　PowDerBlue火药蓝#B0E0E6176,224,230　CadetBlue军校蓝#5F9EA095,158,160　Azure蔚蓝色#F0FFFF240,255,255　LightCyan淡青色#E1FFFF225,255,255　PaleTurquoise苍白的绿宝石#AFEEEE175,238,238　Cyan青色#00FFFF0,255,255　Aqua水绿色#D4F2E7212,242,231　DarkTurquoise深绿宝石#00CED10,206,209　DarkSlateGray深石板灰#2F4F4F47,79,79　DarkCyan深青色#008B8B0,139,139　Teal水鸭色#0080800,128,128　MediumTurquoise适中的绿宝石#48D1CC72,209,204　LightSeaGreen浅海洋绿#20B2AA32,178,170　Turquoise绿宝石#40E0D064,224,208　Auqamarin绿玉\碧绿色#7FFFAA127,255,170　MediumAquamarine适中的碧绿色#00FA9A0,250,154　MediumSpringGreen适中的春天的绿色#00FF7F0,255,127　MintCream薄荷奶油#F5FFFA245,255,250　SpringGreen春天的绿色#3CB37160,179,113　SeaGreen海洋绿#2E8B5746,139,87　Honeydew蜂蜜#F0FFF0240,255,240　LightGreen淡绿色#90EE90144,238,144　PaleGreen苍白的绿色#98FB98152,251,152　DarkSeaGreen深海洋绿#8FBC8F143,188,143　LimeGreen酸橙绿#32CD3250,205,50　Lime酸橙色#00FF000,255,0　ForestGreen森林绿#228B2234,139,34　Green纯绿#0080000,128,0　DarkGreen深绿色#0064000,100,0　Chartreuse查特酒绿#7FFF00127,255,0　LawnGreen草坪绿#7CFC00124,252,0　GreenYellow绿黄色#ADFF2F173,255,47　OliveDrab橄榄土褐色#556B2F85,107,47　Beige米色(浅褐色)#F5F5DC245,245,220　LightGoldenrodYellow浅秋麒麟黄#FAFAD2250,250,210　Ivory象牙#FFFFF0255,255,240　LightYellow浅黄色#FFFFE0255,255,224　Yellow纯黄#FFFF00255,255,0　Olive橄榄#808000128,128,0　DarkKhaki深卡其布#BDB76B189,183,107　LemonChiffon柠檬薄纱#FFFACD255,250,205　PaleGodenrod灰秋麒麟#EEE8AA238,232,170　Khaki卡其布#F0E68C240,230,140　Gold金#FFD700255,215,0　Cornislk玉米色#FFF8DC255,248,220　GoldEnrod秋麒麟#DAA520218,165,32　FloralWhite花的白色#FFFAF0255,250,240　OldLace老饰带#FDF5E6253,245,230　Wheat小麦色#F5DEB3245,222,179　Moccasin鹿皮鞋#FFE4B5255,228,181　Orange橙色#FFA500255,165,0　PapayaWhip番木瓜#FFEFD5255,239,213　BlanchedAlmond漂白的杏仁#FFEBCD255,235,205　NavajoWhite纳瓦霍白#FFDEAD255,222,173　AntiqueWhite古代的白色#FAEBD7250,235,215　Tan晒黑#D2B48C210,180,140　BrulyWood结实的树#DEB887222,184,135　Bisque(浓汤)乳脂,番茄等#FFE4C4255,228,196　DarkOrange深橙色#FF8C00255,140,0　Linen亚麻布#FAF0E6250,240,230　Peru秘鲁#CD853F205,133,63　PeachPuff桃色#FFDAB9255,218,185　SandyBrown沙棕色#F4A460244,164,96　Chocolate巧克力#D2691E210,105,30　SaddleBrown马鞍棕色#8B4513139,69,19　SeaShell海贝壳#FFF5EE255,245,238　Sienna黄土赭色#A0522D160,82,45　LightSalmon浅鲜肉(鲑鱼)色#FFA07A255,160,122　Coral珊瑚#FF7F50255,127,80　OrangeRed橙红色#FF4500255,69,0　DarkSalmon深鲜肉(鲑鱼)色#E9967A233,150,122　Tomato番茄#FF6347255,99,71　MistyRose薄雾玫瑰#FFE4E1255,228,225　Salmon鲜肉(鲑鱼)色#FA8072250,128,114　Snow雪#FFFAFA255,250,250　LightCoral淡珊瑚色#F08080240,128,128　RosyBrown玫瑰棕色#BC8F8F188,143,143　IndianRed印度红#CD5C5C205,92,92　Red纯红#FF0000255,0,0　Brown棕色#A52A2A165,42,42　FireBrick耐火砖#B22222178,34,34　DarkRed深红色#8B0000139,0,0　Maroon栗色#800000128,0,0　White纯白#FFFFFF255,255,255　WhiteSmoke白烟#F5F5F5245,245,245　Gainsboro亮灰色#DCDCDC220,220,220　LightGrey浅灰色#D3D3D3211,211,211　Silver银白色#C0C0C0192,192,192　DarkGray深灰色#A9A9A9169,169,169　Gray灰色#808080128,128,128　DimGray暗淡的灰色#696969105,105,105　Black纯黑#0000000,0,0

前端页面： <div> <ul> {% if not curuent_page.has_previous %} <li> <a href="#"> <span>上一页</span> </a> </li> {% else %} <li> <a href="?page={{ curuent_page.previous_page_number }}"> <span>上一页</span> </a> </li> {% endif %} {% for p_range in pag_range %} {# {% if curuent_page_num == p_range %}#} <li> <a href="?page={{ p_range }}">{{ p_range }}</a> </li> {# {% else %}#} {# <li>#} {# <a href="?page={{ p_range }}">{{ p_range }}</a>#} {# </li>#} {# {% endif %}#} {% endfor %} {% if not curuent_page.has_next %} <li> <a href="?page={{ curuent_page_num }}"> <span>下一页</span> </a> </li> {% else %} <li> <a href="?page={{ curuent_page.next_page_number }}"> <span>下一页</span> </a> </li> {% endif %} </ul> </div>views.py：from django.core.paginator import Paginator sk = Sky.objects.all() #获取所有数据 pagenitor = Paginator(sk,11) #每页的数据分多少行 page_num = pagenitor.num_pages #获取总页数 curuent_page_num = int(request.GET.get('page',1)) #获取当前页数，默认为1 curuent_page = pagenitor.page(curuent_page_num) #获取当前页的数据 print(page_num) if page_num <11: pag_range = pagenitor.page_range elif page_num >11: if curuent_page_num<6: pag_range = range(1,11) elif curuent_page_num>(pagenitor.num_pages)-5: pag_range = range(page_num-9,page_num+1) else: pag_range = range(curuent_page_num-5,curuent_page_num+5) return render(request,'ajax.html',{'sk':sk,'pagenitor':pagenitor,'curuent_page':curuent_page,'curuent_page_num':curuent_page_num,'pag_range':pag_range})

嗯

前端：<form method="post" action="ajax.html">{% csrf_token %} <p><input type="text" name="name" placeholder="姓名"> <input type="text" name="age" placeholder="年龄"> <input type="text" name="department" placeholder="部门"> <button type="submit">查询</button></p> </form>后端views.py:后端： name = request.POST.get('name') age = request.POST.get('age') department = request.POST.get('department') search = dict() if name: search['name']=name if age: search['age'] = age if department: search['department'] = department sk = Sky.objects.filter(**search) #重要** print(sk) return render(request,'ajax.html',{'sk':sk})

<td class="cs" id="cs{{ s.id }}">删除</td> <script> $('.cs').click(function () { alert($(this).attr('id')) }) </script>

views.py @csrf_exempt def xin(request): name = request.GET.get('name') sk = Sky.objects.filter(name=name) ret = [] for i in range(0,len(sk)): st = {} st['id'] = sk[i].id st['name'] = sk[i].name st['age'] = sk[i].age st['department'] = sk[i].department ret.append(st) return HttpResponse(str(ret))前端： <p><input name="name" type="text" placeholder="姓名" id="name" > <button id="find" type="button" >提交</button> </p> <table id="pst"> <thead> <tr> <th>序号</th> <th>姓名</th> <th>年龄</th> <th>部门</th> </tr> </thead> <tbody> {% for s in sk %} <tr> <td>{{ s.id }}</td> <td>{{ s.name }}</td> <td>{{ s.age }}</td> <td>{{ s.department }}</td> </tr> {% endfor %} </tbody> </table> <script src="../static/js/jquery.min.js"></script> <script> $(document).ready(function () { $('#find').click(function () { var name = $('#name').val(); $.get("/xin/",{'name':name}, function(ret){ var obj = eval(ret); var tbody = $('<tbody></tbody>'); for(var i=0;i<obj.length;i++){ var tr = $('<tr></tr>'); tr.append('<td>'+obj[i]['id']+'</td>'+'<td>'+obj[i]['name']+'</td>'+'<td>'+obj[i]['age']+'</td>'+'<td>'+obj[i]['department']+'</td>'); tbody.append(tr); } $('#pst tbody').replaceWith(tbody); }) }) }) </script>

$('#'+likes[i].id)

https://www.postman.com/downloads/

sk = Sky.objects.fliter(name='小白')sk[0].name  获取第一个的姓名sk[0].age    获取第一个的年龄

jQuery使用document.ready来保证所要执行的代码是在DOM元素被加载完成的情况下执行。

在Mysqldump前加上mysql的绝对路径，到/bin目录