|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectcom.dhtmlx.connector.DataWrapper
com.dhtmlx.connector.DBDataWrapper
com.dhtmlx.connector.MSSQLDBDataWrapper
public class MSSQLDBDataWrapper
The Class MSSQLDBDataWrapper.
Field Summary | |
---|---|
private int |
start_from
The start index |
Fields inherited from class com.dhtmlx.connector.DataWrapper |
---|
config, connection |
Constructor Summary | |
---|---|
MSSQLDBDataWrapper()
|
Method Summary | |
---|---|
java.lang.String |
escape(java.lang.String data)
Escape the data, befor using in SQL |
java.lang.String |
get_new_id(ConnectorResultSet result)
Gets the new id |
protected java.sql.Statement |
getStatement()
Gets the statement |
protected java.lang.String |
select_query(java.lang.String select,
java.lang.String from,
java.lang.String where,
java.lang.String sort,
java.lang.String start,
java.lang.String count)
Generates sql for select query |
ConnectorResultSet |
select(DataRequest source)
Select data from storage |
Methods inherited from class com.dhtmlx.connector.DBDataWrapper |
---|
attach, begin_transaction, build_order, build_where, commit_transaction, delete, get_connection, get_size, get_sql, get_variants, insert_query, insert, query, rollback_transaction, sequence, update |
Methods inherited from class com.dhtmlx.connector.DataWrapper |
---|
init, is_global_transaction, is_record_transaction, set_transaction_mode |
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
private int start_from
Constructor Detail |
---|
public MSSQLDBDataWrapper()
Method Detail |
---|
public java.lang.String escape(java.lang.String data)
DBDataWrapper
escape
in class DBDataWrapper
data
- the incoming data
public java.lang.String get_new_id(ConnectorResultSet result) throws ConnectorOperationException
DBDataWrapper
get_new_id
in class DBDataWrapper
result
- the resultset, which contains the new ID
ConnectorOperationException
- the connector operation exceptionprotected java.lang.String select_query(java.lang.String select, java.lang.String from, java.lang.String where, java.lang.String sort, java.lang.String start, java.lang.String count)
DBDataWrapper
select_query
in class DBDataWrapper
select
- the list of fieldsfrom
- the name of tablewhere
- the filtering rulessort
- the sorting rulesstart
- the start indexcount
- the count of records to fetch
protected java.sql.Statement getStatement() throws java.sql.SQLException
DBDataWrapper
getStatement
in class DBDataWrapper
java.sql.SQLException
- the SQL exceptionpublic ConnectorResultSet select(DataRequest source) throws ConnectorOperationException
DataWrapper
select
in class DBDataWrapper
source
- the source defined by DataRequest object
ConnectorOperationException
- the connector operation exception
|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |