Run influxd.exe;
In Eclipse, run the Demo1Application.java as "Spring Boot App" (Tomcat shows the port is 8080 in the console);
Go to localhost:8080/start and click "LOAD"
The screen shows "Loaded!" and the result of the query
SELECT mean(NO2_GT) FROM AirParameters WHERE time>=1072886400000000000 AND time<=1104508799000000000
is the mean of NO2(GT) in 2004
- The result of the query need parsing while I only print the Series' toString() on the webpage;
- I didn't implement the button but used a hyperlink instead;
- I haven't read the interactive data table framework yet.
- I updated the SQL Query:
SELECT mean(CO_GT) FROM AirParameters WHERE time>=1072933200000000000 AND time<=1104555599000000000 GROUP BY *
by adding Date as a tag;
- Implement the button and a plain table of mean CO & NO2 everyday in 2004 (airquality.html);
- Create a AirQuery class to faciliate displaying the table;
- Set portal 8080 as default, so I can go to "localhost/start" directly.
- I am learning JavaScript currently, but I use the recommended framework Thymeleaf to display the table instead;
- "GROUP BY DATE" doesn't work, so I use "GROUP BY *" instead. I don't know why...