02 building project (servlet+java bean+jsp shopping mall tutorial)

Build projects

  • Databases and tables
  • Package structure
  • jar package
  • Tool classes and profiles
  • Foreground files (html,css,js,img and other static resources)

1) database and table

Create a new database store, create a data table and insert data according to the entity structure analyzed in the previous section:

user table:

	CREATE TABLE `user` (
	  `uid` varchar(32) NOT NULL,
	  `username` varchar(20) DEFAULT NULL,
	  `password` varchar(20) DEFAULT NULL,
	  `name` varchar(20) DEFAULT NULL,
	  `email` varchar(30) DEFAULT NULL,
	  `telephone` varchar(20) DEFAULT NULL,
	  `birthday` date DEFAULT NULL,
	  `sex` varchar(10) DEFAULT NULL,
	  `state` int(11) DEFAULT NULL,
	  `code` varchar(64) DEFAULT NULL,
	  PRIMARY KEY (`uid`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

orders table

	CREATE TABLE `orders` (
	  `oid` varchar(32) NOT NULL,
	  `ordertime` datetime DEFAULT NULL,
	  `total` double DEFAULT NULL,
	  `state` int(11) DEFAULT NULL,
	  `address` varchar(30) DEFAULT NULL,
	  `name` varchar(20) DEFAULT NULL,
	  `telephone` varchar(20) DEFAULT NULL,
	  `uid` varchar(32) DEFAULT NULL,
	  PRIMARY KEY (`oid`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

category table

	CREATE TABLE `category` (
	  `cid` varchar(32) NOT NULL,
	  `cname` varchar(20) DEFAULT NULL,
	  PRIMARY KEY (`cid`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

product table

	CREATE TABLE `product` (
	  `pid` varchar(32) NOT NULL,
	  `pname` varchar(50) DEFAULT NULL,
	  `market_price` double DEFAULT NULL,
	  `shop_price` double DEFAULT NULL,
	  `pimage` varchar(200) DEFAULT NULL,
	  `pdate` date DEFAULT NULL,
	  `is_hot` int(11) DEFAULT NULL,
	  `pdesc` varchar(255) DEFAULT NULL,
	  `pflag` int(11) DEFAULT NULL,
	  `cid` varchar(32) DEFAULT NULL,
	  PRIMARY KEY (`pid`),
	  KEY `sfk_0001` (`cid`),
	  CONSTRAINT `sfk_0001` FOREIGN KEY (`cid`) REFERENCES `category` (`cid`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

orderitem table

	CREATE TABLE `orderitem` (
	  `itemid` varchar(32) NOT NULL,
	  `count` int(11) DEFAULT NULL,
	  `subtotal` double DEFAULT NULL,
	  `pid` varchar(32) DEFAULT NULL,
	  `oid` varchar(32) DEFAULT NULL,
	  PRIMARY KEY (`itemid`),
	  KEY `fk_0001` (`pid`),
	  KEY `fk_0002` (`oid`),
	  CONSTRAINT `fk_0001` FOREIGN KEY (`pid`) REFERENCES `product` (`pid`),
	  CONSTRAINT `fk_0002` FOREIGN KEY (`oid`) REFERENCES `orders` (`oid`)
	) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2) package structure

Create a new web project store, and create the following package structure:
com.zhumengkj.web.servlet       ---->servlet
Com.zhangkj.web.filter ----- filter
Com.zhangkj.dao interface
Com.zhangkj.dao.impl ----- > Dao's implementation class
Com.zhangkj.service ----- service interface
Com.zumengkj.service.impl ----- service implementation class
Com.zhangkj.entity class
Com.zhangkj.utils ----- tool class
Com.zhangkj.constant

3) jar package

Driver package, c3p0, dbutils, bianutils, jstl, mail
Copy the jar package to lib under WEB-INF:

4) tools and configuration files

Database: datasourceutils and c3p0 configuration files
Generate random code: uuidutils
File upload: uploadutils
Encryption: md5utils
Email: mailutils

5) front page

Copy the prepared material to the WebContent of the project
(material download: https://download.csdn.net/download/qq_34598667/11045034)

Add raw data to data table

##Insert data - Classification
	INSERT INTO `store`.`category` (`cid`, `cname`) VALUES ('1', 'Mobile phone digital');
	INSERT INTO `store`.`category` (`cid`, `cname`) VALUES ('2', 'Computer office');

##Insert data - Product
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('1', 'Millet 4 c Standard Edition', '1399', '1299', 'products/1/c_0001.jpg', '2015-11-02', '1', 'Millet 4 c Standard Version all Netcom white Mobile Unicom 4 G Mobile dual card dual standby', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('10', 'HUAWEI Ascend Mate7', '2699', '2599', 'products/1/c_0010.jpg', '2015-11-02', '1', 'HUAWEI Ascend Mate7 Moonlight silver move 4 G Mobile double card, double standby, double communication, 6-inch HD large screen, slim body, intelligent super eight core, press fingerprint recognition!!Select "mobile old user 4" below G Fly to enjoy the contract ", no need to change the number, there is a monthly return of phone charges!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('11', 'vivo X5Pro', '2399', '2298', 'products/1/c_0014.jpg', '2015-11-02', '1', 'China Mobile Dual 4 G Mobile phone 3 G Transport and storage version of Aurora white+Bluetooth self timer] new upgrade 3 G Running memory·Double 2.5D Arc glass·Eyeball recognition technology', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('12', 'Nubia ( nubia)My Bragg', '1899', '1799', 'products/1/c_0013.jpg', '2015-11-02', '0', 'Nubia ( nubia)My Prague silver white Mobile 4 G Mobile phone dual card dual standby [hi 11, next stand minus 100] metal body, fast charging! Prague camera new experience!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('13', 'Huawei maimang 4', '2599', '2499', 'products/1/c_0012.jpg', '2015-11-02', '1', 'Huawei maimang 4 chenxijin all net version 4 G Mobile phone double card double waiting metal body 2.5D Arc screen fingerprint unlocking optical anti shake', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('14', 'vivo X5M', '1899', '1799', 'products/1/c_0011.jpg', '2015-11-02', '0', 'vivo X5M Mobile 4 G Mobile phone double card double waiting champagne gold+Bluetooth self timer] 5.0 Inch large screen display·Eight core dual card dual standby·Hi-Fi move KTV', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('15', 'Apple iPhone 6 (A1586)', '4399', '4288', 'products/1/c_0015.jpg', '2015-11-02', '1', 'Apple iPhone 6 (A1586) 16GB Golden Mobile Unicom 4 G Long term saving of mobile phone is the real saving! Click to buy the phone and send the fee version, send the phone fee every month, enjoy the discount every month, enjoy 4 G Network, in Unicom 4 G!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('16', 'HUAWEI HUAWEI Mate S Lucky Edition', '4200', '4087', 'products/1/c_0016.jpg', '2015-11-03', '0', 'HUAWEI HUAWEI Mate S Zhenxiang mobile phone jidaijin Mobile Unicom Dual 4 G(Gao pin)30 yuan will be refunded for full star evaluation; power will be delivered when you buy it+Clear water jacket+Creative mobile phone stand; elegant arc screen, mate7 Upgraded version', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('17', 'SONY(SONY) E6533 Z3+', '4099', '3999', 'products/1/c_0017.jpg', '2015-11-02', '0', 'SONY(SONY) E6533 Z3+ Double card double 4 G Mobile phone waterproof and dustproof Jianhu green Sony z3 Professional waterproof 20.7 million pixel Mobile Unicom Dual 4 G', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('18', 'HTC One M9+', '3599', '3499', 'products/1/c_0018.jpg', '2015-11-02', '0', 'HTC One M9+(M9pw) Jinyinhui Mobile Unicom Dual 4 G Mobile phone 5.2 Inch, 8-core CPU,Fingerprint identification, UltraPixel Super pixel front camera+2000 ten thousand/200 10000 rear dual lens camera! Price reduction and special sale, surprise constantly!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('19', 'HTC Desire 826d 32G Pearl White', '1599', '1469', 'products/1/c_0020.jpg', '2015-11-02', '1', 'Post 13 million+UltraPixel Super pixel front camera+[Dual] front speaker+5.5 Inch [1080 p]Big screen!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('2', 'Zhongxing AXON', '2899', '2699', 'products/1/c_0002.jpg', '2015-11-05', '1', 'Zhongxing AXON Secret mini Pressure screen version B2015 Wall Gold Mobile Unicom 4 G Dual card dual standby', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('20', 'Millet red rice 2 A Enhanced white', '649', '549', 'products/1/c_0019.jpg', '2015-11-02', '0', 'Increased to 2 GB Memory+16GB Capacity! Four G Dual card, dual standby, 4-core, 1-core.5GHz Processor!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('21', 'Meizu Meilan note2 16GB white', '1099', '999', 'products/1/c_0021.jpg', '2015-11-02', '0', 'Grab the stock quickly, and stop after it! Five.5 Inch 1080 P Resolution screen, 64 bit 8-core 1.3GHz Processor, 13 megapixel camera, dual color temperature dual flash!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('22', 'Samsung Galaxy S5 (G9008W) Glitter white', '2099', '1999', 'products/1/c_0022.jpg', '2015-11-02', '1', '5.1 Inch Full HD gorgeous screen, 2.5GHz Quad core processor, 16 megapixel', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('23', 'sonim XP7700 4G Mobile phone', '1799', '1699', 'products/1/c_0023.jpg', '2015-11-09', '1', 'Three defense smart phone mobile/Unicom double 4 G Safety black yellow double 4 G US military industry IP69 30 Tianchang standby 3M waterproof and fall proof Beidou', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('24', 'Nubia ( nubia)Z9 Elite gold', '3988', '3888', 'products/1/c_0024.jpg', '2015-11-02', '1', 'China Mobile 4 G Mobile double card double waiting for real borderless! Golden Edition! Four GB+64GB Big memory!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('25', 'Apple iPhone 6 Plus (A1524) 16GB Golden', '5188', '4988', 'products/1/c_0025.jpg', '2015-11-02', '0', 'Apple iPhone 6 Plus (A1524) 16GB Golden Mobile Unicom 4 G Mobile hard goods hard power', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('26', 'Apple iPhone 6s (A1700) 64G Rose Gold', '6388', '6088', 'products/1/c_0026.jpg', '2015-11-02', '0', 'Apple iPhone 6 Plus (A1524) 16GB Golden Mobile Unicom 4 G Mobile hard goods hard power', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('27', 'Samsung Galaxy Note5(N9200)32G edition', '5588', '5388', 'products/1/c_0027.jpg', '2015-11-02', '0', 'Flagship! Five.7 Inch screen, 4+32G Memory! Inequable SPen More optimized floating window instructions! Free wireless charging board!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('28', 'Samsung Galaxy S6 Edge+(G9280)32G Platinum plate', '5999', '5888', 'products/1/c_0028.jpg', '2015-11-02', '0', 'Free mobile power supply+Selfie stick+Samsung OTG Metal U disc+wireless charger +Transparent protective shell', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('29', 'LG G4(H818)Ceramic white International Edition', '3018', '2978', 'products/1/c_0029.jpg', '2015-11-02', '0', 'Li Minho, F1.8 Large aperture 16 million rear camera, 5.5 Inch 2 K Screen, 3 G+32G Memory, LG Flagship aircraft of the year!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('3', 'Huawei glory 6', '1599', '1499', 'products/1/c_0003.jpg', '2015-11-02', '0', 'Glory 6 (H60-L01) 3GB Memory standard black mobile 4 G Mobile phone', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('30', 'Microsoft(Microsoft) Lumia 640 LTE DS (RM-1113)', '1099', '999', 'products/1/c_0030.jpg', '2015-11-02', '0', 'Microsoft's first dual network dual card dual 4 G Mobile phone, 5.0 Inch HD large screen, dual network dual card dual 4 G!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('31', 'Acer ( acer)ATC705-N50 Desktop computer', '2399', '2299', 'products/1/c_0031.jpg', '2015-11-02', '0', 'Top quality Acer, special offers come, why wait 11.11,Buy early and get cheap!', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('32', 'Apple MacBook Air MJVE2CH/A 13.3 inch', '6788', '6688', 'products/1/c_0032.jpg', '2015-11-02', '0', 'Widescreen laptop 128 GB Flash Memory', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('33', 'Lenovo ( ThinkPad) Lightweight series E450C(20EH0001CD)', '4399', '4199', 'products/1/c_0033.jpg', '2015-11-02', '0', 'Lenovo ( ThinkPad) Lightweight series E450C(20EH0001CD)14 Inch Laptop(i5-4210U 4G 500G 2G Self evident Win8.1)', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('34', 'Lenovo ( Lenovo)Little new V3000 Classic version', '4599', '4499', 'products/1/c_0034.jpg', '2015-11-02', '0', '14 Inch slim laptop( i7-5500U 4G 500G+8G SSHD 2G Single display full clear screen) black full 1000 minus 100, crazy minus! Open fire for three days!', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('35', 'ASUS ( ASUS)Classic series R557LI', '3799', '3699', 'products/1/c_0035.jpg', '2015-11-02', '0', '15.6 Inch Laptop( i5-5200U 4G 7200 Turn 500 G 2G Self evident D Engraved Bluetooth Win8.1 Black)', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('36', 'ASUS ( ASUS)X450J', '4599', '4399', 'products/1/c_0036.jpg', '2015-11-02', '0', '14 Inch Laptop( i5-4200H 4G 1TB GT940M 2G Display Bluetooth 4.0 D moment Win8.1 Black)', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('37', 'DELL ( DELL)Lingyue Flying Box 3000 Series', '3399', '3299', 'products/1/c_0037.jpg', '2015-11-03', '0', ' Ins14C-4528B 14 Inch notebook( i5-5200U 4G 500G GT820M 2G Self evident Win8)black', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('38', 'HP(HP)WASD Shadow Elves', '5699', '5499', 'products/1/c_0038.jpg', '2015-11-02', '0', '15.6 Inch game notebook(i5-6300HQ 4G 1TB+128G SSD GTX950M 4G Self evident Win10)', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('39', 'Apple Equipment Retina Display screen MacBook', '11299', '10288', 'products/1/c_0039.jpg', '2015-11-02', '0', 'Pro MF840CH/A 13.3 Inch wide screen laptop 256 GB Flash Memory', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('4', 'association P1', '2199', '1999', 'products/1/c_0004.jpg', '2015-11-02', '0', 'association P1 16G Earl Mobile 4 G Charge the phone for 5 minutes, talk for 3 hours! Technology comes from transcendence! Quality comes from precipitation! Five thousand mAh Big battery! High end business matching!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('40', 'Mechanical revolution( MECHREVO)MR X6S-M', '6799', '6599', 'products/1/c_0040.jpg', '2015-11-02', '0', '15.6 Inch Game Book(I7-4710MQ 8G 64GSSD+1T GTX960M 2G Self evident IPS screen WIN7)black', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('41', 'Shenzhou ( HASEE) God of War K660D-i7D2', '5699', '5499', 'products/1/c_0041.jpg', '2015-11-02', '0', '15.6 Inch Game Book(i7-4710MQ 8G 1TB GTX960M 2G Du Xian 1080 P)black', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('42', 'MSI ( MSI)GE62 2QC-264XCN', '6199', '5999', 'products/1/c_0042.jpg', '2015-11-02', '0', '15.6 Inch game notebook( i5-4210H 8G 1T GTX960MG DDR5 2G Backlit keyboard) black', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('43', 'Raytheon ( ThundeRobot)G150S', '5699', '5499', 'products/1/c_0043.jpg', '2015-11-02', '0', '15.6 Inch Game Book ( i7-4710MQ 4G 500G GTX950M 2G Single display package without highlights full height clear screen) gold', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('44', 'HP ( HP)Lightweight series HP', '3199', '3099', 'products/1/c_0044.jpg', '2015-11-02', '0', '15-r239TX 15.6 Inch Laptop( i5-5200U 4G 500G GT820M 2G Self evident win8.1)Metal ash', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('45', 'Future human( Terrans Force)T5', '10999', '9899', 'products/1/c_0045.jpg', '2015-11-02', '0', '15.6 Inch Game Book( i7-5700HQ 16G 120G solid state+1TB GTX970M 3G GDDR5 Black)', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('46', 'DELL ( DELL)Vostro 3800-R6308 Desktop computer', '3299', '3199', 'products/1/c_0046.jpg', '2015-11-02', '0', '(i3-4170 4G 500G DVD Three year on site service Win7)black', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('47', 'Lenovo ( Lenovo)H3050 Desktop computer', '5099', '4899', 'products/1/c_0047.jpg', '2015-11-11', '0', '(i5-4460 4G 500G GT720 1G Self evident DVD Gigabit Ethernet Win10)23 inch', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('48', 'Apple iPad mini 2 ME279CH/A', '2088', '1888', 'products/1/c_0048.jpg', '2015-11-02', '0', '(Equipment Retina Display 7.9 Inch 16 G WLAN Model silver)', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('49', 'Millet ( MI)7.9 Inch flat', '1399', '1299', 'products/1/c_0049.jpg', '2015-11-02', '0', 'WIFI 64GB(NVIDIA Tegra K1 2.2GHz 2G 64G 2048*1536 Retina screen 800 W)white', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('5', 'Motorola moto x(x+1)', '1799', '1699', 'products/1/c_0005.jpg', '2015-11-01', '0', 'Motorola moto x(x+1)(XT1085) 32GB Natural bamboo all in one 4 G Mobile 11 November! MOTO X Shock special offers! 1699 yuan! Play black technology with you! Natural material, original smooth system!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('50', 'Apple iPad Air 2 MGLW2CH/A', '2399', '2299', 'products/1/c_0050.jpg', '2015-11-12', '0', '(9.7 Inch 16 G WLAN Model silver)', '0', '2');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('6', 'Meizu MX5 16GB Silver Black', '1899', '1799', 'products/1/c_0006.jpg', '2015-11-02', '0', 'Meizu MX5 16GB Silver Black Mobile Unicom Dual 4 G Mobile phone double card double to be sent tempered film of original factory+Protective shell+Headset! Five.5 Inch large screen, 3 G Operating memory, 20.7 million+500 Megapixel camera! Long term province is the real province!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('7', 'Samsung Galaxy On7', '1499', '1398', 'products/1/c_0007.jpg', '2015-11-14', '0', 'Samsung Galaxy On7(G6000)Ang Xiaoqi gold all Netcom 4 G Mobile phone double card double waiting for new products in hot rush! Jingdong enjoys a great opportunity! Five.5 Inch HD big screen! One thousand and three hundred+500W Pixels! Evaluation wins 30 yuan phone bill voucher!', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('8', 'NUU NU5', '1288', '1190', 'products/1/c_0008.jpg', '2015-11-02', '0', 'NUU NU5 16GB China Mobile Dual 4 G Smart phone dual card dual waiting list courtesy chengguangjin Hong Kong brand 2.5D Toughened glass before and after radian comes with a mobile phone cover+Mobile power supply for toughened film drying sheet+Bluetooth headset', '0', '1');
INSERT INTO `store`.`product` (`pid`, `pname`, `market_price`, `shop_price`, `pimage`, `pdate`, `is_hot`, `pdesc`, `pflag`, `cid`) VALUES ('9', 'Music vision ( Letv)Yue 1 pro(X800)', '2399', '2299', 'products/1/c_0009.jpg', '2015-11-02', '0', 'Music vision ( Letv)Yue 1 pro(X800)64GB Golden Mobile 4 G Mobile double card double waiting for LETV ecology UI+5.5 Inch 2 K screen+Qualcomm 8-core processor+4GB Running memory+64GB storage+1300 Ten thousand cameras!', '0', '1');

Tags: Mobile Database network shell

Posted on Fri, 29 Nov 2019 21:59:04 -0800 by nuttynibbles