A B C D E F G H I M N O P Q R S T U V W
All Classes All Packages
All Classes All Packages
All Classes All Packages
A
- AbstractConditionalBuilder<B extends ConditionalBuilder<B,T>,T extends SQLAction<?>> - Class in cc.carm.lib.easysql.builder.impl
- AbstractConditionalBuilder(SQLManagerImpl) - Constructor for class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- AbstractSQLAction<T> - Class in cc.carm.lib.easysql.action
- AbstractSQLAction(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.action.AbstractSQLAction
- AbstractSQLAction(SQLManagerImpl, String, long) - Constructor for class cc.carm.lib.easysql.action.AbstractSQLAction
- AbstractSQLAction(SQLManagerImpl, String, UUID) - Constructor for class cc.carm.lib.easysql.action.AbstractSQLAction
- AbstractSQLAction(SQLManagerImpl, String, UUID, long) - Constructor for class cc.carm.lib.easysql.action.AbstractSQLAction
- AbstractSQLBuilder - Class in cc.carm.lib.easysql.builder
- AbstractSQLBuilder(SQLManagerImpl) - Constructor for class cc.carm.lib.easysql.builder.AbstractSQLBuilder
- accept(SQLException, SQLAction<?>) - Method in class cc.carm.lib.easysql.api.function.defaults.DefaultSQLExceptionHandler
- accept(T) - Method in interface cc.carm.lib.easysql.api.function.SQLHandler
- addAutoIncrementColumn(String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为该表添加一个自增列
自增列强制要求为数字类型,非空,且为UNIQUE。 - addAutoIncrementColumn(String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
为该表添加一个INT类型的自增主键列
- addAutoIncrementColumn(String, boolean) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
为该表添加一个INT类型的自增列
- addAutoIncrementColumn(String, boolean, boolean) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
为该表添加一个INT类型的自增主键列
- addAutoIncrementColumn(String, NumberType) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为该表添加一个自增列
自增列强制要求为数字类型,非空,且为UNIQUE。 - addAutoIncrementColumn(String, NumberType, boolean, boolean) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为该表添加一个自增列
- addAutoIncrementColumn(String, NumberType, boolean, boolean) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
为该表添加一个自增列
- addAutoIncrementColumn(String, NumberType, boolean, boolean) - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- addBatch(String) - Method in class cc.carm.lib.easysql.action.SQLUpdateBatchActionImpl
- addBatch(String) - Method in interface cc.carm.lib.easysql.api.action.SQLUpdateBatchAction
-
添加一条批量执行的SQL语句
- addColumn(String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
为该表添加一个列
- addColumn(String) - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- addColumn(String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为表添加一列
- addColumn(String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
为该表添加一个列
- addColumn(String, String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
为该表添加一个列
- addColumn(String, String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为表添加一列
- addColumn(String, String, String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- addCondition(String[], Object[]) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- addCondition(String[], Object[]) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- addCondition(String, String, Object) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- addCondition(String, String, Object) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- addCondition(String, Object) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- addCondition(String) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- addCondition(String) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- addForeignKey(String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
以本表位从表,为表中某列设定自参照外键(即自参照完整性)。
- addForeignKey(String, String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
以本表位从表,为表中某列设定外键。
- addForeignKey(String, String, String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
以本表位从表,为表中某列设定外键。
- addForeignKey(String, String, String, String, ForeignKeyRule, ForeignKeyRule) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
以本表位从表,为表中某列设定外键。
- addForeignKey(String, String, String, String, ForeignKeyRule, ForeignKeyRule) - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- addIndex(IndexType, String, String, String...) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- addIndex(IndexType, String, String, String...) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- addNotNullCondition(String) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- addNotNullCondition(String) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- addParamsBatch(Object...) - Method in class cc.carm.lib.easysql.action.PreparedSQLBatchUpdateActionImpl
- addParamsBatch(Object...) - Method in interface cc.carm.lib.easysql.api.action.PreparedSQLUpdateBatchAction
-
添加一组SQL语句中所有 ?
- addTimeCondition(String, long, long) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- addTimeCondition(String, Date, Date) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- addTimeCondition(String, Date, Date) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- alterTable(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
对库中的某个表执行更改
- alterTable(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- andThen(SQLHandler<? super T>) - Method in interface cc.carm.lib.easysql.api.function.SQLHandler
- apply(T) - Method in interface cc.carm.lib.easysql.api.function.SQLFunction
B
- BIGINT - cc.carm.lib.easysql.api.enums.NumberType
- build() - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
-
将现有条件构建完整的SQL语句用于执行。
- build() - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
将现有条件构建完整的SQL语句用于执行。
- build() - Method in class cc.carm.lib.easysql.builder.impl.DeleteBuilderImpl
- build() - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- build() - Method in class cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl
- build() - Method in class cc.carm.lib.easysql.builder.impl.UpdateBuilderImpl
- buildConditionSQL() - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- buildIndexSettings(IndexType, String, String, String...) - Static method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- buildLimitSQL() - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- buildSQL(String, List<String>) - Static method in class cc.carm.lib.easysql.builder.impl.InsertBuilderImpl
- buildSQL(String, List<String>) - Static method in class cc.carm.lib.easysql.builder.impl.ReplaceBuilderImpl
C
- CASCADE - cc.carm.lib.easysql.api.enums.ForeignKeyRule
-
级联删除,删除包含与已删除键值有参照关系的所有记录
- cc.carm.lib.easysql - package cc.carm.lib.easysql
- cc.carm.lib.easysql.action - package cc.carm.lib.easysql.action
- cc.carm.lib.easysql.action.query - package cc.carm.lib.easysql.action.query
- cc.carm.lib.easysql.api - package cc.carm.lib.easysql.api
- cc.carm.lib.easysql.api.action - package cc.carm.lib.easysql.api.action
- cc.carm.lib.easysql.api.action.query - package cc.carm.lib.easysql.api.action.query
- cc.carm.lib.easysql.api.builder - package cc.carm.lib.easysql.api.builder
- cc.carm.lib.easysql.api.enums - package cc.carm.lib.easysql.api.enums
- cc.carm.lib.easysql.api.function - package cc.carm.lib.easysql.api.function
- cc.carm.lib.easysql.api.function.defaults - package cc.carm.lib.easysql.api.function.defaults
- cc.carm.lib.easysql.api.util - package cc.carm.lib.easysql.api.util
- cc.carm.lib.easysql.builder - package cc.carm.lib.easysql.builder
- cc.carm.lib.easysql.builder.impl - package cc.carm.lib.easysql.builder.impl
- cc.carm.lib.easysql.manager - package cc.carm.lib.easysql.manager
- cc.carm.lib.easysql.query - package cc.carm.lib.easysql.query
- cc.carm.lib.easysql.util - package cc.carm.lib.easysql.util
- changeComment(String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- changeComment(String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- close() - Method in interface cc.carm.lib.easysql.api.SQLQuery
-
关闭所有内容
- close() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- ConditionalBuilder<B extends ConditionalBuilder<B,T>,T extends SQLAction<?>> - Interface in cc.carm.lib.easysql.api.builder
- createDelete(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
创建删除操作
- createDelete(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- createInsert(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
创建一条插入操作
- createInsert(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- createInsertBatch(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
创建支持多组数据的插入操作
- createInsertBatch(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- createManager(BeeDataSourceConfig) - Static method in class cc.carm.lib.easysql.EasySQL
- createManager(String, String, String, String) - Static method in class cc.carm.lib.easysql.EasySQL
- createPrepareStatement(Connection, String, Object[]) - Static method in class cc.carm.lib.easysql.util.StatementUtil
-
创建一个
PreparedStatement。 - createPrepareStatement(Connection, String, Object[], boolean) - Static method in class cc.carm.lib.easysql.util.StatementUtil
-
创建一个
PreparedStatement。 - createPrepareStatementBatch(Connection, String, Iterable<Object[]>) - Static method in class cc.carm.lib.easysql.util.StatementUtil
-
创建批量操作的一个
PreparedStatement。 - createPrepareStatementBatch(Connection, String, Iterable<Object[]>, boolean) - Static method in class cc.carm.lib.easysql.util.StatementUtil
-
创建批量操作的一个
PreparedStatement。 - createQuery() - Method in interface cc.carm.lib.easysql.api.SQLManager
-
新建一个查询
- createQuery() - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- createReplace(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
创建一条替换操作
- createReplace(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- createReplaceBatch(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
创建支持多组数据的替换操作
- createReplaceBatch(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- createTable(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
在库中创建一个表
- createTable(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- createUpdate(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
创建更新操作
- createUpdate(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
D
- debug(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- defaultExceptionHandler() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
默认的异常处理器
- DefaultSQLExceptionHandler - Class in cc.carm.lib.easysql.api.function.defaults
- DefaultSQLExceptionHandler(Logger) - Constructor for class cc.carm.lib.easysql.api.function.defaults.DefaultSQLExceptionHandler
- defaultTablesSettings() - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
- DeleteBuilder - Interface in cc.carm.lib.easysql.api.builder
- DeleteBuilderImpl - Class in cc.carm.lib.easysql.builder.impl
- DeleteBuilderImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.builder.impl.DeleteBuilderImpl
- dropForeignKey(String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为该表移除一个外键
- dropForeignKey(String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- dropIndex(String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为该表移除一个索引
- dropIndex(String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- dropPrimaryKey() - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
-
为该表移除主键(须添加新主键)
- dropPrimaryKey() - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
E
- EasySQL - Class in cc.carm.lib.easysql
- EasySQL() - Constructor for class cc.carm.lib.easysql.EasySQL
- execute() - Method in class cc.carm.lib.easysql.action.PreparedSQLBatchUpdateActionImpl
- execute() - Method in class cc.carm.lib.easysql.action.PreparedSQLUpdateActionImpl
- execute() - Method in class cc.carm.lib.easysql.action.query.PreparedQueryActionImpl
- execute() - Method in class cc.carm.lib.easysql.action.query.QueryActionImpl
- execute() - Method in class cc.carm.lib.easysql.action.SQLUpdateActionImpl
- execute() - Method in class cc.carm.lib.easysql.action.SQLUpdateBatchActionImpl
- execute() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
执行该Action对应的SQL语句
- execute(SQLFunction<T, R>, SQLExceptionHandler) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
执行语句并处理返回值
- execute(SQLFunction<T, R>, R, SQLExceptionHandler) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
执行语句并处理返回值
- execute(SQLExceptionHandler) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
执行语句并返回值
- executeAsync() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
异步执行SQL语句,采用默认异常处理,无需返回值。
- executeAsync(SQLHandler<T>) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
异步执行SQL语句
- executeAsync(SQLHandler<T>, SQLExceptionHandler) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
异步执行SQL语句
- executeAsync(SQLHandler<SQLQuery>, SQLExceptionHandler) - Method in class cc.carm.lib.easysql.action.query.QueryActionImpl
- executeAsync(SQLHandler<T>, SQLExceptionHandler) - Method in class cc.carm.lib.easysql.action.AbstractSQLAction
- executeFunction(SQLFunction<SQLQuery, R>, R) - Method in interface cc.carm.lib.easysql.api.action.query.QueryAction
- executeFunction(SQLFunction<T, R>) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
执行语句并处理返回值
- executeFunction(SQLFunction<T, R>, R) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
执行语句并处理返回值
- executeSQL(String) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
执行一条不需要返回结果的SQL语句(多用于UPDATE、REPLACE、DELETE方法) 该方法使用 Statement 实现,请注意SQL注入风险!
- executeSQL(String) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- executeSQL(String, Object[]) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
执行一条不需要返回结果的预处理SQL更改(UPDATE、REPLACE、DELETE)
- executeSQL(String, Object[]) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- executeSQLBatch(Iterable<String>) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
执行多条不需要返回结果的SQL。
- executeSQLBatch(Iterable<String>) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- executeSQLBatch(String, String...) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
执行多条不需要返回结果的SQL。
- executeSQLBatch(String, String...) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- executeSQLBatch(String, Iterable<Object[]>) - Method in interface cc.carm.lib.easysql.api.SQLManager
-
执行多条不需要返回结果的SQL更改(UPDATE、REPLACE、DELETE)
- executeSQLBatch(String, Iterable<Object[]>) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- executeTime - Variable in class cc.carm.lib.easysql.query.SQLQueryImpl
- executorPool - Variable in class cc.carm.lib.easysql.manager.SQLManagerImpl
F
- fillParams(PreparedStatement, Iterable<?>) - Static method in class cc.carm.lib.easysql.util.StatementUtil
-
填充PreparedStatement的参数。
- fillParams(PreparedStatement, Iterable<?>, Map<Integer, Integer>) - Static method in class cc.carm.lib.easysql.util.StatementUtil
-
填充PreparedStatement的参数。
- ForeignKeyRule - Enum in cc.carm.lib.easysql.api.enums
- format - Static variable in class cc.carm.lib.easysql.api.util.TimeDateUtils
- FULLTEXT_INDEX - cc.carm.lib.easysql.api.enums.IndexType
-
全文索引 主要用来查找文本中的关键字,而不是直接与索引中的值相比较。
G
- get(Logger) - Static method in class cc.carm.lib.easysql.api.function.defaults.DefaultSQLExceptionHandler
- getAction() - Method in interface cc.carm.lib.easysql.api.SQLQuery
-
得到承载该SQLQuery的对应
QueryAction - getAction() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- getActionUUID() - Method in class cc.carm.lib.easysql.action.AbstractSQLAction
- getActionUUID() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
得到该Action的UUID
- getActiveQuery() - Method in interface cc.carm.lib.easysql.api.SQLManager
-
得到正使用的查询。
- getActiveQuery() - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- getConditionParams() - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- getConnection() - Method in interface cc.carm.lib.easysql.api.SQLManager
-
得到一个数据库连接实例
- getConnection() - Method in interface cc.carm.lib.easysql.api.SQLQuery
- getConnection() - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- getConnection() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- getCreateTime() - Method in class cc.carm.lib.easysql.action.AbstractSQLAction
- getCreateTime() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
得到该Action的创建时间
- getCurrentTime() - Static method in class cc.carm.lib.easysql.api.util.TimeDateUtils
-
得到当前时间文本。
- getCustomHandler() - Static method in class cc.carm.lib.easysql.api.function.defaults.DefaultSQLExceptionHandler
- getDataSource() - Method in interface cc.carm.lib.easysql.api.SQLManager
-
得到连接池源
- getDataSource() - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- getExecuteTime() - Method in interface cc.carm.lib.easysql.api.SQLQuery
-
获取该查询创建的时间
- getExecuteTime() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- getExecutorPool() - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- getFormat() - Static method in class cc.carm.lib.easysql.api.util.TimeDateUtils
- getLogger() - Method in class cc.carm.lib.easysql.api.function.defaults.DefaultSQLExceptionHandler
- getLogger() - Method in interface cc.carm.lib.easysql.api.SQLManager
- getLogger() - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- getManager() - Method in class cc.carm.lib.easysql.action.AbstractSQLAction
- getManager() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
得到承载该Action的对应
SQLManager - getManager() - Method in interface cc.carm.lib.easysql.api.SQLBuilder
-
得到承载该Builder的对应
SQLManager - getManager() - Method in interface cc.carm.lib.easysql.api.SQLQuery
-
得到承载该SQLQuery的对应
SQLManager - getManager() - Method in class cc.carm.lib.easysql.builder.AbstractSQLBuilder
- getManager() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- getName() - Method in enum cc.carm.lib.easysql.api.enums.IndexType
- getNullType(PreparedStatement, int) - Static method in class cc.carm.lib.easysql.util.StatementUtil
-
获取null字段对应位置的数据类型 如果类型获取失败将使用默认的
Types.VARCHAR - getResultSet() - Method in interface cc.carm.lib.easysql.api.SQLQuery
- getResultSet() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- getRuleName() - Method in enum cc.carm.lib.easysql.api.enums.ForeignKeyRule
- getShortID() - Method in class cc.carm.lib.easysql.action.AbstractSQLAction
- getShortID() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
得到短八位格式的UUID
- getSQLContent() - Method in class cc.carm.lib.easysql.action.AbstractSQLAction
- getSQLContent() - Method in interface cc.carm.lib.easysql.api.action.SQLUpdateBatchAction
- getSQLContent() - Method in interface cc.carm.lib.easysql.api.SQLAction
-
得到该Action所要执行的源SQL语句
- getSQLContent() - Method in interface cc.carm.lib.easysql.api.SQLQuery
-
得到设定的SQL语句
- getSQLContent() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- getSQLContents() - Method in class cc.carm.lib.easysql.action.SQLUpdateBatchActionImpl
- getSQLContents() - Method in interface cc.carm.lib.easysql.api.action.SQLUpdateBatchAction
- getStatement() - Method in interface cc.carm.lib.easysql.api.SQLQuery
- getStatement() - Method in class cc.carm.lib.easysql.query.SQLQueryImpl
- getTableName() - Method in interface cc.carm.lib.easysql.api.builder.DeleteBuilder
- getTableName() - Method in interface cc.carm.lib.easysql.api.builder.InsertBuilder
- getTableName() - Method in interface cc.carm.lib.easysql.api.builder.ReplaceBuilder
- getTableName() - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
- getTableName() - Method in interface cc.carm.lib.easysql.api.builder.TableQueryBuilder
- getTableName() - Method in interface cc.carm.lib.easysql.api.builder.UpdateBuilder
- getTableName() - Method in interface cc.carm.lib.easysql.api.builder.UpsertBuilder
-
Deprecated.
- getTableName() - Method in class cc.carm.lib.easysql.builder.impl.DeleteBuilderImpl
- getTableName() - Method in class cc.carm.lib.easysql.builder.impl.InsertBuilderImpl
- getTableName() - Method in class cc.carm.lib.easysql.builder.impl.ReplaceBuilderImpl
- getTableName() - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- getTableName() - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- getTableName() - Method in class cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl
- getTableName() - Method in class cc.carm.lib.easysql.builder.impl.UpdateBuilderImpl
- getTableSettings() - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
得到表的设定。
- getTableSettings() - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- getThis() - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- getThis() - Method in class cc.carm.lib.easysql.builder.impl.DeleteBuilderImpl
- getThis() - Method in class cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl
- getThis() - Method in class cc.carm.lib.easysql.builder.impl.UpdateBuilderImpl
- getTimeDate(String) - Static method in class cc.carm.lib.easysql.api.util.TimeDateUtils
-
得到一个时间文本的对应日期实例
- getTimeString(long) - Static method in class cc.carm.lib.easysql.api.util.TimeDateUtils
-
得到一个时间戳的文本
- getTimeString(Date) - Static method in class cc.carm.lib.easysql.api.util.TimeDateUtils
-
得到一个日期时间的文本
H
- handleException(SQLExceptionHandler, SQLException) - Method in interface cc.carm.lib.easysql.api.SQLAction
- handleStatement(Consumer<PreparedStatement>) - Method in class cc.carm.lib.easysql.action.query.PreparedQueryActionImpl
- handleStatement(Consumer<PreparedStatement>) - Method in interface cc.carm.lib.easysql.api.action.query.PreparedQueryAction
-
直接对
PreparedStatement进行处理 - hasConditionParams() - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- hasConditions() - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
I
- INDEX - cc.carm.lib.easysql.api.enums.IndexType
-
普通索引(由关键字KEY或INDEX定义的索引)的唯一任务是加快对数据的访问速度。
- IndexType - Enum in cc.carm.lib.easysql.api.enums
- InsertBuilder<T extends SQLAction<?>> - Interface in cc.carm.lib.easysql.api.builder
- InsertBuilderImpl<T extends SQLAction<?>> - Class in cc.carm.lib.easysql.builder.impl
- InsertBuilderImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.builder.impl.InsertBuilderImpl
- INT - cc.carm.lib.easysql.api.enums.NumberType
- inTable(String) - Method in interface cc.carm.lib.easysql.api.builder.QueryBuilder
-
创建表查询
- inTable(String) - Method in class cc.carm.lib.easysql.builder.impl.QueryBuilderImpl
- isDebugMode() - Method in interface cc.carm.lib.easysql.api.SQLManager
- isDebugMode() - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
M
- MEDIUMINT - cc.carm.lib.easysql.api.enums.NumberType
- modifyColumn(String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- modifyColumn(String, String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- modifyColumn(String, String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
N
- NO_ACTION - cc.carm.lib.easysql.api.enums.ForeignKeyRule
-
啥也不做
- NumberType - Enum in cc.carm.lib.easysql.api.enums
O
- orderBy(String, boolean) - Method in interface cc.carm.lib.easysql.api.builder.TableQueryBuilder
-
对结果进行排序
- orderBy(String, boolean) - Method in class cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl
- outputDebugMessage() - Method in class cc.carm.lib.easysql.action.AbstractSQLAction
- outputDebugMessage() - Method in class cc.carm.lib.easysql.action.SQLUpdateBatchActionImpl
P
- parseTimeMillis(String) - Static method in class cc.carm.lib.easysql.api.util.TimeDateUtils
-
得到一个时间文本的时间戳
- PreparedQueryAction - Interface in cc.carm.lib.easysql.api.action.query
- PreparedQueryActionImpl - Class in cc.carm.lib.easysql.action.query
- PreparedQueryActionImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.action.query.PreparedQueryActionImpl
- PreparedSQLBatchUpdateActionImpl - Class in cc.carm.lib.easysql.action
- PreparedSQLBatchUpdateActionImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.action.PreparedSQLBatchUpdateActionImpl
- PreparedSQLUpdateAction - Interface in cc.carm.lib.easysql.api.action
- PreparedSQLUpdateActionImpl - Class in cc.carm.lib.easysql.action
- PreparedSQLUpdateActionImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.action.PreparedSQLUpdateActionImpl
- PreparedSQLUpdateActionImpl(SQLManagerImpl, String, Object[]) - Constructor for class cc.carm.lib.easysql.action.PreparedSQLUpdateActionImpl
- PreparedSQLUpdateActionImpl(SQLManagerImpl, String, List<Object>) - Constructor for class cc.carm.lib.easysql.action.PreparedSQLUpdateActionImpl
- PreparedSQLUpdateBatchAction - Interface in cc.carm.lib.easysql.api.action
- PRIMARY_KEY - cc.carm.lib.easysql.api.enums.IndexType
-
主键索引 是唯一索引的特定类型。
Q
- queryAction - Variable in class cc.carm.lib.easysql.query.SQLQueryImpl
- QueryAction - Interface in cc.carm.lib.easysql.api.action.query
-
SQLQueryAction 是用于承载SQL查询语句并进行处理、返回并自动关闭连接的基本类。
- QueryActionImpl - Class in cc.carm.lib.easysql.action.query
- QueryActionImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.action.query.QueryActionImpl
- QueryBuilder - Interface in cc.carm.lib.easysql.api.builder
- QueryBuilderImpl - Class in cc.carm.lib.easysql.builder.impl
- QueryBuilderImpl(SQLManagerImpl) - Constructor for class cc.carm.lib.easysql.builder.impl.QueryBuilderImpl
R
- removeColumn(String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- removeColumn(String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- removeColumnDefault(String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- removeColumnDefault(String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- renameColumn(String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- renameColumn(String, String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- renameTo(String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- renameTo(String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- ReplaceBuilder<T extends SQLAction<?>> - Interface in cc.carm.lib.easysql.api.builder
-
REPLACE 语句用于将一组值更新进数据表中。
- ReplaceBuilderImpl<T extends SQLAction<?>> - Class in cc.carm.lib.easysql.builder.impl
- ReplaceBuilderImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.builder.impl.ReplaceBuilderImpl
- RESTRICT - cc.carm.lib.easysql.api.enums.ForeignKeyRule
-
拒绝删除要求,直到使用删除键值的辅助表被手工删除,并且没有参照时(这是默认设置,也是最安全的设置)
- returnGeneratedKey() - Method in interface cc.carm.lib.easysql.api.action.SQLUpdateAction
-
设定该操作返回自增键序列。
- returnGeneratedKeys() - Method in interface cc.carm.lib.easysql.api.action.PreparedSQLUpdateBatchAction
-
设定该操作返回自增键序列。
S
- selectColumns(String...) - Method in interface cc.carm.lib.easysql.api.builder.TableQueryBuilder
-
选定用于查询的列名
- selectColumns(String...) - Method in class cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl
- SET_DEFAULT - cc.carm.lib.easysql.api.enums.ForeignKeyRule
-
修改包含与已删除键值有参照关系的所有记录,使用默认值替换(只能用于设定了DEFAULT的字段)
- SET_NULL - cc.carm.lib.easysql.api.enums.ForeignKeyRule
-
修改包含与已删除键值有参照关系的所有记录,使用NULL值替换(只能用于已标记为NOT NULL的字段)
- setAllParams(Iterable<Object[]>) - Method in class cc.carm.lib.easysql.action.PreparedSQLBatchUpdateActionImpl
- setAllParams(Iterable<Object[]>) - Method in interface cc.carm.lib.easysql.api.action.PreparedSQLUpdateBatchAction
-
设定多组SQL语句中所有 ?
- setAutoIncrementIndex(int) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- setAutoIncrementIndex(int) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- setColumnDefault(String, String) - Method in interface cc.carm.lib.easysql.api.builder.TableAlterBuilder
- setColumnDefault(String, String) - Method in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- setColumnNames(String...) - Method in interface cc.carm.lib.easysql.api.builder.InsertBuilder
- setColumnNames(String...) - Method in interface cc.carm.lib.easysql.api.builder.ReplaceBuilder
- setColumnNames(String[], String) - Method in interface cc.carm.lib.easysql.api.builder.UpsertBuilder
-
Deprecated.
- setColumnNames(List<String>) - Method in interface cc.carm.lib.easysql.api.builder.InsertBuilder
- setColumnNames(List<String>) - Method in interface cc.carm.lib.easysql.api.builder.ReplaceBuilder
- setColumns(String...) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
直接设定表的所有列信息
- setColumns(String...) - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- setColumnValues(String[], Object[]) - Method in interface cc.carm.lib.easysql.api.builder.UpdateBuilder
- setColumnValues(String[], Object[]) - Method in class cc.carm.lib.easysql.builder.impl.UpdateBuilderImpl
- setColumnValues(String, Object) - Method in interface cc.carm.lib.easysql.api.builder.UpdateBuilder
- setColumnValues(LinkedHashMap<String, Object>) - Method in interface cc.carm.lib.easysql.api.builder.UpdateBuilder
- setColumnValues(LinkedHashMap<String, Object>) - Method in class cc.carm.lib.easysql.builder.impl.UpdateBuilderImpl
- setConditions(String) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- setConditions(String) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- setConditions(LinkedHashMap<String, Object>) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
- setConditions(LinkedHashMap<String, Object>) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- setCustomHandler(SQLExceptionHandler) - Static method in class cc.carm.lib.easysql.api.function.defaults.DefaultSQLExceptionHandler
- setDebugMode(boolean) - Method in interface cc.carm.lib.easysql.api.SQLManager
- setDebugMode(Supplier<Boolean>) - Method in interface cc.carm.lib.easysql.api.SQLManager
- setDebugMode(Supplier<Boolean>) - Method in class cc.carm.lib.easysql.manager.SQLManagerImpl
- setExceptionHandler(SQLExceptionHandler) - Method in interface cc.carm.lib.easysql.api.SQLAction
-
设定通用的异常处理器。
- setIndex(IndexType, String, String, String...) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
设定表中的某列为索引或键。
- setIndex(IndexType, String, String, String...) - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- setIndex(String, IndexType) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
设定表中的某列为索引或键。
- setKeyIndex(int) - Method in interface cc.carm.lib.easysql.api.action.PreparedSQLUpdateBatchAction
-
Deprecated.
- setKeyIndex(int) - Method in interface cc.carm.lib.easysql.api.action.SQLUpdateAction
-
Deprecated.
- setLimit(int) - Method in interface cc.carm.lib.easysql.api.builder.ConditionalBuilder
-
设定取出的条数
- setLimit(int) - Method in class cc.carm.lib.easysql.builder.impl.AbstractConditionalBuilder
- setPageLimit(int, int) - Method in interface cc.carm.lib.easysql.api.builder.TableQueryBuilder
-
限制查询条数,用于分页查询。
- setPageLimit(int, int) - Method in class cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl
- setParams(Iterable<Object>) - Method in class cc.carm.lib.easysql.action.PreparedSQLUpdateActionImpl
- setParams(Iterable<Object>) - Method in class cc.carm.lib.easysql.action.query.PreparedQueryActionImpl
- setParams(Iterable<Object>) - Method in interface cc.carm.lib.easysql.api.action.PreparedSQLUpdateAction
-
设定SQL语句中所有 ?
- setParams(Iterable<Object>) - Method in interface cc.carm.lib.easysql.api.action.query.PreparedQueryAction
-
设定SQL语句中所有 ?
- setParams(Object...) - Method in class cc.carm.lib.easysql.action.query.PreparedQueryActionImpl
- setParams(Object...) - Method in interface cc.carm.lib.easysql.api.action.query.PreparedQueryAction
-
设定SQL语句中所有 ?
- setParams(Object...) - Method in class cc.carm.lib.easysql.action.PreparedSQLUpdateActionImpl
- setParams(Object...) - Method in interface cc.carm.lib.easysql.api.action.PreparedSQLUpdateAction
-
设定SQL语句中所有 ?
- setReturnGeneratedKey(boolean) - Method in class cc.carm.lib.easysql.action.SQLUpdateActionImpl
- setReturnGeneratedKey(boolean) - Method in interface cc.carm.lib.easysql.api.action.SQLUpdateAction
-
设定该操作是否返回自增键序列。
- setReturnGeneratedKeys(boolean) - Method in class cc.carm.lib.easysql.action.PreparedSQLBatchUpdateActionImpl
- setReturnGeneratedKeys(boolean) - Method in interface cc.carm.lib.easysql.api.action.PreparedSQLUpdateBatchAction
-
设定该操作是否返回自增键序列。
- setTableComment(String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
-
设定表的标注,一般用于解释该表的作用。
- setTableComment(String) - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- setTableSettings(String) - Method in interface cc.carm.lib.easysql.api.builder.TableCreateBuilder
- setTableSettings(String) - Method in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- shutdownManager(SQLManager) - Static method in class cc.carm.lib.easysql.EasySQL
- shutdownManager(SQLManager, boolean, boolean) - Static method in class cc.carm.lib.easysql.EasySQL
- SMALLINT - cc.carm.lib.easysql.api.enums.NumberType
- SQLAction<T> - Interface in cc.carm.lib.easysql.api
-
SQLAction 是用于承载SQL语句并进行处理、返回的基本类。
- SQLBuilder - Interface in cc.carm.lib.easysql.api
-
SQLBuilder 是用于构建SQL语句以生成SQLAction执行操作的中间类。
- sqlContent - Variable in class cc.carm.lib.easysql.action.AbstractSQLAction
- SQLExceptionHandler - Interface in cc.carm.lib.easysql.api.function
- SQLFunction<T,R> - Interface in cc.carm.lib.easysql.api.function
- SQLHandler<T> - Interface in cc.carm.lib.easysql.api.function
- sqlManager - Variable in class cc.carm.lib.easysql.query.SQLQueryImpl
- SQLManager - Interface in cc.carm.lib.easysql.api
- SQLManagerImpl - Class in cc.carm.lib.easysql.manager
- SQLManagerImpl(DataSource) - Constructor for class cc.carm.lib.easysql.manager.SQLManagerImpl
- SQLManagerImpl(DataSource, String) - Constructor for class cc.carm.lib.easysql.manager.SQLManagerImpl
- SQLQuery - Interface in cc.carm.lib.easysql.api
- SQLQueryImpl - Class in cc.carm.lib.easysql.query
- SQLQueryImpl(SQLManagerImpl, QueryActionImpl, Connection, Statement, ResultSet) - Constructor for class cc.carm.lib.easysql.query.SQLQueryImpl
- SQLQueryImpl(SQLManagerImpl, QueryActionImpl, Connection, Statement, ResultSet, long) - Constructor for class cc.carm.lib.easysql.query.SQLQueryImpl
- SQLUpdateAction - Interface in cc.carm.lib.easysql.api.action
- SQLUpdateActionImpl - Class in cc.carm.lib.easysql.action
- SQLUpdateActionImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.action.SQLUpdateActionImpl
- SQLUpdateBatchAction - Interface in cc.carm.lib.easysql.api.action
- SQLUpdateBatchActionImpl - Class in cc.carm.lib.easysql.action
- SQLUpdateBatchActionImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.action.SQLUpdateBatchActionImpl
- StatementUtil - Class in cc.carm.lib.easysql.util
- StatementUtil() - Constructor for class cc.carm.lib.easysql.util.StatementUtil
T
- TableAlterBuilder - Interface in cc.carm.lib.easysql.api.builder
- TableAlterBuilderImpl - Class in cc.carm.lib.easysql.builder.impl
- TableAlterBuilderImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- TableCreateBuilder - Interface in cc.carm.lib.easysql.api.builder
- TableCreateBuilderImpl - Class in cc.carm.lib.easysql.builder.impl
- TableCreateBuilderImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- tableName - Variable in class cc.carm.lib.easysql.builder.impl.TableAlterBuilderImpl
- tableName - Variable in class cc.carm.lib.easysql.builder.impl.TableCreateBuilderImpl
- TableQueryBuilder - Interface in cc.carm.lib.easysql.api.builder
- TableQueryBuilderImpl - Class in cc.carm.lib.easysql.builder.impl
- TableQueryBuilderImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.builder.impl.TableQueryBuilderImpl
- TimeDateUtils - Class in cc.carm.lib.easysql.api.util
- TimeDateUtils() - Constructor for class cc.carm.lib.easysql.api.util.TimeDateUtils
- TINYINT - cc.carm.lib.easysql.api.enums.NumberType
- toDHMSStyle(long) - Static method in class cc.carm.lib.easysql.api.util.TimeDateUtils
-
将秒数转化为 DD:hh:mm:ss 格式
- toUUID(String) - Static method in class cc.carm.lib.easysql.api.util.UUIDUtil
U
- UNIQUE_KEY - cc.carm.lib.easysql.api.enums.IndexType
-
唯一索引 是在表上一个或者多个字段组合建立的索引,这个或者这些字段的值组合起来在表中不可以重复,用于保证数据的唯一性。
- UpdateBuilder - Interface in cc.carm.lib.easysql.api.builder
- UpdateBuilderImpl - Class in cc.carm.lib.easysql.builder.impl
- UpdateBuilderImpl(SQLManagerImpl, String) - Constructor for class cc.carm.lib.easysql.builder.impl.UpdateBuilderImpl
- UpsertBuilder - Interface in cc.carm.lib.easysql.api.builder
-
Deprecated.
- UUIDUtil - Class in cc.carm.lib.easysql.api.util
- UUIDUtil() - Constructor for class cc.carm.lib.easysql.api.util.UUIDUtil
V
- valueOf(String) - Static method in enum cc.carm.lib.easysql.api.enums.ForeignKeyRule
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum cc.carm.lib.easysql.api.enums.IndexType
-
Returns the enum constant of this type with the specified name.
- valueOf(String) - Static method in enum cc.carm.lib.easysql.api.enums.NumberType
-
Returns the enum constant of this type with the specified name.
- values() - Static method in enum cc.carm.lib.easysql.api.enums.ForeignKeyRule
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum cc.carm.lib.easysql.api.enums.IndexType
-
Returns an array containing the constants of this enum type, in the order they are declared.
- values() - Static method in enum cc.carm.lib.easysql.api.enums.NumberType
-
Returns an array containing the constants of this enum type, in the order they are declared.
W
- withBackQuote(String) - Static method in interface cc.carm.lib.easysql.api.SQLBuilder
- withPreparedSQL(String) - Method in interface cc.carm.lib.easysql.api.builder.QueryBuilder
-
通过一条 SQL语句创建预查询
- withPreparedSQL(String) - Method in class cc.carm.lib.easysql.builder.impl.QueryBuilderImpl
- withQuote(String) - Static method in interface cc.carm.lib.easysql.api.SQLBuilder
- withSQL(String) - Method in interface cc.carm.lib.easysql.api.builder.QueryBuilder
-
Deprecated.存在SQL注入风险,建议使用
QueryBuilder.withPreparedSQL(String) - withSQL(String) - Method in class cc.carm.lib.easysql.builder.impl.QueryBuilderImpl
-
Deprecated.
All Classes All Packages