java+微信小程序开发+ssm+uniapp开发简单案例

/* Navicat MySQL Data Transfer Source Server : zz106ms Source Server Version : 50728 Source Host : localhost:3306 Source Database : hmshop Target Server Type : MYSQL Target Server Version : 50728 File Encoding : 65001 Date: 2024-02-03 10:24:43 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `banner` -- ---------------------------- DROP TABLE IF EXISTS `banner`; CREATE TABLE `banner` ( `id` int(11) NOT NULL AUTO_INCREMENT, `url` varchar(200) NOT NULL, `img` varchar(300) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of banner -- ---------------------------- INSERT INTO `banner` VALUES ('1', 'http://www.hotdoger.com', 'http://127.0.0.1:8080/hmshop/static/images/b11.jpg'); INSERT INTO `banner` VALUES ('2', 'http://www.hotdoger.com', 'http://127.0.0.1:8080/hmshop/static/images/b22.jpg'); INSERT INTO `banner` VALUES ('3', 'http://www.hotdoger.com', 'http://127.0.0.1:8080/hmshop/static/images/b33.jpg'); INSERT INTO `banner` VALUES ('4', 'http://www.hotdoger.com', 'http://127.0.0.1:8080/hmshop/static/images/b44.jpg'); -- ---------------------------- -- Table structure for `flag` -- ---------------------------- DROP TABLE IF EXISTS `flag`; CREATE TABLE `flag` ( `id` int(11) NOT NULL AUTO_INCREMENT, `flagname` varchar(30) NOT NULL, `uid` int(11) NOT NULL, `state` int(2) NOT NULL DEFAULT '0' COMMENT '0-可用，1禁用', PRIMARY KEY (`id`), KEY `uid` (`uid`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=109 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flag -- ---------------------------- INSERT INTO `flag` VALUES ('103', 'SEO技术', '20', '0'); INSERT INTO `flag` VALUES ('104', 'SEO顾问', '20', '0'); INSERT INTO `flag` VALUES ('105', 'SEO新闻', '20', '0'); INSERT INTO `flag` VALUES ('106', 'SEO行情', '20', '0'); INSERT INTO `flag` VALUES ('107', 'SEO外包', '20', '0'); INSERT INTO `flag` VALUES ('108', '开箱机标签', '20', '0'); -- ---------------------------- -- Table structure for `flink` -- ---------------------------- DROP TABLE IF EXISTS `flink`; CREATE TABLE `flink` ( `id` int(11) NOT NULL AUTO_INCREMENT, `webcontact` varchar(100) NOT NULL COMMENT '联系人电话', `webname` varchar(100) NOT NULL COMMENT '网站名字', `webroot` varchar(255) NOT NULL COMMENT '网站地址', `des` varchar(255) NOT NULL COMMENT '网站基本描述', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of flink -- ---------------------------- INSERT INTO `flink` VALUES ('24', '杨瑞亮', '郑州SEO优化', 'http://www.zsggw.cn/', '郑州SEO优化'); INSERT INTO `flink` VALUES ('27', '广告平台网站', '广告平台网站', 'http://www.hotdoger.com', '广告平台网站'); INSERT INTO `flink` VALUES ('29', '推广广告平台', '推广广告平台', 'http://www.hotdoger.com', '推广广告平台'); INSERT INTO `flink` VALUES ('30', '郑州画室', '郑州画室', 'http://www.106ms.com', '郑州画室'); INSERT INTO `flink` VALUES ('34', '广告代理平台', '广告代理平台', 'http://hotdoger.cn', '广告代理平台'); INSERT INTO `flink` VALUES ('35', '郑州SEO优化', '郑州SEO优化', 'http://www.zsggw.cn', '郑州SEO优化'); INSERT INTO `flink` VALUES ('36', '广告代理发布平台', '广告代理发布平台', 'http://www.hotdoger.com', '广告代理发布平台'); INSERT INTO `flink` VALUES ('37', '郑州SEO优化外包顾问', '郑州SEO优化外包顾问', 'http://hnseo321.com', '郑州SEO优化外包顾问'); INSERT INTO `flink` VALUES ('38', '测试友链', '测试友链', 'http://www.baidu.com', '测试友链'); -- ---------------------------- -- Table structure for `goods` -- ---------------------------- DROP TABLE IF EXISTS `goods`; CREATE TABLE `goods` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(60) DEFAULT NULL, `add_time` varchar(50) DEFAULT NULL, `zhaiyao` varchar(200) DEFAULT NULL, `click` int(11) DEFAULT NULL, `img_url` varchar(250) DEFAULT NULL, `sell_price` float(11,0) DEFAULT NULL, `market_price` float(11,0) DEFAULT NULL, `stock_quantity` int(11) DEFAULT NULL, `attr` int(11) DEFAULT '0' COMMENT '属性，0-默认，1-首页，2-推荐，3-热门', `state` int(11) DEFAULT '0' COMMENT '0-可用，1-禁用', `content` mediumtext COMMENT '商品主体内容', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of goods -- ---------------------------- INSERT INTO `goods` VALUES ('1', '戴尔新款商务笔记本电脑16G内存双核处理器', '2021-12-30 16:09:24', '戴尔新款商务笔记本电脑16G内存双核处理器，快到飞起来的速度！', '0', 'http://127.0.0.1:8080//sppeitu/1640851766.jpg', '4899', '5400', '120', '3', '0', '<p>戴尔新款商务笔记本电脑16G内存双核处理器，快到飞起来的速度！</p><p><img src=\"/image/1640851825.jpg\" alt=\"1640851825.jpg\"><br></p>'); INSERT INTO `goods` VALUES ('2', '华为新款手机8G内存高清摄像头', '2021-12-30 16:12:10', '华为新款手机8G内存高清摄像头！想拍就拍，就是这么爽！', '0', 'http://127.0.0.1:8080//sppeitu/1640851887.jpg', '6900', '8900', '1201', '3', '0', '<p>华为新款手机8G内存高清摄像头！想拍就拍，就是这么爽！</p><p><img src=\"/image/1640851913.jpg\" alt=\"1640851913.jpg\"><br></p>'); INSERT INTO `goods` VALUES ('3', '儿童益智玩具手动滑翔机模具批发', '2021-12-30 16:13:32', '儿童益智玩具手动滑翔机模具批发，儿童益智玩具手动滑翔机模具批发', '0', 'http://127.0.0.1:8080//sppeitu/1640851973.jpg', '102', '146', '15991', '3', '0', '<p>儿童益智玩具手动滑翔机模具批发，儿童益智玩具手动滑翔机模具批发</p><p><img src=\"/image/1640852015.jpg\" alt=\"1640852015.jpg\"><br></p>'); INSERT INTO `goods` VALUES ('4', '赛车摩托车批发零售机车迷发烧友推荐款', '2021-12-30 16:14:25', '赛车摩托车批发零售机车迷发烧友推荐款', '0', 'http://127.0.0.1:8080//sppeitu/1640852028.jpg', '9999', '10200', '1891', '3', '0', '<p>赛车摩托车批发零售机车迷发烧友推荐款</p><p><img src=\"/image/1640852049.jpg\" alt=\"1640852049.jpg\"><br></p>'); INSERT INTO `goods` VALUES ('5', '赛车玩具车儿童玩具车批发零售', '2021-12-30 16:14:51', '赛车玩具车儿童玩具车批发零售', '0', 'http://127.0.0.1:8080//sppeitu/1640852080.jpg', '88', '102', '109451', '3', '0', '<p>赛车玩具车儿童玩具车批发零售</p><p><img src=\"/image/1640852107.jpg\" alt=\"1640852107.jpg\"><br></p>'); INSERT INTO `goods` VALUES ('6', '额外产品带图片测试第一次', '2021-12-30 18:01:49', '额外产品带图片测试第一次', '0', 'http://127.0.0.1:8080//sppeitu/1640858471.jpg', '122', '15', '120', '3', '0', '<p>额外产品带图片测试第一次！<img src=\"/image/1640858521.jpg\" alt=\"1640858521.jpg\"></p>'); INSERT INTO `goods` VALUES ('7', '测试视频商品第二次带配图', '2021-12-31 09:55:18', '测试视频商品第二次带配图', '0', 'http://127.0.0.1:8080//sppeitu/1640915704.jpg', '258', '156', '1222', '3', '0', '<p>测试视频商品第二次带配图测试视频商品第二次带配图</p><p><img src=\"/image/1640915729.png\" alt=\"1640915729.png\"><br></p>'); INSERT INTO `goods` VALUES ('8', '游戏图片测试商品得吃', '2021-12-31 10:06:05', '游戏图片测试商品得吃', '0', 'http://127.0.0.1:8080//sppeitu/1640916329.jpg', '233', '15', '21', '3', '0', '<p>游戏图片测试商品得吃</p><p><img src=\"/image/1640916374.jpg\" alt=\"1640916374.jpg\"><br></p>'); INSERT INTO `goods` VALUES ('9', '都是才算是第三次带图视频', '2021-12-31 10:14:31', '都是才算是第三次