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.directory.business.parameter;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.ReferenceItem;
38 import fr.paris.lutece.util.ReferenceList;
39 import fr.paris.lutece.util.sql.DAOUtil;
40
41
42
43
44
45
46 public class EntryParameterDAO implements IEntryParameterDAO
47 {
48 private static final String TRUE = "1";
49 private static final String SQL_QUERY_SELECT = " SELECT parameter_value FROM directory_entry_parameter WHERE parameter_key = ? ";
50 private static final String SQL_QUERY_UPDATE = " UPDATE directory_entry_parameter SET parameter_value = ? WHERE parameter_key = ? ";
51 private static final String SQL_QUERY_SELECT_ALL = " SELECT parameter_key, parameter_value FROM directory_entry_parameter ORDER BY parameter_key ASC ";
52
53
54
55
56 @Override
57 public ReferenceList selectAll( Plugin plugin )
58 {
59 ReferenceList listParams = new ReferenceList( );
60 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_ALL, plugin );
61 daoUtil.executeQuery( );
62
63 while ( daoUtil.next( ) )
64 {
65 ReferenceItem param = new ReferenceItem( );
66 param.setCode( daoUtil.getString( 1 ) );
67 param.setName( daoUtil.getString( 2 ) );
68 param.setChecked( param.getName( ).equals( TRUE ) ? true : false );
69 listParams.add( param );
70 }
71
72 daoUtil.free( );
73
74 return listParams;
75 }
76
77
78
79
80 @Override
81 public ReferenceItem load( String strParameterKey, Plugin plugin )
82 {
83 ReferenceItem param = null;
84 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, plugin );
85 daoUtil.setString( 1, strParameterKey );
86 daoUtil.executeQuery( );
87
88 if ( daoUtil.next( ) )
89 {
90 param = new ReferenceItem( );
91 param.setCode( strParameterKey );
92 param.setName( daoUtil.getString( 1 ) );
93 }
94
95 daoUtil.free( );
96
97 return param;
98 }
99
100
101
102
103 @Override
104 public void store( ReferenceItem param, Plugin plugin )
105 {
106 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, plugin );
107
108 daoUtil.setString( 1, param.getName( ) );
109 daoUtil.setString( 2, param.getCode( ) );
110
111 daoUtil.executeUpdate( );
112 daoUtil.free( );
113 }
114 }