org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager Class Reference

Inheritance diagram for org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager:

org.openmobileis.common.util.database.AbstractQueryManager org.openmobileis.synchro.algo.syncnumber.impl.SyncNumberQueryManager List of all members.

Detailed Description

Title: OpenMobileIS project source
Description: This class manages the synchronization number For each user, a number is associated with the synchronization to manage the incremental sync.

Data mapping is made for InstantDB database

Author:
Philippe Delrieu
Since:
JDK 1.1
Version:
1.0.

Definition at line 44 of file MSSQLSyncNumberQueryManager.java.

Public Member Functions

 MSSQLSyncNumberQueryManager ()
 MSSQLSyncNumberQueryManager (JdbcPoolManagerDB pool)
void create (String parameters[]) throws DatabaseException
 create() insert a new version number for a user ID.
void createSyncTable () throws DatabaseException, java.sql.SQLException
 check if the sync table exists.
void delete (String parameters[]) throws DatabaseException
 delete() delete a synchronisation from the USERID
void update (String parameters[]) throws DatabaseException
 update() update a synchronisation : Not used here (same as create)
ResultSet getTimeStampForsn (String parameters[]) throws DatabaseException
 getLastSyncNumberbysn() get the sync number with specified ns
ResultSet getLastSyncNumber () throws DatabaseException
 getLastSyncNumber() get the last sync number
ResultSet getSyncNumberbysn (String parameters[]) throws DatabaseException
 getLastSyncNumberbysn() get the sync number with specified ns


Member Function Documentation

void org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager.create ( String  parameters[]  )  throws DatabaseException

create() insert a new version number for a user ID.

Create the user Id if it does not exist.

Parameters:
Array containing a String parameters representing the variable values giving the USERID, VERSION_NB Refer to the database schema for more details
Returns:
None
Exceptions:
None 

Implements org.openmobileis.synchro.algo.syncnumber.impl.SyncNumberQueryManager.

Definition at line 95 of file MSSQLSyncNumberQueryManager.java.

void org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager.createSyncTable (  )  throws DatabaseException, java.sql.SQLException

check if the sync table exists.

IF it does not exist, create it

Implements org.openmobileis.synchro.algo.syncnumber.impl.SyncNumberQueryManager.

Definition at line 102 of file MSSQLSyncNumberQueryManager.java.

References org.openmobileis.common.util.database.AbstractQueryManager.executeUpdate().

void org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager.delete ( String  parameters[]  )  throws DatabaseException

delete() delete a synchronisation from the USERID

Parameters:
Array containing a String parameters : USERID
Returns:
None
Exceptions:
None 

Implements org.openmobileis.synchro.algo.syncnumber.impl.SyncNumberQueryManager.

Definition at line 132 of file MSSQLSyncNumberQueryManager.java.

References org.openmobileis.common.util.database.AbstractQueryManager.executeUpdate().

void org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager.update ( String  parameters[]  )  throws DatabaseException

update() update a synchronisation : Not used here (same as create)

Parameters:
Array containing a String parameters
Returns:
None
Exceptions:
None 

Implements org.openmobileis.synchro.algo.syncnumber.impl.SyncNumberQueryManager.

Definition at line 142 of file MSSQLSyncNumberQueryManager.java.

ResultSet org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager.getTimeStampForsn ( String  parameters[]  )  throws DatabaseException

getLastSyncNumberbysn() get the sync number with specified ns

Parameters:
: array containing sync number
Returns:
ResultSet : A unique row containing the sunc num (int)
Exceptions:
None 

Definition at line 153 of file MSSQLSyncNumberQueryManager.java.

References org.openmobileis.common.util.database.AbstractQueryManager.executeQuery().

ResultSet org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager.getLastSyncNumber (  )  throws DatabaseException

getLastSyncNumber() get the last sync number

Returns:
ResultSet : A unique row containing the sunc num (int)
Exceptions:
None 

Implements org.openmobileis.synchro.algo.syncnumber.impl.SyncNumberQueryManager.

Definition at line 162 of file MSSQLSyncNumberQueryManager.java.

References org.openmobileis.common.util.database.AbstractQueryManager.executeQuery().

ResultSet org.openmobileis.synchro.algo.syncnumber.impl.MSSQLSyncNumberQueryManager.getSyncNumberbysn ( String  parameters[]  )  throws DatabaseException

getLastSyncNumberbysn() get the sync number with specified ns

Parameters:
: array containing sync number
Returns:
ResultSet : A unique row containing the sunc num (int)
Exceptions:
None 

Implements org.openmobileis.synchro.algo.syncnumber.impl.SyncNumberQueryManager.

Definition at line 172 of file MSSQLSyncNumberQueryManager.java.


The documentation for this class was generated from the following file:
Generated on Mon Dec 4 11:03:41 2006 for OpenMobileIS by  doxygen 1.5.1-p1