Is there a way to make a Java method that maps an SQL result list to an entity class generic?

I have this method that executes a native SQL query successfully. No issues. It maps the result list from the query to the relevant entity class:

@Data
public class DemoManager {

  Transaction transaction;
  static Session session;
  Query query;
  DemoEntity demoResultList;


  String url = "...";
  String username = "...";
  String password = "...";
  Class<DemoEntity> demoEntity = DemoEntity.class;


  public void executiveQuery(String sql) {
    session = Base.getSessionFactory(url, username, password, demoEntity).openSession();
    transaction = session.beginTransaction();
    query = session.createNativeQuery(sql, demoEntity);
    demoResultList = (DemoEntity) query.getResultList().get(0);
    session.close();
  }

Now, the problem. I want to make the executeQuery() method generic, so that when it is called, any entity class can be passed as an argument, instead of creating a new method whenever there is a new entity. To try achieve that, I tried this:

...

public static Class<T>  resultList;
Class<T> entity;

...

public <T> void executiveQuery(String sql, Class<T> entity) {
    session = Base.getSessionFactory(url, username, password, entity).openSession();
    transaction = session.beginTransaction();
    query = session.createNativeQuery(sql, entity);
    resultList = (entity) query.getResultList().get(0); // the entity on this line could not be compiled
    session.close();
  }

I couldn't get that method to compile. How do I make the executiveQuery() generic to accept any entity class so that I can get my database column returned in returnList like this:

public String getTestColmn() {
return resultList.getTestId();

}

And then call executeQuery() and pass any entity class to it, perhaps something like this:

public void callExecuteQuery(String sql, Class<T> entity) {
    demoManager.executeQuery(sql, DemoEntity.class);
  }

What am I doing wrong?

To make a method generic you need the class to be generic as well

public class DemoManager<T> {

 T resultList;

 @SuppressWarnings("unchecked")
 public void executiveQuery(String sql) {
    ...
    resultList = (T) query.getResultList().get(0);
    ...
 }
}

...

// And you need to change the creation of the `DemoManager`
DemoManager<DemoEntity> demoManager = new DemoManager<>(...);
demoManager.executiveQuery(sql);
String testColumn = demoManager.getResultList().getTestColmn();

Noting that if there is a type mismatch during the casting it will throw an error at runtime.

Another option is to have the executeQuery as static and get the session and the generic class as parameters

public class DemoManager {

 @SuppressWarnings("unchecked")
 public <T> static T executiveQuery(Session session, String sql, Class<T> entity) {
    transaction = session.beginTransaction();
    query = session.createNativeQuery(sql, demoEntity);
    return (entity) query.getResultList().get(0);
 }
}

...

Session session = ...;
DemoEntity entity = DemoManager.executiveQuery(session, sql, DemoEntity.class);
String testColumn = entity.getTestColumn();