Package cc.carm.lib.easysql.api

Class SQLTable

java.lang.Object

cc.carm.lib.easysql.api.SQLTable

public abstract class SQLTable
extends java.lang.Object

SQLTable 基于 TableCreateBuilder 构建表，用于快速创建与该表相关的操作。

• 1. 调用 of(String, String[]) 方法创建一个 SQLTable 对象;
• 2. 在应用初始化阶段调用 create(SQLManager) 方法初始化 SQLTable 对象;
• 3. 获取已创建的SQLTable 实例，直接调用对应方法进行关于表的相关操作。

Since:

0.3.10

Author:

CarmJos

Field Summary

Fields

Modifier and Type	Field	Description
protected SQLManager	manager
protected java.lang.String	tablePrefix

Method Summary

Modifier and Type	Method	Description
boolean	create(@NotNull SQLManager sqlManager)
abstract boolean	create(@NotNull SQLManager sqlManager, @Nullable java.lang.String tablePrefix)	使用指定 SQLManager 进行本示例的初始化。
@NotNull DeleteBuilder	createDelete()
@NotNull DeleteBuilder	createDelete(@NotNull SQLManager sqlManager)
@NotNull InsertBuilder<PreparedSQLUpdateAction<java.lang.Integer>>	createInsert()
@NotNull InsertBuilder<PreparedSQLUpdateAction<java.lang.Integer>>	createInsert(@NotNull SQLManager sqlManager)
@NotNull InsertBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>>	createInsertBatch()
@NotNull InsertBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>>	createInsertBatch(@NotNull SQLManager sqlManager)
@NotNull TableQueryBuilder	createQuery()
@NotNull TableQueryBuilder	createQuery(@NotNull SQLManager sqlManager)
@NotNull ReplaceBuilder<PreparedSQLUpdateAction<java.lang.Integer>>	createReplace()
@NotNull ReplaceBuilder<PreparedSQLUpdateAction<java.lang.Integer>>	createReplace(@NotNull SQLManager sqlManager)
@NotNull ReplaceBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>>	createReplaceBatch()
@NotNull ReplaceBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>>	createReplaceBatch(@NotNull SQLManager sqlManager)
@NotNull UpdateBuilder	createUpdate()
@NotNull UpdateBuilder	createUpdate(@NotNull SQLManager sqlManager)
@NotNull java.lang.String	getTableName()
static @NotNull SQLTable	of(@NotNull java.lang.String tableName, @NotNull java.lang.String[] columns)
static @NotNull SQLTable	of(@NotNull java.lang.String tableName, @NotNull java.lang.String[] columns, @Nullable java.lang.String tableSettings)
static @NotNull SQLTable	of(@NotNull java.lang.String tableName, @Nullable SQLHandler<TableCreateBuilder> table)

Methods inherited from class java.lang.Object

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

Field Detail

tablePrefix

protected java.lang.String tablePrefix

manager

protected SQLManager manager

Method Detail

of

@NotNull
public static @NotNull SQLTable of(@NotNull
                                   @NotNull java.lang.String tableName,
                                   @Nullable
                                   @Nullable SQLHandler<TableCreateBuilder> table)

of

@NotNull
public static @NotNull SQLTable of(@NotNull
                                   @NotNull java.lang.String tableName,
                                   @NotNull
                                   @NotNull java.lang.String[] columns)

of

@NotNull
public static @NotNull SQLTable of(@NotNull
                                   @NotNull java.lang.String tableName,
                                   @NotNull
                                   @NotNull java.lang.String[] columns,
                                   @Nullable
                                   @Nullable java.lang.String tableSettings)

getTableName

@NotNull
public @NotNull java.lang.String getTableName()

create

public abstract boolean create(@NotNull
                               @NotNull SQLManager sqlManager,
                               @Nullable
                               @Nullable java.lang.String tablePrefix)
                        throws java.sql.SQLException

使用指定 SQLManager 进行本示例的初始化。

Parameters:

sqlManager - SQLManager

tablePrefix - 表名前缀

Returns:

本表是否为首次创建

Throws:

java.sql.SQLException - 出现任何错误时抛出

create

public boolean create(@NotNull
                      @NotNull SQLManager sqlManager)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

createQuery

@NotNull
public @NotNull TableQueryBuilder createQuery(@NotNull
                                              @NotNull SQLManager sqlManager)

createQuery

@NotNull
public @NotNull TableQueryBuilder createQuery()

createDelete

@NotNull
public @NotNull DeleteBuilder createDelete()

createDelete

@NotNull
public @NotNull DeleteBuilder createDelete(@NotNull
                                           @NotNull SQLManager sqlManager)

createUpdate

@NotNull
public @NotNull UpdateBuilder createUpdate()

createUpdate

@NotNull
public @NotNull UpdateBuilder createUpdate(@NotNull
                                           @NotNull SQLManager sqlManager)

createInsert

@NotNull
public @NotNull InsertBuilder<PreparedSQLUpdateAction<java.lang.Integer>> createInsert()

createInsert

@NotNull
public @NotNull InsertBuilder<PreparedSQLUpdateAction<java.lang.Integer>> createInsert(@NotNull
                                                                                       @NotNull SQLManager sqlManager)

createInsertBatch

@NotNull
public @NotNull InsertBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>> createInsertBatch()

createInsertBatch

@NotNull
public @NotNull InsertBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>> createInsertBatch(@NotNull
                                                                                                 @NotNull SQLManager sqlManager)

createReplace

@NotNull
public @NotNull ReplaceBuilder<PreparedSQLUpdateAction<java.lang.Integer>> createReplace()

createReplace

@NotNull
public @NotNull ReplaceBuilder<PreparedSQLUpdateAction<java.lang.Integer>> createReplace(@NotNull
                                                                                         @NotNull SQLManager sqlManager)

createReplaceBatch

@NotNull
public @NotNull ReplaceBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>> createReplaceBatch()

createReplaceBatch

@NotNull
public @NotNull ReplaceBuilder<PreparedSQLUpdateBatchAction<java.lang.Integer>> createReplaceBatch(@NotNull
                                                                                                   @NotNull SQLManager sqlManager)