基于javaweb和mysql的ssm家具商城系统(java+ssm+jsp+bootstrap+echarts+mysql)

私信源码获取及调试交流

私信源码获取及调试交流

运行环境

Java≥8、MySQL≥5.7、Tomcat≥8

开发工具

eclipse/idea/myeclipse/sts等均可配置运行

适用

课程设计，大作业，毕业设计，项目练习，学习演示等

功能说明

基于javaweb的SSM家具商城系统(java+ssm+jsp+bootstrap+echarts+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项目：是；

技术栈

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

		return "message/message";
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByEntity 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByEntity")
	public String listByEntity(Message message, Model model, HttpServletRequest request, HttpServletResponse response){
		List<Message> listAll = messageService.listAllByEntity(message);
		model.addAttribute("list", listAll);
		return "message/message";
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByMap 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByMap")
	public String listByMap(Message message, Model model, HttpServletRequest request, HttpServletResponse response){
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
	        if(!isEmpty(message.getName())){
	        	params.put("name", message.getName());
			}
	        if(!isEmpty(message.getPhone())){
	        	params.put("phone", message.getPhone());
			}
	        if(!isEmpty(message.getContent())){
	        	params.put("content", message.getContent());

		Pager<OrderDetail> pagers = orderDetailService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", orderDetail);
		return "orderDetail/ulist";
	}
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(orderDetail.getItemId())){
        	params.put("itemId", orderDetail.getItemId());
		}
        if(!isEmpty(orderDetail.getOrderId())){
        	params.put("orderId", orderDetail.getOrderId());
		}
        if(!isEmpty(orderDetail.getStatus())){
        	params.put("status", orderDetail.getStatus());
		}
		//分页查询
		Pager<OrderDetail> pagers = orderDetailService.findByMap(params);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", orderDetail);
		return "orderDetail/orderDetail";
	}
	
	/**********************************【增删改】******************************************************/
	
	/**
	 * 跳至添加页面
	 * @return
	 */
	@RequestMapping(value = "/add")
	public String add() {

@Controller
@RequestMapping("/login")
public class LoginController  extends BaseController{
	
	@Autowired
	private ManageService manageService;
	
	@Autowired
	private UserService userService;
	
	@Autowired
	private ItemOrderService itemOrderService;
	
	@Autowired

        	sql += " and userId like '%"+comment.getUserId()+"%'";
		}
        if(!isEmpty(comment.getItemId())){
        	sql += " and itemId like '%"+comment.getItemId()+"%'";
		}
        if(!isEmpty(comment.getContent())){
        	sql += " and content like '%"+comment.getContent()+"%'";
		}
        if(!isEmpty(comment.getAddTime())){
        	sql += " and addTime like '%"+comment.getAddTime()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Comment> pagers = commentService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", comment);
		return "comment/comment";
	}
	
	
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByMap")
	public String findByMap(Comment comment, Model model, HttpServletRequest request, HttpServletResponse response) {
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
        if(!isEmpty(comment.getUserId())){
        	params.put("userId", comment.getUserId());
		}
        if(!isEmpty(comment.getItemId())){
        	params.put("itemId", comment.getItemId());
		}
        if(!isEmpty(comment.getContent())){
        	params.put("content", comment.getContent());
		}
        if(!isEmpty(comment.getAddTime())){
        	params.put("addTime", comment.getAddTime());
		}
		//分页查询
		Pager<Comment> pagers = commentService.findByMap(params);
		model.addAttribute("pagers", pagers);

		//load.setIsDelete(1);
		//addressService.update(load);
		return "redirect:/address/findBySql.action";
	}
	
	// --------------------------------------- 华丽分割线 ------------------------------
	// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------

	/*********************************查询列表【不分页】***********************************************/
	
	/**
	 * 【不分页 => 查询列表 => 无条件】
	* @Title: listAll 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
	@ResponseBody
	public 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 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
	@ResponseBody
	public 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 设定文件 

	 */
    @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 "";
	}
 // --------------------------------------- 华丽分割线 ------------------------------
	
	
}

        if(!isEmpty(user.getUserName())){
        	params.put("userName", user.getUserName());
		}
        if(!isEmpty(user.getPassWord())){
        	params.put("passWord", user.getPassWord());
		}
        if(!isEmpty(user.getPhone())){
        	params.put("phone", user.getPhone());
		}
        if(!isEmpty(user.getRealName())){
        	params.put("realName", user.getRealName());
		}
        if(!isEmpty(user.getSex())){
        	params.put("sex", user.getSex());
		}
        if(!isEmpty(user.getAddress())){
        	params.put("address", user.getAddress());
		}
        if(!isEmpty(user.getEmail())){
        	params.put("email", user.getEmail());
		}
		//分页查询
		Pager<User> pagers = userService.findByMap(params);
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("pagers", pagers);
		jsonObject.put("obj", user);
		return jsonObject.toString();
	}
	
	
	/**
	 * 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();
	}
	

	
	/*********************************查询列表【不分页】***********************************************/
	
	/**
	 * 【不分页 => 查询列表 => 无条件】
	* @Title: listAll 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listAll")
	public String listAll(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response){
		List<ItemCategory> listAll = itemCategoryService.listAll();
		model.addAttribute("list", listAll);
		return "itemCategory/itemCategory";
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByEntity 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByEntity")
	public String listByEntity(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response){
		List<ItemCategory> listAll = itemCategoryService.listAllByEntity(itemCategory);
		model.addAttribute("list", listAll);
		return "itemCategory/itemCategory";
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByMap 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByMap")
	public String listByMap(ItemCategory itemCategory, Model model, HttpServletRequest request, HttpServletResponse response){

	// --------------------------------------- 华丽分割线 ------------------------------
	// --------------------------------------- 【下面是ajax操作的方法。】 ------------------------------

	/*********************************查询列表【不分页】***********************************************/
	
	/**
	 * 【不分页 => 查询列表 => 无条件】
	* @Title: listAll 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listAllJson", method = RequestMethod.POST)
	@ResponseBody
	public String listAllJson(User user, HttpServletRequest request, HttpServletResponse response){
		List<User> listAll = userService.listAll();
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("list", listAll);
		jsonObject.put("obj", user);
		return jsonObject.toString();
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByEntity 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByEntityJson", method = RequestMethod.POST)
	@ResponseBody
	public String listByEntityJson(User user,  HttpServletRequest request, HttpServletResponse response){
		List<User> listAll = userService.listAllByEntity(user);
		JSONObject jsonObject = new JSONObject();
		jsonObject.put("list", listAll);
		jsonObject.put("obj", user);
		return jsonObject.toString();
	}
	
	/**
	 *  【不分页=》查询列表=>有条件】

	    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())){

	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByObj")
	public String findByObj(Sc sc, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		Pager<Sc> pagers = scService.findByEntity(sc);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", sc);
		return "sc/sc";
	}
	
	/**
	 * 分页查询 返回list对象(通过对By Sql)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findBySql")
	public String findBySql(Sc sc, 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 sc WHERE 1=1 and user_id="+userId;
        if(!isEmpty(sc.getItemId())){
        	sql += " and itemId like '%"+sc.getItemId()+"%'";
		}
        if(!isEmpty(sc.getUserId())){
        	sql += " and userId like '%"+sc.getUserId()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Sc> pagers = scService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", sc);
		return "sc/my";
	}
	

		    	}
			}
	    	 
		item.setGmNum(0);
		item.setIsDelete(0);
		item.setScNum(0);
		ItemCategory byId = itemCategoryService.getById(item.getCategoryIdTwo());
		item.setCategoryIdOne(byId.getPid());
		itemService.insert(item);
		return "redirect:/item/findBySql.action";
	}
	/**
	 * 跳至修改页面
	 * @return
	 */
	@RequestMapping(value = "/update")
	public String update(Integer id,Model model) {
		Item obj = itemService.load(id);
		String sql = "SELECT * FROM item_category WHERE isDelete = 0 and pid is not null";
		List<ItemCategory> listBySqlReturnEntity = itemCategoryService.listBySqlReturnEntity(sql);
		model.addAttribute("types",listBySqlReturnEntity);
		model.addAttribute("obj",obj);
		return "item/update";
	}
	
	/**
	 * 添加修改
	 * @return
	 * @throws IOException 
	 * @throws IllegalStateException 
	 */
	@RequestMapping(value = "/exUpdate")
	public String exUpdate(Item item, Model model, @RequestParam("file") CommonsMultipartFile[] files, HttpServletRequest request, HttpServletResponse response) throws IllegalStateException, IOException {
		//1.通过实体类修改，可以多传修改条件
		ItemCategory byId = itemCategoryService.getById(item.getCategoryIdTwo());
		item.setCategoryIdOne(byId.getPid());
		
		if (files.length > 0){
			 // 0 1 2 3 4
			for (int s = 0;s < files.length;s++){
				 System.out.println("开始");  
		          long  startTime=System.currentTimeMillis();
		          System.out.println("fileName："+files[s].getOriginalFilename());
		          String n = UUIDUtils.create();
		          String path="D:/my/upload/"+n+files[s].getOriginalFilename();
		          System.out.println("===================================================");
		           System.out.println(path);
		          File newFile=new File(path);
		          //通过CommonsMultipartFile的方法直接写文件（注意这个时候）
		          files[s].transferTo(newFile);
		          long  endTime=System.currentTimeMillis();
		          System.out.println("方法二的运行时间："+String.valueOf(endTime-startTime)+"ms");
		         System.out.println("*********************************************************");

	/**
	 *  【不分页=》查询列表=>有条件】
	* @Title: listByMap 
	* @Description: TODO(这里用一句话描述这个方法的作用) 
	* @param @return 设定文件 
	* @return String 返回类型 
	* @throws
	 */
	@RequestMapping(value = "/listByMapJson", method = RequestMethod.POST)
	@ResponseBody
	public String listByMapJson(Car car,HttpServletRequest request, HttpServletResponse response){
		//通过map查询
		Map<String,Object> params = new HashMap<String,Object>();
	        if(!isEmpty(car.getItemId())){
	        	params.put("itemId", car.getItemId());
			}
	        if(!isEmpty(car.getUserId())){
	        	params.put("userId", car.getUserId());
			}
	        if(!isEmpty(car.getNum())){
	        	params.put("num", car.getNum());
			}
	        if(!isEmpty(car.getTotal())){
	        	params.put("total", car.getTotal());
			}
	    List<Car> listAll = carService.listByMap(params);
	    JSONObject jsonObject = new JSONObject();
		jsonObject.put("list", listAll);
		jsonObject.put("obj", car);
		return jsonObject.toString();
	}
	
	
	/**
	 * 分页查询 返回list json(通过对象)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByObjJson", method = RequestMethod.POST)
	@ResponseBody
	public String findByObjByEntityJson(Car car, HttpServletRequest request, HttpServletResponse response) {

	@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";
	}

		//存储查询条件
		model.addAttribute("obj", sc);
		return "sc/sc";
	}
	
	/**
	 * 分页查询 返回list对象(通过对By Sql)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findBySql")
	public String findBySql(Sc sc, 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 sc WHERE 1=1 and user_id="+userId;
        if(!isEmpty(sc.getItemId())){
        	sql += " and itemId like '%"+sc.getItemId()+"%'";
		}
        if(!isEmpty(sc.getUserId())){
        	sql += " and userId like '%"+sc.getUserId()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<Sc> pagers = scService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", sc);
		return "sc/my";
	}
	
	
	/**
	 * 分页查询 返回list对象(通过Map)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */

	@ResponseBody
	public String exDeleteJson(Integer id, Model model, HttpServletRequest request, HttpServletResponse response) {
		///1.通过主键删除
		messageService.deleteById(id);
		/*以下是多种删除方式*/
//		//2.通过实体条件删除
//		messageService.deleteByEntity(message);
//		//3.通过参数删除
//        //通过map查询
//		Map<String,Object> params = new HashMap<String,Object>();
//		
//        if(!isEmpty(message.getName())){
//        	params.put("name", message.getName());
//		}
//       
//        if(!isEmpty(message.getPhone())){
//        	params.put("phone", message.getPhone());
//		}
//       
//        if(!isEmpty(message.getContent())){
//        	params.put("content", message.getContent());
//		}
//       
//		messageService.deleteByMap(params);
//		//4.状态删除
//		Message load = messageService.getById(message.getId())
//		load.setIsDelete(1);
//		messageService.update(load);
		//5.状态删除
		//Message load = messageService.load(id);
		//load.setIsDelete(1);
		//messageService.update(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);  

//     //通过map查询
//		Map<String,Object> params = new HashMap<String,Object>();
//		
//        if(!isEmpty(itemOrder.getItemId())){
//        	params.put("itemId", itemOrder.getItemId());
//		}
//       
//        if(!isEmpty(itemOrder.getUserId())){
//        	params.put("userId", itemOrder.getUserId());
//		}
//       
//        if(!isEmpty(itemOrder.getCode())){
//        	params.put("code", itemOrder.getCode());
//		}
//       
//        if(!isEmpty(itemOrder.getAddTime())){
//        	params.put("addTime", itemOrder.getAddTime());
//		}
//       
//        if(!isEmpty(itemOrder.getTotal())){
//        	params.put("total", itemOrder.getTotal());
//		}
//       
//        if(!isEmpty(itemOrder.getIsDelete())){
//        	params.put("isDelete", itemOrder.getIsDelete());
//		}
//       
//        if(!isEmpty(itemOrder.getStatus())){
//        	params.put("status", itemOrder.getStatus());
//		}
//       
//		itemOrderService.deleteByMap(params);
//		//4.状态删除
//		ItemOrder load = itemOrderService.getById(itemOrder.getId())
//		load.setIsDelete(1);
//		itemOrderService.update(load);
		//5.状态删除
		//ItemOrder load = itemOrderService.load(id);
		//load.setIsDelete(1);
		//itemOrderService.update(load);
		return "redirect:/itemOrder/findBySql.action";

	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findByObj")
	public String findByObj(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		Pager<OrderDetail> pagers = orderDetailService.findByEntity(orderDetail);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", orderDetail);
		return "orderDetail/orderDetail";
	}
	
	/**
	 * 分页查询 返回list对象(通过对By Sql)
	 * 
	 * @param request
	 * @param response
	 * @return
	 */
	@RequestMapping(value = "/findBySql")
	public String findBySql(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询
		String sql = "SELECT * FROM orderDetail WHERE 1=1 ";
        if(!isEmpty(orderDetail.getItemId())){
        	sql += " and itemId like '%"+orderDetail.getItemId()+"%'";
		}
        if(!isEmpty(orderDetail.getOrderId())){
        	sql += " and orderId like '%"+orderDetail.getOrderId()+"%'";
		}
        if(!isEmpty(orderDetail.getStatus())){
        	sql += " and status like '%"+orderDetail.getStatus()+"%'";
		}
       sql += " ORDER BY ID DESC ";
		Pager<OrderDetail> pagers = orderDetailService.findBySqlRerturnEntity(sql);
		model.addAttribute("pagers", pagers);
		//存储查询条件
		model.addAttribute("obj", orderDetail);
		return "orderDetail/orderDetail";
	}
	
	
	@RequestMapping(value = "/ulist")
	public String ulist(OrderDetail orderDetail, Model model, HttpServletRequest request, HttpServletResponse response) {
		//分页查询