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.tagcloud.business.portlet;
35
36 import fr.paris.lutece.portal.business.portlet.Portlet;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39 import java.util.ArrayList;
40 import java.util.Collection;
41
42
43
44
45
46 public final class TagCloudPortletDAO implements ITagCloudPortletDAO
47 {
48
49 private static final String SQL_QUERY_SELECT = "SELECT id_portlet, id_cloud FROM tagcloud_portlet WHERE id_portlet = ?";
50 private static final String SQL_QUERY_INSERT = "INSERT INTO tagcloud_portlet ( id_portlet, id_cloud ) VALUES ( ?, ? ) ";
51 private static final String SQL_QUERY_DELETE = "DELETE FROM tagcloud_portlet WHERE id_portlet = ? ";
52 private static final String SQL_QUERY_UPDATE = "UPDATE tagcloud_portlet SET id_portlet = ?, id_cloud = ? WHERE id_portlet = ?";
53 private static final String SQL_QUERY_SELECTALL = "SELECT id_portlet, id_cloud FROM tagcloud_portlet";
54 private static final String SQL_QUERY_SELECT_TAGCLOUD_BY_PORTLET = "SELECT id_cloud FROM tagcloud_portlet WHERE id_portlet = ?";
55
56
57
58
59
60
61 public void insert( TagCloudPortlet tagCloudPortlet )
62 {
63 }
64
65
66
67
68
69
70
71 public TagCloudPortlet load( int nId )
72 {
73 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT );
74 daoUtil.setInt( 1, nId );
75 daoUtil.executeQuery( );
76
77 TagCloudPortlet tagCloudPortlet = null;
78
79 if ( daoUtil.next( ) )
80 {
81 tagCloudPortlet = new TagCloudPortlet( );
82
83 tagCloudPortlet.setIdPortlet( daoUtil.getInt( 1 ) );
84 tagCloudPortlet.setIdCloud( daoUtil.getInt( 2 ) );
85 }
86
87 daoUtil.free( );
88
89 return tagCloudPortlet;
90 }
91
92
93
94
95
96
97 public void delete( int nTagCloudPortletId )
98 {
99 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE );
100 daoUtil.setInt( 1, nTagCloudPortletId );
101 daoUtil.executeUpdate( );
102 daoUtil.free( );
103 }
104
105
106
107
108
109 public void store( TagCloudPortlet tagCloudPortlet )
110 {
111 }
112
113
114
115
116
117
118 public Collection<TagCloudPortlet> selectTagCloudPortletsList( )
119 {
120 Collection<TagCloudPortlet> tagCloudPortletList = new ArrayList<TagCloudPortlet>( );
121 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL );
122 daoUtil.executeQuery( );
123
124 while ( daoUtil.next( ) )
125 {
126 TagCloudPortletness/portlet/TagCloudPortlet.html#TagCloudPortlet">TagCloudPortlet tagCloudPortlet = new TagCloudPortlet( );
127
128 tagCloudPortlet.setIdPortlet( daoUtil.getInt( 1 ) );
129 tagCloudPortlet.setIdCloud( daoUtil.getInt( 2 ) );
130
131 tagCloudPortletList.add( tagCloudPortlet );
132 }
133
134 daoUtil.free( );
135
136 return tagCloudPortletList;
137 }
138
139
140
141
142
143
144 public Collection<Integer> selectTagCloudByPortlet( int nPortletId )
145 {
146 Collection<Integer> tagCloudPortletList = new ArrayList<Integer>( );
147 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_TAGCLOUD_BY_PORTLET );
148 daoUtil.setInt( 1, nPortletId );
149 daoUtil.executeQuery( );
150
151 while ( daoUtil.next( ) )
152 {
153 tagCloudPortletList.add( daoUtil.getInt( 1 ) );
154 }
155
156 daoUtil.free( );
157
158 return tagCloudPortletList;
159 }
160
161
162
163
164
165
166 public void insertCloud( int nPortletId, int nCloudId )
167 {
168 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT );
169
170 daoUtil.setInt( 1, nPortletId );
171 daoUtil.setInt( 2, nCloudId );
172
173 daoUtil.executeUpdate( );
174 daoUtil.free( );
175 }
176
177
178
179
180
181
182 public void storeCloud( int nPortletId, int nCloudId )
183 {
184 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE );
185
186 daoUtil.setInt( 1, nPortletId );
187 daoUtil.setInt( 2, nCloudId );
188 daoUtil.setInt( 3, nPortletId );
189
190 daoUtil.executeUpdate( );
191 daoUtil.free( );
192 }
193
194
195
196
197
198 public void insert( Portlet portlet )
199 {
200 TagCloudPortlet./../../../../fr/paris/lutece/plugins/tagcloud/business/portlet/TagCloudPortlet.html#TagCloudPortlet">TagCloudPortlet port = (TagCloudPortlet) portlet;
201 insertCloud( port.getId( ), port.getIdCloud( ) );
202 }
203
204
205
206
207
208 public void store( Portlet portlet )
209 {
210
211 }
212 }