一:先在自己的本地数据库里新建一个叫dzy的数据库,里面建有四个表,下面是建表的代码#用户表CREATETABLEuser(idint(11)notNULLPRIMARYKEYauto_increment,usernameVARCHAR(30)notNULLUNIQUE,emailVARCHAR(30)notnull,passwordVARCHAR(100)notnull);
#商品表CREATETABLEgoods(idint(11)notnullPRIMARYKEYauto_increment,EAnameVARCHAR(50)notNULL,brandVARCHAR(30)notnull,placeVARCHAR(30)notnull,refpriceVARCHAR(10)notnull,vippriceVARCHAR(10)notnull,photoVARCHAR(100)notnull);
#订单表CREATETABLEdingdan(orderidint(11)notnullPRIMARYKEYauto_increment,xiadanrenVARCHAR(30)notnull,telVARCHAR(30)notnull,addressVARCHAR(100)notnull,shangpinminVARCHAR(100)notnull)
#购物车表CREATETABLEshopping_cart(idINTAUTO_INCREMENTPRIMARYKEY,user_idINTNOTNULL,product_idINTNOTNULL,quantityINTNOTNULLDEFAULT1,added_atTIMESTAMPDEFAULTCURRENT_TIMESTAMP);
建完四个表后,需要往goods表里添加商品,下面是添加商品的代码,复制即可#添加数据INSERTINTOgoods(id,EAname,brand,place,refprice,vipprice,photo)VALUES(1,'wcf亲授登山宝典','wcf','南充','23','19','ds.png')
INSERTINTOgoods(id,EAname,brand,place,refprice,vipprice,photo)VALUES(2,'qxl绝密化妆宝典','qxl','南充','55','34','hz.png')
INSERTINTOgoods(id,EAname,brand,place,refprice,vipprice,photo)VALUES(3,'mh足球必胜圣经','mhwq','凉山','33','23','zq.png')
INSERTINTOgoods(id,EAname,brand,place,refprice,vipprice,photo)VALUES(4,'zw亲传上王者技巧','zzw','泸州','888','12','wzry.png')
INSERTINTOgoods(id,EAname,brand,place,refprice,vipprice,photo)VALUES(5,'zh无敌美术宝典','zzh','成都','432','38','ms.png')
INSERTINTOgoods(id,EAname,brand,place,refprice,vipprice,photo)VALUES(6,'七组无敌绿宝书','第七组','世界','888','1888','lbs.png')
注:请把里面的字母改为我们的名字,比如第一个wcf是什么意思你们懂得。