基于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;
