-- 删除表
DROP TABLE IF EXISTS `sys_message`;
DROP TABLE IF EXISTS `sys_column`;
DROP TABLE IF EXISTS `sys_log`;
DROP TABLE IF EXISTS `sys_quartz`;
-- 删除数据
delete from sys_config where sort > 2;
delete from sys_dict where sort > 100;
-- 测试数据
INSERT INTO `subject` VALUES ('1486582494410342401', 'item/2022/01/27/1486582426072547329.jpg', '测试数据标题11', '名称11', '1489159140648697858', '2022-02-03', '测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11测试内容11', '1466403614605258754', '2022-01-27 14:11:01', '1466403614605258754', '2022-02-03 19:04:01', 0);
INSERT INTO `subject` VALUES ('1486584129563951105', 'item/2022/01/27/1486584093128032257.jpg', '测试数据标题10', '名称10', '1489159140648697858', '2022-02-03', '测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10测试内容10', '', '2022-01-27 14:17:31', '1466403614605258754', '2022-02-03 19:03:56', 0);
INSERT INTO `subject` VALUES ('1486584220064448514', 'item/2022/01/27/1486584168566784002.jpg', '测试数据标题9', '名称9', '1489159140648697858', '2022-02-03', '测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9测试内容9', '', '2022-01-27 14:17:52', '1466403614605258754', '2022-02-03 19:03:51', 0);
INSERT INTO `subject` VALUES ('1486584318274076673', 'item/2022/01/27/1486584287890538498.jpg', '测试数据标题8', '名称8', '1489159140648697858', '2022-02-03', '测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8测试内容8', '', '2022-01-27 14:18:16', '1466403614605258754', '2022-02-03 19:03:45', 0);
INSERT INTO `subject` VALUES ('1486584393247260674', 'item/2022/01/27/1486584334308900865.jpg', '测试数据标题7', '名称7', '1489159140648697858', '2022-02-03', '测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7测试内容7', '', '2022-01-27 14:18:33', '1466403614605258754', '2022-02-03 19:03:40', 0);
INSERT INTO `subject` VALUES ('1486584494476787713', 'item/2022/01/27/1486584444912697345.jpg', '测试数据标题6', '名称6', '1489159140648697858', '2022-02-03', '测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6测试内容6', '', '2022-01-27 14:18:58', '1466403614605258754', '2022-02-03 19:03:36', 0);
INSERT INTO `subject` VALUES ('1486584545294974978', 'item/2022/01/27/1486584510952013826.jpg', '测试数据标题5', '名称5', '1489159140648697858', '2022-02-03', '测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5测试内容5', '', '2022-01-27 14:19:10', '1466403614605258754', '2022-02-03 19:03:32', 0);
INSERT INTO `subject` VALUES ('1486585512765718529', 'item/2022/01/27/1486585481677537281.jpg', '测试数据标题4', '名称4', '1489159140648697858', '2022-02-03', '测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4测试内容4', '', '2022-01-27 14:23:00', '1466403614605258754', '2022-02-03 19:03:27', 0);
INSERT INTO `subject` VALUES ('1486585565160964097', 'item/2022/01/27/1486585534391549954.jpg', '测试数据标题3', '名称3', '1489159140648697858', '2022-02-02', '测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3测试内容3', '', '2022-01-27 14:23:13', '1466403614605258754', '2022-02-03 19:03:23', 0);
INSERT INTO `subject` VALUES ('1486585627647705090', 'item/2022/01/27/1486585598627315714.jpg', '测试数据标题2', '名称2', '1489159108201562114', '2022-02-02', '测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2测试内容2', '', '2022-01-27 14:23:28', '1466403614605258754', '2022-02-03 19:03:18', 0);
INSERT INTO `subject` VALUES ('1486585676398100482', 'item/2022/01/27/1486585647952330753.jpg', '测试数据标题1', '名称1', '1489159079843872770', '2022-02-01', '测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1测试内容1', '', '2022-01-27 14:23:39', '1466403614605258754', '2022-02-03 19:03:12', 0);
-- 通知数据
INSERT INTO `notice` VALUES ('1487289033093836802', 'notice/2022/01/29/1487288994686595074.jpg', '相别之时别亦难', 1, '2022-01-29 00:00:00', '相别之时别亦难,东风无力谊浓浓;此番归去未有期,不知何时能相逢;拍照留念存美好,暂凭杯酒长精神;高声恭祝同窗好,前途远大一帆顺!', '', '2022-01-29 12:58:33', '', '2022-01-29 13:04:50', 0);
INSERT INTO `notice` VALUES ('1487289094108377089', 'notice/2022/01/29/1487289069248737281.jpg', '相识在最美的季节', 2, '2022-01-29 00:00:00', '相约在美丽的校园,意气相投;相识在最美的季节,情谊无价;相聚在青春的海洋,热情奔放;相别在毕业的时光,难舍难离。6月毕业季,祝福同窗前途辉煌,一路精彩!', '', '2022-01-29 12:58:47', '', '2022-01-29 13:32:35', 0);
INSERT INTO `notice` VALUES ('1487289143852822530', 'notice/2022/01/29/1487289119647494146.jpg', '我们拒绝伤感', 3, '2022-01-29 00:00:00', '六月,总是阳光灿烂。六月,总要曲终人散。六月,我们拒绝伤感。花儿谢了芬芳,迎来硕果飘香。毕业带来别离,我们走向辉煌。毕业了,挥挥手,祝朋友一路走好!', '', '2022-01-29 12:58:59', '', '2022-01-29 13:02:33', 0);
INSERT INTO `notice` VALUES ('1487289191936323586', 'notice/2022/01/29/1487289164660764673.jpg', '一起走过的日子格外的明亮', 1, '2022-01-29 00:00:00', '曾几何时,品尝青春的琼浆,你我共饮;曾几何时,采撷智慧的花瓣;曾几何时,畅游知识的海洋,你我悦读;曾几何时,草场并肩拼搏,你我携手。亲在的朋友,太多的回忆让一起走过的日子格外的明亮,只希望未来的路,你我都好。', '', '2022-01-29 12:59:11', '', '2022-01-29 13:05:21', 0);
INSERT INTO `notice` VALUES ('1487289234722418689', 'notice/2022/01/29/1487289207157452801.jpg', '夏花盛放的季节', 2, '2022-01-29 00:00:00', '夏花盛放的季节,我们相聚在一起;秋果飘香的季节,我们形影不离;冬雪纷飞的季节,我们不离不弃;柳叶起舞的季节,我们并肩而战。又是一年夏花盛放,又是一年六月到,我们却要挥手作别。亲爱的挚友们,来年的六月我们再相会。', '', '2022-01-29 12:59:21', '', '2022-01-29 13:01:15', 0);
//获取柱状图
DataLine line = ChartUtils.createLine();
Map<String, IntSummaryStatistics> collect = list.stream().collect(Collectors.groupingBy(Fee::getOfficeId, Collectors.summarizingInt(Fee::getFeeAmount)));
for (Map.Entry<String, IntSummaryStatistics> entry : collect.entrySet()) {
System.out.println("Key = " + entry.getKey() + ", Value = " + entry.getValue());
line.getxData().add(entry.getKey());
line.getyData().add(entry.getValue().getSum()+"");
}
return ResultInfo.ok("获取柱状图成功", lin
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![zip](https://img-home.csdnimg.cn/images/20210720083736.png)
![py](https://img-home.csdnimg.cn/images/20210720083646.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![rar](https://img-home.csdnimg.cn/images/20210720083606.png)
![pdf](https://img-home.csdnimg.cn/images/20210720083512.png)
收起资源包目录
![package](https://csdnimg.cn/release/downloadcmsfe/public/img/package.f3fc750b.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/UNKNOWN.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
![file-type](https://csdnimg.cn/release/download/static_files/pc/images/minetype/GIF.png)
共 1403 条
- 1
- 2
- 3
- 4
- 5
- 6
- 15
资源评论
![avatar-default](https://csdnimg.cn/release/downloadcmsfe/public/img/lazyLogo2.1882d7f4.png)
- wxdanniu052024-03-06终于找到了超赞的宝藏资源,果断冲冲冲,支持!
![avatar](https://profile-avatar.csdnimg.cn/d4bb382e060d455f8728e6d8c9e204ca_qq_36584673.jpg!1)
![avatar-vip](https://csdnimg.cn/release/downloadcmsfe/public/img/user-vip.1c89f3c5.png)
十小大
- 粉丝: 1w+
- 资源: 1518
上传资源 快速赚钱
我的内容管理 展开
我的资源 快来上传第一个资源
我的收益
登录查看自己的收益我的积分 登录查看自己的积分
我的C币 登录后查看C币余额
我的收藏
我的下载
下载帮助
![voice](https://csdnimg.cn/release/downloadcmsfe/public/img/voice.245cc511.png)
![center-task](https://csdnimg.cn/release/downloadcmsfe/public/img/center-task.c2eda91a.png)
安全验证
文档复制为VIP权益,开通VIP直接复制
![dialog-icon](https://csdnimg.cn/release/downloadcmsfe/public/img/green-success.6a4acb44.png)