美文网首页
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