使用方法Condition condition = new Condition(实体类.class),适用于单表操作
andEqualTo相当于 api_id = '127.0.0.1'
andEqualTo(apiId("api_id"写成驼峰形式),传入的值)
Condition condition = new Condition(BizApiRelational.class);
condition.createCriteria().andEqualTo("apiId", bizApiConfig.getId()).andEqualTo("domainId", check.getId());
List<BizApiRelational> relationals = bizApiRelationalService.findByCondition(condition);
andLike相当于 parent_ids like '%94b381b43c5b4adca0b9c8085b8e85dd1%'
Condition condition = new Condition(CmsHoliday.class);
condition.createCriteria().andLike("parentIds","%"+id+"%");
cmsBeachMapper.updateByConditionSelective(cmsBeach,condition);
updateByConditionSelective(实体类,条件)
andNotEqualTo相当于 !=
new 一个新的实体类把需要修改的字段附上值
注意:updateByConditionSelective只会修改被赋值的字段,而updateByCondition会修改全部字段,未赋值的字段会被修改为null
Condition condition = new Condition(AppThemeConfiguration.class);
condition.createCriteria().andNotEqualTo("id",appThemeConfiguration.getId());
AppThemeConfiguration configuration = new AppThemeConfiguration();
configuration.setState("0");
appThemeConfigurationMapper.updateByConditionSelective(configuration,condition);