美文网首页
Spring boot执行sql返回JSON

Spring boot执行sql返回JSON

作者: SWLB | 来源:发表于2019-06-05 08:12 被阅读0次
    controller:
    @RestController
    public class Data {
        @Autowired
        DataMapper dataMapper;
        @GetMapping("/companysoftusage/{compname}")
        //只返回查询出来的字段
        public  List<Map<String, Object>> getCompanySoftUsage(@PathVariable("compname") String compname) {
            return dataMapper.getProgramUsageNumberByCompany( compname);
        }
    }
    mapper:
    @Mapper
    public interface DataMapper {
        @Select("select count(d.p) numbers, concat(d.n,'(v',REPLACE(REPLACE(d.v, ',', '.'),' ',''),')') as pname  from d  where d.c =  #{compname}  group by   p ,n,v order by count(p) asc;")
        public List<Map<String, Object>> getProgramUsageNumberByCompany(String compname);
    
    }
    
    

    获取多个变量

    @RequestMapping("show5/{id}/{name}")
    public String test5(@PathVariable("id") Long ids ,@PathVariable("name") String names) ;
    

    相关文章

      网友评论

          本文标题:Spring boot执行sql返回JSON

          本文链接:https://www.haomeiwen.com/subject/vkadxctx.html