基于SSM的垃圾科普設(shè)計與實現(xiàn)-計算機畢業(yè)設(shè)計源碼+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, '系統(tǒng)公告', '<p>\r\n 歡迎大家登陸我站，我站主要是為廣大朋友精心制作的一個系統(tǒng)，希望大家能夠在我站獲得一個好心情，謝謝！\r\n</p>\r\n<p>\r\n 自強不息，海納百川，努力學(xué)習(xí)！fff\r\n</p>');
INSERT INTO `dx` VALUES (2, '系統(tǒng)簡介', '系統(tǒng)簡介hhrthrrrrr22ggg');
INSERT INTO `dx` VALUES (3, '關(guān)于我們', ' 本公司堅持走:以質(zhì)量求生存,以科技求發(fā)展,重合同守信用的道路,生產(chǎn)經(jīng)營得到迅速發(fā)展。我們將以優(yōu)質(zhì)的產(chǎn)品和最完善的售后服務(wù)來真誠與各界朋友開展廣泛的合作,共同創(chuàng)造一個美好的未來!<br />? <br />? 公司行為準(zhǔn)則:忠信仁義，以人為本。 <br />? 忠：即忠誠，? 包括三重含義：企業(yè)忠于國家、忠于民族；企業(yè)忠于客戶；員工忠于企業(yè)。 <br />? 信：即誠信，做企業(yè)要立足根本道德、信義，要誠實、講信用。 <br />? 仁：即仁愛，上司對下屬要仁愛、體貼，同事之間要關(guān)懷、友愛。 <br />? 義：即大義，公司在與合作伙伴、客戶的交往過程中，不做損人利己的事，維護(hù)自己利益的前提是不損害他人利益；對民族、社會要共襄義舉，要識大義，明是非。 <br />');
INSERT INTO `dx` VALUES (4, '聯(lián)系方式', '聯(lián)系人：xxxxxxxx<br />? 電話：0000-0000000<br />? 手機：010000000000<br />? 傳真：0000-0000000<br />? 郵件：xxxxxxxx@163.com<br />? 地址：您公司的地址<br />? 網(wǎng)址：http://www.xxxx.com<br />');
-- ----------------------------
-- 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', '', '', '', '大學(xué)生成網(wǎng)絡(luò)傳銷主力 禁不起金錢誘惑是主因', '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', '', '', '', '錢庫轄區(qū)消防違法拘留公告4', 'upload/nopic6.jpg', '009', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (7, '016', '', '', '', '大學(xué)生成網(wǎng)絡(luò)傳銷主力 禁不起金錢誘惑是主因', 'upload/nopic4.jpg', '028', '是', 0, 0, '2022-03-10 16:32:38');
INSERT INTO `jianshangfenxiang` VALUES (8, '011', '', '', '', '大學(xué)生成網(wǎng)絡(luò)傳銷主力 禁不起金錢誘惑是主因', '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', '網(wǎng)友投訴：蘇寧2999元iphone根本“搶不到”', '', '鄧超', 'ok', '2022-02-22', 'upload/nopic6.jpg', 0, 0, '2022-03-10 16:32:37');
INSERT INTO `shici` VALUES (8, '310909331374', '省委創(chuàng)先爭優(yōu)辦：學(xué)習(xí)省委全會精神深化創(chuàng)先爭優(yōu)活動', '', '舒暢', '無', '2022-02-18', 'upload/nopic8.jpg', 0, 0, '2022-03-10 16:32:37');
INSERT INTO `shici` VALUES (9, '310919983284', '省委創(chuàng)先爭優(yōu)辦：學(xué)習(xí)省委全會精神深化創(chuàng)先爭優(yōu)活動', '', '吳官本', '無', '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;
