打卡 热度图
1、热度图地址 及 JS代码
点击： Examples - Apache ECharts，粘贴以下示例代码，然后在
// prettier-ignore
const data =
[ 这里粘贴上Java 代码 生成的 CoordFile.txt 的数据 ]
// prettier-ignore const hours = [ '8:45', '8:47', '8:49', '8:51', '8:53', '8:55', '8:57', '8:59', '9:01', '9:03', '9:05', '9:07', '9:09','9:11', '9:13', '9:15', '9:17', '9:19', '9:21', '9:23', '9:25','9:27','9:29','9:31', '9:33', '9:35', '9:37', '9:39', '9:41', '9:43', '9:45', '9:47', '9:49', '9:51', '9:53', '9:55', '9:57', '9:59', '10:01', '10:03' ]; // prettier-ignore const days = [ '31 日', '30 六', '29 五', '28 四', '27 三', '26 二', '25 一', '24 日', '23 六', '22 五', '21 四', '20 三', '19 二', '18 一' ]; // prettier-ignore const data = [ [2,1,1],[2,4,1],[2,7,2],[2,9,1],[2,10,2],[2,11,1],[2,13,2],[2,15,5],[2,17,4],[2,18,5],[2,19,4],[2,20,7],[2,21,2],[2,22,1],[2,31,2],[2,33,1],[2,37,1],[3,2,2],[3,5,1],[3,9,1],[3,11,2],[3,12,1],[3,13,2],[3,14,1],[3,15,4],[3,16,5],[3,17,2],[3,18,2],[3,19,7],[3,20,2],[3,21,6],[3,22,1],[3,26,1],[3,37,2],[4,10,1],[4,11,5],[4,12,1],[4,13,2],[4,14,1],[4,15,1],[4,16,4],[4,17,2],[4,18,3],[4,19,1],[4,20,7],[4,21,7],[4,22,3],[4,24,1],[4,29,1],[4,37,2],[5,4,1],[5,7,1],[5,9,1],[5,11,2],[5,12,2],[5,13,1],[5,15,3],[5,16,2],[5,17,1],[5,18,4],[5,19,4],[5,20,3],[5,21,5],[5,22,3],[5,23,3],[5,31,1],[5,37,5],[6,6,1],[6,9,1],[6,11,1],[6,13,2],[6,14,4],[6,15,2],[6,16,2],[6,17,2],[6,19,10],[6,20,4],[6,21,4],[6,22,4],[6,37,4],[8,1,1],[8,3,2],[8,5,1],[8,8,1],[8,10,3],[8,11,2],[8,13,2],[8,16,1],[8,17,2],[8,19,4],[8,20,7],[8,21,3],[8,28,1],[8,37,8],[9,-2,1],[9,-1,1],[9,0,1],[9,5,1],[9,10,1],[9,12,1],[9,13,1],[9,14,1],[9,15,4],[9,16,3],[9,18,9],[9,19,7],[9,20,3],[9,21,2],[9,30,1],[9,37,1],[10,10,2],[10,12,6],[10,13,2],[10,14,2],[10,15,3],[10,16,2],[10,17,2],[10,19,2],[10,20,6],[10,21,2],[10,22,2],[10,25,1],[11,10,3],[11,12,1],[11,13,1],[11,14,4],[11,15,2],[11,16,1],[11,17,2],[11,18,6],[11,19,4],[11,20,7],[11,22,1],[12,2,1],[12,7,2],[12,9,1],[12,11,1],[12,13,2],[12,14,1],[12,15,3],[12,16,4],[12,17,4],[12,18,2],[12,19,4],[12,20,1],[12,21,5],[12,22,2],[12,23,1],[12,30,1],[12,37,2],[13,10,1],[13,11,1],[13,13,1],[13,14,4],[13,15,2],[13,17,1],[13,18,6],[13,19,9],[13,20,1],[13,21,4],[13,22,3],[13,28,1],[13,37,3],[18,1,1],[18,5,1],[18,9,3],[18,12,3],[18,13,1],[18,14,3],[18,16,3],[18,17,3],[18,18,3],[18,19,2],[18,20,6],[18,21,1],[18,25,1],[18,37,1], ] .map(function (item) { return [item[1], item[0], item[2] || '-']; }); option = { tooltip: { position: 'top' }, grid: { height: '50%', top: '10%' }, xAxis: { type: 'category', data: hours, splitArea: { show: true } }, yAxis: { type: 'category', data: days, splitArea: { show: true } }, visualMap: { min: 0, max: 10, calculable: true, orient: 'horizontal', left: 'center', bottom: '15%' }, series: [ { name: 'Punch Card', type: 'heatmap', data: data, label: { show: true }, emphasis: { itemStyle: { shadowBlur: 10, shadowColor: 'rgba(0, 0, 0, 0.5)' } } } ] };
2、表设计
create table t_punch_in( id int primary key auto_increment, time varchar(255), `name` varchar(255), gender varchar(5), remark varchar(255), insertTime datetime )
insert into table t_punch_in values(67,'2022-07-19 9:31','张三','M','公司办公','2022-07-23 12:29:35'); insert into table t_punch_in values(88,'2022-07-18 9:23','张三','M','公司办公','2022-07-23 12:31:51'); insert into table t_punch_in values(112,'2022-07-20 9:10','张三','M','公司办公','2022-07-23 12:34:06'); insert into table t_punch_in values(140,'2022-07-21 9:06','张三','M','公司办公','2022-07-23 12:35:26'); insert into table t_punch_in values(174,'2022-07-22 8:46','张三','M','公司办公','2022-07-23 12:37:09'); insert into table t_punch_in values(221,'2022-07-23 9:12','张三','M','公司办公','2022-07-23 17:11:46'); insert into table t_punch_in values(291,'2022-07-25 9:03','张三','M','公司办公','2022-07-25 19:18:36'); insert into table t_punch_in values(335,'2022-07-26 9:04','张三','M','公司办公','2022-07-26 16:12:55'); insert into table t_punch_in values(378,'2022-07-28 9:10','张三','M','公司办公','2022-07-29 09:13:04'); insert into table t_punch_in values(419,'2022-07-27 9:08','张三','M','公司办公','2022-07-29 09:18:00'); insert into table t_punch_in values(461,'2022-07-29 9:06','张三','M','公司办公','2022-07-29 15:08:53');
--1 drop table t_group_analysis; create table t_group_analysis as select subStr(time,9,2)`date`,subStr(time,12,5)`time` from t_punch_in; select * from t_group_analysis; --1.5 select 31-`date` as `y`,time x,substr(x,1,1)xx,count(0) num from t_group_analysis group by y,x; --2 drop table t_coord create table t_coord as select 31-`date` as `y`, CASE substr(time,1,1) WHEN 8 THEN FLOOR((substr(time,3,2)-45)/2) ELSE (case substr(time,1,1) WHEN 9 then FLOOR((substr(time,3,2)+15)/2) else FLOOR(75/2) end) END x, count(0) num from t_group_analysis group by y,x; select * from t_coord; select * from t_punch_in where name like '%%' order by time;
-- ---------------------------- -- Records of t_group_analysis -- ---------------------------- INSERT INTO t_group_analysis VALUES ('13', '8:47'); INSERT INTO t_group_analysis VALUES ('13', '8:55'); INSERT INTO t_group_analysis VALUES ('13', '9:03'); INSERT INTO t_group_analysis VALUES ('13', '9:04'); INSERT INTO t_group_analysis VALUES ('13', '9:04'); INSERT INTO t_group_analysis VALUES ('13', '9:09'); INSERT INTO t_group_analysis VALUES ('13', '9:09'); INSERT INTO t_group_analysis VALUES ('13', '9:10'); INSERT INTO t_group_analysis VALUES ('13', '9:11'); INSERT INTO t_group_analysis VALUES ('13', '9:14'); INSERT INTO t_group_analysis VALUES ('13', '9:14'); INSERT INTO t_group_analysis VALUES ('13', '9:14'); INSERT INTO t_group_analysis VALUES ('13', '9:17'); INSERT INTO t_group_analysis VALUES ('13', '9:18'); INSERT INTO t_group_analysis VALUES ('13', '9:18'); INSERT INTO t_group_analysis VALUES ('13', '9:19'); INSERT INTO t_group_analysis VALUES ('13', '9:20'); INSERT INTO t_group_analysis VALUES ('13', '9:20'); INSERT INTO t_group_analysis VALUES ('13', '9:21'); INSERT INTO t_group_analysis VALUES ('13', '9:22'); INSERT INTO t_group_analysis VALUES ('13', '9:22'); INSERT INTO t_group_analysis VALUES ('13', '9:23'); INSERT INTO t_group_analysis VALUES ('13', '9:23'); INSERT INTO t_group_analysis VALUES ('13', '9:25'); INSERT INTO t_group_analysis VALUES ('13', '9:25'); INSERT INTO t_group_analysis VALUES ('13', '9:25'); INSERT INTO t_group_analysis VALUES ('13', '9:25'); INSERT INTO t_group_analysis VALUES ('13', '9:26'); INSERT INTO t_group_analysis VALUES ('13', '9:26'); INSERT INTO t_group_analysis VALUES ('13', '9:28'); INSERT INTO t_group_analysis VALUES ('13', '9:36'); INSERT INTO t_group_analysis VALUES ('13', '休'); INSERT INTO t_group_analysis VALUES ('19', '8:50'); INSERT INTO t_group_analysis VALUES ('19', '9:00'); INSERT INTO t_group_analysis VALUES ('19', '9:00'); INSERT INTO t_group_analysis VALUES ('19', '9:04'); INSERT INTO t_group_analysis VALUES ('19', '9:08'); INSERT INTO t_group_analysis VALUES ('19', '9.11'); INSERT INTO t_group_analysis VALUES ('19', '9:11'); INSERT INTO t_group_analysis VALUES ('19', '9:14'); INSERT INTO t_group_analysis VALUES ('19', '9:16'); INSERT INTO t_group_analysis VALUES ('19', '9:16'); INSERT INTO t_group_analysis VALUES ('19', '9:16'); INSERT INTO t_group_analysis VALUES ('19', '9.18'); INSERT INTO t_group_analysis VALUES ('19', '9:18'); INSERT INTO t_group_analysis VALUES ('19', '9:18'); INSERT INTO t_group_analysis VALUES ('19', '9:18'); INSERT INTO t_group_analysis VALUES ('19', '9:20'); INSERT INTO t_group_analysis VALUES ('19', '9:20'); INSERT INTO t_group_analysis VALUES ('19', '9:20'); INSERT INTO t_group_analysis VALUES ('19', '9:20'); INSERT INTO t_group_analysis VALUES ('19', '9:22'); INSERT INTO t_group_analysis VALUES ('19', '9:22'); INSERT INTO t_group_analysis VALUES ('19', '9.23'); INSERT INTO t_group_analysis VALUES ('19', '9:23'); INSERT INTO t_group_analysis VALUES ('19', '9:23'); INSERT INTO t_group_analysis VALUES ('19', '9:24'); INSERT INTO t_group_analysis VALUES ('19', '9:25'); INSERT INTO t_group_analysis VALUES ('19', '9:27'); INSERT INTO t_group_analysis VALUES ('19', '9:27'); INSERT INTO t_group_analysis VALUES ('19', '9:27'); INSERT INTO t_group_analysis VALUES ('19', '9:27'); INSERT INTO t_group_analysis VALUES ('19', '9:27'); INSERT INTO t_group_analysis VALUES ('19', '9:29'); INSERT INTO t_group_analysis VALUES ('19', '9.29'); INSERT INTO t_group_analysis VALUES ('19', '9:31'); INSERT INTO t_group_analysis VALUES ('19', '9:45'); INSERT INTO t_group_analysis VALUES ('19', '休'); INSERT INTO t_group_analysis VALUES ('19', '休'); INSERT INTO t_group_analysis VALUES ('18', '9:06'); INSERT INTO t_group_analysis VALUES ('18', '9:08'); INSERT INTO t_group_analysis VALUES ('18', '9:11'); INSERT INTO t_group_analysis VALUES ('18', '9:14'); INSERT INTO t_group_analysis VALUES ('18', '9:14'); INSERT INTO t_group_analysis VALUES ('18', '9:14'); INSERT INTO t_group_analysis VALUES ('18', '9:14'); INSERT INTO t_group_analysis VALUES ('18', '9:15'); INSERT INTO t_group_analysis VALUES ('18', '9:15'); INSERT INTO t_group_analysis VALUES ('18', '9:20'); INSERT INTO t_group_analysis VALUES ('18', '9:21'); INSERT INTO t_group_analysis VALUES ('18', '9:21'); INSERT INTO t_group_analysis VALUES ('18', '9:21'); INSERT INTO t_group_analysis VALUES ('18', '9:21'); INSERT INTO t_group_analysis VALUES ('18', '9:21'); INSERT INTO t_group_analysis VALUES ('18', '9:21'); INSERT INTO t_group_analysis VALUES ('18', '9:23'); INSERT INTO t_group_analysis VALUES ('18', '9:23'); INSERT INTO t_group_analysis VALUES ('18', '9:24'); INSERT INTO t_group_analysis VALUES ('18', '9:24'); INSERT INTO t_group_analysis VALUES ('18', '9:24'); INSERT INTO t_group_analysis VALUES ('18', '9:24'); INSERT INTO t_group_analysis VALUES ('18', '9:24'); INSERT INTO t_group_analysis VALUES ('18', '9:24'); INSERT INTO t_group_analysis VALUES ('18', '9:24'); INSERT INTO t_group_analysis VALUES ('18', '9:26'); INSERT INTO t_group_analysis VALUES ('18', '9:27'); INSERT INTO t_group_analysis VALUES ('18', '9:27'); INSERT INTO t_group_analysis VALUES ('18', '9:27'); INSERT INTO t_group_analysis VALUES ('18', '9:28'); INSERT INTO t_group_analysis VALUES ('18', '9.29'); INSERT INTO t_group_analysis VALUES ('18', '9:30'); INSERT INTO t_group_analysis VALUES ('18', '9:30'); INSERT INTO t_group_analysis VALUES ('18', '9:42'); INSERT INTO t_group_analysis VALUES ('18', '通宵'); INSERT INTO t_group_analysis VALUES ('18', '休'); INSERT INTO t_group_analysis VALUES ('18', '休'); INSERT INTO t_group_analysis VALUES ('20', '9:30'); INSERT INTO t_group_analysis VALUES ('20', '9:06'); INSERT INTO t_group_analysis VALUES ('20', '9:06'); INSERT INTO t_group_analysis VALUES ('20', '9:06'); INSERT INTO t_group_analysis VALUES ('20', '9:10'); INSERT INTO t_group_analysis VALUES ('20', '9:12'); INSERT INTO t_group_analysis VALUES ('20', '9:13'); INSERT INTO t_group_analysis VALUES ('20', '9:13'); INSERT INTO t_group_analysis VALUES ('20', '9:13'); INSERT INTO t_group_analysis VALUES ('20', '9:13'); INSERT INTO t_group_analysis VALUES ('20', '9:15'); INSERT INTO t_group_analysis VALUES ('20', '9:16'); INSERT INTO t_group_analysis VALUES ('20', '9:18'); INSERT INTO t_group_analysis VALUES ('20', '9:19'); INSERT INTO t_group_analysis VALUES ('20', '9:20'); INSERT INTO t_group_analysis VALUES ('20', '9:21'); INSERT INTO t_group_analysis VALUES ('20', '9:21'); INSERT INTO t_group_analysis VALUES ('20', '9:22'); INSERT INTO t_group_analysis VALUES ('20', '9:22'); INSERT INTO t_group_analysis VALUES ('20', '9:22'); INSERT INTO t_group_analysis VALUES ('20', '9:22'); INSERT INTO t_group_analysis VALUES ('20', '9:23'); INSERT INTO t_group_analysis VALUES ('20', '9:23'); INSERT INTO t_group_analysis VALUES ('20', '9:23'); INSERT INTO t_group_analysis VALUES ('20', '9:23'); INSERT INTO t_group_analysis VALUES ('20', '9:25'); INSERT INTO t_group_analysis VALUES ('20', '9:25'); INSERT INTO t_group_analysis VALUES ('20', '9:25'); INSERT INTO t_group_analysis VALUES ('20', '9:26'); INSERT INTO t_group_analysis VALUES ('20', '9:26'); INSERT INTO t_group_analysis VALUES ('20', '9:26'); INSERT INTO t_group_analysis VALUES ('20', '9:26'); INSERT INTO t_group_analysis VALUES ('21', '9:06'); INSERT INTO t_group_analysis VALUES ('21', '9:06'); INSERT INTO t_group_analysis VALUES ('21', '9:10'); INSERT INTO t_group_analysis VALUES ('21', '9:10'); INSERT INTO t_group_analysis VALUES ('21', '9:10'); INSERT INTO t_group_analysis VALUES ('21', '9:10'); INSERT INTO t_group_analysis VALUES ('21', '9:10'); INSERT INTO t_group_analysis VALUES ('21', '9:10'); INSERT INTO t_group_analysis VALUES ('21', '9:12'); INSERT INTO t_group_analysis VALUES ('21', '9:12'); INSERT INTO t_group_analysis VALUES ('21', '9:13'); INSERT INTO t_group_analysis VALUES ('21', '9:14'); INSERT INTO t_group_analysis VALUES ('21', '9:15'); INSERT INTO t_group_analysis VALUES ('21', '9:15'); INSERT INTO t_group_analysis VALUES ('21', '9:15'); INSERT INTO t_group_analysis VALUES ('21', '9:17'); INSERT INTO t_group_analysis VALUES ('21', '9:18'); INSERT INTO t_group_analysis VALUES ('21', '9:20'); INSERT INTO t_group_analysis VALUES ('21', '9:20'); INSERT INTO t_group_analysis VALUES ('21', '9:23'); INSERT INTO t_group_analysis VALUES ('21', '9:24'); INSERT INTO t_group_analysis VALUES ('21', '9:26'); INSERT INTO t_group_analysis VALUES ('21', '9:26'); INSERT INTO t_group_analysis VALUES ('21', '9:26'); INSERT INTO t_group_analysis VALUES ('21', '9:26'); INSERT INTO t_group_analysis VALUES ('21', '9:26'); INSERT INTO t_group_analysis VALUES ('21', '9:26'); INSERT INTO t_group_analysis VALUES ('21', '9:27'); INSERT INTO t_group_analysis VALUES ('21', '9:28'); INSERT INTO t_group_analysis VALUES ('21', '9:30'); INSERT INTO t_group_analysis VALUES ('21', '9:30'); INSERT INTO t_group_analysis VALUES ('21', '9:35'); INSERT INTO t_group_analysis VALUES ('22', '8:42'); INSERT INTO t_group_analysis VALUES ('22', '8:44'); INSERT INTO t_group_analysis VALUES ('22', '8:46'); INSERT INTO t_group_analysis VALUES ('22', '8:56'); INSERT INTO t_group_analysis VALUES ('22', '9:05'); INSERT INTO t_group_analysis VALUES ('22', '9:10'); INSERT INTO t_group_analysis VALUES ('22', '9:12'); INSERT INTO t_group_analysis VALUES ('22', '9:14'); INSERT INTO t_group_analysis VALUES ('22', '9:16'); INSERT INTO t_group_analysis VALUES ('22', '9:16'); INSERT INTO t_group_analysis VALUES ('22', '9:16'); INSERT INTO t_group_analysis VALUES ('22', '9:16'); INSERT INTO t_group_analysis VALUES ('22', '9:17'); INSERT INTO t_group_analysis VALUES ('22', '9:17'); INSERT INTO t_group_analysis VALUES ('22', '9:18'); INSERT INTO t_group_analysis VALUES ('22', '9:21'); INSERT INTO t_group_analysis VALUES ('22', '9:21'); INSERT INTO t_group_analysis VALUES ('22', '9:21'); INSERT INTO t_group_analysis VALUES ('22', '9:21'); INSERT INTO t_group_analysis VALUES ('22', '9:21'); INSERT INTO t_group_analysis VALUES ('22', '9:21'); INSERT INTO t_group_analysis VALUES ('22', '9:22'); INSERT INTO t_group_analysis VALUES ('22', '9:22'); INSERT INTO t_group_analysis VALUES ('22', '9:22'); INSERT INTO t_group_analysis VALUES ('22', '9:23'); INSERT INTO t_group_analysis VALUES ('22', '9:23'); INSERT INTO t_group_analysis VALUES ('22', '9:23'); INSERT INTO t_group_analysis VALUES ('22', '9:23'); INSERT INTO t_group_analysis VALUES ('22', '9:24'); INSERT INTO t_group_analysis VALUES ('22', '9:24'); INSERT INTO t_group_analysis VALUES ('22', '9:24'); INSERT INTO t_group_analysis VALUES ('22', '9:25'); INSERT INTO t_group_analysis VALUES ('22', '9:25'); INSERT INTO t_group_analysis VALUES ('22', '9:25'); INSERT INTO t_group_analysis VALUES ('22', '9:28'); INSERT INTO t_group_analysis VALUES ('22', '9:28'); INSERT INTO t_group_analysis VALUES ('22', '9:46'); INSERT INTO t_group_analysis VALUES ('22', '休'); INSERT INTO t_group_analysis VALUES ('23', '11:57'); INSERT INTO t_group_analysis VALUES ('23', '8:48'); INSERT INTO t_group_analysis VALUES ('23', '8:51'); INSERT INTO t_group_analysis VALUES ('23', '8:51'); INSERT INTO t_group_analysis VALUES ('23', '8:55'); INSERT INTO t_group_analysis VALUES ('23', '9:01'); INSERT INTO t_group_analysis VALUES ('23', '9:05'); INSERT INTO t_group_analysis VALUES ('23', '9:05'); INSERT INTO t_group_analysis VALUES ('23', '9:06'); INSERT INTO t_group_analysis VALUES ('23', '9:07'); INSERT INTO t_group_analysis VALUES ('23', '9:07'); INSERT INTO t_group_analysis VALUES ('23', '9:12'); INSERT INTO t_group_analysis VALUES ('23', '9:12'); INSERT INTO t_group_analysis VALUES ('23', '9:17'); INSERT INTO t_group_analysis VALUES ('23', '9:19'); INSERT INTO t_group_analysis VALUES ('23', '9:20'); INSERT INTO t_group_analysis VALUES ('23', '9:23'); INSERT INTO t_group_analysis VALUES ('23', '9:23'); INSERT INTO t_group_analysis VALUES ('23', '9:23'); INSERT INTO t_group_analysis VALUES ('23', '9:23'); INSERT INTO t_group_analysis VALUES ('23', '9:25'); INSERT INTO t_group_analysis VALUES ('23', '9:25'); INSERT INTO t_group_analysis VALUES ('23', '9:25'); INSERT INTO t_group_analysis VALUES ('23', '9:25'); INSERT INTO t_group_analysis VALUES ('23', '9:26'); INSERT INTO t_group_analysis VALUES ('23', '9:26'); INSERT INTO t_group_analysis VALUES ('23', '9:26'); INSERT INTO t_group_analysis VALUES ('23', '9:27'); INSERT INTO t_group_analysis VALUES ('23', '9:28'); INSERT INTO t_group_analysis VALUES ('23', '9:28'); INSERT INTO t_group_analysis VALUES ('23', '9:41'); INSERT INTO t_group_analysis VALUES ('23', '通宵'); INSERT INTO t_group_analysis VALUES ('23', '休'); INSERT INTO t_group_analysis VALUES ('23', '休'); INSERT INTO t_group_analysis VALUES ('23', '休'); INSERT INTO t_group_analysis VALUES ('23', '休'); INSERT INTO t_group_analysis VALUES ('23', '休'); INSERT INTO t_group_analysis VALUES ('23', '休'); INSERT INTO t_group_analysis VALUES ('25', '10:25'); INSERT INTO t_group_analysis VALUES ('25', '8:58'); INSERT INTO t_group_analysis VALUES ('25', '9:03'); INSERT INTO t_group_analysis VALUES ('25', '9:08'); INSERT INTO t_group_analysis VALUES ('25', '9:11'); INSERT INTO t_group_analysis VALUES ('25', '9:12'); INSERT INTO t_group_analysis VALUES ('25', '9:13'); INSERT INTO t_group_analysis VALUES ('25', '9:13'); INSERT INTO t_group_analysis VALUES ('25', '9:14'); INSERT INTO t_group_analysis VALUES ('25', '9:14'); INSERT INTO t_group_analysis VALUES ('25', '9:16'); INSERT INTO t_group_analysis VALUES ('25', '9:16'); INSERT INTO t_group_analysis VALUES ('25', '9:17'); INSERT INTO t_group_analysis VALUES ('25', '9:17'); INSERT INTO t_group_analysis VALUES ('25', '9.19'); INSERT INTO t_group_analysis VALUES ('25', '9:19'); INSERT INTO t_group_analysis VALUES ('25', '9:23'); INSERT INTO t_group_analysis VALUES ('25', '9:23'); INSERT INTO t_group_analysis VALUES ('25', '9:23'); INSERT INTO t_group_analysis VALUES ('25', '9:23'); INSERT INTO t_group_analysis VALUES ('25', '9:23'); INSERT INTO t_group_analysis VALUES ('25', '9:23'); INSERT INTO t_group_analysis VALUES ('25', '9:24'); INSERT INTO t_group_analysis VALUES ('25', '9:24'); INSERT INTO t_group_analysis VALUES ('25', '9:24'); INSERT INTO t_group_analysis VALUES ('25', '9:24'); INSERT INTO t_group_analysis VALUES ('25', '9:25'); INSERT INTO t_group_analysis VALUES ('25', '9.25'); INSERT INTO t_group_analysis VALUES ('25', '9:26'); INSERT INTO t_group_analysis VALUES ('25', '9:26'); INSERT INTO t_group_analysis VALUES ('25', '9:27'); INSERT INTO t_group_analysis VALUES ('25', '9:27'); INSERT INTO t_group_analysis VALUES ('25', '9:28'); INSERT INTO t_group_analysis VALUES ('25', '9:28'); INSERT INTO t_group_analysis VALUES ('25', '9:30'); INSERT INTO t_group_analysis VALUES ('25', '9:30'); INSERT INTO t_group_analysis VALUES ('25', '9:30'); INSERT INTO t_group_analysis VALUES ('25', '9:30'); INSERT INTO t_group_analysis VALUES ('25', '通宵'); INSERT INTO t_group_analysis VALUES ('25', '休'); INSERT INTO t_group_analysis VALUES ('25', '休'); INSERT INTO t_group_analysis VALUES ('26', '10:24'); INSERT INTO t_group_analysis VALUES ('26', '11:06'); INSERT INTO t_group_analysis VALUES ('26', '11:28'); INSERT INTO t_group_analysis VALUES ('26', '8:54'); INSERT INTO t_group_analysis VALUES ('26', '9:00'); INSERT INTO t_group_analysis VALUES ('26', '9:04'); INSERT INTO t_group_analysis VALUES ('26', '9:08'); INSERT INTO t_group_analysis VALUES ('26', '9:08'); INSERT INTO t_group_analysis VALUES ('26', '9:09'); INSERT INTO t_group_analysis VALUES ('26', '9:10'); INSERT INTO t_group_analysis VALUES ('26', '9:11'); INSERT INTO t_group_analysis VALUES ('26', '9:16'); INSERT INTO t_group_analysis VALUES ('26', '9:16'); INSERT INTO t_group_analysis VALUES ('26', '9:16'); INSERT INTO t_group_analysis VALUES ('26', '9:17'); INSERT INTO t_group_analysis VALUES ('26', '9:18'); INSERT INTO t_group_analysis VALUES ('26', '9:19'); INSERT INTO t_group_analysis VALUES ('26', '9:21'); INSERT INTO t_group_analysis VALUES ('26', '9:21'); INSERT INTO t_group_analysis VALUES ('26', '9:21'); INSERT INTO t_group_analysis VALUES ('26', '9:21'); INSERT INTO t_group_analysis VALUES ('26', '9:23'); INSERT INTO t_group_analysis VALUES ('26', '9:23'); INSERT INTO t_group_analysis VALUES ('26', '9:24'); INSERT INTO t_group_analysis VALUES ('26', '9:24'); INSERT INTO t_group_analysis VALUES ('26', '9:26'); INSERT INTO t_group_analysis VALUES ('26', '9:26'); INSERT INTO t_group_analysis VALUES ('26', '9:26'); INSERT INTO t_group_analysis VALUES ('26', '9:27'); INSERT INTO t_group_analysis VALUES ('26', '9:27'); INSERT INTO t_group_analysis VALUES ('26', '9:27'); INSERT INTO t_group_analysis VALUES ('26', '9:28'); INSERT INTO t_group_analysis VALUES ('26', '9:28'); INSERT INTO t_group_analysis VALUES ('26', '9:29'); INSERT INTO t_group_analysis VALUES ('26', '9:29'); INSERT INTO t_group_analysis VALUES ('26', '9:30'); INSERT INTO t_group_analysis VALUES ('26', '9.31'); INSERT INTO t_group_analysis VALUES ('26', '9:31'); INSERT INTO t_group_analysis VALUES ('26', '9:32'); INSERT INTO t_group_analysis VALUES ('26', '9:47'); INSERT INTO t_group_analysis VALUES ('26', '休'); INSERT INTO t_group_analysis VALUES ('26', '休'); INSERT INTO t_group_analysis VALUES ('28', '8:49'); INSERT INTO t_group_analysis VALUES ('28', '8:49'); INSERT INTO t_group_analysis VALUES ('28', '8:55'); INSERT INTO t_group_analysis VALUES ('28', '9:03'); INSERT INTO t_group_analysis VALUES ('28', '9:07'); INSERT INTO t_group_analysis VALUES ('28', '9:08'); INSERT INTO t_group_analysis VALUES ('28', '9:10'); INSERT INTO t_group_analysis VALUES ('28', '9:12'); INSERT INTO t_group_analysis VALUES ('28', '9:12'); INSERT INTO t_group_analysis VALUES ('28', '9:14'); INSERT INTO t_group_analysis VALUES ('28', '9:16'); INSERT INTO t_group_analysis VALUES ('28', '9:16'); INSERT INTO t_group_analysis VALUES ('28', '9:16'); INSERT INTO t_group_analysis VALUES ('28', '9:16'); INSERT INTO t_group_analysis VALUES ('28', '9:17'); INSERT INTO t_group_analysis VALUES ('28', '9:17'); INSERT INTO t_group_analysis VALUES ('28', '9:17'); INSERT INTO t_group_analysis VALUES ('28', '9:17'); INSERT INTO t_group_analysis VALUES ('28', '9:18'); INSERT INTO t_group_analysis VALUES ('28', '9:20'); INSERT INTO t_group_analysis VALUES ('28', '9:20'); INSERT INTO t_group_analysis VALUES ('28', '9:22'); INSERT INTO t_group_analysis VALUES ('28', '9:22'); INSERT INTO t_group_analysis VALUES ('28', '9:24'); INSERT INTO t_group_analysis VALUES ('28', '9:24'); INSERT INTO t_group_analysis VALUES ('28', '9:24'); INSERT INTO t_group_analysis VALUES ('28', '9:24'); INSERT INTO t_group_analysis VALUES ('28', '9:24'); INSERT INTO t_group_analysis VALUES ('28', '9:24'); INSERT INTO t_group_analysis VALUES ('28', '9:24'); INSERT INTO t_group_analysis VALUES ('28', '9:25'); INSERT INTO t_group_analysis VALUES ('28', '9:26'); INSERT INTO t_group_analysis VALUES ('28', '9:27'); INSERT INTO t_group_analysis VALUES ('28', '9:27'); INSERT INTO t_group_analysis VALUES ('28', '9:27'); INSERT INTO t_group_analysis VALUES ('28', '9:28'); INSERT INTO t_group_analysis VALUES ('28', '9:28'); INSERT INTO t_group_analysis VALUES ('28', '9:28'); INSERT INTO t_group_analysis VALUES ('28', '9:29'); INSERT INTO t_group_analysis VALUES ('28', '9:37'); INSERT INTO t_group_analysis VALUES ('28', '旷'); INSERT INTO t_group_analysis VALUES ('28', '休'); INSERT INTO t_group_analysis VALUES ('27', '9:05'); INSERT INTO t_group_analysis VALUES ('27', '9:07'); INSERT INTO t_group_analysis VALUES ('27', '9:07'); INSERT INTO t_group_analysis VALUES ('27', '9:07'); INSERT INTO t_group_analysis VALUES ('27', '9:07'); INSERT INTO t_group_analysis VALUES ('27', '9:08'); INSERT INTO t_group_analysis VALUES ('27', '9.09'); INSERT INTO t_group_analysis VALUES ('27', '9:12'); INSERT INTO t_group_analysis VALUES ('27', '9:12'); INSERT INTO t_group_analysis VALUES ('27', '9:13'); INSERT INTO t_group_analysis VALUES ('27', '9:16'); INSERT INTO t_group_analysis VALUES ('27', '9:17'); INSERT INTO t_group_analysis VALUES ('27', '9:17'); INSERT INTO t_group_analysis VALUES ('27', '9:17'); INSERT INTO t_group_analysis VALUES ('27', '9:18'); INSERT INTO t_group_analysis VALUES ('27', '9:19'); INSERT INTO t_group_analysis VALUES ('27', '9:20'); INSERT INTO t_group_analysis VALUES ('27', '9:21'); INSERT INTO t_group_analysis VALUES ('27', '9:21'); INSERT INTO t_group_analysis VALUES ('27', '9:22'); INSERT INTO t_group_analysis VALUES ('27', '9:24'); INSERT INTO t_group_analysis VALUES ('27', '9:25'); INSERT INTO t_group_analysis VALUES ('27', '9:25'); INSERT INTO t_group_analysis VALUES ('27', '9:25'); INSERT INTO t_group_analysis VALUES ('27', '9:25'); INSERT INTO t_group_analysis VALUES ('27', '9:25'); INSERT INTO t_group_analysis VALUES ('27', '9:25'); INSERT INTO t_group_analysis VALUES ('27', '9:26'); INSERT INTO t_group_analysis VALUES ('27', '9:27'); INSERT INTO t_group_analysis VALUES ('27', '9:27'); INSERT INTO t_group_analysis VALUES ('27', '9:27'); INSERT INTO t_group_analysis VALUES ('27', '9:27'); INSERT INTO t_group_analysis VALUES ('27', '9:27'); INSERT INTO t_group_analysis VALUES ('27', '9:27'); INSERT INTO t_group_analysis VALUES ('27', '9:27'); INSERT INTO t_group_analysis VALUES ('27', '9:29'); INSERT INTO t_group_analysis VALUES ('27', '9:30'); INSERT INTO t_group_analysis VALUES ('27', '9:30'); INSERT INTO t_group_analysis VALUES ('27', '9:34'); INSERT INTO t_group_analysis VALUES ('27', '9:43'); INSERT INTO t_group_analysis VALUES ('27', '旷'); INSERT INTO t_group_analysis VALUES ('27', '休'); INSERT INTO t_group_analysis VALUES ('29', '8.47'); INSERT INTO t_group_analysis VALUES ('29', '8:53'); INSERT INTO t_group_analysis VALUES ('29', '8:59'); INSERT INTO t_group_analysis VALUES ('29', '9:00'); INSERT INTO t_group_analysis VALUES ('29', '9.04'); INSERT INTO t_group_analysis VALUES ('29', '9:06'); INSERT INTO t_group_analysis VALUES ('29', '9:06'); INSERT INTO t_group_analysis VALUES ('29', '9:07'); INSERT INTO t_group_analysis VALUES ('29', '9:12'); INSERT INTO t_group_analysis VALUES ('29', '9:12'); INSERT INTO t_group_analysis VALUES ('29', '9:15'); INSERT INTO t_group_analysis VALUES ('29', '9:15'); INSERT INTO t_group_analysis VALUES ('29', '9:16'); INSERT INTO t_group_analysis VALUES ('29', '9:16'); INSERT INTO t_group_analysis VALUES ('29', '9:16'); INSERT INTO t_group_analysis VALUES ('29', '9:19'); INSERT INTO t_group_analysis VALUES ('29', '9:19'); INSERT INTO t_group_analysis VALUES ('29', '9:19'); INSERT INTO t_group_analysis VALUES ('29', '9:19'); INSERT INTO t_group_analysis VALUES ('29', '9:22'); INSERT INTO t_group_analysis VALUES ('29', '9:22'); INSERT INTO t_group_analysis VALUES ('29', '9:22'); INSERT INTO t_group_analysis VALUES ('29', '9:22'); INSERT INTO t_group_analysis VALUES ('29', '9:22'); INSERT INTO t_group_analysis VALUES ('29', '9:23'); INSERT INTO t_group_analysis VALUES ('29', '9:23'); INSERT INTO t_group_analysis VALUES ('29', '9:23'); INSERT INTO t_group_analysis VALUES ('29', '9:24'); INSERT INTO t_group_analysis VALUES ('29', '9:26'); INSERT INTO t_group_analysis VALUES ('29', '9:26'); INSERT INTO t_group_analysis VALUES ('29', '9:26'); INSERT INTO t_group_analysis VALUES ('29', '9:26'); INSERT INTO t_group_analysis VALUES ('29', '9:26'); INSERT INTO t_group_analysis VALUES ('29', '9:26'); INSERT INTO t_group_analysis VALUES ('29', '9:26'); INSERT INTO t_group_analysis VALUES ('29', '9:28'); INSERT INTO t_group_analysis VALUES ('29', '9:28'); INSERT INTO t_group_analysis VALUES ('29', '9:30'); INSERT INTO t_group_analysis VALUES ('29', '9:47'); INSERT INTO t_group_analysis VALUES ('29', '9:47'); INSERT INTO t_group_analysis VALUES ('29', '9.52'); INSERT INTO t_group_analysis VALUES ('29', '休');
3、Java 代码
package fileTest; import config.*; import lombok.AllArgsConstructor; import lombok.Data; import org.springframework.context.ApplicationContext; import org.springframework.context.annotation.AnnotationConfigApplicationContext; import javax.sql.DataSource; import java.sql.Connection; import java.sql.PreparedStatement; import java.sql.ResultSet; /** * @Author: liuyuan * @Date: 2022/07/25 10:32 */ public class CoordTest { public static void main(String[] args) throws Exception { String sql = "select * from t_coord"; ApplicationContext ac = new AnnotationConfigApplicationContext(MyJDBCConfig.class); DataSource dataSource = (DataSource) ac.getBean("dataSource"); Connection connection = dataSource.getConnection(); //获取连接 Long startTime = System.currentTimeMillis(); PreparedStatement preparedStatement = connection.prepareStatement(sql); ResultSet resultSet = preparedStatement.executeQuery(); while (resultSet.next()){ int anInt = resultSet.getInt(1); int anInt1 = resultSet.getInt(2); int anInt2 = resultSet.getInt(3); Coord coord = new Coord(anInt, anInt1, anInt2); System.out.println(coord); CoordFileConfig.invoke(coord); } Long endTime = System.currentTimeMillis(); Long timeSpend = endTime-startTime; System.out.println("startTime : "+startTime+" startTime : "+endTime+" timeSpend : "+timeSpend); System.out.println(SystemResponseFileConfig.file.getAbsolutePath()); } @Data @AllArgsConstructor public static class Coord{ int x; int y; int num; } }
config
package config; import fileTest.CoordTest; import java.io.File; import java.io.FileOutputStream; import java.io.IOException; /** * @Author: liuyuan * @Date: 2022/07/29 12:30 */ public class CoordFileConfig { private static String path = SearchRelevanceFileConfig.class.getClassLoader().getResource("").getPath() + "CoordFile.txt"; public static File file = new File(path); private static FileOutputStream fos; static { try { if (!file.exists()) { file.createNewFile(); } fos = new FileOutputStream(file); } catch (Exception e) { e.printStackTrace(); } } public static void write(String value) throws IOException { fos.write(value.getBytes()); System.out.println("Sink>" + value); } public static void invoke(CoordTest.Coord value) throws Exception { String str = ""; StringBuffer sb = new StringBuffer(str); sb.append("["); sb.append(value.getX()); sb.append(","); sb.append(value.getY()); sb.append(","); sb.append(value.getNum()); sb.append("]"); sb.append(","); sb.append("\r\n"); write(sb.toString()); sb=new StringBuffer(str); } }
<?xml version="1.0" encoding="UTF-8"?> <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <parent> <artifactId>youpin-parent</artifactId> <groupId>com.uu898.youpin</groupId> <version>0.1.0</version> </parent> <artifactId>youpin-report-push</artifactId> <version>0.1.0</version> <properties> <maven.compiler.source>11</maven.compiler.source> <maven.compiler.target>11</maven.compiler.target> <flink.version>1.13.0</flink.version> <scala.binary.version>2.11</scala.binary.version> <spring.hadoop.version>2.5.0.RELEASE</spring.hadoop.version> <alihbase.version>2.2.3</alihbase.version> <connector.version>2.1.0.1</connector.version> </properties> <dependencies> <dependency> <groupId> org.springframework</groupId> <artifactId> spring-context</artifactId> </dependency> <dependency> <groupId> org.springframework</groupId> <artifactId> spring-jdbc</artifactId> </dependency> <dependency> <groupId>com.alibaba</groupId> <artifactId>druid</artifactId> <version>1.0.9</version> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-validation</artifactId> </dependency> <dependency> <groupId>com.alibaba.cloud</groupId> <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId> </dependency> <dependency> <groupId>com.alibaba.cloud</groupId> <artifactId>spring-cloud-starter-alibaba-nacos-config</artifactId> </dependency> <dependency> <groupId>com.uu898.youpin</groupId> <artifactId>youpin-commons-base</artifactId> </dependency> <dependency> <groupId>com.uu898.youpin</groupId> <artifactId>youpin-commons-web</artifactId> </dependency> <dependency> <groupId>com.uu898.youpin</groupId> <artifactId>youpin-commons-jpa</artifactId> </dependency> <dependency> <groupId>org.apache.shardingsphere</groupId> <artifactId>sharding-jdbc-spring-boot-starter</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> <scope>test</scope> </dependency> <dependency> <groupId>org.springframework.data</groupId> <artifactId>spring-data-envers</artifactId> </dependency> <!-- 如果使用的是Java 9及以上的版本，则需要添加jaxb相关依赖 --> <dependency> <groupId>javax.xml.bind</groupId> <artifactId>jaxb-api</artifactId> </dependency> <dependency> <groupId>javax.activation</groupId> <artifactId>activation</artifactId> </dependency> <dependency> <groupId>org.glassfish.jaxb</groupId> <artifactId>jaxb-runtime</artifactId> </dependency> <dependency> <groupId>com.uu898.youpin</groupId> <artifactId>youpin-commons-log</artifactId> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-amqp</artifactId> </dependency> <!--增加alihbase-client的依赖--> <dependency> <groupId>com.alibaba.hbase</groupId> <artifactId>alihbase-client</artifactId> <version>${alihbase.version}</version> <exclusions> <exclusion> <artifactId>logback-core</artifactId> <groupId>ch.qos.logback</groupId> </exclusion> <exclusion> <artifactId>logback-classic</artifactId> <groupId>ch.qos.logback</groupId> </exclusion> <exclusion> <artifactId>zookeeper</artifactId> <groupId>org.apache.zookeeper</groupId> </exclusion> <exclusion> <artifactId>slf4j-api</artifactId> <groupId>org.slf4j</groupId> </exclusion> <exclusion> <artifactId>slf4j-log4j12</artifactId> <groupId>org.slf4j</groupId> </exclusion> <exclusion> <artifactId>slf4j-simple</artifactId> <groupId>org.slf4j</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.apache.zookeeper</groupId> <artifactId>zookeeper</artifactId> <version>3.4.10</version> <exclusions> <exclusion> <groupId>ch.qos.logback</groupId> <artifactId>logback-core</artifactId> </exclusion> <exclusion> <groupId>ch.qos.logback</groupId> <artifactId>logback-classic</artifactId> </exclusion> <exclusion> <artifactId>slf4j-api</artifactId> <groupId>org.slf4j</groupId> </exclusion> <exclusion> <artifactId>slf4j-log4j12</artifactId> <groupId>org.slf4j</groupId> </exclusion> <exclusion> <artifactId>slf4j-simple</artifactId> <groupId>org.slf4j</groupId> </exclusion> </exclusions> </dependency> <!--${connector-version} 需要替换成hbase-client对应的版本，版本对应关系见最下面表格的依赖--> <dependency> <groupId>com.alibaba.hbase</groupId> <artifactId>alihbase-connector</artifactId> <version>${connector.version}</version> <exclusions> <exclusion> <groupId>org.apache.hbase</groupId> <artifactId>hbase-client</artifactId> </exclusion> <exclusion> <artifactId>zookeeper</artifactId> <groupId>org.apache.zookeeper</groupId> </exclusion> <exclusion> <artifactId>logback-core</artifactId> <groupId>ch.qos.logback</groupId> </exclusion> <exclusion> <artifactId>logback-classic</artifactId> <groupId>ch.qos.logback</groupId> </exclusion> <exclusion> <artifactId>slf4j-api</artifactId> <groupId>org.slf4j</groupId> </exclusion> <exclusion> <artifactId>slf4j-log4j12</artifactId> <groupId>org.slf4j</groupId> </exclusion> <exclusion> <artifactId>slf4j-simple</artifactId> <groupId>org.slf4j</groupId> </exclusion> </exclusions> </dependency> <dependency> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-starter-test</artifactId> </dependency> <!--flink--> <dependency> <groupId>org.apache.flink</groupId> <artifactId>flink-core</artifactId> <version>${flink.version}</version> </dependency> <dependency> <groupId>org.apache.flink</groupId> <artifactId>flink-java</artifactId> <version>${flink.version}</version> </dependency> <dependency> <groupId>org.apache.flink</groupId> <artifactId>flink-streaming-java_${scala.binary.version}</artifactId> <version>${flink.version}</version> </dependency> <dependency> <groupId>org.apache.flink</groupId> <artifactId>flink-clients_${scala.binary.version}</artifactId> <version>${flink.version}</version> </dependency> <dependency> <groupId>org.apache.flink</groupId> <artifactId>flink-csv</artifactId> <version>1.10.0</version> </dependency> </dependencies> <build> <resources> <resource> <directory>../youpin-commons/youpin-commons-base/src/main/resources</directory> <includes> <include>**/*.properties</include> </includes> </resource> <resource> <directory>src/main/resources</directory> <includes> <include>**/*</include> </includes> </resource> </resources> <finalName>${artifactId}</finalName> <plugins> <plugin> <groupId>org.springframework.boot</groupId> <artifactId>spring-boot-maven-plugin</artifactId> </plugin> </plugins> </build> </project>
【推荐】国内首个AI IDE，深度理解中文开发场景，立即下载体验Trae
【推荐】编程新体验，更懂你的AI，立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包，你的智能百科全书，全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell：AI 加持，快人一步
· TypeScript + Deepseek 打造卜卦网站：技术与玄学的结合
· Manus的开源复刻OpenManus初探
· AI 智能体引爆开源社区「GitHub 热点速览」
· 从HTTP原因短语缺失研究HTTP/2和HTTP/3的设计差异
· 三行代码完成国际化适配，妙~啊~