作者主页：夜未央5788
简介：Java领域优质创作者、Java项目、学习资料、技术互助
文末获取源码
项目介绍
本项目分为前后台，前台为普通用户登录，后台为管理员登录；
管理员角色包含以下功能：
管理员登录,类目管理,用户管理,商品管理,订单管理,发货管理,提交发货,公告管理,留言管理,日志查看等功能。
用户角色包含以下功能：
用户登录,用户首页,查看公告,提交留言,查看商品详情,加入购物车,商品结算等功能。
环境需要
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项目：是；
技术栈
1. 后端：Spring+SpringMVC+Mybatis
2. 前端：JSP+CSS+JavaScript+jquery+bootstrap+echarts
使用说明
1. 使用Navicat或者其它工具，在mysql中创建对应名称的数据库，并导入项目的sql文件；
2. 使用IDEA/Eclipse/MyEclipse导入项目，Eclipse/MyEclipse导入时，若为maven项目请选择maven;
若为maven项目，导入成功后请执行maven clean;maven install命令，然后运行；
3. 将项目中db.properties配置文件中的数据库配置改为自己的配置;
4. 运行项目，在浏览器中输入http://localhost:8080/shop 登录
用户账号/密码： user/123456
管理员账号/密码：admin/admin
运行截图
前台界面
后台界面
代码相关
地址管理控制器
@Controller
@RequestMapping("/address")
public class AddressController extends BaseController {/*** 依赖注入 start dao/service/===*/@Autowiredprivate AddressService addressService;// --------------------------------------- 华丽分割线 ------------------------------/*********************************查询列表【不分页】***********************************************//*** 【不分页 => 查询列表 => 无条件】* @Title: listAll * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listAll")public String listAll(Address address, Model model, HttpServletRequest request, HttpServletResponse response){List<Address> listAll = addressService.listAll();model.addAttribute("list", listAll);return "address/address";}/*** 【不分页=》查询列表=>有条件】* @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listByEntity")public String listByEntity(Address address, Model model, HttpServletRequest request, HttpServletResponse response){List<Address> listAll = addressService.listAllByEntity(address);model.addAttribute("list", listAll);return "address/address";}/*** 【不分页=》查询列表=>有条件】* @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws*/@RequestMapping(value = "/listByMap")public String listByMap(Address address, Model model, HttpServletRequest request, HttpServletResponse response){//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(address.getName())){params.put("name", address.getName());}if(!isEmpty(address.getPhone())){params.put("phone", address.getPhone());}if(!isEmpty(address.getArea())){params.put("area", address.getArea());}if(!isEmpty(address.getBm())){params.put("bm", address.getBm());}if(!isEmpty(address.getIsUse())){params.put("isUse", address.getIsUse());}List<Address> listAll = addressService.listByMap(params);model.addAttribute("list", listAll);return "address/address";}/*********************************查询列表【分页】***********************************************//*** 分页查询 返回list对象(通过对象)* * @param request* @param response* @return*/@RequestMapping(value = "/findByObj")public String findByObj(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {//分页查询Pager<Address> pagers = addressService.findByEntity(address);model.addAttribute("pagers", pagers);//存储查询条件model.addAttribute("obj", address);return "address/address";}/*** 分页查询 返回list对象(通过对By Sql)* * @param request* @param response* @return*/@RequestMapping(value = "/findBySql")public String findBySql(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {//分页查询String sql = "SELECT * FROM address WHERE 1=1 ";if(!isEmpty(address.getName())){sql += " and name like '%"+address.getName()+"%'";}if(!isEmpty(address.getPhone())){sql += " and phone like '%"+address.getPhone()+"%'";}if(!isEmpty(address.getArea())){sql += " and area like '%"+address.getArea()+"%'";}if(!isEmpty(address.getBm())){sql += " and bm like '%"+address.getBm()+"%'";}if(!isEmpty(address.getIsUse())){sql += " and isUse like '%"+address.getIsUse()+"%'";}sql += " ORDER BY ID DESC ";Pager<Address> pagers = addressService.findBySqlRerturnEntity(sql);model.addAttribute("pagers", pagers);//存储查询条件model.addAttribute("obj", address);return "address/address";}@RequestMapping(value = "/my")public String my(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {//分页查询Object attribute = request.getSession().getAttribute("userId");if (attribute == null){return "redirect:/login/uLogin";}JSONObject js = new JSONObject();Integer userId = Integer.valueOf(attribute.toString());String sql = "SELECT * FROM address WHERE 1=1 and userId = "+userId;if(!isEmpty(address.getName())){sql += " and name like '%"+address.getName()+"%'";}if(!isEmpty(address.getPhone())){sql += " and phone like '%"+address.getPhone()+"%'";}if(!isEmpty(address.getArea())){sql += " and area like '%"+address.getArea()+"%'";}if(!isEmpty(address.getBm())){sql += " and bm like '%"+address.getBm()+"%'";}if(!isEmpty(address.getIsUse())){sql += " and isUse like '%"+address.getIsUse()+"%'";}sql += " ORDER BY ID DESC ";Pager<Address> pagers = addressService.findBySqlRerturnEntity(sql);model.addAttribute("pagers", pagers);//存储查询条件model.addAttribute("obj", address);return "address/my";}/*** 分页查询 返回list对象(通过Map)* * @param request* @param response* @return*/@RequestMapping(value = "/findByMap")public String findByMap(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(address.getName())){params.put("name", address.getName());}if(!isEmpty(address.getPhone())){params.put("phone", address.getPhone());}if(!isEmpty(address.getArea())){params.put("area", address.getArea());}if(!isEmpty(address.getBm())){params.put("bm", address.getBm());}if(!isEmpty(address.getIsUse())){params.put("isUse", address.getIsUse());}//分页查询Pager<Address> pagers = addressService.findByMap(params);model.addAttribute("pagers", pagers);//存储查询条件model.addAttribute("obj", address);return "address/address";}/**********************************【增删改】******************************************************//*** 跳至添加页面* @return*/@RequestMapping(value = "/add")public String add() {return "address/add";}/*** 跳至详情页面* @return*/@RequestMapping(value = "/view")public String view(Integer id,Model model) {Address obj = addressService.load(id);model.addAttribute("obj",obj);return "address/view";}/*** 添加执行* @return*/@RequestMapping(value = "/exAdd")public String exAdd(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {Object attribute = request.getSession().getAttribute("userId");if (attribute == null){return "redirect:/login/uLogin";}Integer userId = Integer.valueOf(attribute.toString());address.setUserId(userId);address.setIsUse(0);addressService.insert(address);return "redirect:/car/view.action";}@RequestMapping(value = "/exAdd1")public String exAdd1(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {Object attribute = request.getSession().getAttribute("userId");if (attribute == null){return "redirect:/login/uLogin";}Integer userId = Integer.valueOf(attribute.toString());address.setUserId(userId);address.setIsUse(0);addressService.insert(address);return "redirect:/address/my.action";}/*** 跳至修改页面* @return*/@RequestMapping(value = "/update")public String update(Integer id,Model model) {Address obj = addressService.load(id);model.addAttribute("obj",obj);return "address/update";}/*** 添加修改* @return*/@RequestMapping(value = "/exUpdate")public String exUpdate(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {//1.通过实体类修改，可以多传修改条件addressService.updateById(address);//2.通过主键id修改//addressService.updateById(address);return "redirect:/car/view.action";}@RequestMapping(value = "/exUpdate2")public String exUpdate2(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {//1.通过实体类修改，可以多传修改条件addressService.updateById(address);//2.通过主键id修改//addressService.updateById(address);return "redirect:/address/my.action";}@RequestMapping(value = "/delete1")public String delete1(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {///1.通过主键删除addressService.deleteById(id);/*以下是多种删除方式*/return "redirect:/address/my.action";}@RequestMapping(value = "/mr")public String mr(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {///1.通过主键删除//分页查询Object attribute = request.getSession().getAttribute("userId");if (attribute == null){return "redirect:/login/uLogin";}JSONObject js = new JSONObject();Integer userId = Integer.valueOf(attribute.toString());String sql = "SELECT * FROM address WHERE 1=1 and userId = "+userId;List<Address> listBySqlReturnEntity = addressService.listBySqlReturnEntity(sql);if (!CollectionUtils.isEmpty(listBySqlReturnEntity)){for(Address a : listBySqlReturnEntity){a.setIsUse(0);addressService.updateById(a);}}Address load = addressService.load(id);load.setIsUse(1);addressService.updateById(load);/*以下是多种删除方式*/return "redirect:/address/my.action";}/*** 删除通过主键* @return*/@RequestMapping(value = "/delete")public String delete(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {///1.通过主键删除addressService.deleteById(id);/*以下是多种删除方式*/
// //2.通过实体条件删除
// addressService.deleteByEntity(address);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(address.getName())){
// params.put("name", address.getName());
// }
//
// if(!isEmpty(address.getPhone())){
// params.put("phone", address.getPhone());
// }
//
// if(!isEmpty(address.getArea())){
// params.put("area", address.getArea());
// }
//
// if(!isEmpty(address.getBm())){
// params.put("bm", address.getBm());
// }
//
// if(!isEmpty(address.getIsUse())){
// params.put("isUse", address.getIsUse());
// }
//
// addressService.deleteByMap(params);
// //4.状态删除
// Address load = addressService.getById(address.getId())
// load.setIsDelete(1);
// addressService.update(load);//5.状态删除//Address load = addressService.load(id);//load.setIsDelete(1);//addressService.update(load);return "redirect:/address/findBySql.action";}// --------------------------------------- 华丽分割线 ------------------------------// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------/*********************************查询列表【不分页】***********************************************//*** 【不分页 => 查询列表 => 无条件】* @Title: listAll * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)@ResponseBodypublic String listAllJson(Address address, HttpServletRequest request, HttpServletResponse response){List<Address> listAll = addressService.listAll();JSONObject jsonObject = new JSONObject();jsonObject.put("list", listAll);jsonObject.put("obj", address);return jsonObject.toString();}/*** 【不分页=》查询列表=>有条件】* @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)@ResponseBodypublic String listByEntityJson(Address address, HttpServletRequest request, HttpServletResponse response){List<Address> listAll = addressService.listAllByEntity(address);JSONObject jsonObject = new JSONObject();jsonObject.put("list", listAll);jsonObject.put("obj", address);return jsonObject.toString();}/*** 【不分页=》查询列表=>有条件】* @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws*/@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)@ResponseBodypublic String listByMapJson(Address address,HttpServletRequest request, HttpServletResponse response){//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(address.getName())){params.put("name", address.getName());}if(!isEmpty(address.getPhone())){params.put("phone", address.getPhone());}if(!isEmpty(address.getArea())){params.put("area", address.getArea());}if(!isEmpty(address.getBm())){params.put("bm", address.getBm());}if(!isEmpty(address.getIsUse())){params.put("isUse", address.getIsUse());}List<Address> listAll = addressService.listByMap(params);JSONObject jsonObject = new JSONObject();jsonObject.put("list", listAll);jsonObject.put("obj", address);return jsonObject.toString();}/*** 分页查询 返回list json(通过对象)* * @param request* @param response* @return*/@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)@ResponseBodypublic String findByObjByEntityJson(Address address, HttpServletRequest request, HttpServletResponse response) {//分页查询Pager<Address> pagers = addressService.findByEntity(address);JSONObject jsonObject = new JSONObject();jsonObject.put("pagers", pagers);jsonObject.put("obj", address);return jsonObject.toString();}/*** 分页查询 返回list json(通过Map)* * @param request* @param response* @return*/@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)@ResponseBodypublic String findByMapJson(Address address,HttpServletRequest request, HttpServletResponse response) {//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(address.getName())){params.put("name", address.getName());}if(!isEmpty(address.getPhone())){params.put("phone", address.getPhone());}if(!isEmpty(address.getArea())){params.put("area", address.getArea());}if(!isEmpty(address.getBm())){params.put("bm", address.getBm());}if(!isEmpty(address.getIsUse())){params.put("isUse", address.getIsUse());}//分页查询Pager<Address> pagers = addressService.findByMap(params);JSONObject jsonObject = new JSONObject();jsonObject.put("pagers", pagers);jsonObject.put("obj", address);return jsonObject.toString();}/*** ajax 添加* @param * @return*/@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)@ResponseBodypublic String exAddJson(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {addressService.insert(address);JSONObject jsonObject = new JSONObject();jsonObject.put("message", "添加成功");return jsonObject.toString();}/*** ajax 修改* @param * @return*/@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)@ResponseBodypublic String exUpdateJson(Address address, Model model, HttpServletRequest request, HttpServletResponse response) {//1.通过实体类修改，可以多传修改条件addressService.updateById(address);//2.通过主键id修改//addressService.updateById(address);JSONObject jsonObject = new JSONObject();jsonObject.put("message", "修改成功");return jsonObject.toString();}/*** ajax 删除* @return*/@RequestMapping(value = "/delete.json", method = RequestMethod.POST)@ResponseBodypublic String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {///1.通过主键删除addressService.deleteById(id);/*以下是多种删除方式*/
// //2.通过实体条件删除
// addressService.deleteByEntity(address);
// //3.通过参数删除
// //通过map查询
// Map<String,Object> params = new HashMap<String,Object>();
//
// if(!isEmpty(address.getName())){
// params.put("name", address.getName());
// }
//
// if(!isEmpty(address.getPhone())){
// params.put("phone", address.getPhone());
// }
//
// if(!isEmpty(address.getArea())){
// params.put("area", address.getArea());
// }
//
// if(!isEmpty(address.getBm())){
// params.put("bm", address.getBm());
// }
//
// if(!isEmpty(address.getIsUse())){
// params.put("isUse", address.getIsUse());
// }
//
// addressService.deleteByMap(params);
// //4.状态删除
// Address load = addressService.getById(address.getId())
// load.setIsDelete(1);
// addressService.updateById(load);//5.状态删除//Address load = addressService.load(id);//load.setIsDelete(1);//addressService.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("开始"); String path = request.getSession().getServletContext().getRealPath("/upload"); String fileName = file.getOriginalFilename(); System.out.println(path); File targetFile = new File(path, fileName); if(!targetFile.exists()){ targetFile.mkdirs(); } //保存 try { file.transferTo(targetFile); } catch (Exception e) { e.printStackTrace(); } return ""; } /*** 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 "";}// --------------------------------------- 华丽分割线 ------------------------------}
管理端控制器
@Controller
@RequestMapping("/manage")
public class ManageController extends BaseController {/*** 依赖注入 start dao/service/===*/@Autowiredprivate ManageService manageService;// --------------------------------------- 华丽分割线 ------------------------------/*********************************查询列表【不分页】***********************************************//*** 【不分页 => 查询列表 => 无条件】* @Title: listAll * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listAll")public String listAll(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){List<Manage> listAll = manageService.listAll();model.addAttribute("list", listAll);return "manage/manage";}/*** 【不分页=》查询列表=>有条件】* @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listByEntity")public String listByEntity(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){List<Manage> listAll = manageService.listAllByEntity(manage);model.addAttribute("list", listAll);return "manage/manage";}/*** 【不分页=》查询列表=>有条件】* @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws*/@RequestMapping(value = "/listByMap")public String listByMap(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response){//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(manage.getUserName())){params.put("userName", manage.getUserName());}if(!isEmpty(manage.getPassWord())){params.put("passWord", manage.getPassWord());}if(!isEmpty(manage.getRealName())){params.put("realName", manage.getRealName());}List<Manage> listAll = manageService.listByMap(params);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.getUserName())){sql += " and userName like '%"+manage.getUserName()+"%'";}if(!isEmpty(manage.getPassWord())){sql += " and passWord like '%"+manage.getPassWord()+"%'";}if(!isEmpty(manage.getRealName())){sql += " and realName like '%"+manage.getRealName()+"%'";}sql += " ORDER BY ID DESC ";Pager<Manage> pagers = manageService.findBySqlRerturnEntity(sql);model.addAttribute("pagers", pagers);//存储查询条件model.addAttribute("obj", manage);return "manage/manage";}/*** 分页查询 返回list对象(通过Map)* * @param request* @param response* @return*/@RequestMapping(value = "/findByMap")public String findByMap(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(manage.getUserName())){params.put("userName", manage.getUserName());}if(!isEmpty(manage.getPassWord())){params.put("passWord", manage.getPassWord());}if(!isEmpty(manage.getRealName())){params.put("realName", manage.getRealName());}//分页查询Pager<Manage> pagers = manageService.findByMap(params);model.addAttribute("pagers", pagers);//存储查询条件model.addAttribute("obj", manage);return "manage/manage";}/**********************************【增删改】******************************************************//*** 跳至添加页面* @return*/@RequestMapping(value = "/add")public String add() {return "manage/add";}/*** 跳至详情页面* @return*/@RequestMapping(value = "/view")public String view(Integer id,Model model) {Manage obj = manageService.load(id);model.addAttribute("obj",obj);return "manage/view";}/*** 添加执行* @return*/@RequestMapping(value = "/exAdd")public String exAdd(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {manageService.insert(manage);return "redirect:/manage/findBySql.action";}/*** 跳至修改页面* @return*/@RequestMapping(value = "/update")public String update(Integer id,Model model) {Manage obj = manageService.load(id);model.addAttribute("obj",obj);return "manage/update";}/*** 添加修改* @return*/@RequestMapping(value = "/exUpdate")public String exUpdate(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {//1.通过实体类修改，可以多传修改条件manageService.updateById(manage);//2.通过主键id修改//manageService.updateById(manage);return "redirect:/manage/findBySql.action";}/*** 删除通过主键* @return*/@RequestMapping(value = "/delete")public String delete(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.getUserName())){
// params.put("userName", manage.getUserName());
// }
//
// if(!isEmpty(manage.getPassWord())){
// params.put("passWord", manage.getPassWord());
// }
//
// if(!isEmpty(manage.getRealName())){
// params.put("realName", manage.getRealName());
// }
//
// 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.update(load);return "redirect:/manage/findBySql.action";}// --------------------------------------- 华丽分割线 ------------------------------// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------/*********************************查询列表【不分页】***********************************************//*** 【不分页 => 查询列表 => 无条件】* @Title: listAll * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)@ResponseBodypublic String listAllJson(Manage manage, HttpServletRequest request, HttpServletResponse response){List<Manage> listAll = manageService.listAll();JSONObject jsonObject = new JSONObject();jsonObject.put("list", listAll);jsonObject.put("obj", manage);return jsonObject.toString();}/*** 【不分页=》查询列表=>有条件】* @Title: listByEntity * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author* @return String 返回类型 * @throws*/@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)@ResponseBodypublic String listByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response){List<Manage> listAll = manageService.listAllByEntity(manage);JSONObject jsonObject = new JSONObject();jsonObject.put("list", listAll);jsonObject.put("obj", manage);return jsonObject.toString();}/*** 【不分页=》查询列表=>有条件】* @Title: listByMap * @Description: TODO(这里用一句话描述这个方法的作用) * @param @return 设定文件 * @author * @return String 返回类型 * @throws*/@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)@ResponseBodypublic String listByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response){//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(manage.getUserName())){params.put("userName", manage.getUserName());}if(!isEmpty(manage.getPassWord())){params.put("passWord", manage.getPassWord());}if(!isEmpty(manage.getRealName())){params.put("realName", manage.getRealName());}List<Manage> listAll = manageService.listByMap(params);JSONObject jsonObject = new JSONObject();jsonObject.put("list", listAll);jsonObject.put("obj", manage);return jsonObject.toString();}/*** 分页查询 返回list json(通过对象)* * @param request* @param response* @return*/@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)@ResponseBodypublic String findByObjByEntityJson(Manage manage, HttpServletRequest request, HttpServletResponse response) {//分页查询Pager<Manage> pagers = manageService.findByEntity(manage);JSONObject jsonObject = new JSONObject();jsonObject.put("pagers", pagers);jsonObject.put("obj", manage);return jsonObject.toString();}/*** 分页查询 返回list json(通过Map)* * @param request* @param response* @return*/@RequestMapping(value = "/findByMapJson", method = RequestMethod.POST)@ResponseBodypublic String findByMapJson(Manage manage,HttpServletRequest request, HttpServletResponse response) {//通过map查询Map<String,Object> params = new HashMap<String,Object>();if(!isEmpty(manage.getUserName())){params.put("userName", manage.getUserName());}if(!isEmpty(manage.getPassWord())){params.put("passWord", manage.getPassWord());}if(!isEmpty(manage.getRealName())){params.put("realName", manage.getRealName());}//分页查询Pager<Manage> pagers = manageService.findByMap(params);JSONObject jsonObject = new JSONObject();jsonObject.put("pagers", pagers);jsonObject.put("obj", manage);return jsonObject.toString();}/*** ajax 添加* @param * @return*/@RequestMapping(value = "/exAddJson", method = RequestMethod.POST)@ResponseBodypublic String exAddJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {manageService.insert(manage);JSONObject jsonObject = new JSONObject();jsonObject.put("message", "添加成功");return jsonObject.toString();}/*** ajax 修改* @param * @return*/@RequestMapping(value = "/exUpdate.json", method = RequestMethod.POST)@ResponseBodypublic String exUpdateJson(Manage manage, Model model, HttpServletRequest request, HttpServletResponse response) {//1.通过实体类修改，可以多传修改条件manageService.updateById(manage);//2.通过主键id修改//manageService.updateById(manage);JSONObject jsonObject = new JSONObject();jsonObject.put("message", "修改成功");return jsonObject.toString();}/*** ajax 删除* @return*/@RequestMapping(value = "/delete.json", method = RequestMethod.POST)@ResponseBodypublic 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.getUserName())){
// params.put("userName", manage.getUserName());
// }
//
// if(!isEmpty(manage.getPassWord())){
// params.put("passWord", manage.getPassWord());
// }
//
// if(!isEmpty(manage.getRealName())){
// params.put("realName", manage.getRealName());
// }
//
// 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("开始"); String path = request.getSession().getServletContext().getRealPath("/upload"); String fileName = file.getOriginalFilename(); System.out.println(path); File targetFile = new File(path, fileName); if(!targetFile.exists()){ targetFile.mkdirs(); } //保存 try { file.transferTo(targetFile); } catch (Exception e) { e.printStackTrace(); } return ""; } /*** 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 "";}// --------------------------------------- 华丽分割线 ------------------------------}如果也想学习本系统，下面领取。关注并回复：132ssm
