com.scooterframework.orm.sqldataexpress.service
Interface SqlServiceSpecific

All Known Subinterfaces:
SqlService
All Known Implementing Classes:
SqlServiceImpl

public interface SqlServiceSpecific

SqlServiceSpecific interface specified services that are specific.


Method Summary
 int delete(java.util.Map<java.lang.String,java.lang.Object> inputs, java.lang.String processorType, java.lang.String processorName)
          Delete data from database.
 void insert(java.util.Map<java.lang.String,java.lang.Object> inputs, java.lang.String processorType, java.lang.String processorName)
          Insert data to database.
 TableData retrieveRow(java.util.Map<java.lang.String,java.lang.Object> inputs, java.lang.String processorType, java.lang.String processorName)
          Retrieve a single row data from database.
 TableData retrieveRows(java.util.Map<java.lang.String,java.lang.Object> inputs, java.lang.String processorType, java.lang.String processorName)
          Retrieve a list of rows from database.
 TableData retrieveRows(java.util.Map<java.lang.String,java.lang.Object> inputs, java.lang.String processorType, java.lang.String processorName, int limitOrFixed)
          Retrieve a list of rows from database with a certain limit range.
 TableData retrieveRows(java.util.Map<java.lang.String,java.lang.Object> inputs, java.lang.String processorType, java.lang.String processorName, int limitOrFixed, int offset)
          Retrieve a list of rows from database with a certain limit range.
 int update(java.util.Map<java.lang.String,java.lang.Object> inputs, java.lang.String processorType, java.lang.String processorName)
          Update data in database.
 

Method Detail

retrieveRow

TableData retrieveRow(java.util.Map<java.lang.String,java.lang.Object> inputs,
                      java.lang.String processorType,
                      java.lang.String processorName)
                      throws BaseSQLException
Retrieve a single row data from database.

Parameters:
inputs - Map of input data
processorType - A named SQL or direct SQL or stored procedure
processorName - SQL name or SQL itself or stored procedure name
Returns:
TableData The row data
Throws:
BaseSQLException

retrieveRows

TableData retrieveRows(java.util.Map<java.lang.String,java.lang.Object> inputs,
                       java.lang.String processorType,
                       java.lang.String processorName)
                       throws BaseSQLException
Retrieve a list of rows from database.

Parameters:
inputs - Map of input data
processorType - A named SQL or direct SQL or stored procedure
processorName - SQL name or SQL itself or stored procedure name
Returns:
TableData The list of row data
Throws:
BaseSQLException

retrieveRows

TableData retrieveRows(java.util.Map<java.lang.String,java.lang.Object> inputs,
                       java.lang.String processorType,
                       java.lang.String processorName,
                       int limitOrFixed)
                       throws BaseSQLException
Retrieve a list of rows from database with a certain limit range. If the number of returned records is more than the preset limit range, an UnexpectedDataException will be thrown. If DataProcessor.input_key_records_fixed key has value "true" in inputs, absolute fixed number of records is required. An UnexpectedDataException will be thrown if the number of retrieved records is not equal to limitOrFixed. If the limitOrFixed = -1, all records are retrieved.

Parameters:
inputs - Map of input data
processorType - A named SQL or direct SQL or stored procedure
processorName - SQL name or SQL itself or stored procedure name
limitOrFixed - Number of desired (limit) or fixed records to retrieve
Returns:
TableData The row data
Throws:
BaseSQLException

retrieveRows

TableData retrieveRows(java.util.Map<java.lang.String,java.lang.Object> inputs,
                       java.lang.String processorType,
                       java.lang.String processorName,
                       int limitOrFixed,
                       int offset)
                       throws BaseSQLException
Retrieve a list of rows from database with a certain limit range. If the number of returned records is more than the preset limit range, an UnexpectedDataException will be thrown. If DataProcessor.input_key_records_fixed key has value "true" in inputs, absolute fixed number of records is required. An UnexpectedDataException will be thrown if the number of retrieved records is not equal to limitOrFixed. If the limitOrFixed = -1, all records are retrieved. offset defaults to 0.

Parameters:
inputs - Map of input data
processorType - A named SQL or direct SQL or stored procedure
processorName - SQL name or SQL itself or stored procedure name
limitOrFixed - Number of desired (limit) or fixed records to retrieve
offset - int for offset
Returns:
TableData The row data
Throws:
BaseSQLException

insert

void insert(java.util.Map<java.lang.String,java.lang.Object> inputs,
            java.lang.String processorType,
            java.lang.String processorName)
            throws BaseSQLException
Insert data to database.

Parameters:
inputs - Map of input data
processorType - A named SQL or direct SQL or stored procedure
processorName - SQL name or SQL itself or stored procedure name
Throws:
BaseSQLException

delete

int delete(java.util.Map<java.lang.String,java.lang.Object> inputs,
           java.lang.String processorType,
           java.lang.String processorName)
           throws BaseSQLException
Delete data from database.

Parameters:
inputs - Map of input data
processorType - A named SQL or direct SQL or stored procedure
processorName - SQL name or SQL itself or stored procedure name
Returns:
int number of rows deleted
Throws:
BaseSQLException

update

int update(java.util.Map<java.lang.String,java.lang.Object> inputs,
           java.lang.String processorType,
           java.lang.String processorName)
           throws BaseSQLException
Update data in database.

Parameters:
inputs - Map of input data
processorType - A named SQL or direct SQL or stored procedure
processorName - SQL name or SQL itself or stored procedure name
Returns:
int number of rows updated
Throws:
BaseSQLException