幻灯片后台

幻灯片后台

• 分析题目

  任务11： 管理端：实现幻灯片管理功能（8分）

  【功能说明】

  在Shopping管理端实现幻灯片管理功能。

  • 

     

     

    图3-10幻灯片管理界面

     

     

    图3-11幻灯片编辑界面

    【任务要求】

    1. 实现幻灯片详情数据显示（幻灯片名称、描述、缩略图、更新者、操作），如图3-10。

    2. 点击【编辑】按钮，可编辑当前幻灯片的名称、描述、图片、排序序号等信息，编辑后可以保存当前幻灯片信息。如图3-11。

    3. 点击【删除】按钮，可以将当前幻灯片信息删除。

  • 进行逆向生成代码

    1.数据库

  •  

    

    2.配置

    2.1根目录(需要 mysql jar 和 新建 src 文件夹)

  •  

    

    2.2配置文件 （用记事本转换为ANSI编码）

  •  

    

    3.编译

  •  

    

    4.将逆向编译的代码文件放进项目 （src文件夹）

  • 编写Service层

    1.AdvertService

        /**
         * 获取幻灯片列表
         */
        public Map<String, Object> getAdvertInByCondition(PageInformation pageInfo,Advert advert);
        /**
         *删除
         */
        public int delteAdvert(String id);
        
        public int addAdvert(Advert advert);
        
        public int updateAdvert(Advert advert);
        
        public List<Advert> getAdvertById(int id);

    2.AdvertServiceImpl

  @Service
  public class AdvertServiceImpl implements AdvertService {
      @Autowired
      AdvertMapper advertMapper;
      @Autowired
      PagingTool pagingTool;
  ​
      @Override
      public Map<String, Object> getAdvertInByCondition(PageInformation pageInfo,Advert advert) {
          // TODO Auto-generated method stub
          AdvertExample advertExample = new AdvertExample();
          Criteria createCriteria = advertExample.createCriteria();
          long countByExample = advertMapper.countByExample(advertExample);
          advertExample.setOrderByClause("sort_id asc");
          createCriteria.andTitleLike("%"+advert.getTitle()+"%");
          createCriteria.andMessageLike("%"+advert.getMessage()+"%");
          
          
          List<Advert> pagingData = pagingTool.PagingData("com.sybinal.shop.mapper.AdvertMapper.selectByExample", advertExample,
                  Integer.parseInt(pageInfo.getiDisplayStart()) / Integer.parseInt(pageInfo.getiDisplayLength()),
                  Integer.parseInt(pageInfo.getiDisplayLength()));
          
          
          HashMap<String, Object> datas = new HashMap<String, Object>();
          datas.put("sEcho", pageInfo.getsEcho());
          datas.put("iTotalRecords", countByExample);
          datas.put("iTotalDisplayRecords", countByExample);
          datas.put("aaData", pagingData);
          return datas;
      }
  ​
      @Override
      public int delteAdvert(String id) {
          // TODO Auto-generated method stub
          int i = 0;
          List<Integer> ids = new ArrayList<Integer>();
          String[] categoryIds = id.split("-");
          if(categoryIds != null && categoryIds.length != 0){
              for(String categoryId : categoryIds){
                  Integer idTemp = Integer.parseInt(categoryId);
                  ids.add(idTemp);
              }
          }
          i = advertMapper.deleteAdvertList(ids);
          return i;
      }
  ​
      @Override
      public int addAdvert(Advert advert) {
          // TODO Auto-generated method stub
          return advertMapper.insertSelective(advert);
      }
  ​
      @Override
      public int updateAdvert(Advert advert) {
          // TODO Auto-generated method stub
          return advertMapper.updateByPrimaryKeySelective(advert);
      }
  ​
      @Override
      public List<Advert> getAdvertById(int id) {
          // TODO Auto-generated method stub
          AdvertExample advertExample=new AdvertExample();
          Criteria createCriteria = advertExample.createCriteria();
          createCriteria.andIdEqualTo(id);
          List<Advert> selectByExample = advertMapper.selectByExample(advertExample);
          return selectByExample;
      }
  ​
  }

   

  3.AdvertController

  @Controller
  public class AdvertController {
      @Autowired
      AdvertService advertService;
  ​
      @RequestMapping(value = "/admin/advert", method = RequestMethod.GET)
      public ModelAndView getAdvert() {
          ModelAndView model = new ModelAndView();
          model.setViewName("admin/advert/advertMain");
          return model;
      }
  ​
      @RequestMapping(value = "/admin/advertInList", method = RequestMethod.POST)
      @ResponseBody
      public Map<String, Object> productCategorynfoDataTable(PageInformation pageInfo, Advert advert) {
          return advertService.getAdvertInByCondition(pageInfo, advert);
      }
  ​
      @RequestMapping(value = "/admin/delAdvert", method = RequestMethod.POST)
      @ResponseBody
      public Map<String, Object> checkVerifyProduct(@RequestBody String id) {
          Map<String, Object> map = new HashMap<String, Object>();
          if (StringUtils.isEmpty(id) == true) {
              map.put("error", "-1"); // 失败
          } else {
              int i = advertService.delteAdvert(id);
              if (i > 0) {
                  map.put("error", "0"); // 成功
              } else {
                  map.put("error", "-1"); // 失败
              }
          }
          return map;
      }
  ​
      @RequestMapping(value = "/admin/addAdvert", method = RequestMethod.GET)
      public ModelAndView addAdvert() {
          ModelAndView model = new ModelAndView();
          model.setViewName("admin/advert/advertEdit");
          return model;
      }
      
      @RequestMapping(value = "/admin/advert/edit", method = RequestMethod.POST)
      @ResponseBody
      public ModelAndView editAdvert(@RequestParam("id") Integer id) {
          ModelAndView model = new ModelAndView();
          List<Advert> advertById = advertService.getAdvertById(id);
          Advert advert=new Advert();
          advert=advertById.get(0);
          if (advert != null) {
              model.addObject("advert", advert);
          }
          model.setVi