spring data jpa 利用@Query进行查询
原生SQL查询
@Query(value = "select * from licence_record where machine_code =?1 and is_void=0" ,nativeQuery = true ) LicenceRecord findLicenceRecordByMachineCode(String machineCode); //nativeQuery = true 为true就是开启原生SQL。
原生SQL查询
@Query(value = "select * from licence_record where machine_code =?1 and is_void=0" ,nativeQuery = true ) LicenceRecord findLicenceRecordByMachineCode(String machineCode); //nativeQuery = true 为true就是开启原生SQL。