Java全栈项目：实验室预约管理系统的设计与实现

一、项目介绍

实验室预约管理系统是一个基于Java全栈技术开发的Web应用系统，旨在提供便捷的实验室预约、管理和使用体验。本系统主要面向高校师生，实现实验室资源的智能化、信息化管理。

二、技术栈

前端技术

• Vue.js
• Element UI
• Axios
• Vue Router
• Vuex

后端技术

• Spring Boot
• Spring Security
• MyBatis Plus
• MySQL
• Redis
• JWT

三、核心功能模块

1. 用户管理模块

• 用户注册与登录
• 角色权限管理
• 个人信息维护

2. 实验室管理模块

• 实验室信息管理
• 设备资源管理
• 实验室状态监控

3. 预约管理模块

• 在线预约申请
• 预约审批流程
• 预约记录查询
• 使用情况统计

4. 系统管理模块

• 系统参数配置
• 日志管理
• 数据备份

四、数据库设计

主要数据表

-- 用户表
CREATE TABLE user (id BIGINT PRIMARY KEY,username VARCHAR(50),password VARCHAR(100),role VARCHAR(20),create_time DATETIME
);-- 实验室表
CREATE TABLE laboratory (id BIGINT PRIMARY KEY,name VARCHAR(100),capacity INT,status VARCHAR(20),description TEXT
);-- 预约记录表
CREATE TABLE reservation (id BIGINT PRIMARY KEY,user_id BIGINT,lab_id BIGINT,start_time DATETIME,end_time DATETIME,status VARCHAR(20)
);

五、核心功能实现

1. 预约流程实现

@Service
public class ReservationService {@Autowiredprivate ReservationMapper reservationMapper;@Transactionalpublic Result createReservation(ReservationDTO dto) {// 检查实验室是否可用if (!checkLabAvailable(dto.getLabId())) {return Result.fail("实验室不可用");}// 检查时间冲突if (checkTimeConflict(dto)) {return Result.fail("预约时间冲突");}// 创建预约记录Reservation reservation = new Reservation();BeanUtils.copyProperties(dto, reservation);reservationMapper.insert(reservation);return Result.success();}
}

2. 权限控制实现

@Configuration
@EnableWebSecurity
public class SecurityConfig extends WebSecurityConfigurerAdapter {@Overrideprotected void configure(HttpSecurity http) throws Exception {http.authorizeRequests().antMatchers("/api/public/**").permitAll().antMatchers("/api/admin/**").hasRole("ADMIN").antMatchers("/api/user/**").hasRole("USER").anyRequest().authenticated().and().addFilter(new JWTAuthenticationFilter(authenticationManager())).addFilter(new JWTAuthorizationFilter(authenticationManager()));}
}

六、系统特点

1. 用户友好：直观的界面设计，操作简单便捷
2. 实时响应：采用WebSocket实现实验室状态实时更新
3. 高可用性：使用Redis缓存提升系统性能
4. 安全可靠：完善的权限控制和数据加密机制

七、项目部署

环境要求

• JDK 1.8+
• Maven 3.6+
• MySQL 5.7+
• Redis 6.0+
• Node.js 12+

部署步骤

1. 数据库初始化
2. 后端服务部署
3. 前端项目打包
4. Nginx配置

八、总结与展望

本项目实现了实验室预约管理的核心功能，通过现代化的技术栈，提供了良好的用户体验。未来计划添加以下功能：

1. 引入人脸识别功能
2. 集成物联网设备
3. 开发移动端应用
4. 添加数据分析功能

---

本文介绍了实验室预约管理系统的主要功能和技术实现，希望能为相似项目的开发提供参考。

实验室预约管理系统核心模块详解（上）

一、用户管理模块

1. 数据库设计

-- 用户表
CREATE TABLE sys_user (id BIGINT PRIMARY KEY AUTO_INCREMENT,username VARCHAR(50) NOT NULL COMMENT '用户名',password VARCHAR(100) NOT NULL COMMENT '密码',real_name VARCHAR(50) COMMENT '真实姓名',phone VARCHAR(20) COMMENT '手机号',email VARCHAR(100) COMMENT '邮箱',avatar VARCHAR(200) COMMENT '头像URL',status TINYINT DEFAULT 1 COMMENT '状态:0-禁用,1-启用',create_time DATETIME COMMENT '创建时间',update_time DATETIME COMMENT '更新时间'
);-- 角色表
CREATE TABLE sys_role (id BIGINT PRIMARY KEY AUTO_INCREMENT,role_name VARCHAR(50) NOT NULL COMMENT '角色名称',role_code VARCHAR(50) NOT NULL COMMENT '角色编码',description VARCHAR(200) COMMENT '角色描述',status TINYINT DEFAULT 1 COMMENT '状态'
);-- 用户角色关联表
CREATE TABLE sys_user_role (id BIGINT PRIMARY KEY AUTO_INCREMENT,user_id BIGINT NOT NULL COMMENT '用户ID',role_id BIGINT NOT NULL COMMENT '角色ID'
);-- 权限表
CREATE TABLE sys_permission (id BIGINT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(50) COMMENT '权限名称',code VARCHAR(50) COMMENT '权限编码',type TINYINT COMMENT '类型:1-菜单,2-按钮',parent_id BIGINT COMMENT '父级ID',path VARCHAR(200) COMMENT '路由路径',icon VARCHAR(50) COMMENT '图标'
);

2. 核心功能实现

2.1 用户注册

@Service
public class UserService {@Autowiredprivate PasswordEncoder passwordEncoder;@Autowiredprivate UserMapper userMapper;@Transactionalpublic Result register(UserRegisterDTO dto) {// 验证用户名是否存在if(checkUsernameExist(dto.getUsername())) {return Result.fail("用户名已存在");}// 密码加密String encodedPassword = passwordEncoder.encode(dto.getPassword());// 创建用户SysUser user = new SysUser();user.setUsername(dto.getUsername());user.setPassword(encodedPassword);user.setPhone(dto.getPhone());user.setEmail(dto.getEmail());user.setCreateTime(new Date());userMapper.insert(user);// 分配默认角色assignDefaultRole(user.getId());return Result.success();}
}

2.2 用户登录

@Service
public class AuthService {@Autowiredprivate UserService userService;@Autowiredprivate JwtUtils jwtUtils;public Result login(LoginDTO loginDTO) {// 用户认证UsernamePasswordAuthenticationToken authenticationToken = new UsernamePasswordAuthenticationToken(loginDTO.getUsername(), loginDTO.getPassword());Authentication authentication = authenticationManager.authenticate(authenticationToken);if (authentication == null) {throw new BadCredentialsException("用户名或密码错误");}// 生成JWT tokenString token = jwtUtils.generateToken(authentication);// 获取用户信息UserVO userInfo = userService.getUserInfo(loginDTO.getUsername());Map<String, Object> result = new HashMap<>();result.put("token", token);result.put("userInfo", userInfo);return Result.success(result);}
}

2.3 角色权限管理

@Service
public class RoleService {@Autowiredprivate RoleMapper roleMapper;@Autowiredprivate UserRoleMapper userRoleMapper;@Transactionalpublic Result assignRoles(Long userId, List<Long> roleIds) {// 删除原有角色userRoleMapper.deleteByUserId(userId);// 分配新角色if (!CollectionUtils.isEmpty(roleIds)) {List<SysUserRole> userRoles = roleIds.stream().map(roleId -> new SysUserRole(userId, roleId)).collect(Collectors.toList());userRoleMapper.batchInsert(userRoles);}return Result.success();}public List<PermissionVO> getRolePermissions(Long roleId) {return roleMapper.selectPermissionsByRoleId(roleId);}
}

二、实验室管理模块

1. 数据库设计

-- 实验室表
CREATE TABLE lab_info (id BIGINT PRIMARY KEY AUTO_INCREMENT,name VARCHAR(100) NOT NULL COMMENT '实验室名称',location VARCHAR(200) COMMENT '位置',capacity INT COMMENT '容量',description TEXT COMMENT '描述',status TINYINT DEFAULT 1 COMMENT '状态:0-维护中,1-可用',create_time DATETIME,update_time DATETIME
);-- 设备表
CREATE TABLE lab_equipment (id BIGINT PRIMARY KEY AUTO_INCREMENT,lab_id BIGINT COMMENT '实验室ID',name VARCHAR(100) COMMENT '设备名称',model VARCHAR(100) COMMENT '型号',serial_number VARCHAR(100) COMMENT '序列号',status TINYINT COMMENT '状态:0-故障,1-正常',purchase_date DATE COMMENT '购买日期',maintenance_date DATE COMMENT '上次维护日期'
);-- 实验室状态记录表
CREATE TABLE lab_status_log (id BIGINT PRIMARY KEY AUTO_INCREMENT,lab_id BIGINT COMMENT '实验室ID',status TINYINT COMMENT '状态',remark VARCHAR(500) COMMENT '备注',create_time DATETIME
);

2. 核心功能实现

2.1 实验室信息管理

@Service
public class LabService {@Autowiredprivate LabMapper labMapper;@Autowiredprivate LabEquipmentMapper equipmentMapper;@Transactionalpublic Result createLab(LabCreateDTO dto) {// 创建实验室基本信息LabInfo lab = new LabInfo();BeanUtils.copyProperties(dto, lab);lab.setCreateTime(new Date());labMapper.insert(lab);// 添加设备信息if (!CollectionUtils.isEmpty(dto.getEquipments())) {List<LabEquipment> equipments = dto.getEquipments().stream().map(e -> {LabEquipment equipment = new LabEquipment();equipment.setLabId(lab.getId());BeanUtils.copyProperties(e, equipment);return equipment;}).collect(Collectors.toList());equipmentMapper.batchInsert(equipments);}return Result.success();}public PageResult<LabVO> queryLabs(LabQueryDTO query) {Page<LabInfo> page = new Page<>(query.getPageNum(), query.getPageSize());IPage<LabVO> labPage = labMapper.selectLabPage(page, query);return new PageResult<>(labPage);}
}

2.2 设备资源管理

@Service
public class EquipmentService {@Autowiredprivate LabEquipmentMapper equipmentMapper;@Autowiredprivate MaintenanceRecordMapper maintenanceMapper;public Result updateEquipmentStatus(Long equipmentId, Integer status, String remark) {LabEquipment equipment = equipmentMapper.selectById(equipmentId);if (equipment == null) {return Result.fail("设备不存在");}// 更新设备状态equipment.setStatus(status);equipmentMapper.updateById(equipment);// 记录维护信息if (status == EquipmentStatusEnum.MAINTENANCE.getCode()) {MaintenanceRecord record = new MaintenanceRecord();record.setEquipmentId(equipmentId);record.setMaintenanceDate(new Date());record.setRemark(remark);maintenanceMapper.insert(record);}return Result.success();}public List<EquipmentVO> getLabEquipments(Long labId) {return equipmentMapper.selectByLabId(labId);}
}

2.3 实验室状态监控

@Service
public class LabMonitorService {@Autowiredprivate LabStatusLogMapper statusLogMapper;@Autowiredprivate WebSocketServer webSocketServer;@Asyncpublic void monitorLabStatus() {// 定时检查实验室状态List<LabInfo> labs = labMapper.selectList(null);for (LabInfo lab : labs) {LabStatusDTO status = checkLabStatus(lab.getId());// 记录状态变更if (isStatusChanged(lab.getId(), status.getStatus())) {LabStatusLog log = new LabStatusLog();log.setLabId(lab.getId());log.setStatus(status.getStatus());log.setRemark(status.getRemark());statusLogMapper.insert(log);// 推送状态更新webSocketServer.sendMessage(String.format("lab_%d", lab.getId()),JSON.toJSONString(status));}}}public List<LabStatusVO> getLabStatusHistory(Long labId, Date startTime, Date endTime) {return statusLogMapper.selectStatusHistory(labId, startTime, endTime);}
}

3. 前端实现示例

3.1 用户登录组件

<template><div class="login-container"><el-form :model="loginForm" :rules="loginRules" ref="loginForm"><el-form-item prop="username"><el-input v-model="loginForm.username" placeholder="用户名"><i slot="prefix" class="el-icon-user"></i></el-input></el-form-item><el-form-item prop="password"><el-input type="password" v-model="loginForm.password" placeholder="密码"><i slot="prefix" class="el-icon-lock"></i></el-input></el-form-item><el-button type="primary" @click="handleLogin" :loading="loading">登录</el-button></el-form></div>
</template><script>
export default {data() {return {loginForm: {username: '',password: ''},loginRules: {username: [{ required: true, message: '请输入用户名', trigger: 'blur' }],password: [{ required: true, message: '请输入密码', trigger: 'blur' }]},loading: false}},methods: {async handleLogin() {try {await this.$refs.loginForm.validate()this.loading = trueconst res = await this.$api.login(this.loginForm)if (res.code === 0) {this.$store.commit('SET_TOKEN', res.data.token)this.$store.commit('SET_USER_INFO', res.data.userInfo)this.$router.push('/')}} catch (error) {console.error(error)} finally {this.loading = false}}}
}
</script>

3.2 实验室管理组件

<template><div class="lab-manage"><!-- 搜索栏 --><div class="search-bar"><el-form :inline="true" :model="queryForm"><el-form-item label="实验室名称"><el-input v-model="queryForm.name" placeholder="请输入"></el-input></el-form-item><el-form-item label="状态"><el-select v-model="queryForm.status" placeholder="请选择"><el-option label="可用" :value="1"></el-option><el-option label="维护中" :value="0"></el-option></el-select></el-form-item><el-form-item><el-button type="primary" @click="handleSearch">查询</el-button><el-button @click="handleReset">重置</el-button></el-form-item></el-form></div><!-- 实验室列表 --><el-table :data="labList" border><el-table-column prop="name" label="实验室名称"></el-table-column><el-table-column prop="location" label="位置"></el-table-column><el-table-column prop="capacity" label="容量"></el-table-column><el-table-column label="状态"><template slot-scope="scope"><el-tag :type="scope.row.status === 1 ? 'success' : 'danger'">{{ scope.row.status === 1 ? '可用' : '维护中' }}</el-tag></template></el-table-column><el-table-column label="操作" width="200"><template slot-scope="scope"><el-button type="text" @click="handleEdit(scope.row)">编辑</el-button><el-button type="text" @click="handleEquipment(scope.row)">设备管理</el-button><el-button type="text" @click="handleStatus(scope.row)">状态记录</el-button></template></el-table-column></el-table><!-- 分页 --><el-pagination@current-change="handleCurrentChange"@size-change="handleSizeChange":current-page="queryForm.pageNum":page-sizes="[10, 20, 50]":page-size="queryForm.pageSize"layout="total, sizes, prev, pager, next":total="total"></el-pagination></div>
</template><script>
export default {data() {return {queryForm: {name: '',status: '',pageNum: 1,pageSize: 10},labList: [],total: 0}},created() {this.fetchLabList()},methods: {async fetchLabList() {try {const res = await this.$api.queryLabs(this.queryForm)this.labList = res.data.recordsthis.total = res.data.total} catch (error) {console.error(error)}},handleSearch() {this.queryForm.pageNum = 1this.fetchLabList()},handleReset() {this.queryForm = {name: '',status: '',pageNum: 1,pageSize: 10}this.fetchLabList()}// ... 其他方法实现}
}
</script>

以上是用户管理模块和实验室管理模块的详细实现。包括了:

1. 完整的数据库表设计
2. 后端核心业务逻辑实现
3. 前端组件示例代码

这些代码展示了基本的CRUD操作、状态管理、实时监控等功能的实现方式。实际项目中还需要根据具体需求进行调整和扩展。

实验室预约管理系统模块详解(下)

一、预约管理模块

1. 数据库设计

-- 预约记录表
CREATE TABLE lab_reservation (id BIGINT PRIMARY KEY AUTO_INCREMENT,user_id BIGINT NOT NULL COMMENT '预约用户ID',lab_id BIGINT NOT NULL COMMENT '实验室ID',start_time DATETIME NOT NULL COMMENT '开始时间',end_time DATETIME NOT NULL COMMENT '结束时间',purpose VARCHAR(500) COMMENT '用途说明',participants INT COMMENT '使用人数',status TINYINT DEFAULT 0 COMMENT '状态:0-待审核,1-已通过,2-已拒绝,3-已取消,4-已完成',create_time DATETIME,update_time DATETIME
);-- 预约审批记录表
CREATE TABLE reservation_approval (id BIGINT PRIMARY KEY AUTO_INCREMENT,reservation_id BIGINT NOT NULL COMMENT '预约ID',approver_id BIGINT NOT NULL COMMENT '审批人ID',approval_status TINYINT COMMENT '审批状态:1-通过,2-拒绝',approval_comment VARCHAR(500) COMMENT '审批意见',approval_time DATETIME COMMENT '审批时间'
);-- 实验室使用记录表
CREATE TABLE lab_usage_record (id BIGINT PRIMARY KEY AUTO_INCREMENT,reservation_id BIGINT COMMENT '预约ID',check_in_time DATETIME COMMENT '签到时间',check_out_time DATETIME COMMENT '签退时间',actual_participants INT COMMENT '实际使用人数',status TINYINT COMMENT '状态:1-正常,2-超时,3-爽约',remark VARCHAR(500) COMMENT '备注'
);

2. 核心功能实现

2.1 预约申请服务

@Service
public class ReservationService {@Autowiredprivate LabReservationMapper reservationMapper;@Autowiredprivate LabService labService;@Transactionalpublic Result createReservation(ReservationCreateDTO dto) {// 验证实验室是否可用LabInfo lab = labService.getLabById(dto.getLabId());if (lab == null || lab.getStatus() != 1) {return Result.fail("实验室不可用");}// 检查时间冲突if (checkTimeConflict(dto.getLabId(), dto.getStartTime(), dto.getEndTime())) {return Result.fail("所选时间段已被预约");}// 创建预约记录LabReservation reservation = new LabReservation();BeanUtils.copyProperties(dto, reservation);reservation.setUserId(SecurityUtils.getCurrentUserId());reservation.setStatus(ReservationStatusEnum.PENDING.getCode());reservation.setCreateTime(new Date());reservationMapper.insert(reservation);// 发送审批通知sendApprovalNotification(reservation);return Result.success();}private boolean checkTimeConflict(Long labId, Date startTime, Date endTime) {return reservationMapper.countConflictReservations(labId, startTime, endTime) > 0;}
}

2.2 预约审批服务

@Service
public class ApprovalService {@Autowiredprivate ReservationApprovalMapper approvalMapper;@Autowiredprivate ReservationService reservationService;@Transactionalpublic Result approveReservation(ApprovalDTO dto) {// 验证预约状态LabReservation reservation = reservationService.getById(dto.getReservationId());if (reservation == null || reservation.getStatus() != ReservationStatusEnum.PENDING.getCode()) {return Result.fail("预约记录不存在或状态异常");}// 记录审批信息ReservationApproval approval = new ReservationApproval();approval.setReservationId(dto.getReservationId());approval.setApproverId(SecurityUtils.getCurrentUserId());approval.setApprovalStatus(dto.getApprovalStatus());approval.setApprovalComment(dto.getComment());approval.setApprovalTime(new Date());approvalMapper.insert(approval);// 更新预约状态Integer newStatus = dto.getApprovalStatus() == 1 ? ReservationStatusEnum.APPROVED.getCode() : ReservationStatusEnum.REJECTED.getCode();reservationService.updateStatus(dto.getReservationId(), newStatus);// 发送通知sendNotification(reservation.getUserId(), newStatus, dto.getComment());return Result.success();}
}

2.3 使用统计服务

@Service
public class LabStatisticsService {@Autowiredprivate LabUsageRecordMapper usageRecordMapper;public Map<String, Object> getLabUsageStatistics(StatisticsQueryDTO query) {Map<String, Object> result = new HashMap<>();// 获取使用率统计List<LabUsageRateVO> usageRates = usageRecordMapper.selectUsageRateByLab(query.getStartDate(), query.getEndDate());result.put("usageRates", usageRates);// 获取预约状态分布List<ReservationStatusVO> statusDistribution = usageRecordMapper.selectReservationStatusDistribution(query.getStartDate(), query.getEndDate());result.put("statusDistribution", statusDistribution);// 获取高峰时段分析List<PeakTimeVO> peakTimes = usageRecordMapper.selectPeakTimeAnalysis(query.getStartDate(), query.getEndDate());result.put("peakTimes", peakTimes);return result;}
}

二、系统管理模块

1. 数据库设计

-- 系统参数表
CREATE TABLE sys_config (id BIGINT PRIMARY KEY AUTO_INCREMENT,param_key VARCHAR(50) NOT NULL COMMENT '参数键',param_value VARCHAR(500) COMMENT '参数值',param_desc VARCHAR(200) COMMENT '参数描述',type TINYINT COMMENT '参数类型:1-系统参数,2-业务参数',create_time DATETIME,update_time DATETIME
);-- 系统日志表
CREATE TABLE sys_log (id BIGINT PRIMARY KEY AUTO_INCREMENT,user_id BIGINT COMMENT '操作用户ID',module VARCHAR(50) COMMENT '操作模块',operation VARCHAR(50) COMMENT '操作类型',method VARCHAR(200) COMMENT '请求方法',params TEXT COMMENT '请求参数',time BIGINT COMMENT '执行时长(ms)',ip VARCHAR(50) COMMENT 'IP地址',create_time DATETIME
);-- 数据备份记录表
CREATE TABLE sys_backup (id BIGINT PRIMARY KEY AUTO_INCREMENT,backup_name VARCHAR(100) COMMENT '备份名称',backup_type TINYINT COMMENT '备份类型:1-全量,2-增量',file_path VARCHAR(200) COMMENT '备份文件路径',file_size BIGINT COMMENT '文件大小(byte)',status TINYINT COMMENT '状态:0-备份中,1-成功,2-失败',start_time DATETIME COMMENT '开始时间',end_time DATETIME COMMENT '结束时间',remark VARCHAR(500) COMMENT '备注'
);

2. 核心功能实现

2.1 系统参数配置服务

@Service
public class SysConfigService {@Autowiredprivate SysConfigMapper configMapper;@Autowiredprivate RedisTemplate<String, String> redisTemplate;private static final String CONFIG_KEY_PREFIX = "sys:config:";public String getConfigValue(String key) {// 先从Redis缓存获取String value = redisTemplate.opsForValue().get(CONFIG_KEY_PREFIX + key);if (value != null) {return value;}// 从数据库获取SysConfig config = configMapper.selectByKey(key);if (config != null) {// 放入缓存redisTemplate.opsForValue().set(CONFIG_KEY_PREFIX + key, config.getParamValue(),24, TimeUnit.HOURS);return config.getParamValue();}return null;}@Transactionalpublic Result updateConfig(ConfigUpdateDTO dto) {SysConfig config = configMapper.selectByKey(dto.getKey());if (config == null) {return Result.fail("参数不存在");}config.setParamValue(dto.getValue());config.setUpdateTime(new Date());configMapper.updateById(config);// 更新缓存redisTemplate.opsForValue().set(CONFIG_KEY_PREFIX + dto.getKey(), dto.getValue(),24, TimeUnit.HOURS);return Result.success();}
}

2.2 系统日志服务

@Aspect
@Component
public class SysLogAspect {@Autowiredprivate SysLogMapper logMapper;@Around("@annotation(com.xxx.annotation.SysLog)")public Object around(ProceedingJoinPoint point) throws Throwable {long beginTime = System.currentTimeMillis();try {// 执行方法Object result = point.proceed();// 保存日志saveLog(point, System.currentTimeMillis() - beginTime);return result;} catch (Exception e) {// 保存异常日志saveExceptionLog(point, e, System.currentTimeMillis() - beginTime);throw e;}}private void saveLog(ProceedingJoinPoint point, long time) {MethodSignature signature = (MethodSignature) point.getSignature();Method method = signature.getMethod();SysLog sysLog = method.getAnnotation(SysLog.class);SysLogEntity log = new SysLogEntity();log.setUserId(SecurityUtils.getCurrentUserId());log.setModule(sysLog.module());log.setOperation(sysLog.operation());log.setMethod(signature.getDeclaringTypeName() + "." + signature.getName());log.setParams(JSON.toJSONString(point.getArgs()));log.setTime(time);log.setIp(IPUtils.getIpAddr());log.setCreateTime(new Date());logMapper.insert(log);}
}

2.3 数据备份服务

@Service
public class BackupService {@Autowiredprivate SysBackupMapper backupMapper;@Value("${backup.path}")private String backupPath;@Asyncpublic void createBackup(BackupCreateDTO dto) {SysBackup backup = new SysBackup();backup.setBackupName(dto.getName());backup.setBackupType(dto.getType());backup.setStatus(0);backup.setStartTime(new Date());backupMapper.insert(backup);try {// 执行备份String fileName = executeBackup(dto);// 更新备份记录File backupFile = new File(fileName);backup.setFilePath(fileName);backup.setFileSize(backupFile.length());backup.setStatus(1);backup.setEndTime(new Date());backupMapper.updateById(backup);} catch (Exception e) {log.error("数据备份失败", e);backup.setStatus(2);backup.setRemark(e.getMessage());backup.setEndTime(new Date());backupMapper.updateById(backup);}}private String executeBackup(BackupCreateDTO dto) throws Exception {String fileName = backupPath + "/" + DateUtils.format(new Date(), "yyyyMMddHHmmss") + ".sql";ProcessBuilder builder = new ProcessBuilder();if (dto.getType() == 1) {// 全量备份builder.command("mysqldump", "-h" + dbHost,"-u" + dbUsername,"-p" + dbPassword,dbName,"--result-file=" + fileName);} else {// 增量备份builder.command("mysqldump","-h" + dbHost,"-u" + dbUsername,"-p" + dbPassword,"--skip-add-locks","--no-create-info",dbName,"--result-file=" + fileName);}Process process = builder.start();int exitCode = process.waitFor();if (exitCode != 0) {throw new RuntimeException("备份执行失败");}return fileName;}
}

3. 前端实现示例

3.1 预约管理组件

<template><div class="reservation-manage"><!-- 预约表单 --><el-form :model="reservationForm" :rules="rules" ref="reservationForm"><el-form-item label="实验室" prop="labId"><el-select v-model="reservationForm.labId" placeholder="请选择实验室"><el-optionv-for="lab in labList":key="lab.id":label="lab.name":value="lab.id"></el-option></el-select></el-form-item><el-form-item label="使用时间" prop="timeRange"><el-date-pickerv-model="reservationForm.timeRange"type="datetimerange"range-separator="至"start-placeholder="开始时间"end-placeholder="结束时间"></el-date-picker></el-form-item><el-form-item label="用途说明" prop="purpose"><el-inputtype="textarea"v-model="reservationForm.purpose"placeholder="请输入用途说明"></el-input></el-form-item><el-form-item><el-button type="primary" @click="submitReservation">提交预约</el-button></el-form-item></el-form><!-- 预约记录列表 --><el-table :data="reservationList" border><el-table-column prop="labName" label="实验室"></el-table-column><el-table-column label="使用时间"><template slot-scope="scope">{{ formatDateTime(scope.row.startTime) }} 至 {{ formatDateTime(scope.row.endTime) }}</template></el-table-column><el-table-column prop="purpose" label="用途" show-overflow-tooltip></el-table-column><el-table-column label="状态"><template slot-scope="scope"><el-tag :type="getStatusType(scope.row.status)">{{ getStatusText(scope.row.status) }}</el-tag></template></el-table-column><el-table-column label="操作" width="150"><template slot-scope="scope"><el-button type="text" @click="cancelReservation(scope.row)"v-if="scope.row.status === 0">取消预约</el-button><el-button type="text" @click="viewDetail(scope.row)">查看详情</el-button></template></el-table-column></el-table></div>
</template><script>
export default {data() {return {reservationForm: {labId: '',timeRange: [],purpose: ''},rules: {labId: [{ required: true, message: '请选择实验室', trigger: 'change' }],timeRange: [{ required: true, message: '请选择使用时间', trigger: 'change' }],purpose: [{ required: true, message: '请输入用途说明', trigger: 'blur' }]},labList: [],reservationList: []}},methods: {async submitReservation() {try {await this.$refs.reservationForm.validate()const [startTime, endTime] = this.reservationForm.timeRangeconst params = {labId: this.reservationForm.labId,startTime,endTime,purpose: this.reservationForm.purpose}await this.$api.createReservation(params)this.$message.success('预约申请提交成功')this.fetchReservationList()} catch (error) {console.error(error)}},getStatusType(status) {const typeMap = {0: 'info',1: 'success',2: 'danger',3: 'info',4: ''}return typeMap[status]},getStatusText(status) {const textMap = {0: '待审核',1: '已通过',2: '已拒绝',3: '已取消',4: '已完成'}return textMap[status]}}
}
</script>

3.2 系统配置组件

<template><div class="sys-config"><el-card class="config-card"><div slot="header"><span>系统参数配置</span></div><el-form :model="configForm" label-width="120px"><el-form-item v-for="item in configList":key="item.key":label="item.desc"><el-input v-model="configForm[item.key]":placeholder="'请输入' + item.desc"></el-input></el-form-item><el-form-item><el-button type="primary" @click="saveConfig">保存配置</el-button></el-form-item></el-form></el-card><el-card class="backup-card"><div slot="header"><span>数据备份</span></div><div class="backup-actions"><el-button type="primary" @click="createBackup(1)">全量备份</el-button><el-button type="warning" @click="createBackup(2)">增量备份</el-button></div><el-table :data="backupList" border style="margin-top: 20px;"><el-table-column prop="backupName" label="备份名称"></el-table-column><el-table-column label="备份类型"><template slot-scope="scope">{{ scope.row.backupType === 1 ? '全量' : '增量' }}</template></el-table-column><el-table-column prop="fileSize" label="文件大小"><template slot-scope="scope">{{ formatFileSize(scope.row.fileSize) }}</template></el-table-column><el-table-column label="状态"><template slot-scope="scope"><el-tag :type="getBackupStatusType(scope.row.status)">{{ getBackupStatusText(scope.row.status) }}</el-tag></template></el-table-column><el-table-column label="操作" width="150"><template slot-scope="scope"><el-button type="text" @click="downloadBackup(scope.row)"v-if="scope.row.status === 1">下载</el-button><el-button type="text" @click="deleteBackup(scope.row)">删除</el-button></template></el-table-column></el-table></el-card></div>
</template><script>
export default {data() {return {configForm: {},configList: [],backupList: []}},created() {this.fetchConfigList()this.fetchBackupList()},methods: {async fetchConfigList() {const res = await this.$api.getConfigList()this.configList = res.data// 初始化表单数据this.configList.forEach(item => {this.$set(this.configForm, item.key, item.value)})},async saveConfig() {try {const params = Object.entries(this.configForm).map(([key, value]) => ({key,value}))await this.$api.updateConfig(params)this.$message.success('配置保存成功')} catch (error) {console.error(error)}},async createBackup(type) {try {const params = {name: `backup_${Date.now()}`,type}await this.$api.createBackup(params)this.$message.success('备份任务已启动')this.fetchBackupList()} catch (error) {console.error(error)}},formatFileSize(size) {if (size < 1024) {return size + 'B'} else if (size < 1024 * 1024) {return (size / 1024).toFixed(2) + 'KB'} else {return (size / 1024 / 1024).toFixed(2) + 'MB'}}}
}
</script>

以上是预约管理模块和系统管理模块的详细实现,包括:

1. 完整的数据库表设计
2. 后端核心服务实现
3. 前端组件示例代码

这些代码展示了预约流程、审批流程、统计分析、系统配置、日志管理、数据备份等功能的具体实现方式。实际项目中还需要根据具体需求进行调整和扩展。