From 6f5dc4ff458a78ec4ff341ca33b5bd5e99fbc8e5 Mon Sep 17 00:00:00 2001
From: xufenglei <xufenglei>
Date: Fri, 13 Jul 2018 14:38:18 +0800
Subject: [PATCH] demo
---
src/main/java/com/moral/controller/DemoConreoller.java | 25 +++++++++++++++++++++++++
src/main/java/com/moral/mapper/DemoMapper.java | 4 ++++
src/main/resources/mapper/DemoMapper.xml | 5 ++++-
3 files changed, 33 insertions(+), 1 deletions(-)
diff --git a/src/main/java/com/moral/controller/DemoConreoller.java b/src/main/java/com/moral/controller/DemoConreoller.java
index 8531945..bb68cb2 100644
--- a/src/main/java/com/moral/controller/DemoConreoller.java
+++ b/src/main/java/com/moral/controller/DemoConreoller.java
@@ -1,10 +1,35 @@
package com.moral.controller;
+import java.util.Collections;
+import java.util.Comparator;
+import java.util.Date;
+import java.util.List;
+import java.util.Map;
+
+import javax.annotation.Resource;
+
+import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
+
+import com.moral.mapper.DemoMapper;
@RestController
@RequestMapping("demo")
public class DemoConreoller {
+ @Resource
+ private DemoMapper demoMapper;
+
+ @GetMapping("list")
+ public List<Map<String, Object>> getDatas(){
+ List<Map<String, Object>> list = demoMapper.getDatas();
+ Collections.sort(list, new Comparator<Map<String, Object>>() {
+ @Override
+ public int compare(Map<String, Object> o1, Map<String, Object> o2) {
+ return ((Date)o1.get("time")).compareTo((Date)o2.get("time"));
+ }
+ });
+ return list;
+ }
}
diff --git a/src/main/java/com/moral/mapper/DemoMapper.java b/src/main/java/com/moral/mapper/DemoMapper.java
index b07a595..7f4c4fb 100644
--- a/src/main/java/com/moral/mapper/DemoMapper.java
+++ b/src/main/java/com/moral/mapper/DemoMapper.java
@@ -1,4 +1,8 @@
package com.moral.mapper;
+import java.util.List;
+import java.util.Map;
+
public interface DemoMapper {
+ List<Map<String, Object>> getDatas();
}
\ No newline at end of file
diff --git a/src/main/resources/mapper/DemoMapper.xml b/src/main/resources/mapper/DemoMapper.xml
index 8403e41..3ab8c7a 100644
--- a/src/main/resources/mapper/DemoMapper.xml
+++ b/src/main/resources/mapper/DemoMapper.xml
@@ -1,4 +1,7 @@
<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
-<mapper namespace="com.moral.mapper.DemoMapper" >
+<mapper namespace="com.moral.mapper.DemoMapper">
+ <select id="getDatas" resultType="map">
+ SELECT * FROM hangzhou_aqi ORDER BY time DESC LIMIT 7
+ </select>
</mapper>
\ No newline at end of file
--
Gitblit v1.8.0