mybatis-plus in work

通用curd：定义好mapper接口后，只要继承BaseMapper<T>即可获得curd功能

条件构造器：通过EntityWrapper<T> ,用于拼接sql

@Tablename(value="tb_employee")

@TableId , @TableField

public interface EmployeeMapper extend BaseMapper<Employee>{}

public interface FireService extends Iservice<FireInfo>

public class FireServiceImpl extend ServiceImpl<FireMapper,FireInfo>  implement FireService 

可以在EmployeeMapper自定义mapper

delete(new EntityWrapper<>() );
insertBatch();
insert(areaCharging);

EntityWrapper<AreaCharging> entityCommunityWrapper = new EntityWrapper<>();
entityWrapper.setSqlSelect("  sum(Replace(remark,'辆','')) as chargingPortNumber ,count(id) as chargingPileNumber ");

entityGridWrapper.le("charging_port_number/house_number",0.375);
entityWrapper.in("risk_level",riskLevelList);
entityCommunityWrapper.eq("LEVEL",5);
entityCommunityWrapper.orderBy("charging_port_number/house_number");
wrapper.like("last_name","张");

ge大于，le小于
groupby

AreaCharging gridAreaCommunityCharging = selectOne(entityCommunityWrapper);
chargingPileService.selectMap(entityWrapper)
List<AreaCharging> communityRiskLevelList = selectList(entityCommunityWrapper);

employeeMapper.selectById(1);

Page<AreaCharging> page = new Page<>(gridPage​,gridSize);
Page<AreaCharging> gridRiskLevelList = selectPage(page,entityGridWrapper);

    @Select(" select ec.name as productWeight,ec.contact_info as contactInfo,ec.corporate,oct.company_id as companyId,sum(oct.product_weight*oct.car_number) as totalWeight " +
            " from order_carrier_total oct " +
            " left join exp_company ec on ec.id = oct.company_id " +
            " where oct.order_product_type = #{orderProductType} " +
            " group by oct.company_id " +
            " HAVING  totalWeight >= #{totalWeight} " +
            " order by totalWeight desc,ec.name ")
    List<OrderCarrierTotal> matchingOptimalCarriers(@Param("totalWeight") String totalWeight,@Param("orderProductType") Integer orderProductType);

@Mapper
public interface BafcBuildingRiskLevelMapper extends BaseMapper<BafcBuildingRiskLevel> {

}

public interface BafcBuildingRiskLevelService extends IService<BafcBuildingRiskLevel> {
    //定时处理bafc_building_risk_level表
    Boolean sheducleDealBuildingRiskLevel();
    Map<String,Integer>  getBuildingRiskLevel();
    List<BafcBuildingRiskLevel> getHighRiskBuild();

    void testSchedule();
}

@Slf4j
@Service
public class BafcBuildingRiskLevelServiceImpl  extends ServiceImpl<BafcBuildingRiskLevelMapper, BafcBuildingRiskLevel> implements BafcBuildingRiskLevelService {