jpa查询方式

最新推荐文章于 2024-06-30 15:03:08 发布

jyblims

最新推荐文章于 2024-06-30 15:03:08 发布

阅读量250

点赞数

分类专栏： java 文章标签： jpa

本文链接：https://blog.csdn.net/jyblims/article/details/115579142

版权

java 专栏收录该内容

13 篇文章 0 订阅

订阅专栏

sql查询

@Query(value = "select * from base_preset where base_sensor_id = ?1 and preset_no in (?2)" ,nativeQuery = true)
	List<BasePreset> findBySensorIdAndPresetNo(Long sensorId, List<String> presetNos);

多条件无sql查询

@Autowired
private BaseDeptSensorRepository baseDeptSensorRepository;


String sensorIdstring = criteria.getSensorId().getEquals();
      List<BaseDeptSensor> sorList =  baseDeptSensorRepository.findAll(new Specification<BaseDeptSensor>(){
	@Override
	public Predicate toPredicate(Root<BaseDeptSensor> root, CriteriaQuery<?> query,
			CriteriaBuilder criteriaBuilder) {
		List<Predicate> predicates = new ArrayList<>();
		predicates.add(criteriaBuilder.notEqual(root.<Long>get("id"),baseSensorDTO.getId()));
		predicates.add(criteriaBuilder.equal(root.<String>get("sensorId"),sensorIdstring)); //sensorId为表中的对象字段
		predicates.add(root.<String>get("presetNo").in(presetNos)); // presetNo为表中对应的对象字段

		return criteriaBuilder.and(predicates.toArray(new Predicate[predicates.size()]));
	}
      });