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.workflow.modules.confirmaction.business;
35
36 import fr.paris.lutece.plugins.workflow.utils.WorkflowUtils;
37 import fr.paris.lutece.plugins.workflowcore.business.config.ITaskConfigDAO;
38 import fr.paris.lutece.util.sql.DAOUtil;
39
40
41
42
43
44
45 public class ConfirmActionTaskConfigDAO implements ITaskConfigDAO<ConfirmActionTaskConfig>
46 {
47
48 private static final String SQL_QUERY_FIND_BY_PRIMARY_KEY = " SELECT id_task, message FROM workflow_task_confirm_action_config WHERE id_task = ? ";
49 private static final String SQL_QUERY_INSERT = " INSERT INTO workflow_task_confirm_action_config ( id_task, message ) VALUES ( ?, ? ) ";
50 private static final String SQL_QUERY_UPDATE = "UPDATE workflow_task_confirm_action_config SET message = ? WHERE id_task = ? ";
51 private static final String SQL_QUERY_DELETE = " DELETE FROM workflow_task_confirm_action_config WHERE id_task = ? ";
52
53
54
55
56 @Override
57 public synchronized void insert( ConfirmActionTaskConfig config )
58 {
59 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, WorkflowUtils.getPlugin( ) ) )
60 {
61 int nIndex = 1;
62
63 daoUtil.setInt( nIndex++, config.getIdTask( ) );
64 daoUtil.setString( nIndex++, config.getMessage( ) );
65
66 daoUtil.executeUpdate( );
67 daoUtil.free( );
68 }
69 }
70
71
72
73
74 @Override
75 public void store( ConfirmActionTaskConfig config )
76 {
77 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, WorkflowUtils.getPlugin( ) ) )
78 {
79 int nIndex = 1;
80
81 daoUtil.setString( nIndex++, config.getMessage( ) );
82
83 daoUtil.setInt( nIndex++, config.getIdTask( ) );
84 daoUtil.executeUpdate( );
85 daoUtil.free( );
86 }
87 }
88
89
90
91
92 @Override
93 public ConfirmActionTaskConfig load( int nIdTask )
94 {
95 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_FIND_BY_PRIMARY_KEY, WorkflowUtils.getPlugin( ) ) )
96 {
97 ConfirmActionTaskConfig config = null;
98
99 daoUtil.setInt( 1, nIdTask );
100
101 daoUtil.executeQuery( );
102
103 int nIndex = 1;
104
105 if ( daoUtil.next( ) )
106 {
107 config = new ConfirmActionTaskConfig( );
108 config.setIdTask( daoUtil.getInt( nIndex++ ) );
109 config.setMessage( daoUtil.getString( nIndex++ ) );
110 }
111
112 daoUtil.free( );
113
114 return config;
115 }
116 }
117
118
119
120
121 @Override
122 public void delete( int nIdTask )
123 {
124 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, WorkflowUtils.getPlugin( ) ) )
125 {
126 daoUtil.setInt( 1, nIdTask );
127 daoUtil.executeUpdate( );
128 daoUtil.free( );
129 }
130 }
131
132 }