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