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.formengine.business.mail;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39 import java.util.ArrayList;
40 import java.util.List;
41
42
43
44
45
46 public final class MailConfigurationDAO implements IMailConfigurationDAO
47 {
48
49 private static final String SQL_QUERY_SELECT = "SELECT form, senderName, senderMail, object FROM formengine_mail_configuration WHERE form = ?";
50 private static final String SQL_QUERY_INSERT = "INSERT INTO formengine_mail_configuration ( form, senderName, senderMail, object ) VALUES ( ?, ?, ?, ? ) ";
51 private static final String SQL_QUERY_DELETE = "DELETE FROM formengine_mail_configuration WHERE form = ? ";
52 private static final String SQL_QUERY_UPDATE = "UPDATE formengine_mail_configuration SET form = ?, senderName = ?, senderMail = ?, object = ? WHERE form = ?";
53 private static final String SQL_QUERY_SELECTALL = "SELECT form, senderName, senderMail, object FROM formengine_mail_configuration";
54
55
56
57
58
59
60 public void insert( MailConfiguration mailConfiguration, Plugin plugin )
61 {
62 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin );
63
64 daoUtil.setString( 1, mailConfiguration.getForm( ) );
65 daoUtil.setString( 2, mailConfiguration.getSenderName( ) );
66 daoUtil.setString( 3, mailConfiguration.getSenderMail( ) );
67 daoUtil.setString( 4, mailConfiguration.getObject( ) );
68
69 daoUtil.executeUpdate( );
70 daoUtil.free( );
71 }
72
73
74
75
76
77
78
79 public MailConfiguration load( String strId, Plugin plugin )
80 {
81 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, plugin );
82 daoUtil.setString( 1, strId );
83 daoUtil.executeQuery( );
84
85 MailConfiguration mailConfiguration = null;
86
87 if ( daoUtil.next( ) )
88 {
89 mailConfiguration = new MailConfiguration( );
90
91 mailConfiguration.setForm( daoUtil.getString( 1 ) );
92 mailConfiguration.setSenderName( daoUtil.getString( 2 ) );
93 mailConfiguration.setSenderMail( daoUtil.getString( 3 ) );
94 mailConfiguration.setObject( daoUtil.getString( 4 ) );
95 }
96
97 daoUtil.free( );
98
99 return mailConfiguration;
100 }
101
102
103
104
105
106
107 public void delete( String strForm, Plugin plugin )
108 {
109 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, plugin );
110 daoUtil.setString( 1, strForm );
111 daoUtil.executeUpdate( );
112 daoUtil.free( );
113 }
114
115
116
117
118
119
120 public void store( MailConfiguration mailConfiguration, Plugin plugin )
121 {
122 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, plugin );
123
124 daoUtil.setString( 1, mailConfiguration.getForm( ) );
125 daoUtil.setString( 2, mailConfiguration.getSenderName( ) );
126 daoUtil.setString( 3, mailConfiguration.getSenderMail( ) );
127 daoUtil.setString( 4, mailConfiguration.getObject( ) );
128 daoUtil.setString( 5, mailConfiguration.getForm( ) );
129
130 daoUtil.executeUpdate( );
131 daoUtil.free( );
132 }
133
134
135
136
137
138
139 public List<MailConfiguration> selectMailConfigurationsList( Plugin plugin )
140 {
141 List<MailConfiguration> mailConfigurationList = new ArrayList<MailConfiguration>( );
142 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL, plugin );
143 daoUtil.executeQuery( );
144
145 while ( daoUtil.next( ) )
146 {
147 MailConfiguration mailConfiguration = new MailConfiguration( );
148
149 mailConfiguration.setForm( daoUtil.getString( 1 ) );
150 mailConfiguration.setSenderName( daoUtil.getString( 2 ) );
151 mailConfiguration.setSenderMail( daoUtil.getString( 3 ) );
152 mailConfiguration.setObject( daoUtil.getString( 4 ) );
153
154 mailConfigurationList.add( mailConfiguration );
155 }
156
157 daoUtil.free( );
158
159 return mailConfigurationList;
160 }
161 }