✨作者主页:IT研究室✨
个人简介:曾从事计算机专业培训教学,擅长Java、Python、微信小程序、Golang、安卓Android等项目实战。接项目定制开发、代码讲解、答辩教学、文档编写、降重等。
☑文末获取源码☑
精彩专栏推荐⬇⬇⬇
Java项目
Python项目
安卓项目
微信小程序项目
一、前言
实验室作为高校教学和科研的重要基地,其管理水平直接影响到教学效果和科研成果的质量。随着教育信息化的推进,传统的实验室管理模式已难以满足现代教育的需求。目前,许多高校的实验室管理仍面临着资源利用率低、管理效率不高等问题。为了提高实验室管理的效率和水平,开放式实验室管理系统应运而生。这种系统通过信息化手段,实现了实验室资源的统一管理和优化配置,促进了实验室设备的开放共享,提高了实验室的使用效率和管理水平。
尽管已有一些实验室管理系统,但它们普遍存在一些问题。例如,系统功能单一,只能解决狭窄领域的问题,缺乏通用性;系统操作复杂,用户体验不佳;数据孤岛现象严重,信息共享和流通不畅;系统安全性不足,存在数据泄露风险等。
本课题旨在设计并实现一个开放式实验室管理系统,该系统将综合实验室的各种管理需求,包括实验室设备、人员、实验数据等方面,实现实验室资源的统一管理和优化配置。系统将提供不同权限的服务功能,满足不同用户的需求,如学生在线查询、预约实验资源;教师在线发布实验任务及跟踪实验进度;实验室管理员对各项软硬件资源的管理;各级院系领导查看阶段性报表、设备资源利用率等功能。
在开放式实验室管理系统中,管理员负责系统用户信息的创建与维护、实验室资源的配置与管理、实验项目和预约的审批、系统公告的发布与更新;学生和教师浏览实验室开放时间、预约实验、提交实验报告、查询实验相关资源等。系统通过这些功能模块的整合,旨在提供一个高效、便捷的实验室管理环境,满足不同用户角色的需求,优化实验室资源的分配和使用。
本课题的研究具有重要的理论意义和实际意义。从理论角度来看,它为实验室管理领域提供了新的研究思路,即如何利用信息技术提升实验室管理的效率和水平。从实际角度来看,开放式实验室管理系统的应用将极大地提高实验室设备的使用率和开放程度,优化实验室资源的配置,提高管理效率和投资效益,促进高校教学和科研工作的开展。
二、开发环境
- 开发语言:Java/Python
- 数据库:MySQL
- 系统架构:B/S
- 后端:SpringBoot/SSM/Django/Flask
- 前端:Vue
三、系统界面展示
- 实验室开放管理系统界面展示:
管理员-实验室管理:
管理员-设备信息室管理:
管理员-实验室预约审核:
管理员-设备借用审核:
学生、教师-预约实验室:
学生、教师-借用设备:
学生、教师-领取设备:
学生、教师-归还设备:
学生、教师-设备报修:
四、代码参考
- 项目实战代码参考:
@RestController
@RequestMapping("/shiyanshiyuyue")
public class ShiyanshiyuyueController {
@Autowired
private ShiyanshiyuyueService shiyanshiyuyueService;
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,ShiyanshiyuyueEntity shiyanshiyuyue,
HttpServletRequest request){
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiaoshi")) {
shiyanshiyuyue.setJiaoshigonghao((String)request.getSession().getAttribute("username"));
}
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
PageUtils page = shiyanshiyuyueService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shiyanshiyuyue), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,ShiyanshiyuyueEntity shiyanshiyuyue,
HttpServletRequest request){
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
PageUtils page = shiyanshiyuyueService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shiyanshiyuyue), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( ShiyanshiyuyueEntity shiyanshiyuyue){
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
ew.allEq(MPUtil.allEQMapPre( shiyanshiyuyue, "shiyanshiyuyue"));
return R.ok().put("data", shiyanshiyuyueService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(ShiyanshiyuyueEntity shiyanshiyuyue){
EntityWrapper< ShiyanshiyuyueEntity> ew = new EntityWrapper< ShiyanshiyuyueEntity>();
ew.allEq(MPUtil.allEQMapPre( shiyanshiyuyue, "shiyanshiyuyue"));
ShiyanshiyuyueView shiyanshiyuyueView = shiyanshiyuyueService.selectView(ew);
return R.ok("查询实验室预约成功").put("data", shiyanshiyuyueView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
ShiyanshiyuyueEntity shiyanshiyuyue = shiyanshiyuyueService.selectById(id);
return R.ok().put("data", shiyanshiyuyue);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
ShiyanshiyuyueEntity shiyanshiyuyue = shiyanshiyuyueService.selectById(id);
return R.ok().put("data", shiyanshiyuyue);
}
/**
* 后端保存
*/
@RequestMapping("/save")
@SysLog("新增实验室预约")
public R save(@RequestBody ShiyanshiyuyueEntity shiyanshiyuyue, HttpServletRequest request){
//ValidatorUtils.validateEntity(shiyanshiyuyue);
shiyanshiyuyueService.insert(shiyanshiyuyue);
return R.ok();
}
/**
* 前端保存
*/
@SysLog("新增实验室预约")
@RequestMapping("/add")
public R add(@RequestBody ShiyanshiyuyueEntity shiyanshiyuyue, HttpServletRequest request){
//ValidatorUtils.validateEntity(shiyanshiyuyue);
shiyanshiyuyueService.insert(shiyanshiyuyue);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
@Transactional
@SysLog("修改实验室预约")
public R update(@RequestBody ShiyanshiyuyueEntity shiyanshiyuyue, HttpServletRequest request){
//ValidatorUtils.validateEntity(shiyanshiyuyue);
shiyanshiyuyueService.updateById(shiyanshiyuyue);//全部更新
return R.ok();
}
/**
* 审核
*/
@RequestMapping("/shBatch")
@Transactional
@SysLog("审核实验室预约")
public R update(@RequestBody Long[] ids, @RequestParam String sfsh, @RequestParam String shhf){
List<ShiyanshiyuyueEntity> list = new ArrayList<ShiyanshiyuyueEntity>();
for(Long id : ids) {
ShiyanshiyuyueEntity shiyanshiyuyue = shiyanshiyuyueService.selectById(id);
shiyanshiyuyue.setSfsh(sfsh);
shiyanshiyuyue.setShhf(shhf);
list.add(shiyanshiyuyue);
}
shiyanshiyuyueService.updateBatchById(list);
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
@SysLog("删除实验室预约")
public R delete(@RequestBody Long[] ids){
shiyanshiyuyueService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* (按值统计)
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}")
public R value(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiaoshi")) {
ew.eq("jiaoshigonghao", (String)request.getSession().getAttribute("username"));
}
List<Map<String, Object>> result = shiyanshiyuyueService.selectValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* (按值统计(多))
*/
@RequestMapping("/valueMul/{xColumnName}")
public R valueMul(@PathVariable("xColumnName") String xColumnName,@RequestParam String yColumnNameMul, HttpServletRequest request) {
String[] yColumnNames = yColumnNameMul.split(",");
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiaoshi")) {
ew.eq("jiaoshigonghao", (String)request.getSession().getAttribute("username"));
}
for(int i=0;i<yColumnNames.length;i++) {
params.put("yColumn", yColumnNames[i]);
List<Map<String, Object>> result = shiyanshiyuyueService.selectValue(params, ew);
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
result2.add(result);
}
return R.ok().put("data", result2);
}
/**
* (按值统计)时间统计类型
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}/{timeStatType}")
public R valueDay(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
params.put("timeStatType", timeStatType);
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiaoshi")) {
ew.eq("jiaoshigonghao", (String)request.getSession().getAttribute("username"));
}
List<Map<String, Object>> result = shiyanshiyuyueService.selectTimeStatValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* (按值统计)时间统计类型(多)
*/
@RequestMapping("/valueMul/{xColumnName}/{timeStatType}")
public R valueMulDay(@PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,@RequestParam String yColumnNameMul,HttpServletRequest request) {
String[] yColumnNames = yColumnNameMul.split(",");
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("timeStatType", timeStatType);
List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiaoshi")) {
ew.eq("jiaoshigonghao", (String)request.getSession().getAttribute("username"));
}
for(int i=0;i<yColumnNames.length;i++) {
params.put("yColumn", yColumnNames[i]);
List<Map<String, Object>> result = shiyanshiyuyueService.selectTimeStatValue(params, ew);
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
result2.add(result);
}
return R.ok().put("data", result2);
}
/**
* 分组统计
*/
@RequestMapping("/group/{columnName}")
public R group(@PathVariable("columnName") String columnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("column", columnName);
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiaoshi")) {
ew.eq("jiaoshigonghao", (String)request.getSession().getAttribute("username"));
}
List<Map<String, Object>> result = shiyanshiyuyueService.selectGroup(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* 总数量
*/
@RequestMapping("/count")
public R count(@RequestParam Map<String, Object> params,ShiyanshiyuyueEntity shiyanshiyuyue, HttpServletRequest request){
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("jiaoshi")) {
shiyanshiyuyue.setJiaoshigonghao((String)request.getSession().getAttribute("username"));
}
EntityWrapper<ShiyanshiyuyueEntity> ew = new EntityWrapper<ShiyanshiyuyueEntity>();
int count = shiyanshiyuyueService.selectCount(MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shiyanshiyuyue), params), params));
return R.ok().put("data", count);
}
}
@RestController
@RequestMapping("/shebeijieyong")
public class ShebeijieyongController {
@Autowired
private ShebeijieyongService shebeijieyongService;
/**
* 后端列表
*/
@RequestMapping("/page")
public R page(@RequestParam Map<String, Object> params,ShebeijieyongEntity shebeijieyong,
HttpServletRequest request){
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
shebeijieyong.setXuehao((String)request.getSession().getAttribute("username"));
}
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
PageUtils page = shebeijieyongService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shebeijieyong), params), params));
return R.ok().put("data", page);
}
/**
* 前端列表
*/
@IgnoreAuth
@RequestMapping("/list")
public R list(@RequestParam Map<String, Object> params,ShebeijieyongEntity shebeijieyong,
HttpServletRequest request){
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
PageUtils page = shebeijieyongService.queryPage(params, MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shebeijieyong), params), params));
return R.ok().put("data", page);
}
/**
* 列表
*/
@RequestMapping("/lists")
public R list( ShebeijieyongEntity shebeijieyong){
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
ew.allEq(MPUtil.allEQMapPre( shebeijieyong, "shebeijieyong"));
return R.ok().put("data", shebeijieyongService.selectListView(ew));
}
/**
* 查询
*/
@RequestMapping("/query")
public R query(ShebeijieyongEntity shebeijieyong){
EntityWrapper< ShebeijieyongEntity> ew = new EntityWrapper< ShebeijieyongEntity>();
ew.allEq(MPUtil.allEQMapPre( shebeijieyong, "shebeijieyong"));
ShebeijieyongView shebeijieyongView = shebeijieyongService.selectView(ew);
return R.ok("查询设备借用成功").put("data", shebeijieyongView);
}
/**
* 后端详情
*/
@RequestMapping("/info/{id}")
public R info(@PathVariable("id") Long id){
ShebeijieyongEntity shebeijieyong = shebeijieyongService.selectById(id);
return R.ok().put("data", shebeijieyong);
}
/**
* 前端详情
*/
@IgnoreAuth
@RequestMapping("/detail/{id}")
public R detail(@PathVariable("id") Long id){
ShebeijieyongEntity shebeijieyong = shebeijieyongService.selectById(id);
return R.ok().put("data", shebeijieyong);
}
/**
* 后端保存
*/
@RequestMapping("/save")
@SysLog("新增设备借用")
public R save(@RequestBody ShebeijieyongEntity shebeijieyong, HttpServletRequest request){
//ValidatorUtils.validateEntity(shebeijieyong);
shebeijieyongService.insert(shebeijieyong);
return R.ok();
}
/**
* 前端保存
*/
@SysLog("新增设备借用")
@RequestMapping("/add")
public R add(@RequestBody ShebeijieyongEntity shebeijieyong, HttpServletRequest request){
//ValidatorUtils.validateEntity(shebeijieyong);
shebeijieyongService.insert(shebeijieyong);
return R.ok();
}
/**
* 修改
*/
@RequestMapping("/update")
@Transactional
@SysLog("修改设备借用")
public R update(@RequestBody ShebeijieyongEntity shebeijieyong, HttpServletRequest request){
//ValidatorUtils.validateEntity(shebeijieyong);
shebeijieyongService.updateById(shebeijieyong);//全部更新
return R.ok();
}
/**
* 审核
*/
@RequestMapping("/shBatch")
@Transactional
@SysLog("审核设备借用")
public R update(@RequestBody Long[] ids, @RequestParam String sfsh, @RequestParam String shhf){
List<ShebeijieyongEntity> list = new ArrayList<ShebeijieyongEntity>();
for(Long id : ids) {
ShebeijieyongEntity shebeijieyong = shebeijieyongService.selectById(id);
shebeijieyong.setSfsh(sfsh);
shebeijieyong.setShhf(shhf);
list.add(shebeijieyong);
}
shebeijieyongService.updateBatchById(list);
return R.ok();
}
/**
* 删除
*/
@RequestMapping("/delete")
@SysLog("删除设备借用")
public R delete(@RequestBody Long[] ids){
shebeijieyongService.deleteBatchIds(Arrays.asList(ids));
return R.ok();
}
/**
* (按值统计)
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}")
public R value(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
ew.eq("xuehao", (String)request.getSession().getAttribute("username"));
}
List<Map<String, Object>> result = shebeijieyongService.selectValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* (按值统计(多))
*/
@RequestMapping("/valueMul/{xColumnName}")
public R valueMul(@PathVariable("xColumnName") String xColumnName,@RequestParam String yColumnNameMul, HttpServletRequest request) {
String[] yColumnNames = yColumnNameMul.split(",");
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
ew.eq("xuehao", (String)request.getSession().getAttribute("username"));
}
for(int i=0;i<yColumnNames.length;i++) {
params.put("yColumn", yColumnNames[i]);
List<Map<String, Object>> result = shebeijieyongService.selectValue(params, ew);
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
result2.add(result);
}
return R.ok().put("data", result2);
}
/**
* (按值统计)时间统计类型
*/
@RequestMapping("/value/{xColumnName}/{yColumnName}/{timeStatType}")
public R valueDay(@PathVariable("yColumnName") String yColumnName, @PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("yColumn", yColumnName);
params.put("timeStatType", timeStatType);
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
ew.eq("xuehao", (String)request.getSession().getAttribute("username"));
}
List<Map<String, Object>> result = shebeijieyongService.selectTimeStatValue(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* (按值统计)时间统计类型(多)
*/
@RequestMapping("/valueMul/{xColumnName}/{timeStatType}")
public R valueMulDay(@PathVariable("xColumnName") String xColumnName, @PathVariable("timeStatType") String timeStatType,@RequestParam String yColumnNameMul,HttpServletRequest request) {
String[] yColumnNames = yColumnNameMul.split(",");
Map<String, Object> params = new HashMap<String, Object>();
params.put("xColumn", xColumnName);
params.put("timeStatType", timeStatType);
List<List<Map<String, Object>>> result2 = new ArrayList<List<Map<String,Object>>>();
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
ew.eq("xuehao", (String)request.getSession().getAttribute("username"));
}
for(int i=0;i<yColumnNames.length;i++) {
params.put("yColumn", yColumnNames[i]);
List<Map<String, Object>> result = shebeijieyongService.selectTimeStatValue(params, ew);
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
result2.add(result);
}
return R.ok().put("data", result2);
}
/**
* 分组统计
*/
@RequestMapping("/group/{columnName}")
public R group(@PathVariable("columnName") String columnName,HttpServletRequest request) {
Map<String, Object> params = new HashMap<String, Object>();
params.put("column", columnName);
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
ew.eq("xuehao", (String)request.getSession().getAttribute("username"));
}
List<Map<String, Object>> result = shebeijieyongService.selectGroup(params, ew);
SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
for(Map<String, Object> m : result) {
for(String k : m.keySet()) {
if(m.get(k) instanceof Date) {
m.put(k, sdf.format((Date)m.get(k)));
}
}
}
return R.ok().put("data", result);
}
/**
* 总数量
*/
@RequestMapping("/count")
public R count(@RequestParam Map<String, Object> params,ShebeijieyongEntity shebeijieyong, HttpServletRequest request){
String tableName = request.getSession().getAttribute("tableName").toString();
if(tableName.equals("xuesheng")) {
shebeijieyong.setXuehao((String)request.getSession().getAttribute("username"));
}
EntityWrapper<ShebeijieyongEntity> ew = new EntityWrapper<ShebeijieyongEntity>();
int count = shebeijieyongService.selectCount(MPUtil.sort(MPUtil.between(MPUtil.likeOrEq(ew, shebeijieyong), params), params));
return R.ok().put("data", count);
}
}
五、论文参考
- 计算机毕业设计选题推荐-实验室开放管理系统论文参考:
六、系统视频
实验室开放管理系统项目视频:
计算机毕业设计选题推荐-实验室开放管理系统-项目实战
结语
计算机毕业设计选题推荐-实验室开放管理系统-Java/Python项目实战
大家可以帮忙点赞、收藏、关注、评论啦~
源码获取:⬇⬇⬇