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.business.resource;
35
36 import fr.paris.lutece.plugins.workflow.utils.WorkflowUtils;
37 import fr.paris.lutece.plugins.workflowcore.business.resource.IResourceUserHistoryDAO;
38 import fr.paris.lutece.plugins.workflowcore.business.resource.ResourceUserHistory;
39 import fr.paris.lutece.util.sql.DAOUtil;
40
41
42
43
44 public final class ResourceUserHistoryDAO implements IResourceUserHistoryDAO
45 {
46
47 private static final String SQL_QUERY_SELECT = "SELECT id_history, user_access_code, email, first_name, last_name, realm FROM workflow_resource_user_history WHERE id_history = ?";
48 private static final String SQL_QUERY_INSERT = "INSERT INTO workflow_resource_user_history ( id_history, user_access_code, email, first_name, last_name, realm ) VALUES ( ?, ?, ?, ?, ?, ? ) ";
49 private static final String SQL_QUERY_DELETE = "DELETE FROM workflow_resource_user_history WHERE id_history = ? ";
50 private static final String SQL_QUERY_UPDATE = "UPDATE workflow_resource_user_history SET user_access_code = ?, email = ?, first_name = ?, last_name = ?, realm = ? WHERE id_history = ?";
51
52
53
54
55 @Override
56 public void insert( ResourceUserHistory resourceUserHistory )
57 {
58 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, WorkflowUtils.getPlugin( ) ) )
59 {
60 int nIndex = 1;
61 daoUtil.setInt( nIndex++, resourceUserHistory.getIdHistory( ) );
62 daoUtil.setString( nIndex++, resourceUserHistory.getUserAccessCode( ) );
63 daoUtil.setString( nIndex++, resourceUserHistory.getEmail( ) );
64 daoUtil.setString( nIndex++, resourceUserHistory.getFirstName( ) );
65 daoUtil.setString( nIndex++, resourceUserHistory.getLastName( ) );
66 daoUtil.setString( nIndex++, resourceUserHistory.getRealm( ) );
67
68 daoUtil.executeUpdate( );
69 }
70
71 }
72
73
74
75
76 @Override
77 public ResourceUserHistory load( int nKey )
78 {
79 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT, WorkflowUtils.getPlugin( ) ) )
80 {
81 daoUtil.setInt( 1, nKey );
82 daoUtil.executeQuery( );
83 ResourceUserHistory resourceUserHistory = null;
84
85 if ( daoUtil.next( ) )
86 {
87 resourceUserHistory = new ResourceUserHistory( );
88 int nIndex = 1;
89 resourceUserHistory.setIdHistory( daoUtil.getInt( nIndex++ ) );
90 resourceUserHistory.setUserAccessCode( daoUtil.getString( nIndex++ ) );
91 resourceUserHistory.setEmail( daoUtil.getString( nIndex++ ) );
92 resourceUserHistory.setFirstName( daoUtil.getString( nIndex++ ) );
93 resourceUserHistory.setLastName( daoUtil.getString( nIndex++ ) );
94 resourceUserHistory.setRealm( daoUtil.getString( nIndex ) );
95 }
96
97 daoUtil.free( );
98 return resourceUserHistory;
99 }
100 }
101
102
103
104
105 @Override
106 public void delete( int nKey )
107 {
108 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, WorkflowUtils.getPlugin( ) ) )
109 {
110 daoUtil.setInt( 1, nKey );
111 daoUtil.executeUpdate( );
112 daoUtil.free( );
113 }
114 }
115
116 @Override
117 public void store( ResourceUserHistory resourceUserHistory )
118 {
119 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE, WorkflowUtils.getPlugin( ) ) )
120 {
121 int nPos = 0;
122
123 daoUtil.setString( ++nPos, resourceUserHistory.getUserAccessCode( ) );
124 daoUtil.setString( ++nPos, resourceUserHistory.getEmail( ) );
125 daoUtil.setString( ++nPos, resourceUserHistory.getFirstName( ) );
126 daoUtil.setString( ++nPos, resourceUserHistory.getLastName( ) );
127 daoUtil.setString( ++nPos, resourceUserHistory.getRealm( ) );
128
129 daoUtil.setInt( ++nPos, resourceUserHistory.getIdHistory( ) );
130
131 daoUtil.executeUpdate( );
132 }
133 }
134 }