品优购品牌管理

川长思鸟来 2022-02-03 04:49 1444阅读 0赞

#### 1.品牌查询所有 ####

> applicationContext-service.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:dubbo="http://code.alibabatech.com/schema/dubbo" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://code.alibabatech.com/schema/dubbo http://code.alibabatech.com/schema/dubbo/dubbo.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
            
    	
        <dubbo:protocol name="dubbo" port="20881"></dubbo:protocol>
        
    	<dubbo:application name="pinyougou-sellergoods-service"/>  
    	
        <dubbo:registry address="zookeeper://192.168.25.129:2181"/>
        
        <dubbo:annotation package="com.pinyougou.sellergoods.service.impl" />  
       
    </beans>

> WEB层-SpringMVC.xml

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:p="http://www.springframework.org/schema/p" xmlns:context="http://www.springframework.org/schema/context" xmlns:dubbo="http://code.alibabatech.com/schema/dubbo" xmlns:mvc="http://www.springframework.org/schema/mvc" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd http://code.alibabatech.com/schema/dubbo http://code.alibabatech.com/schema/dubbo/dubbo.xsd http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context.xsd">
        
        <context:property-placeholder location="classpath:config/application.properties" />
    	
    	<mvc:annotation-driven>
    	  <mvc:message-converters register-defaults="true">
    	  	
    	    <bean class="com.alibaba.fastjson.support.spring.FastJsonHttpMessageConverter">  
    	      <property name="supportedMediaTypes" value="application/json"/>
    	      <property name="features">
    	        <array>
    	          <value>WriteMapNullValue</value>
    	          <value>WriteDateUseDateFormat</value>
    	        </array>
    	      </property>
    	    </bean>
    	  </mvc:message-converters>  
    	</mvc:annotation-driven>
    
    	
    	<dubbo:application name="pinyougou-manager-web" />
    	<dubbo:registry address="zookeeper://192.168.25.129:2181"/>
    	<dubbo:annotation package="com.pinyougou.manager.controller" />  	
    </beans>

> 1.0 PageResult类

public class PageResult implements Serializable{ 
    	// 总记录数
    	private long total;
    	// 当前记录数
    	private List rows;
    }

> 1.1 接口编写

public interface BrandService { 
    	/** * 查询所有 * @return */
    	public List<TbBrand> findAll();
    	/** * 分页查询 * @param pageNum 当前第几页（页码） * @param pageSize 当前页的大小（记录数） * @return */
    	public PageResult findPage(int pageNum, int pageSize);
    }

> 1.2 接口实现类

@Service
    public class BrandServiceImpl implements BrandService { 
    	@Autowired
    	private TbBrandMapper brandMapper;
    	@Override
    	public List<TbBrand> findAll() { 
    		// 返回全部列表，无条件查询
    		return brandMapper.selectByExample(null);
    	}
    	@Override
    	public PageResult findPage(int pageNum, int pageSize) { 
    		/** * MyBatis分页插件 * 在前面写这一句话，会自动实现分页 * 后面该咋写咋写 */
    		PageHelper.startPage(pageNum, pageSize);
    		/** * 查询所有，返回MyBatis的分页对象 */
    		Page<TbBrand> pageBrands = (Page<TbBrand>) brandMapper.selectByExample(null);
    		
    		/** * 返回一个PageResult * getTotal() ： PageResult的总记录数 * getResult() ： PageResult的当前记录数 */
    		return new PageResult(pageBrands.getTotal(), pageBrands.getResult());
    	}
    }

> 1.3 控制层编写

@RestController
    @RequestMapping("/brand")
    public class BrandController { 
    	/** * 因为接口的实现类不在本工程下，所以要用Reference */
    	@Reference
    	private BrandService brandService;
    	@RequestMapping("/findAll")
    	public List<TbBrand> findAll() { 
    		return brandService.findAll();
    	}
    	@RequestMapping("/findPage")
    	public PageResult findPage(int page, int size) { // 通过get方式传入
    		return brandService.findPage(page, size);
    	}
    }

> 1.4 前台页面编写（bootstrap，angular）

<script type="text/javascript" src="../plugins/angularjs/pagination.js"></script>
    <link rel="stylesheet" href="../plugins/angularjs/pagination.css"/>
    
    <script type="text/javascript"> var app = angular.module("pinyougou", ['pagination']); app.controller("brandController", function($scope, $http){ $scope.findAll = function() { $http.get("../brand/findAll.do").success(function(response) { $scope.list = response; }); } // 分页控件配置 $scope.paginationConf = { currentPage:1,// 当前页 totalItems:10,// 总记录数 itemsPerPage:10,// 每页显示的记录数 perPageOptions:[10, 20, 30, 40, 50],// 分页选项 onChange: function() { $scope.reloadList(); } }; // 刷新列表 $scope.reloadList = function() { $scope.findPage($scope.paginationConf.currentPage, $scope.paginationConf.itemsPerPage); } // 分页 $scope.findPage = function(page, size) { $http.get("../brand/findPage.do?page="+page+"&size="+size).success(function(response) { $scope.list = response.rows;// 显示当前页数据 $scope.paginationConf.totalItems = response.total;// 总记录数 }); } } </script>
    <body class="hold-transition skin-red sidebar-mini" ng-app="pinyougou" ng-controller="brandController" >
    	<tbody>
        	<tr ng-repeat="entity in list">
            	<td><input type="checkbox" ></td>			                              
                <td>{
       {entity.id}}</td>
        		<td>{
       {entity.name}}</td>									     
                <td>{
       {entity.firstChar}}</td>		                                 
                <td class="text-center">                                           
                	<button type="button" class="btn bg-olive btn-xs" data-toggle="modal" data-target="#editModal">修改</button>                                           
        		</td>
            </tr>
        </tbody>
        
    	<tm-pagination conf="paginationConf"></tm-pagination>
    </body>

> 1.5 效果展示

![查询所有][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI1NDkwNw_size_35_color_ABCDEF_t_70]

#### 2.新增 ####

> 2.1 接口编写

public void add(TbBrand brand);

> 2.2 实现类编写

@Override
    	public void add(TbBrand brand) { 
    		brandMapper.insert(brand);
    	}

> 2.3 控制层

@RequestMapping("/add")
    public Result add(@RequestBody TbBrand brand) { // @RequestBody：通过Post方式向后台传实体类
    	try { 
    		brandService.add(brand);
    		return new Result(true, "新增成功");
    	} catch (Exception e) { 
    		// TODO Auto-generated catch block
    		e.printStackTrace();
    		return new Result(false, "新增失败");
    	}	
    }

> 2.4 Result类

public class Result implements Serializable{ 
    	// 是否成功
    	private boolean success;
    	// 返回信息
    	private String message;
    	...
    }

> 2.5 brand.html

// 新增
    $scope.save = function() {
    	var methodName = 'add';// 方法名
        if ($scope.entity.id!=null) {
        	methodName = "update";
        }
        $http.post('../brand/'+methodName+'.do', $scope.entity).success(function(response) {
        	if(response.success) {
       			$scope.reloadList();// 刷新列表
      		}else{
        		alert(response.message);
      		}
       	});
    }

#### 3.修改 ####

> 3.1 接口编写

/** * 通过ID查询实体 * @param id * @return */
    public TbBrand findOne(Long id);
    /** * 修改 * @param brand */
    public void update(TbBrand brand);

> 3.2 实现类编写

@Override
    public TbBrand findOne(Long id) { 
    	return brandMapper.selectByPrimaryKey(id);
    }
    @Override
    public void update(TbBrand brand) { 
    	brandMapper.updateByPrimaryKey(brand);
    }

> 3.3 控制层

@RequestMapping("/findOne")
    public TbBrand findOne(Long id) { 
    	return brandService.findOne(id);
    }
    @RequestMapping("/update")
    public Result update(@RequestBody TbBrand brand) { 
    	try { 
    		brandService.update(brand);
    		return new Result(true, "修改成功");
    	} catch (Exception e) { 
    		// TODO Auto-generated catch block
    		e.printStackTrace();
    		return new Result(false, "修改失败");
    	}
    }

> 3.4 brand.html

$scope.save = function() {
        var methodName = 'add';// 方法名
        if ($scope.entity.id!=null) {
        	methodName = "update";
        }
        $http.post('../brand/'+methodName+'.do', $scope.entity).success(function(response) {
        	if(response.success) {
        		$scope.reloadList();// 刷新列表
        	}else{
        		alert(response.message);
        	}
       	});
    }

#### 4.删除 ####

> 4.1 接口

public void delete(Long[] ids);

> 4.2 实现类

@Override
    public void delete(Long[] ids) { 
    	for (Long id : ids) { 
    		brandMapper.deleteByPrimaryKey(id);
    	}
    }

> 4.3 控制层

@RequestMapping("/delete")
    public Result delete(Long[] ids) { 
    	try { 
    		brandService.delete(ids);
    		return new Result(true, "删除成功");
    	} catch (Exception e) { 
    		// TODO Auto-generated catch block
    		e.printStackTrace();
    		return new Result(false, "删除失败");
    	}
    }

> 4.4 brand.html

$scope.dele = function() {
        $http.get('../brand/delete.do?ids='+$scope.selectIds).success(function(response) {
        	if(response.success) {
       			$scope.reloadList();
     		}else {
        		alert(response.message);
        	}
        });
    }

#### 5.条件查询 ####

> 5.1 接口

/** * 条件查询 * @param brand 传入的实体类 * @param pageNum 当前第几页（页码） * @param pageSize 当前页的大小（记录数） * @return */
    public PageResult findPage(TbBrand brand, int pageNum, int pageSize);

> 5.2 实现类

@Override
    public PageResult findPage(TbBrand brand, int pageNum, int pageSize) { 
    	// 分页插件 
    	PageHelper.startPage(pageNum, pageSize);
    	
    	TbBrandExample example = new TbBrandExample();
    	Criteria criteria = example.createCriteria();
    	
    	if(brand!=null) { // 如果输入了条件
    		if(brand.getName()!=null && brand.getName().length() > 0) { // 如果名称不为空
    			criteria.andNameLike("%"+brand.getName()+"%");// 根据名称模糊查询
    		}
    		if(brand.getFirstChar()!=null && brand.getFirstChar().length() > 0) { // 如果firstChar不为空
    			criteria.andFirstCharLike("%"+brand.getFirstChar()+"%");// 根据首字母查询
    		}
    	}
    	Page<TbBrand> pageBrands = (Page<TbBrand>) brandMapper.selectByExample(example );// 将根据条件查询到的结果封装到page(dubbo)里。
    	
    	return new PageResult(pageBrands.getTotal(), pageBrands.getResult());// 最后将PageResult返回
    }

> 5.3 控制层

@RequestMapping("/search")
    public PageResult search(@RequestBody TbBrand brand, int page, int size) { 
    	return brandService.findPage(brand, page, size);
    }

> 5.4 brand.html

$scope.searchEntity = {};
    // 模糊查询
    $scope.search = function(page, size) {
        $http.post("../brand/search.do?page="+page+"&size="+size, $scope.searchEntity).success(function(response) {
        	$scope.list = response.rows;// 显示当前页数据
        	$scope.paginationConf.totalItems = response.total;// 总记录数
        });
    }

> 5.5 结果展示

![结果展示][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI1NDkwNw_size_40_color_ABCDEF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI1NDkwNw_size_35_color_ABCDEF_t_70]: /images/20220203/473e54730cfc449e9b0f3c7eed62263f.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80MzI1NDkwNw_size_40_color_ABCDEF_t_70]: /images/20220203/8331ad1b831c4e968d3796aeaa8ee832.png