django開發商城(提供初始數據,商城首頁及購物車)

1.爬取數據

2.json數據轉化為sql語句

3.新建輪播圖模型(模型名與sql語句對應表名相同)

class Wheel(models.Model):img=models.CharField(max_length=150)name=models.CharField(max_length=20)trackid=models.CharField(max_length=20)

4.終端打開mysql,執行插入語句

5.在首頁進行展示輪播圖(home.html)

      <div class="swiper-container" id="topSlider"><div class="swiper-wrapper">{% for item in sliderList %}<div class="swiper-slide"><a href="#"><img src="{{ item.img }}"></a></div>{% endfor %}</div></div>

設置輪播(home.js)

$(document).ready(function () {var swiper = new Swiper('#topSlider', {direction: 'horizontal',loop: true,speed: 500,autoplay: 2000,pagination: {el: '.swiper-pagination',}})})

6.展示主要商品

建立模型,在數據庫進行插入

class MainShow(models.Model):trackid = models.CharField(max_length=10)name = models.CharField(max_length=20)img = models.CharField(max_length=100)categoryid = models.CharField(max_length=10)brandname = models.CharField(max_length=20)img1 = models.CharField(max_length=100)childcid1 = models.CharField(max_length=10)productid1 = models.CharField(max_length=10)longname1 = models.CharField(max_length=50)price1 = models.CharField(max_length=10)marketprice1 = models.CharField(max_length=10)img2 = models.CharField(max_length=100)childcid2 = models.CharField(max_length=10)productid2 = models.CharField(max_length=10)longname2 = models.CharField(max_length=50)price2 = models.CharField(max_length=10)marketprice2 = models.CharField(max_length=10)img3 = models.CharField(max_length=100)childcid3 = models.CharField(max_length=10)productid3 = models.CharField(max_length=10)longname3 = models.CharField(max_length=50)price3 = models.CharField(max_length=10)marketprice3 = models.CharField(max_length=10)

進行展示

        {#  mainShow #}<section class="mainInfo">{% for item in mainShowList %}<section><h3>{{ item.name }}<a href="#">更多&gt;</a><span></span></h3><div><a href="#"><img src="{{ item.img }}"></a></div><ul><li><a href=""><img src="{{ item.img1}}" alt=""><span class="">{{ item.longname1 }}</span><span>￥{{ item.price1 }}<s>￥{{ item.marketprice1 }}</s></span></a></li><li><a href=""><img src="{{ item.img2}}" alt=""><span class="description">{{ item.longname2 }}</span><span>￥{{ item.price2 }}<s>￥{{ item.marketprice2 }}</s></span></a></li><li><a href=""><img src="{{ item.img3}}" alt=""><span class="description">{{ item.longname3 }}</span><span>￥{{ item.price3 }}<s>￥{{ item.marketprice3 }}</s></span></a></li></ul></section>{% endfor %}</section>

?