com.ajaxjs.sqlman

类 Action

java.lang.Object

com.ajaxjs.sqlman.Action

public class Action
extends Object

The gateway for database actions. A value object with input Sql, data and config.

构造器概要

构造器

构造器和说明
Action(Connection conn)
Action(Connection conn, Map<String,Object> entity, String tableName)
Action(Connection conn, Object entity)
Action(Connection conn, Object entity, String tableName)
Action(Connection conn, String sql)
Action(DataSource dataSource) Create a new action.
Action(Map<String,Object> entity, String tableName)
Action(Object entity)
Action(Object entity, String tableName)
Action(String sql) Create a new action.

方法概要

限定符和类型	方法和说明
Create	create(Object... params) Initialize a create action.
UpdateResult	delete(String tableName, String idField, Serializable id) Execute delete operation.
UpdateResult	deleteWhere(String tableName, String where) Execute delete operation.
Query	query(Object... params) Initialize a query action.
Action	setParams(Object... params)
Update	update(Object... params) Initialize an update action.

从类继承的方法 java.lang.Object

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

构造器详细资料

Action

public Action(DataSource dataSource)

Create a new action.

参数:

dataSource - The data source to be used to obtain the connection.

Action

public Action(Connection conn)

Action

public Action(Map<String,Object> entity,
              String tableName)

Action

public Action(Connection conn,
              Map<String,Object> entity,
              String tableName)

Action

public Action(Object entity,
              String tableName)

Action

public Action(Connection conn,
              Object entity,
              String tableName)

Action

public Action(Object entity)

Action

public Action(Connection conn,
              Object entity)

Action

public Action(String sql)

Create a new action. Default way to initialize the connection. Obtained a connection from local thread.

参数:

sql - The input sql.

Action

public Action(Connection conn,
              String sql)

方法详细资料

setParams

public Action setParams(Object... params)

query

public Query query(Object... params)

Initialize a query action.

参数:

params - The parameters to be bound to the sql

返回:

The query action.

create

public Create create(Object... params)

Initialize a create action.

参数:

params - The parameters to be bound to the sql

返回:

The creation action.

update

public Update update(Object... params)

Initialize an update action.

参数:

params - The parameters to be bound to the sql

返回:

The update action.

delete

public UpdateResult delete(String tableName,
                           String idField,
                           Serializable id)

Execute delete operation. The only argument needed for delete operation is the `connection` when constructing the action, and then is: tableName, idField and id. This is a physical deletion. If you want to delete a logical deletion, please use the update method.

参数:

tableName - Which table?

idField - The name of the field

id - The value of id field

返回:

The result object, contains effected rows.

deleteWhere

public UpdateResult deleteWhere(String tableName,
                                String where)

Execute delete operation. The only argument needed for delete operation is the `connection` when constructing the action, and then is: tableName, where clause. This is a physical deletion. If you want to delete a logical deletion, please use the update method.

参数:

tableName - Which table?

where - The where clause

返回:

The result object, contains effected rows.