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.sql.Statement;
39 import java.util.ArrayList;
40 import java.util.List;
41
42
43
44
45 public final class BlogPageTemplateDAO implements IBlogPageTemplateDAO
46 {
47
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 ( 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
64 @Override
65 public synchronized void insert( BlogPageTemplate blogPageTemplate )
66 {
67 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, Statement.RETURN_GENERATED_KEYS ) )
68 {
69 daoUtil.setString( 1, blogPageTemplate.getDescription( ) );
70 daoUtil.setString( 2, blogPageTemplate.getFile( ) );
71 daoUtil.setString( 3, blogPageTemplate.getPicture( ) );
72
73 daoUtil.executeUpdate( );
74
75 if ( daoUtil.nextGeneratedKey( ) )
76 {
77 blogPageTemplate.setId( daoUtil.getGeneratedKeyInt( 1 ) );
78 }
79 }
80 }
81
82
83
84
85
86
87
88
89 @Override
90 public BlogPageTemplate load( int nPageTemplateId )
91 {
92 BlogPageTemplate blogPageTemplate = null;
93 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT ) )
94 {
95 daoUtil.setInt( 1, nPageTemplateId );
96
97 daoUtil.executeQuery( );
98
99 if ( daoUtil.next( ) )
100 {
101 blogPageTemplate = new BlogPageTemplate( );
102 blogPageTemplate.setId( daoUtil.getInt( 1 ) );
103 blogPageTemplate.setDescription( daoUtil.getString( 2 ) );
104 blogPageTemplate.setFile( daoUtil.getString( 3 ) );
105 blogPageTemplate.setPicture( daoUtil.getString( 4 ) );
106 }
107 }
108
109 return blogPageTemplate;
110 }
111
112
113
114
115
116
117
118 @Override
119 public void delete( int nPageTemplateId )
120 {
121 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE ) )
122 {
123 daoUtil.setInt( 1, nPageTemplateId );
124 daoUtil.executeUpdate( );
125 }
126 }
127
128
129
130
131
132
133
134 @Override
135 public void store( BlogPageTemplate blogPageTemplate )
136 {
137 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE ) )
138 {
139 daoUtil.setInt( 1, blogPageTemplate.getId( ) );
140 daoUtil.setString( 2, blogPageTemplate.getDescription( ) );
141 daoUtil.setString( 3, blogPageTemplate.getFile( ) );
142 daoUtil.setString( 4, blogPageTemplate.getPicture( ) );
143 daoUtil.setInt( 5, blogPageTemplate.getId( ) );
144
145 daoUtil.executeUpdate( );
146 }
147 }
148
149
150
151
152
153
154 @Override
155 public List<BlogPageTemplate> selectPageTemplatesList( )
156 {
157 List<BlogPageTemplate> listBlogPageTemplates = new ArrayList<>( );
158 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL ) )
159 {
160 daoUtil.executeQuery( );
161
162 while ( daoUtil.next( ) )
163 {
164 BlogPageTemplatePageTemplate.html#BlogPageTemplate">BlogPageTemplate blogPageTemplate = new BlogPageTemplate( );
165
166 blogPageTemplate.setId( daoUtil.getInt( 1 ) );
167 blogPageTemplate.setDescription( daoUtil.getString( 2 ) );
168 blogPageTemplate.setFile( daoUtil.getString( 3 ) );
169 blogPageTemplate.setPicture( daoUtil.getString( 4 ) );
170 listBlogPageTemplates.add( blogPageTemplate );
171 }
172
173 }
174 return listBlogPageTemplates;
175 }
176 }