import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
private void initRequiresTransaction(RepositoryMethodMetadata repositoryMethodMetadata)
{
    boolean requiresTransaction = false;
    
    if (ClassUtils.containsMethod(EntityRepositoryHandler.class, repositoryMethodMetadata.getMethod()))
    {
        Method originalMethod = ClassUtils.extractMethod(EntityRepositoryHandler.class,
                repositoryMethodMetadata.getMethod());
        if (originalMethod.isAnnotationPresent(RequiresTransaction.class))
        {
            requiresTransaction = true;
        }
    }

    Query query = repositoryMethodMetadata.getQuery();
    Modifying modifying = repositoryMethodMetadata.getModifying();
    
    if ((query != null && !query.lock().equals(LockModeType.NONE)) || modifying != null)
    {
        requiresTransaction = true;
    }
    
    repositoryMethodMetadata.setRequiresTransaction(requiresTransaction);
}
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("SELECT SUM(c.price) FROM Car c WHERE upper(c.model) like :model")
Double getTotalPriceByModel(@QueryParam("model") String model);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("SELECT m FROM Message m ORDER BY m.timestamp DESC")
List<Message> findAllOrdered();
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("SELECT d FROM Depositor d WHERE d.name=:name")
List<Depositor> findByName(@QueryParam("name") String name);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select BPM from BpMain BPM where BPM.id IN (select BPM.id from BPM.bpRoleses bpr where bpr.roleCode.id= ?1)")
List<BpMain> findAllCustomer(int role);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query(named = "delete.all")
@Modifying
void deleteAll();
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select e from MyEntity e")
List<MyEntity> loadAll();
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query(value = "select e from MyEntity e where e.courseName = ?1", singleResult = OPTIONAL)
MyEntity findByCourse(@NotNull String courseName);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query(value = "select e from AnotherEntity e where e.courseName = ?1", singleResult = OPTIONAL)
AnotherEntity find(@NotNull String courseName);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select e from AnotherEntity e where e.courseName = ?1")
AnotherEntity findOptional(@NotNull String courseName);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query(named = "delete.all")
@Modifying
abstract void deleteAll();
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select e from MyEntity e")
abstract List<MyEntity> loadAll();
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query(value = "select e from MyEntity e where e.courseName = ?1", singleResult = OPTIONAL)
abstract MyEntity findByCourse(@NotNull String courseName);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query(value = "select e from AnotherEntity e where e.courseName = ?1", singleResult = OPTIONAL)
abstract AnotherEntity find(@NotNull String courseName);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select e from AnotherEntity e where e.courseName = ?1")
abstract AnotherEntity findOptional(@NotNull String courseName);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query(value = "select c from Course c left outer join fetch c.enrollmentList where c.courseId = :courseId",
        singleResult = SingleResultType.OPTIONAL)
public Course findCourse(@QueryParam("courseId") int courseId);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select c from Course c left outer join fetch c.enrollmentList order by c.courseId desc")
public List<Course> listAllCourses();
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select e from Enrollment e where e.course = :course")
public List<Enrollment> findByCourse(Course course);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("select e from Employees e where lastName like :name")
public List<Employees> findByname(@QueryParam("name") String name);
 

import org.apache.deltaspike.data.api.Query; //导入依赖的package包/类
@Query("SELECT p FROM Person p where age = ?1")
List<Person> findAllByAge(Integer age);