fr.paris.lutece.plugins.adminsql.business

Interface IDataDAO

All Known Implementing Classes:

DataDAO

public interface IDataDAO

Lists all methods which are in DataDAO

Method Summary

Modifier and Type	Method and Description
void	delete(String strPoolName, String strTableName, List<String> listConcatFieldNameAndData, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService) Delete a row
List<List<String>>	findResultOfUserRequest(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService) Find all data from user request
void	insert(String strPoolName, String strTableName, List<String> listData, List<String> listFieldsNames, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService) Insert into a table of a database
void	insertWithUserRequest(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService, String strPoolName) Insert into a table of a database with user request
List<List<String>>	load(String strTableName, String strContatFieldNameAndData, List<Field> listFields, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService) Find all data in a table
List<String>	selectColumnNames(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService, String strPoolName) Find the names of the columns
List<List<String>>	selectDataList(String strTableName, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService) Selects and loads into the Data object all the data from the database
List<List<String>>	selectDataListUserRequest(String strPoolName, String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService) Creates a new instance of IDataDAO
void	store(String strPoolName, String strTableName, List<FieldValues> listFieldValues, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService) Store the row modified

Method Detail

selectDataList

List<List<String>> selectDataList(String strTableName,
                                  fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)

Selects and loads into the Data object all the data from the database

Parameters:

strTableName - the name of the table

connectionService - PluginConnectionService object

Returns:

the list of data

selectDataListUserRequest

List<List<String>> selectDataListUserRequest(String strPoolName,
                                             String strUserRequest,
                                             fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)

Creates a new instance of IDataDAO

Parameters:

strPoolName - the name of the pool

strUserRequest - user request

connectionService - PluginConnectionService object

Returns:

the list of data from user request

insert

void insert(String strPoolName,
            String strTableName,
            List<String> listData,
            List<String> listFieldsNames,
            fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)

Insert into a table of a database

Parameters:

strPoolName - the name of the pool

strTableName - the name of the table

listData - the list of data

listFieldsNames - the list of field names

connectionService - PluginConnectionService object

insertWithUserRequest

void insertWithUserRequest(String strUserRequest,
                           fr.paris.lutece.portal.service.database.PluginConnectionService connectionService,
                           String strPoolName)

Insert into a table of a database with user request

Parameters:

strUserRequest - user request

connectionService - PluginConnectionService object

strPoolName - the name of the pool

load

List<List<String>> load(String strTableName,
                        String strContatFieldNameAndData,
                        List<Field> listFields,
                        fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)

Find all data in a table

Parameters:

strTableName - the name of the table

strContatFieldNameAndData - the concatenation of the field name and the data

listFields - the list of the fields

connectionService - PluginConnectionService object

Returns:

the list of all data in a table

findResultOfUserRequest

List<List<String>> findResultOfUserRequest(String strUserRequest,
                                           fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)

Find all data from user request

Parameters:

strUserRequest - user request

connectionService - PluginConnectionService object

Returns:

list of data from user request

selectColumnNames

List<String> selectColumnNames(String strUserRequest,
                               fr.paris.lutece.portal.service.database.PluginConnectionService connectionService,
                               String strPoolName)

Find the names of the columns

Parameters:

strUserRequest - user request

connectionService - PluginConnectionService object

strPoolName - the name of the pool

Returns:

all names of the columns

store

void store(String strPoolName,
           String strTableName,
           List<FieldValues> listFieldValues,
           fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)

Store the row modified

Parameters:

strPoolName - the name of the pool

strTableName - the name of the table

listFieldValues - list of the fields values

connectionService - PluginConnectionService object

delete

void delete(String strPoolName,
            String strTableName,
            List<String> listConcatFieldNameAndData,
            fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)

Delete a row

Parameters:

strPoolName - the name of the pool

strTableName - the name of the table

listConcatFieldNameAndData - the concatenation of the field name and the data

connectionService - PluginConnectionService object