Constructor and Description |
---|
DataDAO() |
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 in a table
|
List<List<String>> |
findResultOfUserRequest(String strUserRequest,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Result of user request
|
void |
insert(String strPoolName,
String strTableName,
List<String> listData,
List<String> listFieldsNames,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Insert data in table
|
void |
insertWithUserRequest(String strUserRequest,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService,
String strPoolName)
Insert the data with user request
|
List<List<String>> |
load(String strTableName,
String strContatFieldNameAndData,
List<Field> listFields,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Find the list of data of a table
|
List<String> |
selectColumnNames(String strUserRequest,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService,
String strPoolName)
Find the names of all 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)
Selects and loads into the Data object all the data from the database in user request
|
void |
store(String strPoolName,
String strTableName,
List<FieldValues> listFieldValues,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Store the data in tha table in a database
|
public List<List<String>> selectDataList(String strTableName, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
selectDataList
in interface IDataDAO
strTableName
- the name of the tableconnectionService
- PluginConnectionService Objectpublic List<List<String>> selectDataListUserRequest(String strPoolName, String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
selectDataListUserRequest
in interface IDataDAO
strPoolName
- the name of the poolstrUserRequest
- user requestconnectionService
- PluginConnectionService Objectpublic void insert(String strPoolName, String strTableName, List<String> listData, List<String> listFieldsNames, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
public void store(String strPoolName, String strTableName, List<FieldValues> listFieldValues, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
public void delete(String strPoolName, String strTableName, List<String> listConcatFieldNameAndData, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
public void insertWithUserRequest(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService, String strPoolName)
insertWithUserRequest
in interface IDataDAO
strUserRequest
- user requestconnectionService
- PluginConnectionService objectstrPoolName
- the name of the poolpublic List<List<String>> load(String strTableName, String strContatFieldNameAndData, List<Field> listFields, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
public List<List<String>> findResultOfUserRequest(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
findResultOfUserRequest
in interface IDataDAO
strUserRequest
- user requestconnectionService
- PluginConnectionService objectpublic List<String> selectColumnNames(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService, String strPoolName)
selectColumnNames
in interface IDataDAO
strUserRequest
- user requestconnectionService
- PluginConnectionService objectstrPoolName
- the name of the poolCopyright © 2018 City of Paris. All rights reserved.