基于SSM的垃圾科普设计与实现-计算机毕业设计源码+LW文档

-- ----------------------------
-- Table structure for allusers
-- ----------------------------
DROP TABLE IF EXISTS `allusers`;
CREATE TABLE `allusers`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `pwd` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `cx` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT '普通管理员',
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of allusers
-- ----------------------------
INSERT INTO `allusers` VALUES (2, 'hsg', 'hsg', '超级管理员', '2022-03-10 16:32:38');

-- ----------------------------
-- Table structure for dx
-- ----------------------------
DROP TABLE IF EXISTS `dx`;
CREATE TABLE `dx`  (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `leibie` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of dx
-- ----------------------------
INSERT INTO `dx` VALUES (1, '系统公告', '

\r\n    欢迎大家登陆我站，我站主要是为广大朋友精心制作的一个系统，希望大家能够在我站获得一个好心情，谢谢！\r\n

\r\n

\r\n    自强不息，海纳百川，努力学习！fff\r\n

');
INSERT INTO `dx` VALUES (2, '系统简介', '系统简介hhrthrrrrr22ggg');
INSERT INTO `dx` VALUES (3, '关于我们', '    本公司坚持走:以质量求生存,以科技求发展,重合同守信用的道路,生产经营得到迅速发展。我们将以优质的产品和最完善的售后服务来真诚与各界朋友开展广泛的合作,共同创造一个美好的未来!
 
 公司行为准则:忠信仁义，以人为本。
 忠：即忠诚，  包括三重含义：企业忠于国家、忠于民族；企业忠于客户；员工忠于企业。
 信：即诚信，做企业要立足根本道德、信义，要诚实、讲信用。
 仁：即仁爱，上司对下属要仁爱、体贴，同事之间要关怀、友爱。
 义：即大义，公司在与合作伙伴、客户的交往过程中，不做损人利己的事，维护自己利益的前提是不损害他人利益；对民族、社会要共襄义举，要识大义，明是非。
');
INSERT INTO `dx` VALUES (4, '联系方式', '联系人：xxxxxxxx
 电话：0000-0000000
 手机：010000000000
 传真：0000-0000000
 邮件：xxxxxxxx@163.com
 地址：您公司的地址
 网址：http://www.xxxx.com
');

-- ----------------------------
-- Table structure for jianshangfenxiang
-- ----------------------------
DROP TABLE IF EXISTS `jianshangfenxiang`;
CREATE TABLE `jianshangfenxiang`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bianhao` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `jianshangfangfa` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `jianshangneirong` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `jianshangfangshi` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `biaoti` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `tupian` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `faburen` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `issh` varchar(10) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT '否',
  `dianzan_d` int(11) NULL DEFAULT 0,
  `dianzan_c` int(11) NULL DEFAULT 0,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of jianshangfenxiang
-- ----------------------------
INSERT INTO `jianshangfenxiang` VALUES (2, '014', '', '', '', '也门南部自杀式爆炸袭击致８人死亡', 'upload/nopic1.jpg', '018', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (3, '025', '', '', '', '全国海洋宣传日浙江主场活动在温举行', 'upload/nopic7.jpg', '004', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (4, '008', '', '', '', '大学生成网络传销主力 禁不起金钱诱惑是主因', 'upload/nopic5.jpg', '012', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (5, '021', '', '', '', '也门南部自杀式爆炸袭击致８人死亡', 'upload/nopic8.jpg', '013', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (6, '019', '', '', '', '钱库辖区消防违法拘留公告4', 'upload/nopic6.jpg', '009', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (7, '016', '', '', '', '大学生成网络传销主力 禁不起金钱诱惑是主因', 'upload/nopic4.jpg', '028', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (8, '011', '', '', '', '大学生成网络传销主力 禁不起金钱诱惑是主因', 'upload/nopic2.jpg', '033', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (9, '001', '', '', '', '全国海洋宣传日浙江主场活动在温举行', 'upload/nopic3.jpg', '001', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (10, 'sada', 'asd', 'asd', 'asd', 'asd', '', 'hsg', '否', 0, 0, '2022-03-10 16:48:39');
INSERT INTO `jianshangfenxiang` VALUES (11, '13123', '54阿萨德', '按时', '阿萨德', '阿萨德', 'upload/1646903332150.jpg', '001', '否', 0, 0, '2022-03-10 17:08:56');
INSERT INTO `jianshangfenxiang` VALUES (12, '1', '百度', '百度', '对你', '哈喽', 'upload/1646904910382.jpg', '001', '否', 0, 0, '2022-03-10 17:35:12');
INSERT INTO `jianshangfenxiang` VALUES (13, '1', '塑料袋', '垃圾场', '好', '塑料袋处理', 'upload/1648459792276.jpg', 'hsg', '是', 0, 0, '2022-03-28 17:29:56');

-- ----------------------------
-- Table structure for liuyanban
-- ----------------------------
DROP TABLE IF EXISTS `liuyanban`;
CREATE TABLE `liuyanban`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cheng` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `xingbie` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `QQ` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `youxiang` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `shouji` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `neirong` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `huifuneirong` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of liuyanban
-- ----------------------------

-- ----------------------------
-- Table structure for pinglun
-- ----------------------------
DROP TABLE IF EXISTS `pinglun`;
CREATE TABLE `pinglun`  (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `xinwenID` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pinglunneirong` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pinglunren` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `pingfen` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `biao` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `addtime` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`ID`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of pinglun
-- ----------------------------
INSERT INTO `pinglun` VALUES (1, '12', '1', '001', '1', 'jianshangfenxiang', '2022-03-10 17:35:22');

-- ----------------------------
-- Table structure for shici
-- ----------------------------
DROP TABLE IF EXISTS `shici`;
CREATE TABLE `shici`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bianhao` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `biaoti` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `neirong` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `zuozhe` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `beizhu` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `fabushijian` date NULL DEFAULT NULL,
  `tupian` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `dianzan_d` int(11) NULL DEFAULT 0,
  `dianzan_c` int(11) NULL DEFAULT 0,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of shici
-- ----------------------------
INSERT INTO `shici` VALUES (7, '310968974752', '网友投诉：苏宁2999元iphone根本“抢不到”', '', '邓超', 'ok', '2022-02-22', 'upload/nopic6.jpg', 0, 0, '2022-03-10 16:32:37');
INSERT INTO `shici` VALUES (8, '310909331374', '省委创先争优办：学习省委全会精神深化创先争优活动', '', '舒畅', '无', '2022-02-18', 'upload/nopic8.jpg', 0, 0, '2022-03-10 16:32:37');
INSERT INTO `shici` VALUES (9, '310919983284', '省委创先争优办：学习省委全会精神深化创先争优活动', '', '吴官本', '无', '2022-03-20', 'upload/1646902542967.jpg', 0, 0, '2022-03-10 16:32:37');

-- ----------------------------
-- Table structure for shirenfengcai
-- ----------------------------
DROP TABLE IF EXISTS `shirenfengcai`;
CREATE TABLE `shirenfengcai`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `xingming` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `leixing` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `zhuyaozuopin` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `tupian` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `zhuyaochengjiu` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `beizhu` varchar(500) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `dianzan_d` int(11) NULL DEFAULT 0,
  `dianzan_c` int(11) NULL DEFAULT 0,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of shirenfengcai
-- ----------------------------
INSERT INTO `shirenfengcai` VALUES (7, '李大汉', '', '', 'upload/nopic4.jpg', '', 'abc', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `shirenfengcai` VALUES (8, '司宪策', '', '', 'upload/nopic3.jpg', '', '无', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `shirenfengcai` VALUES (9, '张燕', '豪放派', '', 'upload/1646904847595.jpg', '', '没问题', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `shirenfengcai` VALUES (10, '卡纸', '可回收垃圾', '日常', 'upload/1648459874647.jpg', '123', '123', 0, 0, '2022-03-28 17:31:25');

-- ----------------------------
-- Table structure for shirenleixing
-- ----------------------------
DROP TABLE IF EXISTS `shirenleixing`;
CREATE TABLE `shirenleixing`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `leixing` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of shirenleixing
-- ----------------------------
INSERT INTO `shirenleixing` VALUES (10, '可回收垃圾', '2022-03-10 17:07:29');
INSERT INTO `shirenleixing` VALUES (11, '不可回收垃圾', '2022-03-28 15:35:26');

-- ----------------------------
-- Table structure for shoucangjilu
-- ----------------------------
DROP TABLE IF EXISTS `shoucangjilu`;
CREATE TABLE `shoucangjilu`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `xwid` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `ziduan` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `biao` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `biaoj` varchar(255) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of shoucangjilu
-- ----------------------------
INSERT INTO `shoucangjilu` VALUES (1, '001', '11', 'jianshangfangfa', 'jianshangfenxiang', '2022-03-10 17:09:16', 'jsfx');
INSERT INTO `shoucangjilu` VALUES (2, '001', '12', 'jianshangfangfa', 'jianshangfenxiang', '2022-03-10 17:35:18', 'jsfx');

-- ----------------------------
-- Table structure for xinwentongzhi
-- ----------------------------
DROP TABLE IF EXISTS `xinwentongzhi`;
CREATE TABLE `xinwentongzhi`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `biaoti` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `leibie` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `neirong` text CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL,
  `shouyetupian` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `dianjilv` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `tianjiaren` varchar(50) CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL DEFAULT NULL,
  `addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `zhaiyao` text CHARACTER SET gb2312 COLLATE gb2312_chinese_ci NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = gb2312 COLLATE = gb2312_chinese_ci ROW_FORMAT = Compact;