赞
踩
一份简化的小项目,为了让初学者了解基本的开发流程。可以在Android App上查看物品,购买物品,查看购物车,提交订单,查看历史订单。这个小项目主要是为了达成以下两个目的:
点击这里,前往下载页面。
点击这里,前往下载页面。
/* Navicat MySQL Data Transfer Source Server : mysql Source Server Version : 50626 Source Host : localhost:3306 Source Database : world Target Server Type : MYSQL Target Server Version : 50626 File Encoding : 65001 Date: 2019-06-19 09:04:21 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `city` -- ---------------------------- DROP TABLE IF EXISTS `city`; CREATE TABLE `city` ( `ID` int(11) NOT NULL AUTO_INCREMENT, `Name` char(35) NOT NULL DEFAULT '', `CountryCode` char(3) NOT NULL DEFAULT '', `District` char(20) NOT NULL DEFAULT '', `Population` int(11) NOT NULL DEFAULT '0', `image` varchar(255) DEFAULT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=4080 DEFAULT CHARSET=latin1; -- ---------------------------- -- Records of city -- ---------------------------- INSERT INTO `city` VALUES ('1', 'Kabul', 'AFG', 'Kabol', '1780000', 'img/db1.jpg'); INSERT INTO `city` VALUES ('2', 'Qandahar', 'AFG', 'Qandahar', '237500', 'img/db2.jpg'); INSERT INTO `city` VALUES ('3', 'Herat', 'AFG', 'Herat', '186800', 'img/db3.jpg'); INSERT INTO `city` VALUES ('4', 'Mazar-e-Sharif', 'AFG', 'Balkh', '127800', 'img/db4.jpg'); INSERT INTO `city` VALUES ('5', 'Amsterdam', 'NLD', 'Noord-Holland', '731200', 'img/db5.jpg'); INSERT INTO `city` VALUES ('6', 'Rotterdam', 'NLD', 'Zuid-Holland', '593321', 'img/db6.jpg'); INSERT INTO `city` VALUES ('7', 'Haag', 'NLD', 'Zuid-Holland', '440900', 'img/db7.jpg'); INSERT INTO `city` VALUES ('8', 'Utrecht', 'NLD', 'Utrecht', '234323', 'img/db8.jpg'); INSERT INTO `city` VALUES ('9', 'Eindhoven', 'NLD', 'Noord-Brabant', '201843', 'img/db9.jpg'); INSERT INTO `city` VALUES ('10', 'Tilburg', 'NLD', 'Noord-Brabant', '193238', 'img/db10.jpg'); INSERT INTO `city` VALUES ('11', 'Groningen', 'NLD', 'Groningen', '172701', 'img/db11.jpg'); INSERT INTO `city` VALUES ('12', 'Breda', 'NLD', 'Noord-Brabant', '160398', 'img/db1.jpg'); -- ---------------------------- -- Table structure for `orderinfo` -- ---------------------------- DROP TABLE IF EXISTS `orderinfo`; CREATE TABLE `orderinfo` ( `oid` varchar(100) NOT NULL, `uid` varchar(20) DEFAULT NULL, `odate` varchar(255) DEFAULT NULL, `state` varchar(10) DEFAULT '', `phone` varchar(20) DEFAULT NULL, `address` varchar(255) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of orderinfo -- ---------------------------- INSERT INTO `orderinfo` VALUES ('SN1560830381894', '1001', '2019-06-18 11:59:41', '1', '11001070', '光明学院'); -- ---------------------------- -- Table structure for `orderitem` -- ---------------------------- DROP TABLE IF EXISTS `orderitem`; CREATE TABLE `orderitem` ( `itemid` int(11) NOT NULL AUTO_INCREMENT, `oid` varchar(255) NOT NULL, `pid` int(11) NOT NULL, `pcount` int(11) NOT NULL, `state` varchar(10) DEFAULT '', PRIMARY KEY (`itemid`) ) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of orderitem -- ---------------------------- INSERT INTO `orderitem` VALUES ('6', '1560830381894', '3', '2', '1'); INSERT INTO `orderitem` VALUES ('7', '1560830381894', '9', '2', '1');
这是一个学习项目,供初学者进行项目实训使用,如有侵权或不妥之处,敬请留言,必当尽快修改!
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。