赞
踩
基于javaweb+mysql的ssm+maven动漫影视管理系统视频播放系统(java+ssm+jsp+jquery+mysql)
运行环境
Java≥8、MySQL≥5.7、Tomcat≥8
开发工具
eclipse/idea/myeclipse/sts等均可配置运行
适用
课程设计,大作业,毕业设计,项目练习,学习演示等
功能说明
基于javaweb+mysql的SSM+Maven动漫影视管理系统(java+ssm+jsp+jquery+mysql)
项目介绍
本项目分为前后台,前台为普通用户登录,后台为管理员登录。
管理员角色包含以下功能: 管理员登陆,用户管理,影片列表管理,管理影片等功能。
用户角色包含以下功能: 用户登录注册,用户首页,视频简介,视频播放,评论视频,查看我收藏的视频,查看我的评论等功能。
环境需要
1.运行环境:最好是java jdk 1.8,我们在这个平台上运行的。其他版本理论上也可以。 2.IDE环境:IDEA,Eclipse,Myeclipse都可以。推荐IDEA; 3.tomcat环境:Tomcat 7.x,8.x,9.x版本均可 4.硬件环境:windows 7/8/10 1G内存以上;或者 Mac OS; 5.数据库:MySql 5.7版本; 6.是否Maven项目:是;
技术栈
使用说明
session.invalidate(); return "redirect:/login/login.action"; } @RequestMapping("/view") public String view( HttpServletRequest request, HttpServletResponse response, Model model){ Object attribute = request.getSession().getAttribute("mid"); if (attribute == null){ return "redirect:/login/uIndex.action"; } Integer userId = Integer.valueOf(attribute.toString()); User load = userService.load(userId); model.addAttribute("obj", load); return "login/view"; } @RequestMapping("/sc") public String sc( HttpServletRequest request, HttpServletResponse response, Model model){ Object attribute = request.getSession().getAttribute("mid"); if (attribute == null){ return "redirect:/login/uIndex.action"; } Integer userId = Integer.valueOf(attribute.toString()); User load = userService.load(userId); model.addAttribute("obj", load); List<Collect> listBySqlReturnEntity = collectService.listBySqlReturnEntity("SELECT * FROM collect WHERE userId = "+userId); model.addAttribute("list", listBySqlReturnEntity); return "login/sc"; } @RequestMapping("/pl") public String pl( HttpServletRequest request, HttpServletResponse response, Model model){ Object attribute = request.getSession().getAttribute("mid"); if (attribute == null){ return "redirect:/login/uIndex.action"; } Integer userId = Integer.valueOf(attribute.toString());
} if(!isEmpty(user.getIdCard())){ params.put("idCard", user.getIdCard()); } if(!isEmpty(user.getPassword())){ params.put("password", user.getPassword()); } if(!isEmpty(user.getEmail())){ params.put("email", user.getEmail()); } if(!isEmpty(user.getIsDelete())){ params.put("isDelete", user.getIsDelete()); } List<User> listAll = userService.listByMap(params); JSONObject jsonObject = new JSONObject(); jsonObject.put("list", listAll); jsonObject.put("obj", user); return jsonObject.toString(); } /** * 分页查询 返回list json(通过对象) * * @param request * @param response * @return */ @RequestMapping(value = "/findByObjJson", method = RequestMethod.POST) @ResponseBody public String findByObjByEntityJson(User user, HttpServletRequest request, HttpServletResponse response) { //分页查询 Pager<User> pagers = userService.findByEntity(user); JSONObject jsonObject = new JSONObject(); jsonObject.put("pagers", pagers); jsonObject.put("obj", user); return jsonObject.toString(); } /** * 分页查询 返回list json(通过Map) * * @param request * @param response * @return
@ResponseBody public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) { ///1.通过主键删除 manageService.deleteById(id); /*以下是多种删除方式*/ // //2.通过实体条件删除 // manageService.deleteByEntity(manage); // //3.通过参数删除 // //通过map查询 // Map<String,Object> params = new HashMap<String,Object>(); // // if(!isEmpty(manage.getName())){ // params.put("name", manage.getName()); // } // // if(!isEmpty(manage.getPassWord())){ // params.put("passWord", manage.getPassWord()); // } // // if(!isEmpty(manage.getRealName())){ // params.put("realName", manage.getRealName()); // } // // if(!isEmpty(manage.getType())){ // params.put("type", manage.getType()); // } // // manageService.deleteByMap(params); // //4.状态删除 // Manage load = manageService.getById(manage.getId()) // load.setIsDelete(1); // manageService.updateById(load); //5.状态删除 //Manage load = manageService.load(id); //load.setIsDelete(1); //manageService.updateById(load); JSONObject jsonObject = new JSONObject(); jsonObject.put("message", "删除成功"); return jsonObject.toString(); } /** * 单文件上传 * @param file * @param request * @param model * @return */ @RequestMapping(value = "/saveFile") public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) { System.out.println("开始");
*/ @RequestMapping(value = "/add") public String add() { return "film/add"; } /** * 跳至详情页面 * @return */ @RequestMapping(value = "/view") public String view(Integer id,Model model) { Film obj = filmService.load(id); List<Comment> listBySqlReturnEntity = commentService.listBySqlReturnEntity("SELECT * FROM comment WHERE filmId="+id+" order by addTime desc"); model.addAttribute("obj",obj); model.addAttribute("list",listBySqlReturnEntity); //查询视频列表 List<FilmDetail> listBySqlReturnEntity2 = filmDetailService.listBySqlReturnEntity("SELECT * FROM film_detail WHERE filmId = "+id); model.addAttribute("datails",listBySqlReturnEntity2); return "film/view"; } /** * 添加执行 * @return * @throws IOException * @throws IllegalStateException */ @RequestMapping(value = "/exAdd") public String exAdd(@RequestParam(value = "file", required = false) MultipartFile file,HttpServletRequest request,Film film, Model model, HttpServletResponse response) throws IllegalStateException, IOException { if (!file.isEmpty()){ System.out.println("开始"); long startTime=System.currentTimeMillis(); System.out.println("fileName:"+file.getOriginalFilename()); String n = UUIDUtils.create(); String path=Thread.currentThread().getContextClassLoader().getResource("").getPath().substring(0,Thread.currentThread().getContextClassLoader().getResource("").getPath().length()-16)+"/upload/"+n+file.getOriginalFilename(); System.out.println("==================================================="); System.out.println(path); File newFile=new File(path); //通过CommonsMultipartFile的方法直接写文件(注意这个时候) file.transferTo(newFile); film.setPic("\\upload\\"+n+file.getOriginalFilename()); } film.setIsDelete(0); filmService.insert(film); return "redirect:/film/findBySql.action"; } /** * 跳至修改页面
* @return */ @RequestMapping(value = "/view") public String view(Integer id,Model model) { Film obj = filmService.load(id); List<Comment> listBySqlReturnEntity = commentService.listBySqlReturnEntity("SELECT * FROM comment WHERE filmId="+id+" order by addTime desc"); model.addAttribute("obj",obj); model.addAttribute("list",listBySqlReturnEntity); //查询视频列表 List<FilmDetail> listBySqlReturnEntity2 = filmDetailService.listBySqlReturnEntity("SELECT * FROM film_detail WHERE filmId = "+id); model.addAttribute("datails",listBySqlReturnEntity2); return "film/view"; } /** * 添加执行 * @return * @throws IOException * @throws IllegalStateException */ @RequestMapping(value = "/exAdd") public String exAdd(@RequestParam(value = "file", required = false) MultipartFile file,HttpServletRequest request,Film film, Model model, HttpServletResponse response) throws IllegalStateException, IOException { if (!file.isEmpty()){ System.out.println("开始"); long startTime=System.currentTimeMillis(); System.out.println("fileName:"+file.getOriginalFilename()); String n = UUIDUtils.create(); String path=Thread.currentThread().getContextClassLoader().getResource("").getPath().substring(0,Thread.currentThread().getContextClassLoader().getResource("").getPath().length()-16)+"/upload/"+n+file.getOriginalFilename(); System.out.println("==================================================="); System.out.println(path); File newFile=new File(path); //通过CommonsMultipartFile的方法直接写文件(注意这个时候) file.transferTo(newFile); film.setPic("\\upload\\"+n+file.getOriginalFilename()); } film.setIsDelete(0); filmService.insert(film); return "redirect:/film/findBySql.action"; } /**
//collectService.updateById(collect); JSONObject jsonObject = new JSONObject(); jsonObject.put("message", "修改成功"); return jsonObject.toString(); } /** * ajax 删除 * @return */ @RequestMapping(value = "/delete.json", method = RequestMethod.POST) @ResponseBody public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) { ///1.通过主键删除 collectService.deleteById(id); /*以下是多种删除方式*/ // //2.通过实体条件删除 // collectService.deleteByEntity(collect); // //3.通过参数删除 // //通过map查询 // Map<String,Object> params = new HashMap<String,Object>(); // // if(!isEmpty(collect.getUserId())){ // params.put("userId", collect.getUserId()); // } // // if(!isEmpty(collect.getFilmId())){ // params.put("filmId", collect.getFilmId()); // } // // collectService.deleteByMap(params); // //4.状态删除 // Collect load = collectService.getById(collect.getId()) // load.setIsDelete(1); // collectService.updateById(load); //5.状态删除 //Collect load = collectService.load(id); //load.setIsDelete(1); //collectService.updateById(load); JSONObject jsonObject = new JSONObject(); jsonObject.put("message", "删除成功"); return jsonObject.toString(); } /** * 单文件上传 * @param file * @param request * @param model * @return */ @RequestMapping(value = "/saveFile") public String saveFile(@RequestParam(value = "file", required = false) MultipartFile file, HttpServletRequest request, Model model) {
/** * ajax 添加 * @param * @return */ @RequestMapping(value = "/exAddJson", method = RequestMethod.POST) @ResponseBody public String exAddJson(User user, Model model, HttpServletRequest request, HttpServletResponse response) { userService.insert(user); JSONObject jsonObject = new JSONObject(); jsonObject.put("message", "添加成功"); return jsonObject.toString(); } /** * ajax 修改 * @param * @return */ @RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST) @ResponseBody public String exUpdateJson(User user, Model model, HttpServletRequest request, HttpServletResponse response) { //1.通过实体类修改,可以多传修改条件 userService.updateById(user); //2.通过主键id修改 //userService.updateById(user); JSONObject jsonObject = new JSONObject(); jsonObject.put("message", "修改成功"); return jsonObject.toString(); } /** * ajax 删除 * @return */ @RequestMapping(value = "/delete.json", method = RequestMethod.POST) @ResponseBody public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) { ///1.通过主键删除 userService.deleteById(id); /*以下是多种删除方式*/ // //2.通过实体条件删除 // userService.deleteByEntity(user); // //3.通过参数删除 // //通过map查询 // Map<String,Object> params = new HashMap<String,Object>(); // // if(!isEmpty(user.getNickname())){
jsonObject.put("res", 1); } return jsonObject.toString(); } @RequestMapping("/ulogin") public String ulogin(User manage, HttpServletRequest request, HttpServletResponse response){ User byEntity = userService.getByEntity(manage); JSONObject jsonObject = new JSONObject(); if(byEntity == null){ return "redirect:/login/uIndex.action"; }else{ request.getSession().setAttribute("role", 1); request.getSession().setAttribute("mid", byEntity.getId()); request.getSession().setAttribute("xm",byEntity.getName()); return "redirect:/login/uIndex.action"; } } @RequestMapping("/res") public String res(User user) { user.setIsDelete(0); userService.insert(user); return "redirect:/login/uIndex.action"; } /** * 用户首页查询数据 * @param openId * @param model * @param request * @param response * @return */ @RequestMapping(value = "/uIndex") public String uIndex(Integer type,String name, Model model, HttpServletRequest request, HttpServletResponse response) { String sql = "SELECT * FROM film WHERE isDelete = 0 "; if (type != null ){ sql+=" and type = "+type; } if (StringUtils.isNoneBlank(name)){ sql += " and name like '%"+name+"%'"; } sql+=" order by id desc"; Pager<Film> findBySqlRerturnEntity = filmService.findBySqlRerturnEntity(sql); model.addAttribute("type", type); model.addAttribute("name", name); model.addAttribute("pagers", findBySqlRerturnEntity);
model.addAttribute("list", listAll); return "manage/manage"; } /*********************************查询列表【分页】***********************************************/ /** * 分页查询 返回list对象(通过对象) * * @param request * @param response * @return */ @RequestMapping(value = "/findByObj") public String findByObj(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 Pager<Manage> pagers = manageService.findByEntity(manage); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", manage); return "manage/manage"; } /** * 分页查询 返回list对象(通过对By Sql) * * @param request * @param response * @return */ @RequestMapping(value = "/findBySql") public String findBySql(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 String sql = "SELECT * FROM manage WHERE 1=1 "; if(!isEmpty(manage.getName())){ sql += " and name like '%"+manage.getName()+"%'"; } if(!isEmpty(manage.getPassWord())){ sql += " and passWord like '%"+manage.getPassWord()+"%'"; } if(!isEmpty(manage.getRealName())){ sql += " and realName like '%"+manage.getRealName()+"%'";
} List<FilmDetail> listAll = filmDetailService.listByMap(params); JSONObject jsonObject = new JSONObject(); jsonObject.put("list", listAll); jsonObject.put("obj", filmDetail); return jsonObject.toString(); } /** * 分页查询 返回list json(通过对象) * * @param request * @param response * @return */ @RequestMapping(value = "/findByObjJson", method = RequestMethod.POST) @ResponseBody public String findByObjByEntityJson(FilmDetail filmDetail, HttpServletRequest request, HttpServletResponse response) { //分页查询 Pager<FilmDetail> pagers = filmDetailService.findByEntity(filmDetail); JSONObject jsonObject = new JSONObject(); jsonObject.put("pagers", pagers); jsonObject.put("obj", filmDetail); return jsonObject.toString(); } /** * 分页查询 返回list json(通过Map) * * @param request * @param response * @return */ @RequestMapping(value = "/findByMapJson", method = RequestMethod.POST) @ResponseBody public String findByMapJson(FilmDetail filmDetail,HttpServletRequest request, HttpServletResponse response) { //通过map查询 Map<String,Object> params = new HashMap<String,Object>();
System.out.println("*********************************************************"); System.out.println("*********************************************************"); params.put("state", "SUCCESS"); params.put("url", visitUrl); params.put("size", file.getSize()); params.put("original", file.getOriginalFilename()); params.put("type", file.getContentType()); return params; } } public class SystemContextFilter implements Filter{ private Integer pageSize; public void destroy() { } public void doFilter(ServletRequest req, ServletResponse resp, FilterChain chain) throws IOException, ServletException { Integer offset = 0; try { offset = Integer.parseInt(req.getParameter("pager.offset")); } catch (NumberFormatException e) {} try { SystemContext.setOrder(req.getParameter("order")); SystemContext.setSort(req.getParameter("sort")); SystemContext.setPageOffset(offset); SystemContext.setPageSize(pageSize); SystemContext.setRealPath(((HttpServletRequest)req).getSession().getServletContext().getRealPath("/")); chain.doFilter(req,resp); } finally { SystemContext.removeOrder();
/*以下是多种删除方式*/ // //2.通过实体条件删除 // manageService.deleteByEntity(manage); // //3.通过参数删除 // //通过map查询 // Map<String,Object> params = new HashMap<String,Object>(); // // if(!isEmpty(manage.getName())){ // params.put("name", manage.getName()); // } // // if(!isEmpty(manage.getPassWord())){ // params.put("passWord", manage.getPassWord()); // } // // if(!isEmpty(manage.getRealName())){ // params.put("realName", manage.getRealName()); // } // // if(!isEmpty(manage.getType())){ // params.put("type", manage.getType()); // } // // manageService.deleteByMap(params); // //4.状态删除 // Manage load = manageService.getById(manage.getId()) // load.setIsDelete(1); // manageService.update(load); //5.状态删除 //Manage load = manageService.load(id); //load.setIsDelete(1); //manageService.updateById(load); return "redirect:/manage/findBySql.action"; } // --------------------------------------- 华丽分割线 ------------------------------ // --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------ /*********************************查询列表【不分页】***********************************************/ /** * 【不分页 => 查询列表 => 无条件】 * @Title: listAll * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @return String 返回类型 * @throws */
* @return */ @RequestMapping(value = "/view") public String view(Integer id,Model model) { User obj = userService.load(id); model.addAttribute("obj",obj); return "user/view"; } /** * 添加执行 * @return */ @RequestMapping(value = "/exAdd") public String exAdd(User user, Model model, HttpServletRequest request, HttpServletResponse response) { userService.insert(user); return "redirect:/user/findBySql.action"; } /** * 跳至修改页面 * @return */ @RequestMapping(value = "/update") public String update(Integer id,Model model) { User obj = userService.load(id); model.addAttribute("obj",obj); return "user/update"; } /** * 添加修改 * @return */ @RequestMapping(value = "/exUpdate") public String exUpdate(User user, Model model, HttpServletRequest request, HttpServletResponse response) { //1.通过实体类修改,可以多传修改条件 userService.updateById(user); //2.通过主键id修改 //userService.updateById(user); return "redirect:/user/findBySql.action"; } /** * 删除通过主键 * @return */ @RequestMapping(value = "/delete") public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) { User load = userService.load(id);
* springMvc多文件上传 * @param files * @param id * @return */ @RequestMapping(value = "/saveFiles") public String saveFiles(@RequestParam("file") CommonsMultipartFile[] files,Integer id,HttpServletRequest request){ for(int i = 0;i<files.length;i++){ System.out.println("fileName---------->" + files[i].getOriginalFilename()); if(!files[i].isEmpty()){ int pre = (int) System.currentTimeMillis(); try { //拿到输出流,同时重命名上传的文件 String filePath = request.getRealPath("/upload"); File f=new File(filePath); if(!f.exists()){ f.mkdirs(); } String fileNmae=new Date().getTime() + files[i].getOriginalFilename(); File file=new File(filePath+"/"+pre + files[i].getOriginalFilename()); if(!file.exists()){ file.createNewFile(); } files[i].transferTo(file); } catch (Exception e) { e.printStackTrace(); System.out.println("上传出错"); } } } return ""; } // --------------------------------------- 华丽分割线 ------------------------------ }
* @return String 返回类型 * @throws */ @RequestMapping(value = "/listAllJson", method = RequestMethod.POST) @ResponseBody public String listAllJson(Comment comment, HttpServletRequest request, HttpServletResponse response){ List<Comment> listAll = commentService.listAll(); JSONObject jsonObject = new JSONObject(); jsonObject.put("list", listAll); jsonObject.put("obj", comment); return jsonObject.toString(); } /** * 【不分页=》查询列表=>有条件】 * @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST) @ResponseBody public String listByEntityJson(Comment comment, HttpServletRequest request, HttpServletResponse response){ List<Comment> listAll = commentService.listAllByEntity(comment); JSONObject jsonObject = new JSONObject(); jsonObject.put("list", listAll); jsonObject.put("obj", comment); return jsonObject.toString(); } /** * 【不分页=》查询列表=>有条件】 * @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByMapJson", method = RequestMethod.POST) @ResponseBody public String listByMapJson(Comment comment,HttpServletRequest request, HttpServletResponse response){ //通过map查询
* @param @return 设定文件 * @return String 返回类型 * @throws */ @RequestMapping(value = "/listAllJson", method = RequestMethod.POST) @ResponseBody public String listAllJson(Comment comment, HttpServletRequest request, HttpServletResponse response){ List<Comment> listAll = commentService.listAll(); JSONObject jsonObject = new JSONObject(); jsonObject.put("list", listAll); jsonObject.put("obj", comment); return jsonObject.toString(); } /** * 【不分页=》查询列表=>有条件】 * @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST) @ResponseBody public String listByEntityJson(Comment comment, HttpServletRequest request, HttpServletResponse response){ List<Comment> listAll = commentService.listAllByEntity(comment); JSONObject jsonObject = new JSONObject(); jsonObject.put("list", listAll); jsonObject.put("obj", comment); return jsonObject.toString(); } /** * 【不分页=》查询列表=>有条件】 * @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @return String 返回类型 * @throws */ @RequestMapping(value = "/listByMapJson", method = RequestMethod.POST) @ResponseBody
filmDetailService.updateById(filmDetail); //2.通过主键id修改 //filmDetailService.updateById(filmDetail); JSONObject jsonObject = new JSONObject(); jsonObject.put("message", "修改成功"); return jsonObject.toString(); } /** * ajax 删除 * @return */ @RequestMapping(value = "/delete.json", method = RequestMethod.POST) @ResponseBody public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) { ///1.通过主键删除 filmDetailService.deleteById(id); /*以下是多种删除方式*/ // //2.通过实体条件删除 // filmDetailService.deleteByEntity(filmDetail); // //3.通过参数删除 // //通过map查询 // Map<String,Object> params = new HashMap<String,Object>(); // // if(!isEmpty(filmDetail.getFilmId())){ // params.put("filmId", filmDetail.getFilmId()); // } // // if(!isEmpty(filmDetail.getNum())){ // params.put("num", filmDetail.getNum()); // } // // if(!isEmpty(filmDetail.getUrl())){ // params.put("url", filmDetail.getUrl()); // } // // filmDetailService.deleteByMap(params); // //4.状态删除 // FilmDetail load = filmDetailService.getById(filmDetail.getId()) // load.setIsDelete(1); // filmDetailService.updateById(load);
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。