Uses of Class
sf.dsl.Example

Packages that use Example

Package	Description
sf.core
sf.database.dao
sf.database.jdbc.sql
sf.dsl

Uses of Example in sf.core

Fields in sf.core declared as Example

Modifier and Type	Field and Description
protected Example	DBObject.query

Methods in sf.core that return Example

Modifier and Type	Method and Description
Example	DBObject.useQuery() 使用查询

Uses of Example in sf.database.dao

Methods in sf.database.dao with parameters of type Example

Modifier and Type	Method and Description
List<Map<String,Object>>	DBMethod.select(Example example)
List<Map<String,Object>>	DBClient.select(Example example)
Object[]	DBMethod.selectArray(Example example)
Object[]	DBClient.selectArray(Example example)
<T> List<T>	DBMethod.selectList(Class<T> beanClass, Example example)
<T> List<T>	DBClient.selectList(Class<T> beanClass, Example example)
<T> List<T>	DBMethod.selectList(Class<T> beanClass, long start, int limit, Example example)
<T> List<T>	DBClient.selectList(Class<T> beanClass, long start, int limit, Example example)
<T> List<T>	DBMethod.selectListForUpdate(Class<T> beanClass, Example example)
<T> List<T>	DBClient.selectListForUpdate(Class<T> beanClass, Example example)
<T> T	DBMethod.selectOne(Class<T> beanClass, Example example)
<T> T	DBClient.selectOne(Class<T> beanClass, Example example)
<T> T	DBMethod.selectOneForUpdate(Class<T> beanClass, Example example)
<T> T	DBClient.selectOneForUpdate(Class<T> beanClass, Example example)
<T> Page<T>	DBMethod.selectPage(long start, int limit, Class<T> beanClass, Example example)
<T> Page<T>	DBClient.selectPage(long start, int limit, Class<T> beanClass, Example example)

Uses of Example in sf.database.jdbc.sql

Methods in sf.database.jdbc.sql with parameters of type Example

Modifier and Type	Method and Description
List<Map<String,Object>>	CrudExampleImpl.select(Connection conn, Example example)
List<Map<String,Object>>	CrudExampleInf.select(Connection conn, Example example)
Object[]	CrudExampleImpl.selectArray(Connection conn, Example example)
Object[]	CrudExampleInf.selectArray(Connection conn, Example example)
<T> List<T>	CrudExampleImpl.selectList(Connection conn, Class<T> beanClass, Example example)
<T> List<T>	CrudExampleInf.selectList(Connection conn, Class<T> beanClass, Example example)
<T> List<T>	CrudExampleImpl.selectList(Connection conn, Class<T> beanClass, long start, int limit, Example example)
<T> List<T>	CrudExampleInf.selectList(Connection conn, Class<T> beanClass, long start, int limit, Example example)
<T> List<T>	CrudExampleImpl.selectListForUpdate(Connection conn, Class<T> beanClass, Example example)
<T> List<T>	CrudExampleInf.selectListForUpdate(Connection conn, Class<T> beanClass, Example example)
<T> T	CrudExampleImpl.selectOne(Connection conn, Class<T> beanClass, Example example)
<T> T	CrudExampleInf.selectOne(Connection conn, Class<T> beanClass, Example example)
<T> T	CrudExampleImpl.selectOneForUpdate(Connection conn, Class<T> beanClass, Example example)
<T> T	CrudExampleInf.selectOneForUpdate(Connection conn, Class<T> beanClass, Example example)
<T> Page<T>	CrudExampleImpl.selectPage(Connection conn, long start, int limit, Class<T> beanClass, Example example)
<T> Page<T>	CrudExampleInf.selectPage(Connection conn, long start, int limit, Class<T> beanClass, Example example)

Uses of Example in sf.dsl

Fields in sf.dsl declared as Example

Modifier and Type	Field and Description
protected Example	Example.GeneratedCriteria.example

Methods in sf.dsl that return Example

Modifier and Type	Method and Description
Example	Example.alias(String alias) 设置表别名
Example	Example.excludeProperties(DBField... properties) 排除查询字段，优先级低于 selectProperties
Example	Example.from(String from)
Example	Example.GeneratedCriteria.getExample()
Example	Example.offsetLimit(long start, int limit) 分页参数
Example	Example.orderBy(DBField... properties)
Example	Example.orderBy(DBField property, Example.Order order)
Example	Example.orderByAsc(DBField... properties)
Example	Example.orderByDesc(DBField... properties)
Example	Example.select(String select)
Example	Example.selectCount()
Example	Example.selectCount(DBField property)
Example	Example.selectDistinct(DBField... properties)
Example	Example.selectProperties(DBField... properties) 指定要查询的属性列 - 这里会自动映射到表字段
Example	Example.tableName(String tableName) 设置表名

Methods in sf.dsl with parameters of type Example

Modifier and Type	Method and Description
static String	ExampleSQLHelp.getColumn(Example example, boolean useAlias)
static String	ExampleSQLHelp.getCountColumn(Example example, boolean useAlias)
static String	ExampleSQLHelp.getFromClause(Example example, DBContext context, boolean useAlias)
static String	ExampleSQLHelp.getOrderByClause(Example example, boolean useAlias)
static String	ExampleSQLHelp.getSelectClause(Example example, SelectOpt opt, boolean useAlias)
static SQLContext	ExampleSQLHelp.getSelectSQLContext(Example example, DBContext context, SelectOpt opt, boolean offsetLimit, boolean useAlias) 获取完整的查询
static SQLContext	ExampleSQLHelp.getSQLContextWhereClause(Example example, boolean useAlias)

Constructors in sf.dsl with parameters of type Example

Constructor and Description
Criteria(Example example, Class<? extends DBObject> entityClass)
Criteria(Example example, Map<DBField,ColumnMapping> propertyMap, boolean exists, boolean notNull)
GeneratedCriteria(Example example, Map<DBField,ColumnMapping> propertyMap, boolean exists, boolean notNull)