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