幻灯片后台
-
分析题目
任务11: 管理端:实现幻灯片管理功能(8分)
【功能说明】
在Shopping管理端实现幻灯片管理功能。
-
图3-10幻灯片管理界面
图3-11幻灯片编辑界面
【任务要求】
-
实现幻灯片详情数据显示(幻灯片名称、描述、缩略图、更新者、操作),如图3-10。
-
点击【编辑】按钮,可编辑当前幻灯片的名称、描述、图片、排序序号等信息,编辑后可以保存当前幻灯片信息。如图3-11。
-
点击【删除】按钮,可以将当前幻灯片信息删除。
-
-
进行逆向生成代码
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
-