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