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.blog.business;
35
36 import fr.paris.lutece.util.sql.DAOUtil;
37
38 import java.util.ArrayList;
39 import java.util.List;
40
41
42
43
44 public final class BlogPageTemplateDAO implements IBlogPageTemplateDAO
45 {
46
47 private static final String SQL_QUERY_NEW_PK = " SELECT max( id_page_template_document ) FROM blog_page_template";
48 private static final String SQL_QUERY_SELECT = " SELECT id_page_template_document, description, page_template_path, picture_path FROM blog_page_template WHERE id_page_template_document = ?";
49 private static final String SQL_QUERY_INSERT = " INSERT INTO blog_page_template ( id_page_template_document, description, page_template_path, picture_path ) VALUES ( ?, ?, ?, ? )";
50 private static final String SQL_QUERY_DELETE = " DELETE FROM blog_page_template WHERE id_page_template_document = ?";
51 private static final String SQL_QUERY_UPDATE = " UPDATE blog_page_template SET id_page_template_document = ?, description = ?, page_template_path = ?, picture_path = ? "
52 + " WHERE id_page_template_document = ?";
53 private static final String SQL_QUERY_SELECTALL = " SELECT id_page_template_document , description, page_template_path, picture_path FROM blog_page_template ORDER BY id_page_template_document ";
54
55
56
57
58
59
60
61
62
63 int newPrimaryKey( )
64 {
65 int nKey = 1;
66 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_NEW_PK ) )
67 {
68 daoUtil.executeQuery( );
69 if ( daoUtil.next( ) )
70 {
71 nKey = daoUtil.getInt( 1 ) + 1;
72 }
73 }
74 return nKey;
75 }
76
77
78
79
80
81
82
83 @Override
84 public synchronized void insert( BlogPageTemplate blogPageTemplate )
85 {
86 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT ) )
87 {
88 blogPageTemplate.setId( newPrimaryKey( ) );
89
90 daoUtil.setInt( 1, blogPageTemplate.getId( ) );
91 daoUtil.setString( 2, blogPageTemplate.getDescription( ) );
92 daoUtil.setString( 3, blogPageTemplate.getFile( ) );
93 daoUtil.setString( 4, blogPageTemplate.getPicture( ) );
94
95 daoUtil.executeUpdate( );
96 }
97 }
98
99
100
101
102
103
104
105
106 @Override
107 public BlogPageTemplate load( int nPageTemplateId )
108 {
109 BlogPageTemplate blogPageTemplate = null;
110 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT ) )
111 {
112 daoUtil.setInt( 1, nPageTemplateId );
113
114 daoUtil.executeQuery( );
115
116 if ( daoUtil.next( ) )
117 {
118 blogPageTemplate = new BlogPageTemplate( );
119 blogPageTemplate.setId( daoUtil.getInt( 1 ) );
120 blogPageTemplate.setDescription( daoUtil.getString( 2 ) );
121 blogPageTemplate.setFile( daoUtil.getString( 3 ) );
122 blogPageTemplate.setPicture( daoUtil.getString( 4 ) );
123 }
124 }
125
126 return blogPageTemplate;
127 }
128
129
130
131
132
133
134
135 @Override
136 public void delete( int nPageTemplateId )
137 {
138 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE ) )
139 {
140 daoUtil.setInt( 1, nPageTemplateId );
141 daoUtil.executeUpdate( );
142 }
143 }
144
145
146
147
148
149
150
151 @Override
152 public void store( BlogPageTemplate blogPageTemplate )
153 {
154 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE ) )
155 {
156 daoUtil.setInt( 1, blogPageTemplate.getId( ) );
157 daoUtil.setString( 2, blogPageTemplate.getDescription( ) );
158 daoUtil.setString( 3, blogPageTemplate.getFile( ) );
159 daoUtil.setString( 4, blogPageTemplate.getPicture( ) );
160 daoUtil.setInt( 5, blogPageTemplate.getId( ) );
161
162 daoUtil.executeUpdate( );
163 }
164 }
165
166
167
168
169
170
171 @Override
172 public List<BlogPageTemplate> selectPageTemplatesList( )
173 {
174 List<BlogPageTemplate> listBlogPageTemplates = new ArrayList<>( );
175 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL ) )
176 {
177 daoUtil.executeQuery( );
178
179 while ( daoUtil.next( ) )
180 {
181 BlogPageTemplatePageTemplate.html#BlogPageTemplate">BlogPageTemplate blogPageTemplate = new BlogPageTemplate( );
182
183 blogPageTemplate.setId( daoUtil.getInt( 1 ) );
184 blogPageTemplate.setDescription( daoUtil.getString( 2 ) );
185 blogPageTemplate.setFile( daoUtil.getString( 3 ) );
186 blogPageTemplate.setPicture( daoUtil.getString( 4 ) );
187 listBlogPageTemplates.add( blogPageTemplate );
188 }
189
190 }
191 return listBlogPageTemplates;
192 }
193 }