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.childpages.business.portlet;
35
36 import java.util.ArrayList;
37 import java.util.List;
38
39 import fr.paris.lutece.portal.business.portlet.Portlet;
40 import fr.paris.lutece.util.ReferenceList;
41 import fr.paris.lutece.util.sql.DAOUtil;
42
43
44
45
46
47 public final class ChildPagesPortletDAO implements IChildPagesPortletDAO
48 {
49 private static final String SQL_QUERY_INSERT = "INSERT INTO childpages_portlet ( id_portlet, id_child_page ) VALUES ( ?,? )";
50 private static final String SQL_QUERY_DELETE = "DELETE FROM childpages_portlet WHERE id_portlet = ?";
51 private static final String SQL_QUERY_SELECT = "SELECT id_portlet, id_child_page FROM childpages_portlet WHERE id_portlet = ?";
52 private static final String SQL_QUERY_UPDATE = "UPDATE childpages_portlet SET id_child_page = ? WHERE id_portlet = ?";
53 private static final String SQL_QUERY_SELECT_CHILDPAGE_LIST = "SELECT id_page, name FROM core_page WHERE id_page = ?";
54 private static final String SQL_QUERY_SELECT_PAGE_LIST = "SELECT id_page, name FROM core_page";
55 private static final String SQL_QUERY_SELECT_BY_PARENTPAGEID = "SELECT id_portlet, id_child_page FROM childpages_portlet WHERE id_child_page = ?";
56
57
58
59
60
61
62
63
64
65 public void insert( Portlet portlet )
66 {
67 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT );
68 ChildPagesPortlet../../../../../fr/paris/lutece/plugins/childpages/business/portlet/ChildPagesPortlet.html#ChildPagesPortlet">ChildPagesPortlet p = (ChildPagesPortlet) portlet;
69 daoUtil.setInt( 1, p.getId( ) );
70 daoUtil.setInt( 2, p.getParentPageId( ) );
71 daoUtil.executeUpdate( );
72 daoUtil.free( );
73 }
74
75
76
77
78
79
80 public void delete( int nPortletId )
81 {
82 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE );
83 daoUtil.setInt( 1, nPortletId );
84 daoUtil.executeUpdate( );
85 daoUtil.free( );
86 }
87
88
89
90
91
92
93
94 public Portlet load( int nPortletId )
95 {
96 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT );
97 daoUtil.setInt( 1, nPortletId );
98 daoUtil.executeQuery( );
99
100 ChildPagesPortletges/business/portlet/ChildPagesPortlet.html#ChildPagesPortlet">ChildPagesPortlet portlet = new ChildPagesPortlet( );
101
102 if ( daoUtil.next( ) )
103 {
104 portlet.setId( daoUtil.getInt( 1 ) );
105 portlet.setParentPageId( daoUtil.getInt( 2 ) );
106 }
107
108 daoUtil.free( );
109
110 return portlet;
111 }
112
113
114
115
116
117 public void store( Portlet portlet )
118 {
119 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE );
120 ChildPagesPortlet../../../../../fr/paris/lutece/plugins/childpages/business/portlet/ChildPagesPortlet.html#ChildPagesPortlet">ChildPagesPortlet p = (ChildPagesPortlet) portlet;
121 daoUtil.setInt( 1, p.getParentPageId( ) );
122 daoUtil.setInt( 2, p.getId( ) );
123 daoUtil.executeUpdate( );
124 daoUtil.free( );
125 }
126
127
128
129
130
131
132
133 public ReferenceList selectChildPagesList( int nPageId )
134 {
135 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_CHILDPAGE_LIST );
136 daoUtil.setInt( 1, nPageId );
137 daoUtil.executeQuery( );
138
139 ReferenceList list = new ReferenceList( );
140
141 while ( daoUtil.next( ) )
142 {
143 list.addItem( daoUtil.getInt( 1 ), daoUtil.getString( 2 ) );
144 }
145
146 daoUtil.free( );
147
148 return list;
149 }
150
151
152
153
154
155
156 public ReferenceList selectPagesList( )
157 {
158 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_PAGE_LIST );
159 daoUtil.executeQuery( );
160
161 ReferenceList list = new ReferenceList( );
162
163 while ( daoUtil.next( ) )
164 {
165 list.addItem( daoUtil.getInt( 1 ), daoUtil.getString( 2 ) );
166 }
167
168 daoUtil.free( );
169
170 return list;
171 }
172
173 @Override
174 public List<ChildPagesPortlet> getChildPagesPortlets( int parentPageId )
175 {
176 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_BY_PARENTPAGEID );
177 daoUtil.setInt( 1, parentPageId );
178 daoUtil.executeQuery( );
179
180 List<ChildPagesPortlet> res = new ArrayList<ChildPagesPortlet>( );
181
182 while ( daoUtil.next( ) )
183 {
184 ChildPagesPortletges/business/portlet/ChildPagesPortlet.html#ChildPagesPortlet">ChildPagesPortlet portlet = new ChildPagesPortlet( );
185 portlet.setId( daoUtil.getInt( 1 ) );
186 portlet.setParentPageId( daoUtil.getInt( 2 ) );
187 res.add( portlet );
188 }
189
190 daoUtil.free( );
191
192 return res;
193 }
194 }