MySQL Connector/J 9.2.0 · com.mysql.cj.xdevapi.Table

Method Summary

Modifier and Type	Method and Description
public long	Returns: Number of rows in this table count() Query the number of rows in this table.
public DeleteStatement	Returns: `DeleteStatement` delete() Create a new delete statement.
public InsertStatement	Returns: `InsertStatement` insert() Create an insert statement using the list of all columns in the table.
public InsertStatement	Returns: `InsertStatement` insert(String... one or more projection expressions projection) Create an insert statement using the given list columns.
public InsertStatement	Returns: `InsertStatement` insert(Map<String, Object> table name-value pairs fieldsAndValues) Create an insert statement using the given key/value pairs.
public boolean	Returns: true if this Table is a View isView() Check if the underlying object is a view or not.
public SelectStatement	Returns: `SelectStatement` select(String... one or more projection expressions projections) Create a new select statement using the given projections.
public UpdateStatement	Returns: `UpdateStatement` update() Create a new update statement.

Inherited from com.mysql.cj.xdevapi.DatabaseObject:: existsInDatabase getName getSchema getSession

Method Detail

count	back to summary
public long count() Query the number of rows in this table. Returns:long Number of rows in this table

count

back to summary

public long count()

Query the number of rows in this table.

Returns:long: Number of rows in this table

delete back to summary

delete	back to summary
public DeleteStatement delete() Create a new delete statement. Returns:DeleteStatement `DeleteStatement`

public DeleteStatement delete()

Create a new delete statement.

Returns:DeleteStatement: DeleteStatement

insert back to summary

insert	back to summary
public InsertStatement insert() Create an insert statement using the list of all columns in the table. Returns:InsertStatement `InsertStatement`

public InsertStatement insert()

Create an insert statement using the list of all columns in the table.

Returns:InsertStatement: InsertStatement

insert back to summary

insert	back to summary
public InsertStatement insert(String... projection) Create an insert statement using the given list columns. Parameters projection:String[] one or more projection expressions Returns:InsertStatement `InsertStatement`

public InsertStatement insert(String... projection)

Create an insert statement using the given list columns.

Parameters

projection:String[]: one or more projection expressions

Returns:InsertStatement

InsertStatement

insert back to summary

insert	back to summary
public InsertStatement insert(Map<String, Object> fieldsAndValues) Create an insert statement using the given key/value pairs. Parameters fieldsAndValues:Map<String, Object> table name-value pairs Returns:InsertStatement `InsertStatement`

public InsertStatement insert(Map<String, Object> fieldsAndValues)

Create an insert statement using the given key/value pairs.

Parameters

fieldsAndValues:Map<String, Object>: table name-value pairs

Returns:InsertStatement

InsertStatement

isView	back to summary
public boolean isView() Check if the underlying object is a view or not. Returns:boolean true if this Table is a View

isView

back to summary

public boolean isView()

Check if the underlying object is a view or not.

Returns:boolean: true if this Table is a View

select back to summary

select	back to summary
public SelectStatement select(String... projections) Create a new select statement using the given projections. Parameters projections:String[] one or more projection expressions Returns:SelectStatement `SelectStatement`

public SelectStatement select(String... projections)

Create a new select statement using the given projections.

Parameters

projections:String[]: one or more projection expressions

Returns:SelectStatement

SelectStatement

update back to summary

update	back to summary
public UpdateStatement update() Create a new update statement. Returns:UpdateStatement `UpdateStatement`

public UpdateStatement update()

Create a new update statement.

Returns:UpdateStatement: UpdateStatement

public Interface Table

Method Summary

Method Detail