sscout的博客1.在写sql语句时,引入别名。...select id="findByQueryVo" parameterType="cn.edu.hdu.domain.QueryVo" resultMap="cn.edu.hdu.domain.User"> select id as userId,username as userName,sex as userSex...
哎呦JT不错哦的博客自定义实体类:因为需要做相关记录的统计,而表中没有统计字段 public class TrafficJeevesDistrictCount { //施工top5+1 按区域 private String districtInfo; private String districtCount; public ...
海绵宝宝的海的博客返回map类型,无需自己创建resultMap:SELECT DATE_FORMAT(sm_data,'%Y-%m-%d') name , SUM(sm_inventory) value FROM salesmessage GROUP BY DATE_FORMAT(sm_data,'%Y-%m-%d');根据上一篇,要想利用Echarts的柱状图...