类的使用
io.jboot.db.model.Column

使用Column的程序包

程序包	说明
io.jboot.db.dialect
io.jboot.db.model

io.jboot.db.dialect中Column的使用

类型变量类型为Column的io.jboot.db.dialect中的方法参数

限定符和类型	方法和说明
String	JbootMysqlDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootSqlite3Dialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootInformixDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootSqlServerDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootClickHouseDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootAnsiSqlDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootPostgreSqlDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootOracleDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootDmDialect.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns)
String	JbootMysqlDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootSqlite3Dialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootInformixDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootSqlServerDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootClickHouseDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootAnsiSqlDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootPostgreSqlDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootOracleDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootDmDialect.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, Object limit)
String	JbootMysqlDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootSqlite3Dialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootInformixDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootSqlServerDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootClickHouseDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootAnsiSqlDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootPostgreSqlDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootOracleDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootDmDialect.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns)
String	JbootMysqlDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootSqlite3Dialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootInformixDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootSqlServerDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootClickHouseDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootAnsiSqlDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootPostgreSqlDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootOracleDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)
String	JbootDmDialect.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy)

io.jboot.db.model中Column的使用

io.jboot.db.model中Column的子类

限定符和类型	类和说明
class	Group
class	GroupBy
class	Having
class	Or
(专用程序包) class	SqlPart

类型参数类型为Column的io.jboot.db.model中的字段

限定符和类型	字段和说明
private List<Column>	Columns.cols

返回Column的io.jboot.db.model中的方法

限定符和类型	方法和说明
static Column	Column.create(String name)
static Column	Column.create(String name, Object value)
static Column	Column.create(String name, Object value, String logic)
Column	Column.logic(String logic)

返回变量类型为Column的类型的io.jboot.db.model中的方法

限定符和类型	方法和说明
List<Column>	Columns.getList()

参数类型为Column的io.jboot.db.model中的方法

限定符和类型	方法和说明
Columns	Columns.add(Column column) add new column in Columns
Columns	Columns.addToFirst(Column column) add new column in Columns
static void	SqlBuilder.appendBetweenLogic(StringBuilder sqlBuilder, Column column, char separator)
private static void	SqlBuilder.appendColumnName(StringBuilder sqlBuilder, Column column, char separator)
static void	SqlBuilder.appendGroupLogic(StringBuilder sqlBuilder, Column before, Group group, char separator)
static void	SqlBuilder.appendInLogic(StringBuilder sqlBuilder, Column column, char separator)
private static void	SqlBuilder.appendLinkString(StringBuilder sqlBuilder, Column before)
private static void	SqlBuilder.appendSqlPartLogic(StringBuilder sqlBuilder, Column before, SqlPart sqlPart, char separator)
static Columns	Columns.create(Column column)
boolean	JbootModel.deleteByColumn(Column column)
long	JbootModel.findCountByColumn(Column column)
M	JbootModel.findFirstByColumn(Column column)
M	JbootModel.findFirstByColumn(Column column, String orderBy)
List<M>	JbootModel.findListByColumn(Column column)
List<M>	JbootModel.findListByColumn(Column column, Integer count)
List<M>	JbootModel.findListByColumn(Column column, String orderby)
List<M>	JbootModel.findListByColumn(Column column, String orderBy, Integer count)
com.jfinal.plugin.activerecord.Page<M>	JbootModel.paginateByColumn(int pageNumber, int pageSize, Column column)
com.jfinal.plugin.activerecord.Page<M>	JbootModel.paginateByColumn(int pageNumber, int pageSize, Column column, String orderBy)

类型变量类型为Column的io.jboot.db.model中的方法参数

限定符和类型	方法和说明
private static void	SqlBuilder.buildByColumns(StringBuilder sqlBuilder, List<Column> columns, char separator)
private void	Columns.buildCacheKey(StringBuilder s, List<Column> columns)
static void	SqlBuilder.buildMysqlWhereSql(StringBuilder sqlBuilder, List<Column> columns)
static void	SqlBuilder.buildWhereSql(StringBuilder sqlBuilder, List<Column> columns, char separator)
static void	SqlBuilder.buildWhereSql(StringBuilder sqlBuilder, List<Column> columns, char separator, boolean appendWhereKeyword)
static Columns	Columns.create(List<Column> columns)
List<M>	JbootModel.findListByColumns(List<Column> columns)
List<M>	JbootModel.findListByColumns(List<Column> columns, Integer count)
List<M>	JbootModel.findListByColumns(List<Column> columns, String orderBy)
List<M>	JbootModel.findListByColumns(List<Column> columns, String orderBy, Integer count)
static String	SqlBuilder.forDeleteByColumns(String alias, List<Join> joins, String table, List<Column> columns, char separator)
static StringBuilder	SqlBuilder.forFindByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, String orderBy, char separator)
static String	SqlBuilder.forFindCountByColumns(String alias, List<Join> joins, String table, String loadColumns, List<Column> columns, char separator)
static String	SqlBuilder.forPaginateFrom(String alias, List<Join> joins, String table, List<Column> columns, String orderBy, char separator)
(专用程序包) static Object[]	Util.getValueArray(List<Column> columns)
private static boolean	SqlBuilder.isAllGroupByColumns(List<Column> columns)
com.jfinal.plugin.activerecord.Page<M>	JbootModel.paginateByColumns(int pageNumber, int pageSize, List<Column> columns)
com.jfinal.plugin.activerecord.Page<M>	JbootModel.paginateByColumns(int pageNumber, int pageSize, List<Column> columns, String orderBy)