基于javaweb+mysql的springboot医院预约挂号系统(java+springboot+maven+vue+mysql)
运行环境
Java≥8、MySQL≥5.7、Node.js≥10
开发工具
后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot医院预约挂号系统(java+springboot+maven+vue+mysql)
一、项目运行 环境配置:
Jdk1.8 + Tomcat8.5 + Mysql + HBuilderX(Webstorm也行)+ Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)。
项目技术:
Spring + SpringBoot+ mybatis + Maven + Vue 等等组成,B/S模式 + Maven管理等等。
/**
* 开处方
*/
@PostMapping("/makeCase")
public ResultVo makeCase(@RequestBody Case entity) {
Integer id = entity.getId();
caseService.save(entity);
// 修改挂号状态
Registration registration = new Registration();
registration.setStatus(1);
registration.setId(id);
registrationService.updateById(registration);
return ResultVo.oK();
}
/**
* 管理员或患者查询病例列表
*/
@GetMapping("/list")
public ResultVo list(Case entity, QueryRequest queryRequest, HttpServletRequest request) {
Integer userId = TokenUtil.getAdminUserId(request.getHeader("Authorization"));
if (userManager.isAdminRole(userId)) {
return ResultVo.oK(caseService.queryList(entity, queryRequest));
} else if (userManager.isPatientsRole(userId)) {
return ResultVo.oK(caseService.queryListByPatient(entity, queryRequest, userId));
}
return null;
}
}
if (passToken.required()) {
return true;
}
}
//检查有没有需要用户权限的注解
if (method.isAnnotationPresent(AdminLoginToken.class)) {
AdminLoginToken adminLoginToken = method.getAnnotation(AdminLoginToken.class);
if (adminLoginToken.required()) {
// 执行认证
if (token == null) {
throw new TokenException(403, "无token,请重新登录");
}
// 获取 token 中的 userId
int adminUserId = TokenUtil.getAdminUserId(token);
User adminUser = usersService.getById(adminUserId);
if (adminUser == null) {
throw new TokenException(403, "用户不存在,请重新登录");
}
// 验证 token
JWTVerifier jwtVerifier = JWT.require(Algorithm.HMAC256(TokenUtil.SECRET)).build();
try {
jwtVerifier.verify(token);
} catch (JWTVerificationException e) {
throw new TokenException(403, "token不合法");
}
}
}
return true;
}
@Override
public void postHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, ModelAndView modelAndView) throws Exception {
}
@Override
public void afterCompletion(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object o, Exception e) throws Exception {
}
}
@DeleteMapping("/{userIds}")
public ResultVo remove(@PathVariable Integer[] userIds) {
for (Integer userId : userIds) {
userService.removeById(userId);
return ResultVo.oK();
}
return null;
}
/**
* 修改用户
*
* @return
*/
@PutMapping
public ResultVo edit(@RequestBody User user) {
user.setModifyTime(new Date());
userService.updateById(user);
return ResultVo.oK();
}
/**
* 重置密码
*/
@PutMapping("/resetPwd")
public ResultVo reSetPwd(@RequestBody User user) {
user.setPassword(MD5Util.md5(user.getPassword()));
userService.updateById(user);
return ResultVo.oK();
}
}
/**
* 获取科室下拉框
*/
@GetMapping("/getDepartment")
public ResultVo getDepartment() {
LambdaQueryWrapper<Department> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.select(Department::getId, Department::getDepName);
return ResultVo.oK(departmentService.list(lambdaQueryWrapper));
}
/**
* 通过科室id查询医生
*/
@GetMapping("/getDoctor/{id}")
public ResultVo getDoctor(@PathVariable Integer id) {
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.select(User::getNickName, User::getUserId);
lambdaQueryWrapper.eq(User::getDepId, id);
return ResultVo.oK(userService.list(lambdaQueryWrapper));
}
@PostMapping("/registerDoctor")
public ResultVo registerStudent(User user) {
user.setPassword(MD5Util.md5(user.getPassword()));
user.setCreateTime(new Date());
user.setRoleId(1);
userService.save(user);
return ResultVo.oK();
}
@PostMapping("/registerPatients")
public ResultVo registerTeacher(User user) {
user.setPassword(MD5Util.md5(user.getPassword()));
user.setCreateTime(new Date());
user.setRoleId(2);
userService.save(user);
/**
* 修改账户状态,禁用或者取消
*
* @param user
* @param request
* @return
*/
@PutMapping("/changeStatus")
public ResultVo changeStatus(@RequestBody User user, HttpServletRequest request) {
userService.updateById(user);
return ResultVo.oK();
}
/**
* 根据ID查询用户详情
*
* @param userId
* @return
*/
@GetMapping("/{userId}")
public ResultVo getUserInfo(@PathVariable Integer userId) {
User info = userService.getById(userId);
return ResultVo.oK(info);
}
/**
* 新增用户
*/
@PostMapping
public ResultVo add(@RequestBody User user) {
// 查询用户名是否存在数据库中
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.eq(User::getUsername, user.getUsername());
User entity = userService.getOne(lambdaQueryWrapper);
if (entity == null) {
user.setCreateTime(new Date());
// 设置默认密码1234qwer
user.setPassword(MD5Util.md5("1234qwer"));
user.setRoleId(2);
userService.save(user);
}
return null;
}
/**
* 修改用户
*
* @return
*/
@PutMapping
public ResultVo edit(@RequestBody User user) {
user.setModifyTime(new Date());
userService.updateById(user);
return ResultVo.oK();
}
/**
* 重置密码
*/
@PutMapping("/resetPwd")
public ResultVo reSetPwd(@RequestBody User user) {
user.setPassword(MD5Util.md5(user.getPassword()));
userService.updateById(user);
return ResultVo.oK();
}
}
/**
* 项目名:penint
*
*/
for (Integer id : ids) {
questionsService.removeById(id);
LambdaQueryWrapper<Questions> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.eq(Questions::getParentId, id);
questionsService.remove(lambdaQueryWrapper);
}
return ResultVo.oK();
}
@PutMapping("/reply")
public ResultVo reply(@RequestBody Questions questions, HttpServletRequest request) {
Integer userId = TokenUtil.getAdminUserId(request.getHeader("Authorization"));
Questions entity = new Questions();
entity.setTitle(questions.getReply());
entity.setParentId(questions.getId());
entity.setPatientId(questions.getPatientId());
entity.setDoctorId(userId);
questionsService.save(entity);
return ResultVo.oK();
}
}
/**
* 全局异常处理类
*/
@ControllerAdvice
public class GloablExceptionHandler {
/**
* 文件上传限制异常413
*
* @param e
* @return
*/
@ResponseBody
@ExceptionHandler(MultipartException.class)
public Object handleMultipartException(MultipartException e) {
String msg = e.getMessage();
if (msg == null || msg.equals("")) {
msg = "服务器出错";
}
JSONObject jsonObject = new JSONObject();
* @param userId
* @return
*/
@GetMapping("/{userId}")
public ResultVo getUserInfo(@PathVariable Integer userId) {
User info = userService.getById(userId);
return ResultVo.oK(info);
}
/**
* 新增用户
*/
@PostMapping
public ResultVo add(@RequestBody User user) {
// 查询用户名是否存在数据库中
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.eq(User::getUsername, user.getUsername());
User entity = userService.getOne(lambdaQueryWrapper);
if (entity == null) {
user.setCreateTime(new Date());
// 设置默认密码1234qwer
user.setPassword(MD5Util.md5("1234qwer"));
user.setRoleId(1);
userService.save(user);
return ResultVo.oK("用户:" + user.getUsername() + "新增成功,默认密码为:" + "1234qwer");
} else {
return ResultVo.failed(201, "用户新增失败,用户名:" + user.getUsername() + "已存在");
}
}
/**
* 删除用户
*/
@DeleteMapping("/{userIds}")
public ResultVo remove(@PathVariable Integer[] userIds) {
for (Integer userId : userIds) {
userService.removeById(userId);
return ResultVo.oK();
}
return null;
}
/**
* 修改用户
*
* @return
*/
@PutMapping
entity.setPatientId(questions.getPatientId());
entity.setDoctorId(userId);
questionsService.save(entity);
return ResultVo.oK();
}
}
/**
* 全局异常处理类
*/
@ControllerAdvice
public class GloablExceptionHandler {
/**
* 文件上传限制异常413
*
* @param e
* @return
*/
@ResponseBody
@ExceptionHandler(MultipartException.class)
public Object handleMultipartException(MultipartException e) {
String msg = e.getMessage();
if (msg == null || msg.equals("")) {
msg = "服务器出错";
}
JSONObject jsonObject = new JSONObject();
jsonObject.put("status", 413);
jsonObject.put("msg", "文件太大,不允许上传!" + msg);
return jsonObject;
}
/**
return ResultVo.failed(500, "失败");
}
@PostMapping("/getMeInfo")
@AdminLoginToken
public ResultVo getMeInfo(HttpServletRequest request) {
User user = userService.getById(TokenUtil.getAdminUserId(request.getHeader("Authorization")));
return ResultVo.oK(user);
}
/**
* 判断库中用户名 有没有被使用
*
* @param username
* @return
*/
@GetMapping("/checkUsername/{username}")
public ResultVo checkUsername(@PathVariable String username) {
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.eq(User::getUsername, username);
if (userService.getOne(lambdaQueryWrapper) != null) {
return ResultVo.oK(true);
} else {
return ResultVo.oK(false);
}
}
/**
* 判断请求方法的该用户原密码是否正确
*
* @param password
* @return
*/
@GetMapping("/checkPassword/{password}")
public ResultVo checkPassword(@PathVariable String password, HttpServletRequest request) {
Integer userId = TokenUtil.getAdminUserId(request.getHeader("Authorization"));
String encrypt = MD5Util.md5(password);// 用户输入的密码加密字符串
if (userService.getById(userId).getPassword().equalsIgnoreCase(encrypt)) {
return ResultVo.oK(true);
/**
* <p>
* 挂号表 前端控制器
* </p>
*
*/
@RestController
@RequestMapping("/adminApi/registration")
public class RegistrationController {
@Autowired
private IRegistrationService registrationService;
@Autowired
private IDepartmentService departmentService;
@Autowired
private UserManager userManager;
@GetMapping("/list")
public ResultVo list(Registration entity, QueryRequest queryRequest, HttpServletRequest request) {
Integer userId = TokenUtil.getAdminUserId(request.getHeader("Authorization"));
if (userManager.isAdminRole(userId)) {
return ResultVo.oK(registrationService.queryList(entity, queryRequest));
} else if (userManager.isDoctorRole(userId)) {
return ResultVo.oK(registrationService.queryListByDoctor(entity, queryRequest, userId));
} else if (userManager.isPatientsRole(userId)) {
return ResultVo.oK(registrationService.queryListByPatient(entity, queryRequest, userId));
return ResultVo.oK("已支付" + v.setScale(2, BigDecimal.ROUND_HALF_UP) + "元");
}
/**
* 采纳
*/
@GetMapping("/accept/{id}")
public ResultVo accept(@PathVariable Integer id) {
Registration registration = new Registration();
registration.setId(id);
registration.setAccept(1);
registrationService.updateById(registration);
return ResultVo.oK();
}
/**
* 不采纳
*/
@GetMapping("/notAccept/{id}")
public ResultVo notAccept(@PathVariable Integer id) {
Registration registration = new Registration();
registration.setId(id);
registration.setAccept(2);
registration.setStatus(0);
registrationService.updateById(registration);
return ResultVo.oK();
}
/**
* 评价
*/
@PutMapping("/evaluate")
public ResultVo evaluate(@RequestBody Registration registration) {
registrationService.updateById(registration);
return ResultVo.oK();
}
/**
* 开发票
*/
@PutMapping("/{id}")
public ResultVo openInvoice(@PathVariable Integer id) {
Registration registration = new Registration();
// 生成发票代码,12位数,随即生成
registration.setInvoiceCode(String.valueOf(OrderSnUtil.getRandom(12)));
// 生成发票号,9位数,随机生成
registration.setInvoiceNumber(String.valueOf(OrderSnUtil.getRandom(9)));
// 生成发票日期
user.setPassword(MD5Util.md5(user.getPassword()));
userService.updateById(user);
return ResultVo.oK();
}
}
/**
* 项目名:penint
*
*/
@RestController
@RequestMapping("/adminApi/doctor")
public class DoctorController {
@Autowired
private IUserService userService;
@GetMapping("/list")
public ResultVo list(QueryRequest queryRequest, User user) {
return ResultVo.oK(userService.queryDoctorFuzz(queryRequest, user));
}
/**
* 修改账户状态,禁用或者取消
/**
* 全局异常处理类
*/
@ControllerAdvice
public class GloablExceptionHandler {
/**
* 文件上传限制异常413
*
* @param e
* @return
*/
@ResponseBody
@ExceptionHandler(MultipartException.class)
public Object handleMultipartException(MultipartException e) {
String msg = e.getMessage();
if (msg == null || msg.equals("")) {
msg = "服务器出错";
}
JSONObject jsonObject = new JSONObject();
jsonObject.put("status", 413);
jsonObject.put("msg", "文件太大,不允许上传!" + msg);
return jsonObject;
}
/**
* token 不合法异常,返回403
*
* @param e
* @return
*/
@ResponseBody
@ExceptionHandler(RuntimeException.class)
public Object handleRuntimeException(RuntimeException e) {
String msg = e.getMessage();
if (msg == null || msg.equals("")) {
msg = "服务器出错";
}
JSONObject jsonObject = new JSONObject();
jsonObject.put("status", 401);
jsonObject.put("msg", msg);
return jsonObject;
}
/**
* token 不合法异常,返回403
*
* @param e
* @return
*/
@ResponseBody
@ExceptionHandler(TokenException.class)
public Object handleTokenException(TokenException e) {
/**
* 全局异常处理类
*/
@ControllerAdvice
public class GloablExceptionHandler {
/**
* 文件上传限制异常413
*
* @param e
* @return
*/
@ResponseBody
@ExceptionHandler(MultipartException.class)
public Object handleMultipartException(MultipartException e) {
String msg = e.getMessage();
if (msg == null || msg.equals("")) {
msg = "服务器出错";
}
JSONObject jsonObject = new JSONObject();
jsonObject.put("status", 413);
jsonObject.put("msg", "文件太大,不允许上传!" + msg);
return jsonObject;
}
/**
* token 不合法异常,返回403
*
* @param e
* @return
*/
@ResponseBody
@ExceptionHandler(RuntimeException.class)
public Object handleRuntimeException(RuntimeException e) {
String msg = e.getMessage();
if (msg == null || msg.equals("")) {
msg = "服务器出错";
}
JSONObject jsonObject = new JSONObject();
jsonObject.put("status", 401);
jsonObject.put("msg", msg);
return jsonObject;
}
/**
@GetMapping("/list")
public ResultVo list(QueryRequest queryRequest, User user) {
return ResultVo.oK(userService.queryPatiensFuzz(queryRequest, user));
}
/**
* 修改账户状态,禁用或者取消
*
* @param user
* @param request
* @return
*/
@PutMapping("/changeStatus")
public ResultVo changeStatus(@RequestBody User user, HttpServletRequest request) {
userService.updateById(user);
return ResultVo.oK();
}
/**
* 根据ID查询用户详情
*
* @param userId
* @return
*/
@GetMapping("/{userId}")
public ResultVo getUserInfo(@PathVariable Integer userId) {
User info = userService.getById(userId);
return ResultVo.oK(info);
}
/**
* 新增用户
*/
@PostMapping
public ResultVo add(@RequestBody User user) {
// 查询用户名是否存在数据库中
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.eq(User::getUsername, user.getUsername());
User entity = userService.getOne(lambdaQueryWrapper);
if (entity == null) {
user.setCreateTime(new Date());
// 设置默认密码1234qwer
user.setPassword(MD5Util.md5("1234qwer"));
user.setRoleId(2);
/**
* 获取科室下拉框
*/
@GetMapping("/getDepartment")
public ResultVo getDepartment() {
LambdaQueryWrapper<Department> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.select(Department::getId, Department::getDepName);
return ResultVo.oK(departmentService.list(lambdaQueryWrapper));
}
/**
* 通过科室id查询医生
*/
@GetMapping("/getDoctor/{id}")
public ResultVo getDoctor(@PathVariable Integer id) {
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
lambdaQueryWrapper.select(User::getNickName, User::getUserId);
lambdaQueryWrapper.eq(User::getDepId, id);
return ResultVo.oK(userService.list(lambdaQueryWrapper));
}
@PostMapping("/registerDoctor")
public ResultVo registerStudent(User user) {
user.setPassword(MD5Util.md5(user.getPassword()));
user.setCreateTime(new Date());
user.setRoleId(1);
userService.save(user);
return ResultVo.oK();
}
@PostMapping("/registerPatients")
public ResultVo registerTeacher(User user) {
user.setPassword(MD5Util.md5(user.getPassword()));
user.setCreateTime(new Date());
user.setRoleId(2);
userService.save(user);
return ResultVo.oK();
}
/**
* 忘记密码
*/
@PutMapping("/forgotPassword")
public ResultVo forgotPassword(User sysUser) {
LambdaQueryWrapper<User> lambdaQueryWrapper = new LambdaQueryWrapper<>();
@GetMapping("/{id}")
public ResultVo getInfoById(@PathVariable Integer id) {
return ResultVo.oK(registrationService.getById(id));
}
}
public class AuthenticationInterceptor implements HandlerInterceptor {
@Autowired
private IUserService usersService;
@Override
public boolean preHandle(HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse, Object object) {
String token = httpServletRequest.getHeader("Authorization");// 从 http 请求头中取出 token
// 如果不是映射到方法直接通过
if (!(object instanceof HandlerMethod)) {
return true;
}
HandlerMethod handlerMethod = (HandlerMethod) object;
Method method = handlerMethod.getMethod();
//检查是否有passtoken注释,有则跳过认证
if (method.isAnnotationPresent(PassToken.class)) {
PassToken passToken = method.getAnnotation(PassToken.class);
if (passToken.required()) {
return true;
}