java 增删查改

产品表:

 包含了一些对elasticsearch的操作。

pojo:

//产品类
public class Product {

    private Integer id;

    private String productName;

    private Integer productType;

    private String productDesc;

    private String productCompany;

    private String productVersion;

    private String childrenProductType;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getProductName() {
        return productName;
    }


    public void setProductName(String productName) {
        this.productName = productName == null ? null : productName.trim();
    }


    public Integer getProductType() {
        return productType;
    }

    public void setProductType(Integer productType) {
        this.productType = productType;
    }

    public String getProductDesc() {
        return productDesc;
    }

    public void setProductDesc(String productDesc) {
        this.productDesc = productDesc == null ? null : productDesc.trim();
    }


    public String getProductCompany() {
        return productCompany;
    }


    public void setProductCompany(String productCompany) {
        this.productCompany = productCompany == null ? null : productCompany.trim();
    }


    public String getProductVersion() {
        return productVersion;
    }


    public void setProductVersion(String productVersion) {
        this.productVersion = productVersion == null ? null : productVersion.trim();
    }


    public String getChildrenProductType() {
        return childrenProductType;
    }

    public void setChildrenProductType(String childrenProductType) {
        this.childrenProductType = childrenProductType == null ? null : childrenProductType.trim();
    }
}

ProductController:

/**
	 * 
	 * <p>Title: getList</p>  
	 * <p>Description:分页关键字模糊查询 </p>  
	 * @author duwb  
	 * @param query
	 * @return
	 */
	@RequestMapping(value="/getList",method=RequestMethod.POST)
	public Result getList(@RequestBody Query query){
		return productService.getList(query);
	}
	
	
	/**
	 * 
	 * <p>Title: addOne</p>  
	 * <p>Description: 数据插入</p>  
	 * @author duwb  
	 * @param query
	 * @return
	 */
	@RequestMapping(value="/insert",method=RequestMethod.POST)
	public Result addOne(@RequestBody Product query) throws Exception{
		return productService.addOne(query);
	}
	
	
	/**
	 * 
	 * <p>Title: updateOne</p>  
	 * <p>Description: 更新数据</p>  
	 * @author duwb  
	 * @param query
	 * @return
	 */
	@RequestMapping(value="/update",method=RequestMethod.POST)
	public Result updateOne(@RequestBody Product query) throws Exception{
		return productService.updateOne(query);
	}
	
	
	/**
	 * 
	 * <p>Title: delMore</p>  
	 * <p>Description: 批量删除信息</p>  
	 * @author duwb  
	 * @param ids
	 * @return
	 */
	@RequestMapping(value="/deleteMore",method=RequestMethod.POST)
	public Result delMore(@RequestBody List<Integer> ids){
		return productService.delMore(ids);
	}

 productService:

	/**
	 * 
	 * <p>Title: getList</p>  
	 * <p>Description: 分页查询</p>  
	 * @author duwb  
	 * @param query
	 * @return
	 */
	@Syslog(desc = "分页查询",level = 1L,model = "产品服务")
	public Result getList( Query query){
		ProductExample example = new ProductExample();
		ProductExample.Criteria criteria = example.createCriteria();
		String searchText = query.get("searchText").toString();
		String selectType = query.get("selectType").toString();
        //搜索框
		if(!"".equals(searchText) && searchText != null){
			criteria.andProductNameLike("%"+searchText+"%");
		}
        //类型条件
		if(!"".equals(selectType) && selectType != null){
			criteria.andProductTypeEqualTo(Integer.parseInt(selectType));
		}
        //降序
		example.setOrderByClause("id desc");
		//Mybatis分页插件
PageHelper.startPage(Integer.parseInt(query.get("pageNo").toString()),Integer.parseInt(query.get("limit").toString()),true);
		List<Product> products = productMapper.selectByExample(example);
		if(products == null){
			return Result.error("分页查询失败!");
		}
        //如果需要获取总记录数的话,需要PageInfo类的对象 
		PageInfo<Product> pageInfo = new PageInfo<>(products);
		long total = pageInfo.getTotal();
		products = pageInfo.getList();
		List<ProductVo> productVos = new ArrayList<>();
		products.parallelStream().forEach(product -> {
			String productChildrenTypeName = null;
			//软件
			if(product.getProductType() == 1){
				productChildrenTypeName = dictionariesService.getNameByTableNameAndId("soft_type","name",product.getChildrenProductType());
			}
			//硬件
			else if(product.getProductType() == 2){
				productChildrenTypeName = dictionariesService.getNameByTableNameAndId("situation_dev_type","name",product.getChildrenProductType());
			}
			ProductVo vo = new ProductVo();
			vo.setProductChildrenTypeName(productChildrenTypeName);
			vo.setChildrenProductType(product.getChildrenProductType());
			vo.setId(product.getId());
			vo.setProductType(product.getProductType());
			vo.setProductCompany(product.getProductCompany());
			vo.setProductDesc(product.getProductDesc());
			vo.setProductName(product.getProductName());
			vo.setProductVersion(product.getProductVersion());
			productVos.add(vo);
		});
		return Result.ok("分页查询成功!").put("total",total).put("products",productVos);
	}

	

	/**
	 * 
	 * <p>Title: addOne</p>
	 * <p>Description: 新增</p>  
	 * @author duwb  
	 * @param product
	 * @return
	 */
	@Syslog(desc = "新增",level = 1L,model = "产品服务")
	@Transactional(rollbackFor=RuntimeException.class)
	public Result addOne(Product product){
		int num = productMapper.insertSelective(product);
		if(num<0){
			return Result.error("新增失败!");
		}
		//存储ES
		DicEsEntity esEntity = new DicEsEntity();
		esEntity.setTableName("product");
		esEntity.setDicId(product.getId());
		esEntity.setName(product.getProductName());
		esUtil.save(esEntity, Constants.DICINDEX, Constants.DICTYPE);

		return Result.ok("新增成功!");
	}
	

	/**
	 * 
	 * <p>Title: updateOne</p>
	 * <p>Description: 更新</p>  
	 * @author duwb  
	 * @param product
	 * @return
	 */
	@Syslog(desc = "更新",level = 1L,model = "产品服务")
	@Transactional(rollbackFor=RuntimeException.class)
	public Result updateOne(Product product){
		int num = productMapper.updateByPrimaryKeySelective(product);
		if(num<=0){
			return Result.error("更新失败!");
		}
		//存储ES
		DicEsEntity esEntity = new DicEsEntity();
		esEntity.setTableName("product");
		esEntity.setDicId(product.getId());
		esEntity.setName(product.getProductName());
		esUtil.update(esEntity, Constants.DICINDEX);
		
		return Result.ok("更新成功!");
	}
	
	
	/**
	 * 
	 * <p>Title: delMore</p>  
	 * <p>Description: 批量删除</p>  
	 * @author duwb  
	 * @param ids
	 * @return
	 */
	@Syslog(desc = "批量删除",level = 1L,model = "产品服务")
	@Transactional(rollbackFor=RuntimeException.class)
	public Result delMore(List<Integer> ids){
		ProductExample example = new ProductExample();
		ProductExample.Criteria criteria = example.createCriteria();
		criteria.andIdIn(ids);
	    int rows=productMapper.deleteByExample(example);

	    //删除ES
		esUtil.deleteByIds(ids,Constants.DICINDEX);
	    if (rows ==0) {
			return Result.error("批量删除失败!");
		}
	    
		return Result.ok("批量删除成功!");
	}