现代经济快节奏发展以及不断完善升级的信息化技术,让传统数据信息的管理升级为软件存储,归纳,集中处理数据信息的管理方式。本税务门户网站就是在这样的大环境下诞生,其可以帮助管理者在短时间内处理完毕庞大的数据信息,使用这种软件工具可以帮助管理人员提高事务处理效率,达到事半功倍的效果。此税务门户网站利用当下成熟完善的SSM框架,使用跨平台的可开发大型商业网站的Java语言,以及最受欢迎的RDBMS应用软件之一的Mysql数据库进行程序开发。实现了用户在线选择试题并完成答题,在线查看考核分数。管理员管理客服聊天管理、单位信息管理、字典管理、通知通知公告管理、留言板管理、纳税服务投诉管理、新闻信息管理、人事任免管理、税务欠款管理、违法税收检举管理、意见征集管理、用户管理、政策文件管理、政策文件收藏管理、政策解读管理、政策解读收藏管理、管理员管理等功能。税务门户网站的开发根据操作人员需要设计的界面简洁美观,在功能模块布局上跟同类型网站保持一致,程序在实现基本要求功能时,也为数据信息面临的安全问题提供了一些实用的解决方案。可以说该程序在帮助管理者高效率地处理工作事务的同时,也实现了数据信息的整体化,规范化与自动化。
推荐使用:谷歌浏览器
前台登录页面
http://localhost:8080/shuiwumenhuwangzhan/front/index.html
后台登录页面
http://localhost:8080/shuiwumenhuwangzhan/admin/dist/index.html
管理员 账户:admin 密码:admin
用户 账户:a1 密码:123456
用户 账户:a2 密码:123456
用户 账户:a3 密码:123456
在src\main\resources\config.properties中编辑
jdbc_url=jdbc:mysql://127.0.0.1:3306/shuiwumenhuwangzhan?useUnicode=true&characterEncoding=UTF-8&tinyInt1isBit=false
jdbc_username=root 数据库用户名 root
jdbc_password=123456 用户密码 123456
图片存放路径: src\main\webapp\upload 里面上传图片名里面不能有中文
/*
SQLyog Ultimate v11.3 (64 bit)
MySQL - 5.7.32-log : Database - shuiwumenhuwangzhan
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`shuiwumenhuwangzhan` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `shuiwumenhuwangzhan`;
/*Table structure for table `chat` */
DROP TABLE IF EXISTS `chat`;
CREATE TABLE `chat` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`yonghu_id` int(11) DEFAULT NULL COMMENT '提问用户',
`chat_issue` varchar(200) DEFAULT NULL COMMENT '问题',
`issue_time` timestamp NULL DEFAULT NULL COMMENT '问题时间 Search111',
`chat_reply` varchar(200) DEFAULT NULL COMMENT '回复',
`reply_time` timestamp NULL DEFAULT NULL COMMENT '回复时间 Search111',
`zhuangtai_types` int(255) DEFAULT NULL COMMENT '状态',
`chat_types` int(11) DEFAULT NULL COMMENT '数据类型',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='客服聊天';
/*Data for the table `chat` */
insert into `chat`(`id`,`yonghu_id`,`chat_issue`,`issue_time`,`chat_reply`,`reply_time`,`zhuangtai_types`,`chat_types`,`insert_time`) values (1,1,'三生三世','2022-05-12 16:00:21',NULL,NULL,2,1,'2022-05-12 16:00:21'),(2,1,NULL,NULL,'三生三世付','2022-05-12 16:00:35',NULL,2,'2022-05-12 16:00:36'),(3,1,'啊啊啊啊','2022-05-12 16:39:16',NULL,NULL,2,1,'2022-05-12 16:39:17'),(4,1,NULL,NULL,'更好看看看','2022-05-12 16:39:37',NULL,2,'2022-05-12 16:39:38');
/*Table structure for table `config` */
DROP TABLE IF EXISTS `config`;
DROP TABLE IF EXISTS `gonggao`;
CREATE TABLE `gonggao` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`gonggao_name` varchar(200) DEFAULT NULL COMMENT '通知公告名称 Search111 ',
`gonggao_photo` varchar(200) DEFAULT NULL COMMENT '通知公告图片 ',
`gonggao_types` int(11) NOT NULL COMMENT '通知公告类型 Search111 ',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '通知公告发布时间 ',
`gonggao_content` text COMMENT '通知公告详细内容 ',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='通知公告';
/*Data for the table `gonggao` */
insert into `gonggao`(`id`,`gonggao_name`,`gonggao_photo`,`gonggao_types`,`insert_time`,`gonggao_content`,`create_time`) values (1,'通知公告名称1','http://localhost:8080/shuiwumenhuwangzhan/upload/gonggao1.jpg',1,'2022-05-12 14:02:56','通知公告详细内容1','2022-05-12 14:02:56'),(2,'通知公告名称2','http://localhost:8080/shuiwumenhuwangzhan/upload/gonggao2.jpg',1,'2022-05-12 14:02:56','通知公告详细内容2','2022-05-12 14:02:56'),(3,'通知公告名称3','http://localhost:8080/shuiwumenhuwangzhan/upload/gonggao3.jpg',1,'2022-05-12 14:02:56','通知公告详细内容3','2022-05-12 14:02:56'),(4,'通知公告名称4','http://localhost:8080/shuiwumenhuwangzhan/upload/gonggao4.jpg',1,'2022-05-12 14:02:56','通知公告详细内容4','2022-05-12 14:02:56'),(5,'通知公告名称5','http://localhost:8080/shuiwumenhuwangzhan/upload/gonggao5.jpg',1,'2022-05-12 14:02:56','通知公告详细内容5','2022-05-12 14:02:56');
/*Table structure for table `liuyan` */
DROP TABLE IF EXISTS `liuyan`;
CREATE TABLE `liuyan` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`liuyan_name` varchar(200) DEFAULT NULL COMMENT '留言标题 Search111 ',
`liuyan_text` text COMMENT '留言内容',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '留言时间',
`reply_text` text COMMENT '回复内容',
`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show2 nameShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='留言板';
/*Data for the table `liuyan` */
insert into `liuyan`(`id`,`yonghu_id`,`liuyan_name`,`liuyan_text`,`insert_time`,`reply_text`,`update_time`,`create_time`) values (1,3,'留言标题1','留言内容1','2022-05-12 14:02:56','回复信息1','2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,1,'留言标题2','留言内容2','2022-05-12 14:02:56','回复信息2','2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,3,'留言标题3','留言内容3','2022-05-12 14:02:56','回复信息3','2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,3,'留言标题4','留言内容4','2022-05-12 14:02:56','回复信息4','2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,3,'留言标题5','留言内容5','2022-05-12 14:02:56','回复信息5','2022-05-12 14:02:56','2022-05-12 14:02:56'),(6,1,'标题111','都是水电费华盛顿凤凰','2022-05-12 16:37:07','水水水灌管','2022-05-12 16:40:41','2022-05-12 16:37:07');
/*Table structure for table `nashuifuwutousu` */
DROP TABLE IF EXISTS `nashuifuwutousu`;
CREATE TABLE `nashuifuwutousu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`nashuifuwutousu_name` varchar(200) DEFAULT NULL COMMENT '纳税服务投诉名称 Search111 ',
`nashuifuwutousu_uuid_number` varchar(200) DEFAULT NULL COMMENT '纳税服务投诉编号 Search111 ',
`nashuifuwutousu_photo` varchar(200) DEFAULT NULL COMMENT '纳税服务投诉证据文件',
`nashuifuwutousu_types` int(11) DEFAULT NULL COMMENT '纳税服务投诉类型 Search111',
`nashuifuwutousu_text` text COMMENT '纳税服务投诉内容',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '投诉时间',
`nashuifuwutousu_chuli_types` int(11) DEFAULT NULL COMMENT '状态 Search111',
`nashuifuwutousu_chuli_text` text COMMENT '处理结果',
`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='纳税服务投诉';
/*Data for the table `nashuifuwutousu` */
insert into `nashuifuwutousu`(`id`,`yonghu_id`,`nashuifuwutousu_name`,`nashuifuwutousu_uuid_number`,`nashuifuwutousu_photo`,`nashuifuwutousu_types`,`nashuifuwutousu_text`,`insert_time`,`nashuifuwutousu_chuli_types`,`nashuifuwutousu_chuli_text`,`update_time`,`create_time`) values (1,1,'纳税服务投诉名称1','165233537649661','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,'纳税服务投诉内容1','2022-05-12 14:02:56',1,'处理结果1','2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,1,'纳税服务投诉名称2','165233537649648','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,'纳税服务投诉内容2','2022-05-12 14:02:56',2,'处理结果2','2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,2,'纳税服务投诉名称3','165233537649661','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,'纳税服务投诉内容3','2022-05-12 14:02:56',1,'处理结果3','2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,2,'纳税服务投诉名称4','165233537649728','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',1,'纳税服务投诉内容4','2022-05-12 14:02:56',1,'处理结果4','2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,2,'纳税服务投诉名称5','16523353764974','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,'纳税服务投诉内容5','2022-05-12 14:02:56',2,'处理结果5','2022-05-12 14:02:56','2022-05-12 14:02:56'),(6,1,'纳税服务投诉名称111','1652340453993','http://localhost:8080/shuiwumenhuwangzhan/upload/1652340492539.rar',2,'发大叔大婶闪电发货','2022-05-12 15:28:18',1,NULL,NULL,'2022-05-12 15:28:18'),(7,1,'灌灌灌灌','1652344719287','http://localhost:8080/shuiwumenhuwangzhan/upload/1652344724475.rar',3,'呱唧呱唧kg还款','2022-05-12 16:38:47',2,'逛逛街','2022-05-12 16:41:27','2022-05-12 16:38:47');
/*Table structure for table `news` */
DROP TABLE IF EXISTS `news`;
CREATE TABLE `news` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`news_name` varchar(200) DEFAULT NULL COMMENT '新闻名称 Search111 ',
`news_photo` varchar(200) DEFAULT NULL COMMENT '新闻图片 ',
`news_types` int(11) NOT NULL COMMENT '新闻类型 Search111 ',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '新闻发布时间 ',
`news_content` text COMMENT '新闻详情 ',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='新闻信息';
/*Data for the table `news` */
insert into `news`(`id`,`news_name`,`news_photo`,`news_types`,`insert_time`,`news_content`,`create_time`) values (1,'新闻名称1','http://localhost:8080/shuiwumenhuwangzhan/upload/news1.jpg',3,'2022-05-12 14:02:56','新闻详情1','2022-05-12 14:02:56'),(2,'新闻名称2','http://localhost:8080/shuiwumenhuwangzhan/upload/news2.jpg',3,'2022-05-12 14:02:56','新闻详情2','2022-05-12 14:02:56'),(3,'新闻名称3','http://localhost:8080/shuiwumenhuwangzhan/upload/news3.jpg',2,'2022-05-12 14:02:56','新闻详情3','2022-05-12 14:02:56'),(4,'新闻名称4','http://localhost:8080/shuiwumenhuwangzhan/upload/news4.jpg',3,'2022-05-12 14:02:56','新闻详情4','2022-05-12 14:02:56'),(5,'新闻名称5','http://localhost:8080/shuiwumenhuwangzhan/upload/news5.jpg',3,'2022-05-12 14:02:56','新闻详情5','2022-05-12 14:02:56');
/*Table structure for table `renshirenmian` */
DROP TABLE IF EXISTS `renshirenmian`;
CREATE TABLE `renshirenmian` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`renshirenmian_name` varchar(200) DEFAULT NULL COMMENT '人事任免标题 Search111 ',
`renshirenmian_types` int(11) NOT NULL COMMENT '人事任免类型 Search111 ',
`renshirenmian_photo` varchar(200) DEFAULT NULL COMMENT '人事任免图片 ',
`renshirenmian_xingming` varchar(200) DEFAULT NULL COMMENT '姓名 Search111 ',
`renshirenmian_yuanzhiwei` varchar(200) DEFAULT NULL COMMENT '原职位 Search111 ',
`renshirenmian_xianzhiwei` varchar(200) DEFAULT NULL COMMENT '现职位 Search111 ',
`renshirenmian_content` text COMMENT '人事任免详细内容 ',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '人事任免发布时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 nameShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='人事任免';
/*Data for the table `renshirenmian` */
insert into `renshirenmian`(`id`,`renshirenmian_name`,`renshirenmian_types`,`renshirenmian_photo`,`renshirenmian_xingming`,`renshirenmian_yuanzhiwei`,`renshirenmian_xianzhiwei`,`renshirenmian_content`,`insert_time`,`create_time`) values (1,'人事任免标题1',2,'http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu1.jpg','姓名1','原职位1','现职位1','人事任免详细内容1','2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,'人事任免标题2',2,'http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu2.jpg','姓名2','原职位2','现职位2','人事任免详细内容2','2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,'人事任免标题3',1,'http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu3.jpg','姓名3','原职位3','现职位3','人事任免详细内容3','2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,'人事任免标题4',2,'http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu1.jpg','姓名4','原职位4','现职位4','人事任免详细内容4','2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,'人事任免标题5',1,'http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu2.jpg','姓名5','原职位5','现职位5111','<p>人事任免详细内容5打电话和</p>','2022-05-12 14:02:56','2022-05-12 14:02:56');
/*Table structure for table `shuiwuqiankuan` */
DROP TABLE IF EXISTS `shuiwuqiankuan`;
CREATE TABLE `shuiwuqiankuan` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`shuiwuqiankuan_uuid_number` varchar(200) DEFAULT NULL COMMENT '税务欠款编号 Search111 ',
`shuiwuqiankuan_name` varchar(200) DEFAULT NULL COMMENT '税务欠款名称 Search111 ',
`shuiwuqiankuan_types` int(11) DEFAULT NULL COMMENT '税务欠款类型 Search111',
`shuiwuqiankuan_text` text COMMENT '欠款缘由',
`shuiwuqiankuan_new_money` decimal(10,2) DEFAULT NULL COMMENT '欠款金额',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '通知时间',
`jiaofei_types` int(11) DEFAULT NULL COMMENT '是否缴费 Search111',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='税务欠款';
/*Data for the table `shuiwuqiankuan` */
insert into `shuiwuqiankuan`(`id`,`yonghu_id`,`shuiwuqiankuan_uuid_number`,`shuiwuqiankuan_name`,`shuiwuqiankuan_types`,`shuiwuqiankuan_text`,`shuiwuqiankuan_new_money`,`insert_time`,`jiaofei_types`,`create_time`) values (1,2,'165233537651378','税务欠款名称1',1,'欠款缘由1','435.73','2022-05-12 14:02:56',1,'2022-05-12 14:02:56'),(2,3,'165233537651743','税务欠款名称2',3,'欠款缘由2','373.83','2022-05-12 14:02:56',2,'2022-05-12 14:02:56'),(3,1,'16523353765171','税务欠款名称3',1,'欠款缘由3','204.10','2022-05-12 14:02:56',2,'2022-05-12 14:02:56'),(4,1,'165233537651718','税务欠款名称4',2,'欠款缘由4','33.07','2022-05-12 14:02:56',2,'2022-05-12 14:02:56'),(5,2,'165233537651765','税务欠款名称5',3,'欠款缘由5','447.89','2022-05-12 14:02:56',1,'2022-05-12 14:02:56'),(6,1,'1652344855540','家佛诶11',2,'阿萨德刚打的是个','3333.00','2022-05-12 16:41:07',1,'2022-05-12 16:41:07');
/*Table structure for table `token` */
DROP TABLE IF EXISTS `token`;
CREATE TABLE `token` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`userid` bigint(20) NOT NULL COMMENT '用户id',
`username` varchar(100) NOT NULL COMMENT '用户名',
`tablename` varchar(100) DEFAULT NULL COMMENT '表名',
`role` varchar(100) DEFAULT NULL COMMENT '角色',
`token` varchar(200) NOT NULL COMMENT '密码',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
`expiratedtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '过期时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='token表';
/*Data for the table `token` */
insert into `token`(`id`,`userid`,`username`,`tablename`,`role`,`token`,`addtime`,`expiratedtime`) values (1,6,'admin','users','管理员','g7p863zflhre5fc8mhjr3mtx32g0zu99','2022-05-12 14:14:17','2022-05-12 17:39:21'),(2,1,'a1','yonghu','用户','q4mq96hhthu1icyz5je5sf8ystjirprm','2022-05-12 14:28:49','2022-05-12 17:35:59');
/*Table structure for table `users` */
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
`id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(100) NOT NULL COMMENT '用户名',
`password` varchar(100) NOT NULL COMMENT '密码',
`role` varchar(100) DEFAULT '管理员' COMMENT '角色',
`addtime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '新增时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='管理员';
/*Data for the table `users` */
insert into `users`(`id`,`username`,`password`,`role`,`addtime`) values (6,'admin','admin','管理员','2022-05-02 14:51:13');
/*Table structure for table `weifashuishou` */
DROP TABLE IF EXISTS `weifashuishou`;
CREATE TABLE `weifashuishou` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`weifashuishou_name` varchar(200) DEFAULT NULL COMMENT '违法税收检举名称 Search111 ',
`weifashuishou_uuid_number` varchar(200) DEFAULT NULL COMMENT '违法税收检举编号 Search111 ',
`weifashuishou_photo` varchar(200) DEFAULT NULL COMMENT '违法税收检举证据文件',
`weifashuishou_types` int(11) DEFAULT NULL COMMENT '违法税收检举类型 Search111',
`weifashuishou_text` text COMMENT '违法税收检举内容',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '检举时间',
`weifashuishou_chuli_types` int(11) DEFAULT NULL COMMENT '状态 Search111',
`weifashuishou_chuli_text` text COMMENT '处理结果',
`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='违法税收检举';
/*Data for the table `weifashuishou` */
insert into `weifashuishou`(`id`,`yonghu_id`,`weifashuishou_name`,`weifashuishou_uuid_number`,`weifashuishou_photo`,`weifashuishou_types`,`weifashuishou_text`,`insert_time`,`weifashuishou_chuli_types`,`weifashuishou_chuli_text`,`update_time`,`create_time`) values (1,1,'违法税收检举名称1','165233537652040','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,'违法税收检举内容1','2022-05-12 14:02:56',2,'处理结果1','2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,3,'违法税收检举名称2','165233537652014','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',2,'违法税收检举内容2','2022-05-12 14:02:56',2,'处理结果2','2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,2,'违法税收检举名称3','165233537652082','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',3,'违法税收检举内容3','2022-05-12 14:02:56',2,'处理结果3','2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,3,'违法税收检举名称4','165233537652030','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',2,'违法税收检举内容4','2022-05-12 14:02:56',1,'处理结果4','2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,3,'违法税收检举名称5','165233537652051','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',3,'违法税收检举内容5','2022-05-12 14:02:56',1,'处理结果5','2022-05-12 14:02:56','2022-05-12 14:02:56'),(6,1,'都是水电费恢复的','1652339762310','http://localhost:8080/shuiwumenhuwangzhan/upload/1652339773605.rar',3,'三十多岁的观点和防护','2022-05-12 15:17:19',1,NULL,NULL,'2022-05-12 15:17:19'),(7,1,'法规的房间','1652339871680','http://localhost:8080/shuiwumenhuwangzhan/upload/1652342737874.rar',4,'丰富感觉','2022-05-12 15:18:00',2,'懂法守法啥都会','2022-05-12 16:05:42','2022-05-12 15:18:00'),(8,1,'少时诵诗书','1652344691207','http://localhost:8080/shuiwumenhuwangzhan/upload/1652344697140.rar',4,'大叔大婶','2022-05-12 16:38:22',2,'非法拘禁','2022-05-12 16:41:20','2022-05-12 16:38:22');
/*Table structure for table `yijianzhengji` */
DROP TABLE IF EXISTS `yijianzhengji`;
CREATE TABLE `yijianzhengji` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`yijianzhengji_name` varchar(200) DEFAULT NULL COMMENT '意见征集名称 Search111 ',
`yijianzhengji_uuid_number` varchar(200) DEFAULT NULL COMMENT '意见征集编号 Search111 ',
`yijianzhengji_photo` varchar(200) DEFAULT NULL COMMENT '意见征集文件',
`yijianzhengji_types` int(11) DEFAULT NULL COMMENT '意见征集类型 Search111',
`yijianzhengji_text` text COMMENT '意见征集内容',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '上传时间',
`yijianzhengji_chuli_types` int(11) DEFAULT NULL COMMENT '状态 Search111',
`yijianzhengji_chuli_text` text COMMENT '回复结果',
`update_time` timestamp NULL DEFAULT NULL COMMENT '回复时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='意见征集';
/*Data for the table `yijianzhengji` */
insert into `yijianzhengji`(`id`,`yonghu_id`,`yijianzhengji_name`,`yijianzhengji_uuid_number`,`yijianzhengji_photo`,`yijianzhengji_types`,`yijianzhengji_text`,`insert_time`,`yijianzhengji_chuli_types`,`yijianzhengji_chuli_text`,`update_time`,`create_time`) values (1,1,'意见征集名称1','165233537652330','http://localhost:8080/shuiwumenhuwangzhan/upload/yijianzhengji1.jpg',4,'意见征集内容1','2022-05-12 14:02:56',2,'回复结果1','2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,1,'意见征集名称2','16523353765235','http://localhost:8080/shuiwumenhuwangzhan/upload/yijianzhengji2.jpg',2,'意见征集内容2','2022-05-12 14:02:56',2,'回复结果2','2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,2,'意见征集名称3','165233537652394','http://localhost:8080/shuiwumenhuwangzhan/upload/yijianzhengji3.jpg',1,'意见征集内容3','2022-05-12 14:02:56',2,'回复结果3','2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,3,'意见征集名称4','165233537652327','http://localhost:8080/shuiwumenhuwangzhan/upload/yijianzhengji4.jpg',4,'意见征集内容4','2022-05-12 14:02:56',2,'回复结果4','2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,2,'意见征集名称5','165233537652370','http://localhost:8080/shuiwumenhuwangzhan/upload/yijianzhengji5.jpg',2,'意见征集内容5','2022-05-12 14:02:56',2,'回复结果5','2022-05-12 14:02:56','2022-05-12 14:02:56'),(6,1,'名称111','1652341087683','http://localhost:8080/shuiwumenhuwangzhan/upload/1652341104295.rar',4,'发送到发动机','2022-05-12 15:38:32',1,NULL,NULL,'2022-05-12 15:38:32'),(7,1,'电动机很纠结','1652344736246','http://localhost:8080/shuiwumenhuwangzhan/upload/1652344741738.rar',3,'非公经济','2022-05-12 16:39:05',2,'发动机的房间','2022-05-12 16:41:38','2022-05-12 16:39:05');
/*Table structure for table `yonghu` */
DROP TABLE IF EXISTS `yonghu`;
CREATE TABLE `yonghu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`username` varchar(200) DEFAULT NULL COMMENT '账户',
`password` varchar(200) DEFAULT NULL COMMENT '密码',
`yonghu_name` varchar(200) DEFAULT NULL COMMENT '用户姓名 Search111 ',
`yonghu_phone` varchar(200) DEFAULT NULL COMMENT '用户手机号',
`yonghu_id_number` varchar(200) DEFAULT NULL COMMENT '用户身份证号',
`yonghu_photo` varchar(200) DEFAULT NULL COMMENT '用户头像',
`sex_types` int(11) DEFAULT NULL COMMENT '性别',
`yonghu_email` varchar(200) DEFAULT NULL COMMENT '电子邮箱',
`new_money` decimal(10,2) DEFAULT NULL COMMENT '余额 ',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='用户';
/*Data for the table `yonghu` */
insert into `yonghu`(`id`,`username`,`password`,`yonghu_name`,`yonghu_phone`,`yonghu_id_number`,`yonghu_photo`,`sex_types`,`yonghu_email`,`new_money`,`create_time`) values (1,'a1','123456','用户姓名1','17703786901','410224199610232001','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu1.jpg',1,'1@qq.com','144.62','2022-05-12 14:02:56'),(2,'a2','123456','用户姓名2','17703786902','410224199610232002','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu2.jpg',1,'2@qq.com','826.67','2022-05-12 14:02:56'),(3,'a3','123456','用户姓名3','17703786903','410224199610232003','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu3.jpg',2,'3@qq.com','703.03','2022-05-12 14:02:56');
/*Table structure for table `zhegncewenjian` */
DROP TABLE IF EXISTS `zhegncewenjian`;
CREATE TABLE `zhegncewenjian` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`zhegncewenjian_name` varchar(200) DEFAULT NULL COMMENT '政策文件名称 Search111 ',
`zhegncewenjian_uuid_number` varchar(200) DEFAULT NULL COMMENT '政策文件编号 Search111 ',
`zhegncewenjian_photo` varchar(200) DEFAULT NULL COMMENT '政策文件照片',
`zhegncewenjian_file` varchar(200) DEFAULT NULL COMMENT '文件',
`zhegncewenjian_types` int(11) DEFAULT NULL COMMENT '政策文件类型 Search111',
`zhegncewenjian_clicknum` int(11) DEFAULT NULL COMMENT '政策文件热度 ',
`zhegncewenjian_content` text COMMENT '政策文件内容 ',
`shangxia_types` int(11) DEFAULT NULL COMMENT '是否上架 ',
`zhegncewenjian_delete` int(11) DEFAULT NULL COMMENT '逻辑删除',
`fabu_time` timestamp NULL DEFAULT NULL COMMENT '发布时间',
`zhixing_time` timestamp NULL DEFAULT NULL COMMENT '执行时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='政策文件';
/*Data for the table `zhegncewenjian` */
insert into `zhegncewenjian`(`id`,`zhegncewenjian_name`,`zhegncewenjian_uuid_number`,`zhegncewenjian_photo`,`zhegncewenjian_file`,`zhegncewenjian_types`,`zhegncewenjian_clicknum`,`zhegncewenjian_content`,`shangxia_types`,`zhegncewenjian_delete`,`fabu_time`,`zhixing_time`,`create_time`) values (1,'政策文件名称1','165233537653370','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu1.jpg','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',2,106,'政策文件内容1',1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,'政策文件名称2','165233537653372','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu2.jpg','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',3,59,'政策文件内容2',1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,'政策文件名称3','165233537653359','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu3.jpg','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,443,'政策文件内容3',1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,'政策文件名称4','165233537653386','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu1.jpg','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,37,'政策文件内容4',1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,'政策文件名称5','165233537653335','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu2.jpg','http://localhost:8080/shuiwumenhuwangzhan/upload/file.rar',4,71,'政策文件内容5',1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56','2022-05-12 14:02:56');
/*Table structure for table `zhegncewenjian_collection` */
DROP TABLE IF EXISTS `zhegncewenjian_collection`;
CREATE TABLE `zhegncewenjian_collection` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`zhegncewenjian_id` int(11) DEFAULT NULL COMMENT '政策文件',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`zhegncewenjian_collection_types` int(11) DEFAULT NULL COMMENT '类型',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '收藏时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='政策文件收藏';
/*Data for the table `zhegncewenjian_collection` */
insert into `zhegncewenjian_collection`(`id`,`zhegncewenjian_id`,`yonghu_id`,`zhegncewenjian_collection_types`,`insert_time`,`create_time`) values (1,1,1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,2,1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,3,2,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,4,2,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,5,2,1,'2022-05-12 14:02:56','2022-05-12 14:02:56');
/*Table structure for table `zhengcejiedu` */
DROP TABLE IF EXISTS `zhengcejiedu`;
CREATE TABLE `zhengcejiedu` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键 ',
`zhegncewenjian_id` int(11) DEFAULT NULL COMMENT '政策文件',
`zhengcejiedu_name` varchar(200) DEFAULT NULL COMMENT '政策解读名称 Search111 ',
`zhengcejiedu_photo` varchar(200) DEFAULT NULL COMMENT '政策解读照片',
`zhengcejiedu_content` text COMMENT '政策解读内容 ',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show1 show2 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='政策解读';
/*Data for the table `zhengcejiedu` */
insert into `zhengcejiedu`(`id`,`zhegncewenjian_id`,`zhengcejiedu_name`,`zhengcejiedu_photo`,`zhengcejiedu_content`,`create_time`) values (1,1,'政策解读名称1','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu1.jpg','政策解读内容1','2022-05-12 14:02:56'),(2,2,'政策解读名称2','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu2.jpg','政策解读内容2','2022-05-12 14:02:56'),(3,3,'政策解读名称3','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu3.jpg','政策解读内容3','2022-05-12 14:02:56'),(4,4,'政策解读名称4','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu1.jpg','政策解读内容4','2022-05-12 14:02:56'),(5,3,'政策解读名称5','http://localhost:8080/shuiwumenhuwangzhan/upload/yonghu2.jpg','<p>政策解读内容5</p>','2022-05-12 14:02:56');
/*Table structure for table `zhengcejiedu_collection` */
DROP TABLE IF EXISTS `zhengcejiedu_collection`;
CREATE TABLE `zhengcejiedu_collection` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`zhengcejiedu_id` int(11) DEFAULT NULL COMMENT '政策解读',
`yonghu_id` int(11) DEFAULT NULL COMMENT '用户',
`zhengcejiedu_collection_types` int(11) DEFAULT NULL COMMENT '类型',
`insert_time` timestamp NULL DEFAULT NULL COMMENT '收藏时间',
`create_time` timestamp NULL DEFAULT NULL COMMENT '创建时间 show3 photoShow',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='政策解读收藏';
/*Data for the table `zhengcejiedu_collection` */
insert into `zhengcejiedu_collection`(`id`,`zhengcejiedu_id`,`yonghu_id`,`zhengcejiedu_collection_types`,`insert_time`,`create_time`) values (1,1,3,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(2,2,3,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(3,3,1,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(4,4,3,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(5,5,2,1,'2022-05-12 14:02:56','2022-05-12 14:02:56'),(6,1,1,1,'2022-05-12 14:40:47','2022-05-12 14:40:47');
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;