mybatis-plus拼接sql報(bào)錯(cuò)
復(fù)制報(bào)錯(cuò)sql語句到navicat,字段之間缺少空格，補(bǔ)上就可以了文章來源：http://www.zghlxwxcb.cn/news/detail-813757.html
聚合sql 根據(jù)時(shí)間
json接收
@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date startTime;
@JsonFormat(timezone = "GMT+8", pattern = "yyyy-MM-dd")
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date endTime;
private Integer pageNo;
private Integer pageSize;
查詢語句
xxxMapper.query(startTime , endTime , (pageNo - 1) * pageSize, pageSize)
@Select(" select count(*) as total , " +
"sum(collection_type = 0 ) as c0, " +
"sum(collection_type = 1 ) as c1, " +
"sum(collection_type = 2 ) as c2, " +
"sum(collection_type = 3 ) as c3, " +
"sum(collection_type = 4 ) as c4, " +
"sum(collection_type = 5 ) as c5, " +
"sum(collection_type = 6 ) as c6, " +
"sum(collection_type = 7 ) as c7, " +
"sum(collection_type = 8 ) as c8, " +
"sum(collection_type = 9 ) as c9, " +
"sum(collection_type = 10 ) as c10, " +
"DATE_FORMAT( create_time, '%Y-%m-%d' ) as date " +
"from table " +
"where create_time BETWEEN #{startTime} and #{endTime} " +
"group by DATE_FORMAT( create_time, '%Y-%m-%d' ) " +
"order by DATE_FORMAT( create_time, '%Y-%m-%d' ) desc " +
"limit #{start},#{end} ")
List<TableVo> query(Date startTime, Date endTime, Integer start, Integer end);
結(jié)果
文章來源地址http://www.zghlxwxcb.cn/news/detail-813757.html
到了這里，關(guān)于【每日小bug】——mybatis-plus拼接sql空格報(bào)錯(cuò)，根據(jù)時(shí)間聚合查詢的文章就介紹完了。如果您還想了解更多內(nèi)容，請?jiān)谟疑辖撬阉鱐OY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
