package com.ruoyi.web.controller.system;
|
|
import com.ruoyi.common.annotation.Log;
|
import com.ruoyi.common.annotation.RepeatSubmit;
|
import com.ruoyi.common.core.controller.BaseController;
|
import com.ruoyi.common.core.domain.AjaxResult;
|
import com.ruoyi.common.core.page.TableDataInfo;
|
import com.ruoyi.common.enums.BusinessType;
|
import com.ruoyi.common.utils.StringUtils;
|
import com.ruoyi.common.utils.poi.ExcelUtil;
|
import com.ruoyi.system.domain.SysStudent;
|
import com.ruoyi.system.mapper.SysStudentMapper;
|
import com.ruoyi.system.service.ISysStudentService;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.security.access.prepost.PreAuthorize;
|
import org.springframework.web.bind.annotation.*;
|
|
import java.util.*;
|
import java.util.stream.Collectors;
|
|
/**
|
* 学生信息Controller
|
*
|
* @author ruoyi
|
* @date 2021-10-28
|
*/
|
@RestController
|
@RequestMapping("/system/student")
|
public class SysStudentController extends BaseController {
|
@Autowired
|
private ISysStudentService sysStudentService;
|
|
@Autowired
|
SysStudentMapper sysStudentMapper;
|
|
/**
|
* 查询学生信息列表
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:student:list')")
|
@GetMapping("/list")
|
public TableDataInfo list(SysStudent sysStudent) {
|
startPage();
|
List<SysStudent> list = sysStudentService.queryList(sysStudent);
|
//List<SysStudent> list = sysStudentMapper.selectSysStudentList(sysStudent);
|
//List<SysStudent> list = sysStudentMapper.getStudentByName("测试");
|
|
|
//利用stream流进行foreach遍历
|
list.stream().forEach(student -> {
|
//处理逻辑 打印出所有学生的名单和年龄
|
System.out.println(student.getStudentName() + student.getStudentAge());
|
});
|
|
//利用filter函数进行筛选 获取符合条件的
|
List<SysStudent> lista = list.stream().filter(student -> StringUtils.equals(student.getStudentSex(), "1")).collect(Collectors.toList());
|
|
lista.stream().forEach(student -> {
|
//处理逻辑 打印出所有学生的名单和年龄
|
System.out.println(student.getStudentName() + student.getStudentAge());
|
});
|
|
//对List集合进行去重
|
//将username相同的 进行去重
|
List<SysStudent> unique = list.stream().collect(Collectors.collectingAndThen(
|
Collectors.toCollection(() -> new TreeSet<>(Comparator.comparing(SysStudent::getStudentName))), ArrayList::new));
|
unique.stream().forEach(student -> {
|
System.out.println("-------------------" + student.getStudentName());
|
});
|
|
//取出list集合对象中的某一个属性(取出list中的每一个对象的名字组成一个新的集合)
|
List<String> usernames = list.stream().map(s -> s.getStudentName()).collect(Collectors.toList());//不取重的
|
usernames.stream().forEach(username -> {
|
System.out.println("不取重的-------------------" + username);
|
});
|
|
List<String> names = list.stream().map(SysStudent::getStudentName).distinct().collect(Collectors.toList());//这个是将名字取重之后的
|
names.stream().forEach(username -> {
|
System.out.println("取重之后-------------------" + username);
|
});
|
|
|
//查询姓名不为空的记录
|
List<String> IsEmptyUsernameList = list.stream().map(s -> s.getStudentName()).filter(s -> !s.isEmpty()).collect(Collectors.toList());
|
System.out.println(IsEmptyUsernameList);
|
//根据其中的某一属性值进行计算
|
//(获取年龄的最大值、最小值、平均值、综合、个数)
|
IntSummaryStatistics resultNum = list.stream().mapToInt((s) -> s.getStudentAge()).summaryStatistics();
|
//个数
|
System.out.println(resultNum.getCount());
|
//总大小
|
System.out.println(resultNum.getSum());
|
//最大值
|
System.out.println(resultNum.getMax());
|
//最小值
|
System.out.println(resultNum.getMin());
|
//平均值
|
System.out.println(resultNum.getAverage());
|
|
return getDataTable(list);
|
}
|
|
/**
|
* 导出学生信息列表
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:student:export')")
|
@Log(title = "学生信息", businessType = BusinessType.EXPORT)
|
@GetMapping("/export")
|
public AjaxResult export(SysStudent sysStudent) {
|
List<SysStudent> list = sysStudentService.queryList(sysStudent);
|
ExcelUtil<SysStudent> util = new ExcelUtil<SysStudent>(SysStudent.class);
|
return util.exportExcel(list, "学生信息数据");
|
}
|
|
/**
|
* 获取学生信息详细信息
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:student:query')")
|
@GetMapping(value = "/{studentId}")
|
public AjaxResult getInfo(@PathVariable("studentId") Long studentId) {
|
return AjaxResult.success(sysStudentService.getById(studentId));
|
}
|
|
/**
|
* 新增学生信息
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:student:add')")
|
@Log(title = "学生信息", businessType = BusinessType.INSERT)
|
@PostMapping
|
@RepeatSubmit
|
public AjaxResult add(@RequestBody SysStudent sysStudent) {
|
return toAjax(sysStudentService.save(sysStudent));
|
}
|
|
/**
|
* 修改学生信息
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:student:edit')")
|
@Log(title = "学生信息", businessType = BusinessType.UPDATE)
|
@PostMapping("/edit")
|
@RepeatSubmit
|
public AjaxResult edit(@RequestBody SysStudent sysStudent) {
|
return toAjax(sysStudentService.updateById(sysStudent));
|
}
|
|
/**
|
* 删除学生信息
|
*/
|
// @PreAuthorize("@ss.hasPermi('system:student:remove')")
|
@Log(title = "学生信息", businessType = BusinessType.DELETE)
|
@GetMapping("/remove/{studentIds}")
|
public AjaxResult remove(@PathVariable Long[] studentIds) {
|
return toAjax(sysStudentService.removeByIds(Arrays.asList(studentIds)));
|
}
|
}
|
