SpringBoot+Echarts

package com.imooc.dao;

import com.imooc.domain.VideoAccessTopN;
import com.imooc.utils.MySQLUtils;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 面向接口编程
 */
public class VideoAccessTopNDAO {


    static Map courses = new HashMap（）;
    static {
        courses.put（“4000“ “MySQL优化“）;
        courses.put（“4500“ “Crontab“）;
        courses.put（“4600“ “Swift“）;
        courses.put（“14540“ “SpringData“）;
        courses.put（“14704“ “R“）;
        courses.put（“14390“ “机器学习“）;
        courses.put（“14322“ “redis“）;
        courses.put（“14390“ “神经网络“）;
        courses.put（“14623“ “Docker“）;
    }

    /**
     * 根据课程编号查询课程名称
     */
    public String getCourseName（String id） {
        return courses.get（id）;
    }


    /**
     * 根据day查询当天的最受欢迎的Top5课程
     * @param day
     */
    public List query（String day） {
        List list = new ArrayList（）;

        Connection connection = null;
        PreparedStatement psmt = null;
        ResultSet rs = null;

        try {
            connection = MySQLUtils.getConnection（）;
            String sql = “select cms_id times  from  day_video_access_topn_stat where day =? order by times desc limit 5“;
            psmt = connection.prepareStatement（sql）;
            psmt.setString（1 day）;

            rs = psmt.executeQuery（）;

            VideoAccessTopN domain = null;
            while（rs.next（）） {
                domain = new VideoAccessTopN（）;
                /**
                 * TODO... 在页面上应该显示的是课程名称，而我们此时拿到的是课程编号
                 *
                 * 如何根据课程编号去获取课程名称呢？
                 * 编号和名称是有一个对应关系的，一般是存放在关系型数据库
                 */
                domain.setName（getCourseName（rs.getLong（“cms_id“）+““））;
                domain.setValue（rs.getLong（“times“））;

                list.add（domain）;
            }

        }catch （Exception e） {
            e.printStackTrace（）;
        } finally {
            MySQLUtils.release（connection psmt rs）;
        }
        return list;
    }

    public static void main（String[] args） {
        VideoAccessTopNDAO dao = new VideoAccessTopNDAO（）;
        List list = dao.query（“20170511“）;
        for（VideoAccessTopN result: list） {
            System.out.println（result.getName（） + “  “ + result.getValue（））;
        }
    }

}

 属性            大小     日期    时间   名称
----------- ---------  ---------- -----  ----
     目录           0  2017-06-30 03:05  p1867y
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProject
     文件        4958  2017-06-30 03:05  p1867yImoocSparkSQLProjectpom.xml
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrc
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmain
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmain
esources
     文件     4977417  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmain
esourcesipDatabase.csv
     文件       25433  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmain
esourcesipRegion.xlsx
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscala
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacom
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooc
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclog
     文件        1496  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogAccessConvertUtil.scala
     文件        1041  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogDateUtils.scala
     文件         119  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogDayCityVideoAccessStat.scala
     文件         136  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogDayVideoAccessStat.scala
     文件          92  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogDayVideoTrafficsStat.scala
     文件         252  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogIpUtils.scala
     文件         766  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogMySQLUtils.scala
     文件         854  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogSparkStatCleanJob.scala
     文件         787  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogSparkStatCleanJobYARN.scala
     文件        1047  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogSparkStatFormatJob.scala
     文件        3642  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogStatDAO.scala
     文件        4828  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogTopNStatJob.scala
     文件        4787  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogTopNStatJob2.scala
     文件        4758  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimooclogTopNStatJobYARN.scala
     目录           0  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimoocspark
     文件        1126  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimoocsparkDataframeApp.scala
     文件        1512  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimoocsparkDataframeCase.scala
     文件        1730  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimoocsparkDataframeRDDApp.scala
     文件         807  2017-06-30 03:05  p1867yImoocSparkSQLProjectsrcmainscalacomimoocsparkDatasetApp.scala
............此处省略31个文件信息