/** * Create a query using native SQL. * <p> * The native SQL can contain named parameters or positioned parameters. * </p> * <pre>{@code * * String sql = "select c.id, c.name from customer c where c.name like ? order by c.name"; * * Query<Customer> query = ebeanServer.findNative(Customer.class, sql); * query.setParameter(1, "Rob%"); * * List<Customer> customers = query.findList(); * * }</pre> * * @param beanType The type of entity bean to fetch * @param nativeSql The SQL that can contain named or positioned parameters * @return The query to set parameters and execute */ public static <T> Query<T> findNative(Class<T> beanType, String nativeSql) { return serverMgr.getDefaultServer().findNative(beanType, nativeSql); }
/** * Creates a native sql query. */ public Query<T> nativeSql(String nativeSql) { return db().findNative(type, nativeSql); }
/** * Creates a native sql query. */ protected Query<T> nativeSql(String nativeSql) { return db().findNative(type, nativeSql); }
/** * Create a query using native SQL. * <p> * The native SQL can contain named parameters or positioned parameters. * </p> * <pre>{@code * * String sql = "select c.id, c.name from customer c where c.name like ? order by c.name"; * * Query<Customer> query = ebeanServer.findNative(Customer.class, sql); * query.setParameter(1, "Rob%"); * * List<Customer> customers = query.findList(); * * }</pre> * * @param beanType The type of entity bean to fetch * @param nativeSql The SQL that can contain named or positioned parameters * @return The query to set parameters and execute */ public static <T> Query<T> findNative(Class<T> beanType, String nativeSql) { return serverMgr.getDefaultServer().findNative(beanType, nativeSql); }
/** * Creates a native sql query. */ protected Query<T> nativeSql(String nativeSql) { return db().findNative(type, nativeSql); }
@Override protected EbeanQueryWrapper createEbeanQuery(String queryString) { ResultProcessor resultFactory = getQueryMethod().getResultProcessor(); ReturnedType returnedType = resultFactory.getReturnedType(); return EbeanQueryWrapper.ofEbeanQuery(getEbeanServer().findNative(returnedType.getReturnedType(), queryString)); } }
@Override protected EbeanQueryWrapper createEbeanQuery(String queryString) { ResultProcessor resultFactory = getQueryMethod().getResultProcessor(); ReturnedType returnedType = resultFactory.getReturnedType(); return EbeanQueryWrapper.ofEbeanQuery(getEbeanServer().findNative(returnedType.getReturnedType(), queryString)); } }