基于javaweb+mysql的springboot电影购票管理系统(java+springboot+vue+maven+mysql)
运行环境
Java≥8、MySQL≥5.7、Node.js≥10
开发工具
后端:eclipse/idea/myeclipse/sts等均可配置运行
前端:WebStorm/VSCode/HBuilderX等均可
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SpringBoot电影购票管理系统(java+springboot+vue+maven+mysql)
一、项目运行 环境配置:
Jdk1.8 + Tomcat8.5 + Mysql + HBuilderX(Webstorm也行)+ Eclispe(IntelliJ IDEA,Eclispe,MyEclispe,Sts都支持)。
项目技术:
Spring + SpringBoot+ mybatis + Maven + Vue 等等组成,B/S模式 + Maven管理等等。
@GetMapping("")
@ApiOperation(value = "查询所有订单")
public List<OrderVO> findAll() {
return orderService.findAll();
}
@PutMapping("")
@ApiOperation(value = "查询所有订单")
public void update(@RequestBody Order order) {
orderService.update(order);
}
@GetMapping("/user/{id}")
@ApiOperation(value = "查询用户订单")
public List<OrderVO> findByUser(@PathVariable String id) {
return orderService.findByUser(id);
}
@GetMapping("/pay")
@ApiOperation(value = "支付订单")
public Order save(String id) throws Exception {
return orderService.pay(id);
}
}
@RestController
@Api(tags = "电影评价接口")
@RequestMapping("/api/fe")
public class FilmEvaluateController {
@Api(tags = "电影接口")
@RequestMapping("/api/film")
public class FilmController {
@Resource
private FilmService filmService;
@PostMapping("")
@ApiOperation(value = "保存电影")
public void save(@RequestBody Film film) {
filmService.save(film);
}
@GetMapping("")
@ApiOperation("列出所有电影")
public List<Film> list(String region, String type) {
if (region != null && type != null) {
return filmService.findByRegionAndType(region, type);
}
return filmService.findAll();
}
@GetMapping("/hot/{limit}")
@ApiOperation("获取热榜电影")
public List<Film> listHots(@PathVariable Integer limit) {
return filmService.findHots(limit);
}
@GetMapping("/name/{name}")
@ApiOperation("搜索电影")
public List<Film> search(@PathVariable String name) {
return filmService.findLikeName(name);
}
@GetMapping("/{id}")
@ApiOperation(value = "根据id查找电影")
public Film findById(@PathVariable String id) {
return filmService.findById(id);
}
@PutMapping("")
@ApiOperation(value = "更新电影")
public void update(@RequestBody Film film) {
/**
* 捕获controller异常
* controller抛出异常执行下边的函数
* 返回Response写入ApiResult
*/
@ResponseBody
@RestControllerAdvice
public class GlobalExceptionHandler {
private final Logger logger = LoggerFactory.getLogger(getClass());
@ExceptionHandler(value = Exception.class)
@DisableBaseResponse
public Object handleException(Exception e) {
if (e.getClass().equals(AccessDeniedException.class)){
return new ResponseResult<>(403, "你没有访问权限");
}
logger.error(e.getMessage());
return new ResponseResult<>(400, e.getMessage());
}
}
@RestController
@Api(tags = "客服评价接口")
@RequestMapping("/api/we")
public class WorkerEvaluateController {
@Resource
private WorkerEvaluateService workerEvaluateService;
@PostMapping("")
@ApiOperation(value = "保存客服评价")
}
@RestController
@Api(tags = "电影接口")
@RequestMapping("/api/film")
public class FilmController {
@Resource
private FilmService filmService;
@PostMapping("")
@ApiOperation(value = "保存电影")
public void save(@RequestBody Film film) {
filmService.save(film);
}
@GetMapping("")
@ApiOperation("列出所有电影")
public List<Film> list(String region, String type) {
if (region != null && type != null) {
return filmService.findByRegionAndType(region, type);
}
return filmService.findAll();
}
@GetMapping("/hot/{limit}")
@ApiOperation("获取热榜电影")
public List<Film> listHots(@PathVariable Integer limit) {
return filmService.findHots(limit);
}
@GetMapping("/{id}")
@ApiOperation("根据id查询员工")
public Worker findById(@PathVariable String id){
return workerService.findById(id);
}
@DeleteMapping("/{id}")
@ApiOperation("根据id删除员工")
public void deleteById(@PathVariable String id){
workerService.deleteById(id);
}
@PutMapping("")
@ApiOperation("更新员工信息")
public void update(@RequestBody Worker worker) throws Exception {
workerService.update(worker);
}
}
/**
* Authorization 授权 发放token
*/
}
@Override
protected void doFilterInternal(HttpServletRequest request, HttpServletResponse response, FilterChain chain)
throws IOException, ServletException {
//从Request Header 取出Token
String token = request.getHeader(JwtTokenUtil.TOKEN_HEADER);
//Token为空放行
//如果接下来进入的URL不是公共的地址SpringSecurity会返回403的错误
if (token == null || "null".equals(token)) {
chain.doFilter(request, response);
return;
}
//判断JWT Token是否过期
if (JwtTokenUtil.isExpiration(token)) {
ResponseUtil.writeJson(response, new ResponseResult<>(403, "令牌已过期, 请重新登录"));
return;
}
//解析JWT获取用户信息
String username = JwtTokenUtil.getUsername(token);
ArrayList<SimpleGrantedAuthority> authorities = new ArrayList<>();
for (String role : JwtTokenUtil.getTokenRoles(token)) {
authorities.add(new SimpleGrantedAuthority(role));
}
//向SpringSecurity的Context中加入认证信息
SecurityContextHolder.getContext().setAuthentication(
new UsernamePasswordAuthenticationToken(username, null, authorities));
super.doFilterInternal(request, response, chain);
}
}
@DeleteMapping("")
@ApiOperation(value = "删除图片")
public void delete(@RequestParam("id") String id) {
uploadService.deleteById(id);
}
@GetMapping("")
@ApiOperation(value = "获取图片")
@PermitAll
@DisableBaseResponse
public void get(@RequestParam("id") String id, HttpServletResponse response) throws Exception {
if ("".equals(id)) {
return;
}
Upload upload = uploadMapper.selectById(id);
if (upload == null) {
throw new Exception("图片不存在");
}
byte[] data = upload.getBytes();
response.setContentType("image/jpeg");
response.setCharacterEncoding("UTF-8");
OutputStream outputStream = response.getOutputStream();
InputStream in = new ByteArrayInputStream(data);
int len;
byte[] buf = new byte[1024];
while ((len = in.read(buf, 0, 1024)) != -1) {
outputStream.write(buf, 0, len);
}
outputStream.close();
}
}
@RestController
@Api(tags = "客服评价接口")
@RequestMapping("/api/we")
public class WorkerEvaluateController {
@Resource
private WorkerEvaluateService workerEvaluateService;
@PostMapping("")
@ApiOperation(value = "保存客服评价")
public void save(@RequestBody WorkerEvaluate workerEvaluate) {
workerEvaluateService.save(workerEvaluate);
}
@GetMapping("")
@ApiOperation(value = "查看客服评价")
public List<WorkerEvaluate> save(String id) {
return workerEvaluateService.findByWorkerId(id);
}
@DeleteMapping("{id}")
@ApiOperation(value = "删除客服评价")
public void deleteById(@PathVariable String id) {
workerEvaluateService.deleteById(id);
}
}
@RestController
@Api(tags = "用户购物车接口")
@RequestMapping("/api/cart")
public class CartController {
@Resource
private CartService cartService;
@GetMapping("")
@ApiOperation("查询员工的权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public List<Role> listByWorkerId(String wid) {
return roleService.listRolesByWorkerId(wid);
}
@DeleteMapping("/{id}")
@ApiOperation("删除权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public void delete(@PathVariable String id) throws Exception {
roleService.deleteById(id);
}
}
@RestController
@Api(tags = "订单接口")
@RequestMapping("/api/order")
public class OrderController {
@Resource
private OrderService orderService;
@PostMapping("")
@ApiOperation(value = "创建订单")
public void save(@RequestBody Cart cart) throws Exception {
orderService.create(cart);
}
@GetMapping("")
@ApiOperation(value = "查询所有订单")
public List<OrderVO> findAll() {
return orderService.findAll();
}
@PutMapping("")
@ApiOperation(value = "查询所有订单")
public void update(@RequestBody Order order) {
orderService.update(order);
@DeleteMapping("/{id}")
@ApiOperation("根据id删除员工")
public void deleteById(@PathVariable String id){
workerService.deleteById(id);
}
@PutMapping("")
@ApiOperation("更新员工信息")
public void update(@RequestBody Worker worker) throws Exception {
workerService.update(worker);
}
}
/**
* Authorization 授权 发放token
*/
public class AuthorizationFilter extends BasicAuthenticationFilter {
public AuthorizationFilter(AuthenticationManager authenticationManager) {
super(authenticationManager);
}
@Override
protected void doFilterInternal(HttpServletRequest request, HttpServletResponse response, FilterChain chain)
orderService.update(order);
}
@GetMapping("/user/{id}")
@ApiOperation(value = "查询用户订单")
public List<OrderVO> findByUser(@PathVariable String id) {
return orderService.findByUser(id);
}
@GetMapping("/pay")
@ApiOperation(value = "支付订单")
public Order save(String id) throws Exception {
return orderService.pay(id);
}
}
@RestController
@Api(tags = "电影评价接口")
@RequestMapping("/api/fe")
public class FilmEvaluateController {
@Resource
private FilmEvaluateService filmEvaluateService;
@PostMapping("")
@ApiOperation("评论电影")
public void save(@RequestBody FilmEvaluate filmEvaluate) throws Exception {
filmEvaluateService.save(filmEvaluate);
}
@GetMapping("")
public Role create(@RequestBody Role role) throws Exception {
return roleService.create(role);
}
@GetMapping("")
@ApiOperation("查询员工的权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public List<Role> listByWorkerId(String wid) {
return roleService.listRolesByWorkerId(wid);
}
@DeleteMapping("/{id}")
@ApiOperation("删除权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public void delete(@PathVariable String id) throws Exception {
roleService.deleteById(id);
}
}
@RestController
@Api(tags = "订单接口")
@RequestMapping("/api/order")
public class OrderController {
@Resource
private OrderService orderService;
@PostMapping("")
@ApiOperation(value = "创建订单")
public void save(@RequestBody Cart cart) throws Exception {
orderService.create(cart);
}
@DeleteMapping("{id}")
@ApiOperation("删除活动")
public void delete(@PathVariable String id) {
activityService.deleteById(id);
}
}
@RestController
@Api(tags = "订单异常上报接口")
@RequestMapping("/api/oe")
public class OrderExceptionController {
@Resource
private OrderExceptionService orderExceptionService;
@PostMapping("")
@ApiOperation("添加异常订单")
public OrderException create(@RequestBody OrderException orderException) {
return orderExceptionService.create(orderException);
}
@GetMapping("")
@ApiOperation("查询所有异常订单")
public List<OrderException> findAll() {
return orderExceptionService.findAll();
}
@PutMapping("")
@ApiOperation("工作人员处理异常订单")
public void handle(@RequestBody OrderException orderException) {
orderExceptionService.handleException(orderException);
}
@RestController
@Api(tags = "用户接口")
@RequestMapping("/api/user")
public class UserController {
@Resource
private UserService userService;
@PostMapping("/login")
@ApiOperation("用户登录")
public Map<String, Object> login(@RequestBody LoginDto dto) throws Exception {
User user = userService.login(dto);
Map<String, Object> map = new HashMap<>();
//是否选择记住我
long exp = dto.isRemember() ? JwtTokenUtil.REMEMBER_EXPIRATION_TIME : JwtTokenUtil.EXPIRATION_TIME;
List<String> roles = new ArrayList<>();
roles.add(Roles.ROLE_USER);
map.put("token", JwtTokenUtil.createToken(dto.getUsername(), roles, exp));
map.put("user", user);
return map;
}
@GetMapping("")
@ApiOperation(value = "查找所有用户")
public List<User> findAll() {
return userService.findAll();
}
@PutMapping("")
@ApiOperation(value = "更新用户")
public User updateUser(@RequestBody User user) {
return userService.update(user);
}
@GetMapping("/{id}")
@ApiOperation(value = "查找用户")
public User findById(@PathVariable String id) {
return userService.findById(id);
public static void writeJson(HttpServletResponse response, Object o) {
response.setHeader("Access-Control-Allow-Origin", "*");
response.setHeader("Access-Control-Allow-Credentials", "true");
response.setHeader("Access-Control-Allow-Methods", "POST, GET, PATCH, DELETE, PUT");
response.setHeader("Access-Control-Max-Age", "3600");
response.setHeader("Access-Control-Allow-Headers", "Origin, X-Requested-With, Content-Type, Accept");
response.setContentType("application/json;charset=utf-8");
response.setStatus(200);
try {
PrintWriter writer = response.getWriter();
writer.write(JSON.toJSONString(o));
writer.flush();
writer.close();
} catch (IOException e) {
System.out.println("write json error");
e.printStackTrace();
}
}
}
/**
* 捕获controller异常
* controller抛出异常执行下边的函数
* 返回Response写入ApiResult
*/
@ResponseBody
@RestControllerAdvice
public class GlobalExceptionHandler {
private final Logger logger = LoggerFactory.getLogger(getClass());
@ExceptionHandler(value = Exception.class)
@DisableBaseResponse
public Object handleException(Exception e) {
if (e.getClass().equals(AccessDeniedException.class)){
return new ResponseResult<>(403, "你没有访问权限");
}
logger.error(e.getMessage());
return new ResponseResult<>(400, e.getMessage());
}
}
@DeleteMapping("")
@ApiOperation(("删除所有海报"))
public void deleteAll() {
posterService.deleteAll();
}
}
/**
* 统一拦截Controller中所有方法的返回值
* 封装后返回ResponseResult<T>
*/
@ControllerAdvice(basePackages = "com.movie.api")
public class GlobalResponseHandler implements ResponseBodyAdvice<Object> {
@Override
public boolean supports(MethodParameter methodParameter, Class c) {
//如果方法上带有DisableBaseResponse注解, 不处理返回false
return !methodParameter.hasMethodAnnotation(DisableBaseResponse.class);
}
@Override
public ResponseResult<Object> beforeBodyWrite(Object o, MethodParameter methodParameter, MediaType mediaType, Class aClass,
ServerHttpRequest serverHttpRequest, ServerHttpResponse serverHttpResponse) {
if (o == null) {
return new ResponseResult<>();
}
return new ResponseResult<>(o);
}
}
}
return new ResponseResult<>(o);
}
}
@RestController
@Api(tags = "留言接口")
@RequestMapping("/api/lm")
public class LeavingMessageController {
@Resource
private LeavingMessageService leavingMessageService;
@PostMapping("")
@ApiOperation(value = "新增留言接口")
public void save(@RequestBody LeavingMessage leavingMessage) {
leavingMessageService.save(leavingMessage);
}
@PutMapping("")
@ApiOperation("回复留言")
public void reply(@RequestBody LeavingMessage leavingMessage) {
leavingMessageService.reply(leavingMessage);
}
@GetMapping("")
@ApiOperation("获取所有影院留言")
public List<LeavingMessageVO> list() {
return leavingMessageService.findAll();
}
@GetMapping("/active")
@ApiOperation("获取活跃留言的用户")
public List<ActiveUserVO> findActiveUsers() {
return leavingMessageService.findActiveUsers();
}
}
public class RoleController {
@Resource
private RoleService roleService;
@GetMapping("/system")
@ApiOperation("查看系统设置有哪些权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public String[] listSystemRoles() {
return Roles.roles;
}
@PostMapping("")
@ApiOperation("添加权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public Role create(@RequestBody Role role) throws Exception {
return roleService.create(role);
}
@GetMapping("")
@ApiOperation("查询员工的权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public List<Role> listByWorkerId(String wid) {
return roleService.listRolesByWorkerId(wid);
}
@DeleteMapping("/{id}")
@ApiOperation("删除权限")
@PreAuthorize("hasAnyRole('ROLE_ADMIN')")
public void delete(@PathVariable String id) throws Exception {
roleService.deleteById(id);
}
}