1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34 package fr.paris.lutece.plugins.dila.business.stylesheet.dao.impl;
35
36 import fr.paris.lutece.plugins.dila.business.stylesheet.DilaStyleSheetAction;
37 import fr.paris.lutece.plugins.dila.business.stylesheet.dao.IDilaStyleSheetActionDAO;
38 import fr.paris.lutece.plugins.dila.service.DilaPlugin;
39 import fr.paris.lutece.portal.service.plugin.PluginService;
40 import fr.paris.lutece.util.sql.DAOUtil;
41
42 import java.io.Serializable;
43
44 import java.util.ArrayList;
45 import java.util.List;
46
47
48
49
50
51
52 public class DilaStyleSheetActionDAO implements IDilaStyleSheetActionDAO, Serializable
53 {
54
55 private static final long serialVersionUID = -7176177683841731993L;
56 private static final String SQL_QUERY_SELECT_ACTIONS = "SELECT a.name_key, a.description_key, a.action_url, a.icon_url, a.action_permission " +
57 " FROM dila_action a ";
58
59 @Override
60 public List<DilaStyleSheetAction> selectActions( )
61 {
62 List<DilaStyleSheetAction> listActions = new ArrayList<DilaStyleSheetAction>( );
63 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_ACTIONS, PluginService.getPlugin( DilaPlugin.PLUGIN_NAME ) );
64 daoUtil.executeQuery( );
65
66 while ( daoUtil.next( ) )
67 {
68 DilaStyleSheetAction action = new DilaStyleSheetAction( );
69 action.setNameKey( daoUtil.getString( 1 ) );
70 action.setDescriptionKey( daoUtil.getString( 2 ) );
71 action.setURL( daoUtil.getString( 3 ) );
72 action.setIconUrl( daoUtil.getString( 4 ) );
73 action.setPermission( daoUtil.getString( 5 ) );
74 listActions.add( action );
75 }
76
77 daoUtil.free( );
78
79 return listActions;
80 }
81 }