使用oracle做的数据上传系统后台
kongdeqiang
2026-03-23 bdeb03a42dace46b1211bf12f3ad66837814035d
src/main/java/com/example/controller/UserController.java
@@ -10,6 +10,7 @@
import com.example.service.DepartmentService;
import com.example.service.UserService;
import com.example.utils.Md5Util;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;
@@ -62,6 +63,7 @@
    @PostMapping
    public Result<Boolean> save(@RequestBody User user) {
        User user1 = new User();
        String currentDeptCode = UserContext.getCurrentDeptCode();
        List<String> deptCodes = departmentService.getChildDeptCodes(currentDeptCode);
        if (!deptCodes.contains(user.getDeptCode())) {
@@ -75,7 +77,9 @@
        } else {
            user.setPassword(Md5Util.encrypt("123456"));
        }
        return Result.success(userService.save(user));
        BeanUtils.copyProperties(user,user1);
        System.out.println(user1);
        return Result.success(userService.save(user1));
    }
    @PutMapping
@@ -143,11 +147,46 @@
        example.setRealName("张三");
        example.setEmail("zhangsan@example.com");
        example.setPhone("13800138001");
        example.setDeptCode("001001");
        example.setDeptCode("1001");
        templateData.add(example);
        EasyExcel.write(response.getOutputStream(), UserImportExcel.class)
                .sheet("用户导入模版")
                .doWrite(templateData);
    }
    @PostMapping("/change-password")
    public Result<Boolean> changePassword(@RequestBody ChangePasswordRequest request) {
        Long currentUserId = UserContext.getCurrentUserId();
        if (currentUserId == null) {
            return Result.error("用户未登录");
        }
        boolean success = userService.changePassword(currentUserId, request.getOldPassword(), request.getNewPassword());
        if (success) {
            return Result.success(true);
        } else {
            return Result.error("原密码错误");
        }
    }
    static class ChangePasswordRequest {
        private String oldPassword;
        private String newPassword;
        public String getOldPassword() {
            return oldPassword;
        }
        public void setOldPassword(String oldPassword) {
            this.oldPassword = oldPassword;
        }
        public String getNewPassword() {
            return newPassword;
        }
        public void setNewPassword(String newPassword) {
            this.newPassword = newPassword;
        }
    }
}