org.litepal

类 FluentQuery

java.lang.Object

org.litepal.FluentQuery

public class FluentQuery
extends java.lang.Object

Allows developers to query tables with fluent style.

从以下版本开始:

2.0

方法概要

限定符和类型	方法和说明
double	average(java.lang.Class<?> modelClass, java.lang.String column) Calculates the average value on a given column.
double	average(java.lang.String tableName, java.lang.String column) Calculates the average value on a given column.
AverageExecutor	averageAsync(java.lang.Class<?> modelClass, java.lang.String column) 已过时。
AverageExecutor	averageAsync(java.lang.String tableName, java.lang.String column) 已过时。
int	count(java.lang.Class<?> modelClass) Count the records.
int	count(java.lang.String tableName) Count the records.
CountExecutor	countAsync(java.lang.Class<?> modelClass) 已过时。
CountExecutor	countAsync(java.lang.String tableName) 已过时。
<T> java.util.List<T>	find(java.lang.Class<T> modelClass) Finds multiple records by the cluster parameters.
<T> java.util.List<T>	find(java.lang.Class<T> modelClass, boolean isEager) It is mostly same as find(Class) but an isEager parameter.
<T> FindMultiExecutor<T>	findAsync(java.lang.Class<T> modelClass) 已过时。
<T> FindMultiExecutor<T>	findAsync(java.lang.Class<T> modelClass, boolean isEager) 已过时。
<T> T	findFirst(java.lang.Class<T> modelClass) Finds the first record by the cluster parameters.
<T> T	findFirst(java.lang.Class<T> modelClass, boolean isEager) It is mostly same as findFirst(Class) but an isEager parameter.
<T> FindExecutor<T>	findFirstAsync(java.lang.Class<T> modelClass) 已过时。
<T> FindExecutor<T>	findFirstAsync(java.lang.Class<T> modelClass, boolean isEager) 已过时。
<T> T	findLast(java.lang.Class<T> modelClass) Finds the last record by the cluster parameters.
<T> T	findLast(java.lang.Class<T> modelClass, boolean isEager) It is mostly same as findLast(Class) but an isEager parameter.
<T> FindExecutor<T>	findLastAsync(java.lang.Class<T> modelClass) 已过时。
<T> FindExecutor<T>	findLastAsync(java.lang.Class<T> modelClass, boolean isEager) 已过时。
FluentQuery	limit(int value) Limits the number of rows returned by the query.
<T> T	max(java.lang.Class<?> modelClass, java.lang.String columnName, java.lang.Class<T> columnType) Calculates the maximum value on a given column.
<T> T	max(java.lang.String tableName, java.lang.String columnName, java.lang.Class<T> columnType) Calculates the maximum value on a given column.
<T> FindExecutor<T>	maxAsync(java.lang.Class<?> modelClass, java.lang.String columnName, java.lang.Class<T> columnType) 已过时。
<T> FindExecutor<T>	maxAsync(java.lang.String tableName, java.lang.String columnName, java.lang.Class<T> columnType) 已过时。
<T> T	min(java.lang.Class<?> modelClass, java.lang.String columnName, java.lang.Class<T> columnType) Calculates the minimum value on a given column.
<T> T	min(java.lang.String tableName, java.lang.String columnName, java.lang.Class<T> columnType) Calculates the minimum value on a given column.
<T> FindExecutor<T>	minAsync(java.lang.Class<?> modelClass, java.lang.String columnName, java.lang.Class<T> columnType) 已过时。
<T> FindExecutor<T>	minAsync(java.lang.String tableName, java.lang.String columnName, java.lang.Class<T> columnType) 已过时。
FluentQuery	offset(int value) Declaring the offset of rows returned by the query.
FluentQuery	order(java.lang.String column) Declaring how to order the rows queried from table.
FluentQuery	select(java.lang.String... columns) Declaring to query which columns in table.
<T> T	sum(java.lang.Class<?> modelClass, java.lang.String columnName, java.lang.Class<T> columnType) Calculates the sum of values on a given column.
<T> T	sum(java.lang.String tableName, java.lang.String columnName, java.lang.Class<T> columnType) Calculates the sum of values on a given column.
<T> FindExecutor<T>	sumAsync(java.lang.Class<?> modelClass, java.lang.String columnName, java.lang.Class<T> columnType) 已过时。
<T> FindExecutor<T>	sumAsync(java.lang.String tableName, java.lang.String columnName, java.lang.Class<T> columnType) 已过时。
FluentQuery	where(java.lang.String... conditions) Declaring to query which rows in table.

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

方法详细资料

select

public FluentQuery select(java.lang.String... columns)

Declaring to query which columns in table.

 LitePal.select("name", "age").find(Person.class);
 

This will find all rows with name and age columns in Person table.

参数:

columns - A String array of which columns to return. Passing null will return all columns.

返回:

A ClusterQuery instance.

where

public FluentQuery where(java.lang.String... conditions)

Declaring to query which rows in table.

 LitePal.where("name = ? or age > ?", "Tom", "14").find(Person.class);
 

This will find rows which name is Tom or age greater than 14 in Person table.

参数:

conditions - A filter declaring which rows to return, formatted as an SQL WHERE clause. Passing null will return all rows.

返回:

A ClusterQuery instance.

order

public FluentQuery order(java.lang.String column)

Declaring how to order the rows queried from table.

 LitePal.order("name desc").find(Person.class);
 

This will find all rows in Person table sorted by name with inverted order.

参数:

column - How to order the rows, formatted as an SQL ORDER BY clause. Passing null will use the default sort order, which may be unordered.

返回:

A ClusterQuery instance.

limit

public FluentQuery limit(int value)

Limits the number of rows returned by the query.

 LitePal.limit(2).find(Person.class);
 

This will find the top 2 rows in Person table.

参数:

value - Limits the number of rows returned by the query, formatted as LIMIT clause.

返回:

A ClusterQuery instance.

offset

public FluentQuery offset(int value)

Declaring the offset of rows returned by the query. This method must be used with limit(int), or nothing will return.

 LitePal.limit(1).offset(2).find(Person.class);
 

This will find the third row in Person table.

参数:

value - The offset amount of rows returned by the query.

返回:

A ClusterQuery instance.

find

public <T> java.util.List<T> find(java.lang.Class<T> modelClass)

Finds multiple records by the cluster parameters. You can use the below way to finish a complicated query:

 LitePal.select("name").where("age > ?", "14").order("age").limit(1).offset(2)
                .find(Person.class);
 

You can also do the same job with SQLiteDatabase like this:

 getSQLiteDatabase().query("Person", "name", "age > ?", new String[] { "14" }, null, null, "age",
                "2,1");
 

Obviously, the first way is much more semantic.
Note that the associated models won't be loaded by default considering the efficiency, but you can do that by using find(Class, boolean).

参数:

modelClass - Which table to query and the object type to return as a list.

返回:

An object list with founded data from database, or an empty list.

findAsync

@Deprecated
public <T> FindMultiExecutor<T> findAsync(java.lang.Class<T> modelClass)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

find

public <T> java.util.List<T> find(java.lang.Class<T> modelClass,
                                  boolean isEager)

It is mostly same as find(Class) but an isEager parameter. If set true the associated models will be loaded as well.
Note that isEager will only work for one deep level relation, considering the query efficiency. You have to implement on your own if you need to load multiple deepness of relation at once.

参数:

modelClass - Which table to query and the object type to return as a list.

isEager - True to load the associated models, false not.

返回:

An object list with founded data from database, or an empty list.

findAsync

@Deprecated
public <T> FindMultiExecutor<T> findAsync(java.lang.Class<T> modelClass,
                                                       boolean isEager)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

findFirst

public <T> T findFirst(java.lang.Class<T> modelClass)

Finds the first record by the cluster parameters. You can use the below way to finish a complicated query:

 LitePal.select("name").where("age > ?", "14").order("age").limit(10).offset(2)
                .findFirst(Person.class);
 

Note that the associated models won't be loaded by default considering the efficiency, but you can do that by using findFirst(Class, boolean).

参数:

modelClass - Which table to query and the object type to return.

返回:

An object with founded data from database, or null.

findFirstAsync

@Deprecated
public <T> FindExecutor<T> findFirstAsync(java.lang.Class<T> modelClass)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

findFirst

public <T> T findFirst(java.lang.Class<T> modelClass,
                       boolean isEager)

It is mostly same as findFirst(Class) but an isEager parameter. If set true the associated models will be loaded as well.
Note that isEager will only work for one deep level relation, considering the query efficiency. You have to implement on your own if you need to load multiple deepness of relation at once.

参数:

modelClass - Which table to query and the object type to return.

isEager - True to load the associated models, false not.

返回:

An object with founded data from database, or null.

findFirstAsync

@Deprecated
public <T> FindExecutor<T> findFirstAsync(java.lang.Class<T> modelClass,
                                                       boolean isEager)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

findLast

public <T> T findLast(java.lang.Class<T> modelClass)

Finds the last record by the cluster parameters. You can use the below way to finish a complicated query:

 LitePal.select("name").where("age > ?", "14").order("age").limit(10).offset(2)
                .findLast(Person.class);
 

Note that the associated models won't be loaded by default considering the efficiency, but you can do that by using findLast(Class, boolean).

参数:

modelClass - Which table to query and the object type to return.

返回:

An object with founded data from database, or null.

findLastAsync

@Deprecated
public <T> FindExecutor<T> findLastAsync(java.lang.Class<T> modelClass)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

findLast

public <T> T findLast(java.lang.Class<T> modelClass,
                      boolean isEager)

It is mostly same as findLast(Class) but an isEager parameter. If set true the associated models will be loaded as well.
Note that isEager will only work for one deep level relation, considering the query efficiency. You have to implement on your own if you need to load multiple deepness of relation at once.

参数:

modelClass - Which table to query and the object type to return.

isEager - True to load the associated models, false not.

返回:

An object with founded data from database, or null.

findLastAsync

@Deprecated
public <T> FindExecutor<T> findLastAsync(java.lang.Class<T> modelClass,
                                                      boolean isEager)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

count

public int count(java.lang.Class<?> modelClass)

Count the records.

 LitePal.count(Person.class);
 

This will count all rows in person table.
You can also specify a where clause when counting.

 LitePal.where("age > ?", "15").count(Person.class);
 

参数:

modelClass - Which table to query from by class.

返回:

Count of the specified table.

countAsync

@Deprecated
public CountExecutor countAsync(java.lang.Class<?> modelClass)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

count

public int count(java.lang.String tableName)

Count the records.

 LitePal.count("person");
 

This will count all rows in person table.
You can also specify a where clause when counting.

 LitePal.where("age > ?", "15").count("person");
 

参数:

tableName - Which table to query from.

返回:

Count of the specified table.

countAsync

@Deprecated
public CountExecutor countAsync(java.lang.String tableName)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

average

public double average(java.lang.Class<?> modelClass,
                      java.lang.String column)

Calculates the average value on a given column.

 LitePal.average(Person.class, "age");
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").average(Person.class, "age");
 

参数:

modelClass - Which table to query from by class.

column - The based on column to calculate.

返回:

The average value on a given column.

averageAsync

@Deprecated
public AverageExecutor averageAsync(java.lang.Class<?> modelClass,
                                                 java.lang.String column)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

average

public double average(java.lang.String tableName,
                      java.lang.String column)

Calculates the average value on a given column.

 LitePal.average("person", "age");
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").average("person", "age");
 

参数:

tableName - Which table to query from.

column - The based on column to calculate.

返回:

The average value on a given column.

averageAsync

@Deprecated
public AverageExecutor averageAsync(java.lang.String tableName,
                                                 java.lang.String column)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

max

public <T> T max(java.lang.Class<?> modelClass,
                 java.lang.String columnName,
                 java.lang.Class<T> columnType)

Calculates the maximum value on a given column. The value is returned with the same data type of the column.

 LitePal.max(Person.class, "age", int.class);
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").max(Person.class, "age", Integer.TYPE);
 

参数:

modelClass - Which table to query from by class.

columnName - The based on column to calculate.

columnType - The type of the based on column.

返回:

The maximum value on a given column.

maxAsync

@Deprecated
public <T> FindExecutor<T> maxAsync(java.lang.Class<?> modelClass,
                                                 java.lang.String columnName,
                                                 java.lang.Class<T> columnType)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

max

public <T> T max(java.lang.String tableName,
                 java.lang.String columnName,
                 java.lang.Class<T> columnType)

Calculates the maximum value on a given column. The value is returned with the same data type of the column.

 LitePal.max("person", "age", int.class);
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").max("person", "age", Integer.TYPE);
 

参数:

tableName - Which table to query from.

columnName - The based on column to calculate.

columnType - The type of the based on column.

返回:

The maximum value on a given column.

maxAsync

@Deprecated
public <T> FindExecutor<T> maxAsync(java.lang.String tableName,
                                                 java.lang.String columnName,
                                                 java.lang.Class<T> columnType)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

min

public <T> T min(java.lang.Class<?> modelClass,
                 java.lang.String columnName,
                 java.lang.Class<T> columnType)

Calculates the minimum value on a given column. The value is returned with the same data type of the column.

 LitePal.min(Person.class, "age", int.class);
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").min(Person.class, "age", Integer.TYPE);
 

参数:

modelClass - Which table to query from by class.

columnName - The based on column to calculate.

columnType - The type of the based on column.

返回:

The minimum value on a given column.

minAsync

@Deprecated
public <T> FindExecutor<T> minAsync(java.lang.Class<?> modelClass,
                                                 java.lang.String columnName,
                                                 java.lang.Class<T> columnType)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

min

public <T> T min(java.lang.String tableName,
                 java.lang.String columnName,
                 java.lang.Class<T> columnType)

Calculates the minimum value on a given column. The value is returned with the same data type of the column.

 LitePal.min("person", "age", int.class);
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").min("person", "age", Integer.TYPE);
 

参数:

tableName - Which table to query from.

columnName - The based on column to calculate.

columnType - The type of the based on column.

返回:

The minimum value on a given column.

minAsync

@Deprecated
public <T> FindExecutor<T> minAsync(java.lang.String tableName,
                                                 java.lang.String columnName,
                                                 java.lang.Class<T> columnType)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

sum

public <T> T sum(java.lang.Class<?> modelClass,
                 java.lang.String columnName,
                 java.lang.Class<T> columnType)

Calculates the sum of values on a given column. The value is returned with the same data type of the column.

 LitePal.sum(Person.class, "age", int.class);
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").sum(Person.class, "age", Integer.TYPE);
 

参数:

modelClass - Which table to query from by class.

columnName - The based on column to calculate.

columnType - The type of the based on column.

返回:

The sum value on a given column.

sumAsync

@Deprecated
public <T> FindExecutor<T> sumAsync(java.lang.Class<?> modelClass,
                                                 java.lang.String columnName,
                                                 java.lang.Class<T> columnType)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.

sum

public <T> T sum(java.lang.String tableName,
                 java.lang.String columnName,
                 java.lang.Class<T> columnType)

Calculates the sum of values on a given column. The value is returned with the same data type of the column.

 LitePal.sum("person", "age", int.class);
 

You can also specify a where clause when calculating.

 LitePal.where("age > ?", "15").sum("person", "age", Integer.TYPE);
 

参数:

tableName - Which table to query from.

columnName - The based on column to calculate.

columnType - The type of the based on column.

返回:

The sum value on a given column.

sumAsync

@Deprecated
public <T> FindExecutor<T> sumAsync(java.lang.String tableName,
                                                 java.lang.String columnName,
                                                 java.lang.Class<T> columnType)

已过时。

This method is deprecated and will be removed in the future releases. Handle async db operation in your own logic instead.