springDateJPA的sql的query查询

/**

* 根据供应商类型查询供应商()

* @param houseId

* @param stopFlag

* @param opFlag

* @return

*/

@Query(“select v1 from VendorDict v1 where v1.vendorType=2 or v1.vendorType=3”)

//@Query(value =“select * FROM vendor_dict where vendor_type=2 OR vendor_type=3;”, nativeQuery=true)

List<VendorDict> findVendorByVendorType();

查询语句与之前的不太一样，此处的是面向对象的，where后跟的也是字段属性

@Query(value =“select vendor_code from vendor_dict”, nativeQuery=true)

List<String> findAllCstCode();

此处的查询是mysql的查询，nativeQuery=true既是启用本地数据库查询

查询

@Transactional

@Modifying

@Query(“update OrthopaedicOrder o set o.status=?1 where o.id=?2”)

//@Query(value =“update cst_orthopaedics_order set status=?1 where id=?2”, nativeQuery=true)

int cancelOrder(int status,Long id);

以下写的会报错因为用了order关键字

@Query(“update OrthopaedicOrder order set order.status=?1 where order.id=?2”)

unexpected token: order near line 1, column 43 [update cn.rivamed.entity.OrthopaedicOrder order set order.status=2

where order.id=?1]