package com.snailclimb.bean;
/**
* 圓餅圖展示的時候需要使用到的對象
*
* @author Snailclimb
*
*/
public class ScoreResult {
public int value; // 點贊數
public String name;// 人名
public float getValue() {
return value;
}
public void setValue(int value) {
this.value = value;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public ScoreResult(int value, String name) {
super();
this.value = value;
this.name = name;
}
@Override
public String toString() {
return "ScoreResult [value=" + value + ", name=" + name + "]";
}
}
3.2 dao層
UserMapper.java
package com.snailclimb.dao;
import java.util.List;
import com.snailclimb.bean.User;
public interface UserMapper {
public List selecAgreesTop10();
}
UserMapper.xml
3.3 service層
UserService.java
package com.snailclimb.service;
import java.util.List;
import com.snailclimb.bean.User;
public interface UserService {
public List selecAgreesTop10();
}
3.4 service實現層
UserServiceImpl.java
package com.snailclimb.service.impl;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import com.snailclimb.bean.User;
import com.snailclimb.dao.UserMapper;
import com.snailclimb.service.UserService;
@Service
public class UserServiceImpl implements UserService {
@Autowired
private UserMapper userMapper;
@Override
public List selecAgreesTop10() {
return userMapper.selecAgreesTop10();
}
}
3.5 controller層
package com.snailclimb.controller;
import java.util.ArrayList;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import com.snailclimb.bean.ScoreResult;
import com.snailclimb.bean.User;
import com.snailclimb.service.UserService;
@Controller
@RequestMapping(value = "/echarts")
public class UserController {
@Autowired
private UserService userService;
/**
* 折線圖和直方圖
*
* @return
*/
@RequestMapping(value = "/agreeLineAndBar")
@ResponseBody
public List getAgreesTop10() {
return userService.selecAgreesTop10();
}
/**
* 圓餅圖
*
* @return
*/
@RequestMapping(value = "/agreePie")
@ResponseBody
public List getAgreesTop10T() {
List list = userService.selecAgreesTop10();
List results = new ArrayList();
for (User user : list) {
ScoreResult scoreResult = new ScoreResult(user.getAgrees(), user.getUsername());
results.add(scoreResult);
}
return results;
}
// 跳轉到圓餅圖展示
@RequestMapping(value = "/intoagreePie")
public String intoagreePie() {
return "agreePie";
}
// 跳轉到折線圖和直方圖
@RequestMapping(value = "/intoagreeLineAndBar")
public String Index() {
return "agreeLineAndBar";
}
}
/**
* 圓餅圖
*/
@RequestMapping(value = "/agreePie")
@ResponseBody
public List getAgreesTop10T() {
//查詢數據
List list = userService.selecAgreesTop10();
List results = new ArrayList();
//將數據添加到results中
for (User user : list) {
ScoreResult scoreResult = new ScoreResult(user.getAgrees(), user.getUsername());
results.add(scoreResult);
}
//返回results
return results;
}
