java中折线图统计按照日和月

一、按照日统计数（折线图）

1、xml文件

<select id="dayStudyChart" resultType="com.ckpi.domain.EduUserStudyChartModel">
   SELECT
        videoStudyTime+liveStudyTime AS studyTime
    FROM(
       SELECT
        IFNULL(SUM(cw.watchRate),0)AS videoStudyTime,
        IFNULL((SELECT ROUND(SUM(videoHTime)/60,2) FROM `edu_roomlog` WHERE uid=#{uid}),0)AS  liveStudyTime
      FROM  `course_watchrecord` cw  WHERE cw.`userTid`=#{uid}
    )h
</select>

<!--日数据-->
<select id="dayChartStatus1"  resultType="Double">
  SELECT
     videoStudyTime+liveStudyTime AS studyTime
    FROM(
       SELECT
        IFNULL(SUM(cw.watchRate),0)AS videoStudyTime,
        IFNULL((SELECT ROUND(SUM(videoHTime)/60,2) FROM `edu_roomlog` WHERE uid=#{uid} AND TO_DAYS(#{time}) - TO_DAYS(`addT