@Query(nativeQuery = true, value = "select * from refund r where r.order_no = ?1 AND r.refund_status between 1 and 2 ") List<Refund> findByOrderNo(String orderNo);
不一定,返回的数据要有能够和它对应的实体,实体的属性个数不能小于返回的数据库的字段个数!