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.digglike.business;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39
40
41
42
43
44
45 public class DefaultMessageDAO implements IDefaultMessageDAO
46 {
47 private static final String SQL_QUERY_SELECT = "SELECT " +
48 "unavailability_message,libelle_validate_button,libelle_Contribution, " +
49 "number_digg_submit_in_top_score,number_digg_submit_in_top_comment,number_digg_submit_caracters_shown,notification_new_comment_title,notification_new_comment_body,notification_new_digg_submit_title,notification_new_digg_submit_body " +
50 "FROM digglike_default_message";
51 private static final String SQL_QUERY_UPDATE = "UPDATE digglike_default_message SET " +
52 "unavailability_message=?,libelle_validate_button=?,libelle_Contribution =?,number_digg_submit_in_top_score=?,number_digg_submit_in_top_comment=?,number_digg_submit_caracters_shown=? ,notification_new_comment_title= ?,notification_new_comment_body= ?,notification_new_digg_submit_title= ?,notification_new_digg_submit_body= ?";
53
54
55
56
57
58
59
60 public void store( DefaultMessage defaultMessage, Plugin plugin )
61 {
62 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, plugin );
63
64 daoUtil.setString( 1, defaultMessage.getUnavailabilityMessage( ) );
65 daoUtil.setString( 2, defaultMessage.getLibelleValidateButton( ) );
66 daoUtil.setString( 3, defaultMessage.getLibelleContribution( ) );
67 daoUtil.setInt( 4, defaultMessage.getNumberDiggSubmitInTopScore( ) );
68 daoUtil.setInt( 5, defaultMessage.getNumberDiggSubmitInTopComment( ) );
69 daoUtil.setInt( 6, defaultMessage.getNumberDiggSubmitCaractersShown( ) );
70 daoUtil.setString( 7, defaultMessage.getNotificationNewCommentTitle());
71 daoUtil.setString( 8, defaultMessage.getNotificationNewCommentBody());
72 daoUtil.setString( 9, defaultMessage.getNotificationNewDiggSubmitTitle());
73 daoUtil.setString( 10, defaultMessage.getNotificationNewDiggSubmitBody());
74
75 daoUtil.executeUpdate( );
76
77 daoUtil.free( );
78 }
79
80
81
82
83
84
85
86 public DefaultMessage load( Plugin plugin )
87 {
88 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, plugin );
89 daoUtil.executeQuery( );
90
91 DefaultMessage defaultMessage = null;
92
93 if ( daoUtil.next( ) )
94 {
95 defaultMessage = new DefaultMessage( );
96 defaultMessage.setUnavailabilityMessage( daoUtil.getString( 1 ) );
97 defaultMessage.setLibelleValidateButton( daoUtil.getString( 2 ) );
98 defaultMessage.setLibelleContribution( daoUtil.getString( 3 ) );
99 defaultMessage.setNumberDiggSubmitInTopScore( daoUtil.getInt( 4 ) );
100 defaultMessage.setNumberDiggSubmitInTopComment( daoUtil.getInt( 5 ) );
101 defaultMessage.setNumberDiggSubmitCaractersShown( daoUtil.getInt( 6 ) );
102 defaultMessage.setNotificationNewCommentTitle(daoUtil.getString(7));
103 defaultMessage.setNotificationNewCommentBody(daoUtil.getString(8));
104 defaultMessage.setNotificationNewDiggSubmitTitle(daoUtil.getString(9));
105 defaultMessage.setNotificationNewDiggSubmitBody(daoUtil.getString(10));
106 }
107
108 daoUtil.free( );
109
110 return defaultMessage;
111 }
112 }