demo

xufenglei

2018-07-13 6f5dc4ff458a78ec4ff341ca33b5bd5e99fbc8e5

demo 

 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;

    }

}


 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();
}

 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>