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.portal.business.role;
35
36 import fr.paris.lutece.util.ReferenceList;
37 import fr.paris.lutece.util.sql.DAOUtil;
38
39 import java.util.ArrayList;
40 import java.util.Collection;
41
42
43
44
45
46 public final class RoleDAO implements IRoleDAO
47 {
48
49 private static final String SQL_QUERY_SELECT = " SELECT role, role_description, workgroup_key FROM core_role WHERE role = ?";
50 private static final String SQL_QUERY_SELECTALL = " SELECT role , role_description, workgroup_key FROM core_role ORDER BY role";
51 private static final String SQL_QUERY_INSERT = " INSERT INTO core_role ( role, role_description, workgroup_key ) VALUES ( ?, ?, ? )";
52 private static final String SQL_QUERY_DELETE = " DELETE FROM core_role WHERE role = ? ";
53 private static final String SQL_QUERY_UPDATE = " UPDATE core_role SET role_description = ?, workgroup_key = ? WHERE role = ?";
54
55
56
57
58
59
60
61
62 public void insert( Role role )
63 {
64 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT );
65
66 daoUtil.setString( 1, role.getRole( ) );
67 daoUtil.setString( 2, role.getRoleDescription( ) );
68 daoUtil.setString( 3, role.getWorkgroup( ) );
69
70 daoUtil.executeUpdate( );
71 daoUtil.free( );
72 }
73
74
75
76
77
78
79 public Role load( String strRole )
80 {
81 Role role = null;
82 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT );
83 daoUtil.setString( 1, strRole );
84
85 daoUtil.executeQuery( );
86
87 if ( daoUtil.next( ) )
88 {
89 role = new Role( );
90 role.setRole( daoUtil.getString( 1 ) );
91 role.setRoleDescription( daoUtil.getString( 2 ) );
92 role.setWorkgroup( daoUtil.getString( 3 ) );
93 }
94
95 daoUtil.free( );
96
97 return role;
98 }
99
100
101
102
103
104 public void delete( String strRole )
105 {
106 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE );
107 daoUtil.setString( 1, strRole );
108 daoUtil.executeUpdate( );
109 daoUtil.free( );
110 }
111
112
113
114
115
116 public void store( Role role )
117 {
118 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE );
119
120 daoUtil.setString( 1, role.getRoleDescription( ) );
121 daoUtil.setString( 2, role.getWorkgroup( ) );
122 daoUtil.setString( 3, role.getRole( ) );
123
124 daoUtil.executeUpdate( );
125 daoUtil.free( );
126 }
127
128
129
130
131
132 public ReferenceList selectRolesList( )
133 {
134 ReferenceList roleList = new ReferenceList( );
135 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL );
136 daoUtil.executeQuery( );
137
138 while ( daoUtil.next( ) )
139 {
140 Role role = new Role( );
141 role.setRole( daoUtil.getString( 1 ) );
142 role.setRoleDescription( daoUtil.getString( 2 ) );
143
144 roleList.addItem( role.getRole( ), role.getRoleDescription( ) );
145 }
146
147 daoUtil.free( );
148
149 return roleList;
150 }
151
152
153
154
155
156 public Collection<Role> selectAll( )
157 {
158 Collection<Role> listRoles = new ArrayList<Role>( );
159 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL );
160 daoUtil.executeQuery( );
161
162 while ( daoUtil.next( ) )
163 {
164 Role role = new Role( );
165 role.setRole( daoUtil.getString( 1 ) );
166 role.setRoleDescription( daoUtil.getString( 2 ) );
167 role.setWorkgroup( daoUtil.getString( 3 ) );
168
169 listRoles.add( role );
170 }
171
172 daoUtil.free( );
173
174 return listRoles;
175 }
176 }