public class DataHome extends Object
Constructor and Description |
---|
DataHome() |
Modifier and Type | Method and Description |
---|---|
static List<String> |
create(String strPoolName,
String strTableName,
List<String> listData,
List<String> listFieldsNames,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Create an instance of data
|
static void |
createWithUserRequest(String strUserRequest,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService,
String strPoolName)
Create an instance of data with user request
|
static List<List<String>> |
findAll(String strTableName,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Creates a new instance of DataHome
|
static List<List<String>> |
findAllInUserRequest(String strPoolName,
String strUserRequest,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
List of data of user request
|
static List<List<String>> |
findByPrimaryKey(String strTableName,
String strContatFieldNameAndData,
List<Field> listFields,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
find a row of a table
|
static List<String> |
findFieldsNames(String strUserRequest,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService,
String strPoolName)
Find fields names of a table for user request
|
static void |
remove(String strPoolName,
String strTableName,
List<String> listConcatFieldNameAndData,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Delete a row
|
static void |
update(String strPoolName,
String strTableName,
List<FieldValues> listFieldValues,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Update a row in a table
|
static List<List<String>> |
userRequest(String strUserRequest,
fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
Result of a select request type
|
public static List<List<String>> findAll(String strTableName, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
strTableName
- Name of the tableconnectionService
- Plugin connectionServicepublic static List<List<String>> findAllInUserRequest(String strPoolName, String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
strPoolName
- Name of the poolstrUserRequest
- User RequestconnectionService
- PluginConnectionServicepublic static List<String> create(String strPoolName, String strTableName, List<String> listData, List<String> listFieldsNames, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
strPoolName
- the name of the current poolstrTableName
- the name of the tablelistData
- data to insertlistFieldsNames
- fields of a tableconnectionService
- PluginConnectionServicepublic static void createWithUserRequest(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService, String strPoolName)
strUserRequest
- user requestconnectionService
- PluginConnctionSerice objectstrPoolName
- the name of the poolpublic static List<List<String>> findByPrimaryKey(String strTableName, String strContatFieldNameAndData, List<Field> listFields, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
strTableName
- the name of the tablestrContatFieldNameAndData
- the concatenation of the field name and the datalistFields
- list of field tableconnectionService
- PluginConnectionService objectpublic static List<List<String>> userRequest(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
strUserRequest
- user requestconnectionService
- PluginConnectionService objectpublic static List<String> findFieldsNames(String strUserRequest, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService, String strPoolName)
strUserRequest
- user requestconnectionService
- PluginConnectionService objectstrPoolName
- the name of the poolpublic static void update(String strPoolName, String strTableName, List<FieldValues> listFieldValues, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
strPoolName
- the name of the poolstrTableName
- the name of the tablelistFieldValues
- list of table fieldsconnectionService
- PluginConnectionService objectpublic static void remove(String strPoolName, String strTableName, List<String> listConcatFieldNameAndData, fr.paris.lutece.portal.service.database.PluginConnectionService connectionService)
strPoolName
- the name of the poolstrTableName
- the name of the tablelistConcatFieldNameAndData
- list of concatenation of field name and dataconnectionService
- PluginConnectionService objectCopyright © 2018 City of Paris. All rights reserved.