基于javaweb+mysql的springboot推荐算法短视频平台(java+springboot+maven+vue+element-ui+mysql)
私信源码获取及调试交流
运行环境
Java≥8、MySQL≥5.7、Node.js≥10
开发工具
后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb的SpringBoot推荐算法短视频平台(java+springboot+maven+vue+element-ui+mysql)
项目介绍 基于Springboot的推荐算法短视频平台系统设计与实现.系统分为管理员与普通用户两种角色。
1)登录模块 在进入系统首页后,首先看到的是登录界面,该界面会提供注册用户的功能,公告、平台咨询、视频中心、登录、注册、关键字搜索、忘记密码。 2)客户端模块 本模块分为密钥管理,角色管理,权限管理,个人信息,视频中心推荐、视频标题、视频类型、发布日期、时长、视频、发布数量、发布用户、等组成。 3)后台管理模块 本模块包括用户管理,模块管理、视频中心、在线留言、留言回复、普通用户统计、轮播图、公告管理、资源管理、系统用户、模块管理、视频中心、视频类型、在线留言等等。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。
2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA;
3.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS;
4.是否Maven项目: 否;查看源码目录中是否包含pom.xml;若包含,则为maven项目,否则为非maven项目
5.数据库:MySql 5.7版本;
技术栈 1. 后端:Springboot+SSM(Spring SpringMVC MyBatis)
首页展示:
平台咨询和公告:
用户登录页展示:
视频中心推荐:
视频详情展示:
后台首页展示:
后台统计展示:
轮播图页面展示:
后台用户统计展示:
public void importDb(MultipartFile file) throws IOException {
if (file.isEmpty()) {
return;
}
List<Map<String, String>> body = new ArrayList<>();
String fileName = file.getOriginalFilename();
if (fileName == null) {
return;
}
String suffix = fileName.substring(fileName.lastIndexOf(".") + 1);
InputStream ins = file.getInputStream();
Workbook wb = null;
if (suffix.equals("xlsx")) {
wb = new XSSFWorkbook(ins);
} else {
wb = new HSSFWorkbook(ins);
}
Sheet sheet = wb.getSheetAt(0);
if (null != sheet) {
for (int line = 0; line <= sheet.getLastRowNum(); line++) {
Row row = sheet.getRow(line);
if (null == row) {
continue;
}
Iterator<Cell> cellIterator = row.cellIterator();
StringBuffer sql = new StringBuffer("INSERT INTO ").append(table).append(" VALUES (null,");
while (cellIterator.hasNext()) {
sql.append(cellIterator.next().getStringCellValue()).append(",");
}
sql.deleteCharAt(sql.length());
sql.append(")");
runCountSql(sql.toString());
}
}
}
public HSSFWorkbook exportDb(Map<String, String> query, Map<String, String> config) {
Query select = select(query, config);
List<Map<String, String>> resultList = select.getResultList();
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet(table);
HSSFCellStyle headerStyle = workbook.createCellStyle();
headerStyle.setFillForegroundColor(IndexedColors.YELLOW.index);
headerStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
for (int i = 0; i < resultList.size(); i++) {
HSSFRow row = sheet.createRow(i);
Map<String, String> map = resultList.get(i);
int j = 0;
for (Map.Entry<String, String> entry : map.entrySet()) {
row.createCell(j).setCellValue(new HSSFRichTextString(entry.getValue()));
}
}
return workbook;
}
* 服务对象
*/
@Autowired
public ArticleController(ArticleService service) {
setService(service);
}
}
/**
* (NavAdmin)表控制层
*
*/
@RestController
@RequestMapping("nav_admin")
public class NavAdminController extends BaseController<NavAdmin, NavAdminService> {
/**
* 服务对象
*/
@Autowired
public NavAdminController(NavAdminService service) {
setService(service);
}
}
if (file.isEmpty()) {
return;
}
List<Map<String, String>> body = new ArrayList<>();
String fileName = file.getOriginalFilename();
if (fileName == null) {
return;
}
String suffix = fileName.substring(fileName.lastIndexOf(".") + 1);
InputStream ins = file.getInputStream();
Workbook wb = null;
if (suffix.equals("xlsx")) {
wb = new XSSFWorkbook(ins);
} else {
wb = new HSSFWorkbook(ins);
}
Sheet sheet = wb.getSheetAt(0);
if (null != sheet) {
for (int line = 0; line <= sheet.getLastRowNum(); line++) {
Row row = sheet.getRow(line);
if (null == row) {
continue;
}
Iterator<Cell> cellIterator = row.cellIterator();
StringBuffer sql = new StringBuffer("INSERT INTO ").append(table).append(" VALUES (null,");
while (cellIterator.hasNext()) {
sql.append(cellIterator.next().getStringCellValue()).append(",");
}
sql.deleteCharAt(sql.length());
sql.append(")");
runCountSql(sql.toString());
}
}
}
public HSSFWorkbook exportDb(Map<String, String> query, Map<String, String> config) {
Query select = select(query, config);
List<Map<String, String>> resultList = select.getResultList();
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet sheet = workbook.createSheet(table);
HSSFCellStyle headerStyle = workbook.createCellStyle();
headerStyle.setFillForegroundColor(IndexedColors.YELLOW.index);
headerStyle.setFillPattern(FillPatternType.SOLID_FOREGROUND);
for (int i = 0; i < resultList.size(); i++) {
HSSFRow row = sheet.createRow(i);
Map<String, String> map = resultList.get(i);
int j = 0;
for (Map.Entry<String, String> entry : map.entrySet()) {
row.createCell(j).setCellValue(new HSSFRichTextString(entry.getValue()));
}
if(username == null || username.length() == 0){
return error(30000, "用户名不能为空");
}
if(password == null || password.length() == 0){
return error(30000, "密码不能为空");
}
// 查询用户
Map<String, String> query = new HashMap<>();
query.put("username",username);
Query select = service.select(query, service.readConfig(request));
List list = select.getResultList();
if (list.size() > 0) {
User o = (User) list.get(0);
JSONObject query2 = new JSONObject();
JSONObject form2 = new JSONObject();
// 修改用户密码
query2.put("user_id",o.getUserId());
form2.put("password",service.encryption(password));
service.update(query, service.readConfig(request), form2);
return success(1);
}
return error(70000,"用户不存在");
}
/**
* 登录
* @param data
* @param httpServletRequest
* @return
*/
@PostMapping("login")
public Map<String, Object> login(@RequestBody Map<String, String> data, HttpServletRequest httpServletRequest) {
log.info("[执行登录接口]");
String username = data.get("username");
String email = data.get("email");
String phone = data.get("phone");
String password = data.get("password");
List resultList = null;
Map<String, String> map = new HashMap<>();
if(username != null && "".equals(username) == false){
map.put("username", username);
resultList = service.select(map, new HashMap<>()).getResultList();
}
else if(email != null && "".equals(email) == false){
map.put("email", email);
sql.append("group by ").append(config.get(FindConfig.GROUP_BY)).append(" ");
}
if (config.get(FindConfig.ORDER_BY) != null && !"".equals(config.get(FindConfig.ORDER_BY))) {
sql.append("order by ").append(config.get(FindConfig.ORDER_BY)).append(" ");
}
if (config.get(FindConfig.PAGE) != null && !"".equals(config.get(FindConfig.PAGE))) {
int page = config.get(FindConfig.PAGE) != null && !"".equals(config.get(FindConfig.PAGE)) ? Integer.parseInt(config.get(FindConfig.PAGE)) : 1;
int limit = config.get(FindConfig.SIZE) != null && !"".equals(config.get(FindConfig.SIZE)) ? Integer.parseInt(config.get(FindConfig.SIZE)) : 10;
sql.append(" limit ").append((page - 1) * limit).append(" , ").append(limit);
}
log.info("[{}] - 查询操作,sql: {}", table, sql);
return runEntitySql(sql.toString());
}
@Transactional
public void delete(Map<String, String> query, Map<String, String> config) {
StringBuffer sql = new StringBuffer("DELETE FROM ").append("`").append(table).append("`").append(" ");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.GROUP_BY)), config.get(FindConfig.SQLHWERE)));
log.info("[{}] - 删除操作:{}", table, sql);
Query query1 = runCountSql(sql.toString());
query1.executeUpdate();
}
public Query count(Map<String, String> query, Map<String, String> config) {
StringBuffer sql = new StringBuffer("SELECT ");
log.info("拼接统计函数前");
if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))) {
sql.append(config.get(FindConfig.GROUP_BY)).append(" ,COUNT(").append(config.get(FindConfig.GROUP_BY)).append(") FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
sql.append(" ").append("GROUP BY ").append(config.get(FindConfig.GROUP_BY));
} else {
sql.append("COUNT(*) FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
}
log.info("[{}] - 统计操作,sql: {}", table, sql);
return runCountSql(sql.toString());
}
public Query sum(Map<String, String> query, Map<String, String> config) {
StringBuffer sql = new StringBuffer(" SELECT ");
if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))) {
sql.append("`").append(table).append("`").append(" (");
for (Map.Entry<String, Object> entry : body.entrySet()) {
sql.append("`" + humpToLine(entry.getKey()) + "`").append(",");
}
sql.deleteCharAt(sql.length() - 1);
sql.append(") VALUES (");
for (Map.Entry<String, Object> entry : body.entrySet()) {
Object value = entry.getValue();
if (value instanceof String) {
sql.append("'").append(entry.getValue()).append("'").append(",");
} else {
sql.append(entry.getValue()).append(",");
}
}
sql.deleteCharAt(sql.length() - 1);
sql.append(")");
log.info("[{}] - 插入操作:{}", table, sql);
Query query = runCountSql(sql.toString());
query.executeUpdate();
}
@Transactional
public void update(Map<String, String> query, Map<String, String> config, Map<String, Object> body) {
StringBuffer sql = new StringBuffer("UPDATE ").append("`").append(table).append("`").append(" SET ");
for (Map.Entry<String, Object> entry : body.entrySet()) {
Object value = entry.getValue();
if (value instanceof String) {
sql.append("`" + humpToLine(entry.getKey()) + "`").append("=").append("'").append(value).append("'").append(",");
} else {
sql.append("`" + humpToLine(entry.getKey()) + "`").append("=").append(value).append(",");
}
}
sql.deleteCharAt(sql.length() - 1);
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
// sql.append(";");
log.info("[{}] - 更新操作:{}", table, sql);
Query query1 = runCountSql(sql.toString());
query1.executeUpdate();
}
public Map<String, Object> selectToPage(Map<String, String> query, Map<String, String> config) {
Query select = select(query, config);
Map<String, Object> map = new HashMap<>();
map.put("list", select.getResultList());
config.remove(FindConfig.GROUP_BY);
map.put("count", count(query, config).getSingleResult());
return map;
}
public List<Map<String, Object>> selectToList(Map<String, String> query, Map<String, String> config) {
Query select = selectGroupCount(query, config);
*
*/
@RestController
@RequestMapping("/ordinary_users")
public class OrdinaryUsersController extends BaseController<OrdinaryUsers, OrdinaryUsersService> {
/**
* 普通用户对象
*/
@Autowired
public OrdinaryUsersController(OrdinaryUsersService service) {
setService(service);
}
@PostMapping("/add")
@Transactional
public Map<String, Object> add(HttpServletRequest request) throws IOException {
Map<String,Object> paramMap = service.readBody(request.getReader());
Map<String, String> mapordinary_users = new HashMap<>();
mapordinary_users.put("ordinary_users",String.valueOf(paramMap.get("ordinary_users")));
List listordinary_users = service.select(mapordinary_users, new HashMap<>()).getResultList();
if (listordinary_users.size()>0){
return error(30000, "字段普通用户内容不能重复");
}
this.addMap(paramMap);
return success(1);
}
}
Map<String, Object> map = new HashMap<>();
map.put("list", select.getResultList());
config.remove(FindConfig.GROUP_BY);
map.put("count", count(query, config).getSingleResult());
return map;
}
public List<Map<String, Object>> selectToList(Map<String, String> query, Map<String, String> config) {
Query select = selectGroupCount(query, config);
List<Map<String, Object>> list = new ArrayList<>();
List<Object[]> resultList = select.getResultList();
for (Object[] object : resultList) {
Map<String, Object> mapSub = new HashMap<>();
mapSub.put(config.get(FindConfig.GROUP_BY), object[1]);
mapSub.put("count", object[0]);
mapSub.put("0", object[0]);
mapSub.put("1", object[1]);
list.add(mapSub);
}
return list;
}
public Map<String, Object> selectBarGroup(Map<String, String> query, Map<String, String> config) {
Query select = barGroup(query, config);
Map<String, Object> map = new HashMap<>();
map.put("list", select.getResultList());
return map;
}
public Query barGroup(Map<String, String> query, Map<String, String> config) {
StringBuffer sql = new StringBuffer(" SELECT ");
if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))) {
sql.append(config.get(FindConfig.GROUP_BY));
if (config.get(FindConfig.FIELD) != null && !"".equals(config.get(FindConfig.FIELD))) {
String[] fieldList = config.get(FindConfig.FIELD).split(",");
for (int i = 0; i < fieldList.length; i++)
sql.append(" ,SUM(").append(fieldList[i]).append(")");
}
sql.append(" FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
sql.append(" ").append("GROUP BY ").append(config.get(FindConfig.GROUP_BY));
} else {
sql.append(" SUM(").append(config.get(FindConfig.GROUP_BY)).append(") FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
}
log.info("[{}] - 查询操作,sql: {}", table, sql);
return runCountSql(sql.toString());
}
}
public Query sum(Map<String, String> query, Map<String, String> config) {
StringBuffer sql = new StringBuffer(" SELECT ");
if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))) {
sql.append(config.get(FindConfig.GROUP_BY)).append(" ,SUM(").append(config.get(FindConfig.FIELD)).append(") FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
sql.append(" ").append("GROUP BY ").append(config.get(FindConfig.GROUP_BY));
} else {
sql.append(" SUM(").append(config.get(FindConfig.FIELD)).append(") FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
}
log.info("[{}] - 查询操作,sql: {}", table, sql);
return runCountSql(sql.toString());
}
public Query avg(Map<String, String> query, Map<String, String> config) {
StringBuffer sql = new StringBuffer(" SELECT ");
if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))) {
sql.append(config.get(FindConfig.GROUP_BY)).append(" ,AVG(").append(config.get(FindConfig.FIELD)).append(") FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
sql.append(" ").append("GROUP BY ").append(config.get(FindConfig.GROUP_BY));
} else {
sql.append(" AVG(").append(config.get(FindConfig.FIELD)).append(") FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
}
log.info("[{}] - 查询操作,sql: {}", table, sql);
return runCountSql(sql.toString());
}
public String toWhereSql(Map<String, String> query, Boolean like, String sqlwhere) {
if (query.size() > 0) {
try {
StringBuilder sql = new StringBuilder(" WHERE ");
for (Map.Entry<String, String> entry : query.entrySet()) {
if (entry.getKey().contains(FindConfig.MIN_)) {
String min = humpToLine(entry.getKey()).replace("_min", "");
sql.append("`" + min + "`").append(" >= '").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("' and ");
continue;
}
if (entry.getKey().contains(FindConfig.MAX_)) {
String max = humpToLine(entry.getKey()).replace("_max", "");
sql.append("`" + max + "`").append(" <= '").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("' and ");
continue;
}
if (like == true) {
sql.append("`" + humpToLine(entry.getKey()) + "`").append(" LIKE '%").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("%'").append(" and ");
} else {
sql.append("`" + humpToLine(entry.getKey()) + "`").append(" = '").append(URLDecoder.decode(entry.getValue(), "UTF-8")).append("'").append(" and ");
}
return true;
}
else if (request.getRequestURL().toString().contains("/api/user/register")){
return true;
}
// if (token == null || "".equals(token)){
// if ("POST".equals(request.getMethod())){
// return false;
// }else {
// return true;
// }
// }else {
return true;
// }
}
@Override
public void postHandle(HttpServletRequest request, HttpServletResponse response, Object handler, ModelAndView modelAndView) {
//更新token
}
@Override
public void afterCompletion(HttpServletRequest request, HttpServletResponse response, Object handler, Exception ex) throws Exception {
}
private void failure(HttpServletRequest request, HttpServletResponse response) throws IOException {
response.setHeader("Content-type", "application/json;charset=UTF-8");
response.setStatus(401);
// response.getWriter().write("");
response.sendRedirect("https://www.baidu.com");
}
private void setHeader(HttpServletRequest request, HttpServletResponse response) {
//跨域的header设置
response.setHeader("Access-control-Allow-Origin", request.getHeader("Origin"));
response.setHeader("Access-Control-Allow-Methods", "GET, HEAD, POST, PUT, DELETE, TRACE, OPTIONS, PATCH");
response.setHeader("Access-Control-Allow-Credentials", "true");
response.setHeader("Access-Control-Allow-Headers", request.getHeader("Access-Control-Request-Headers"));
response.setHeader("Access-Control-Max-Age", "1800");
//防止乱码,适用于传输JSON数据
}
/**
* (NavAdmin)表控制层
*
*/
@RestController
@RequestMapping("nav_admin")
public class NavAdminController extends BaseController<NavAdmin, NavAdminService> {
/**
* 服务对象
*/
@Autowired
public NavAdminController(NavAdminService service) {
setService(service);
}
}
public HitsController(HitsService service) {
setService(service);
}
}
/**
* 文章:用于内容管理系统的文章(Article)表控制层
*
*/
@RestController
@RequestMapping("article")
public class ArticleController extends BaseController<Article, ArticleService> {
/**
* 服务对象
*/
@Autowired
public ArticleController(ArticleService service) {
setService(service);
}
}
/**
*/
@Slf4j
public class BaseController<E, S extends BaseService<E>> {
@Setter
protected S service;
@PostMapping("/add")
@Transactional
public Map<String, Object> add(HttpServletRequest request) throws IOException {
service.insert(service.readBody(request.getReader()));
return success(1);
}
@Transactional
public Map<String, Object> addMap(Map<String,Object> map){
service.insert(map);
return success(1);
}
@PostMapping("/set")
@Transactional
public Map<String, Object> set(HttpServletRequest request) throws IOException {
service.update(service.readQuery(request), service.readConfig(request), service.readBody(request.getReader()));
return success(1);
@Autowired
public VideoTypeController(VideoTypeService service) {
setService(service);
}
@PostMapping("/add")
@Transactional
public Map<String, Object> add(HttpServletRequest request) throws IOException {
Map<String,Object> paramMap = service.readBody(request.getReader());
this.addMap(paramMap);
return success(1);
}
}
/**
* 文章频道:用于汇总浏览文章,在不同频道下展示不同文章。(ArticleType)表控制层
*
*/
@RestController
@RequestMapping("article_type")
public class ArticleTypeController extends BaseController<ArticleType, ArticleTypeService> {
/**
* 服务对象
*/
@Autowired
public ArticleTypeController(ArticleTypeService service) {
setService(service);
}
}
Map<String, Object> map = new HashMap<>();
map.put("list", select.getResultList());
config.remove(FindConfig.GROUP_BY);
map.put("count", count(query, config).getSingleResult());
return map;
}
public List<Map<String, Object>> selectToList(Map<String, String> query, Map<String, String> config) {
Query select = selectGroupCount(query, config);
List<Map<String, Object>> list = new ArrayList<>();
List<Object[]> resultList = select.getResultList();
for (Object[] object : resultList) {
Map<String, Object> mapSub = new HashMap<>();
mapSub.put(config.get(FindConfig.GROUP_BY), object[1]);
mapSub.put("count", object[0]);
mapSub.put("0", object[0]);
mapSub.put("1", object[1]);
list.add(mapSub);
}
return list;
}
public Map<String, Object> selectBarGroup(Map<String, String> query, Map<String, String> config) {
Query select = barGroup(query, config);
Map<String, Object> map = new HashMap<>();
map.put("list", select.getResultList());
return map;
}
public Query barGroup(Map<String, String> query, Map<String, String> config) {
StringBuffer sql = new StringBuffer(" SELECT ");
if (config.get(FindConfig.GROUP_BY) != null && !"".equals(config.get(FindConfig.GROUP_BY))) {
sql.append(config.get(FindConfig.GROUP_BY));
if (config.get(FindConfig.FIELD) != null && !"".equals(config.get(FindConfig.FIELD))) {
String[] fieldList = config.get(FindConfig.FIELD).split(",");
for (int i = 0; i < fieldList.length; i++)
sql.append(" ,SUM(").append(fieldList[i]).append(")");
}
sql.append(" FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
sql.append(" ").append("GROUP BY ").append(config.get(FindConfig.GROUP_BY));
} else {
sql.append(" SUM(").append(config.get(FindConfig.GROUP_BY)).append(") FROM ").append("`").append(table).append("`");
sql.append(toWhereSql(query, "0".equals(config.get(FindConfig.LIKE)), config.get(FindConfig.SQLHWERE)));
}
log.info("[{}] - 查询操作,sql: {}", table, sql);
* (NavAdmin)表控制层
*
*/
@RestController
@RequestMapping("nav_admin")
public class NavAdminController extends BaseController<NavAdmin, NavAdminService> {
/**
* 服务对象
*/
@Autowired
public NavAdminController(NavAdminService service) {
setService(service);
}
}
/**
* 收藏:(Collect)表控制层
*
*/
@RestController
@RequestMapping("collect")
public class CollectController extends BaseController<Collect, CollectService> {
/**
* 服务对象
*/
@Autowired
public CollectController(CollectService service) {
setService(service);
}
response.setContentType("application/octet-stream");
response.setHeader("Content-disposition", "attachment;filename=employee.xls");
response.flushBuffer();
sheets.write(response.getOutputStream());
sheets.close();
}
public Map<String, Object> success(Object o) {
Map<String, Object> map = new HashMap<>();
if (o == null) {
map.put("result", null);
return map;
}
if (o instanceof List) {
if (((List) o).size() == 1) {
o = ((List) o).get(0);
map.put("result", o);
}else {
String jsonString = JSONObject.toJSONString(o);
JSONArray objects = service.covertArray(JSONObject.parseArray(jsonString));
map.put("result", objects);
}
} else if (o instanceof Integer || o instanceof String) {
map.put("result", o);
} else {
String jsonString = JSONObject.toJSONString(o);
JSONObject jsonObject = JSONObject.parseObject(jsonString);
JSONObject j = service.covertObject(jsonObject);
map.put("result", j);
}
return map;
}
public Map<String, Object> error(Integer code, String message) {
Map<String, Object> map = new HashMap<>();
map.put("error", new HashMap<String, Object>(4) {{
put("code", code);
put("message", message);
}});
return map;
}
}
@RequestMapping("/get_hits_list")
public Map<String, Object> getHits(HttpServletRequest request) {
Map<String,String> paramMap = service.readQuery(request);
if (paramMap.get("user_id")==null||paramMap.get("user_id").equals("")){
return this.getList(request);
}else{
//查询该类产品用户每个产品的访问量
String hitsCountSql = "SELECT COUNT( hits_id ) AS hits_count, source_id FROM hits WHERE source_table = 'video_center' AND user_id = "+paramMap.get("user_id")+" GROUP BY source_id";
//查询最高访问量的产品id
String maxHitsCountSql = "SELECT t1.source_id FROM ( "+hitsCountSql+" ) t1 ORDER BY hits_count DESC LIMIT 0,1";
//查询用户最高访问量对应的类型
String typeSql = "SELECT video_type FROM video_center WHERE video_center_id = ( "+maxHitsCountSql+" )";
//查询该产品类型有哪些产品
String productListSql = "SELECT * FROM video_center WHERE video_type = ( "+typeSql+" )";
//按产品点击量排序,取前4条数据
String sql = productListSql + " ORDER BY hits DESC LIMIT 0,4";
Query select=service.runEntitySql(sql);
Map<String, Object> map=new HashMap<>();
map.put("list",select.getResultList());
map.put("count",select.getResultList().size());
return success(map);
}
}
}
/**
* 发布用户:(PublishingUsers)表控制层
*
*/
@RestController
@RequestMapping("/publishing_users")
public class PublishingUsersController extends BaseController<PublishingUsers, PublishingUsersService> {
/**
* 发布用户对象