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.mylutece.modules.database.authentication.business.parameter;
35
36 import fr.paris.lutece.portal.service.plugin.Plugin;
37 import fr.paris.lutece.util.ReferenceItem;
38 import fr.paris.lutece.util.ReferenceList;
39 import fr.paris.lutece.util.sql.DAOUtil;
40
41
42
43
44
45
46 public class DatabaseUserParameterDAO implements IDatabaseUserParameterDAO
47 {
48 private static final String SQL_QUERY_SELECT_USER_PARAMETERS_VALUE = " SELECT parameter_value FROM mylutece_database_user_parameter WHERE parameter_key = ? ";
49 private static final String SQL_QUERY_UPDATE_USER_PARAMETERS = " UPDATE mylutece_database_user_parameter SET parameter_value = ? WHERE parameter_key = ? ";
50 private static final String SQL_QUERY_SELECT_ALL = " SELECT parameter_key, parameter_value FROM mylutece_database_user_parameter ";
51
52
53
54
55 public ReferenceItem load( String strParameterKey, Plugin plugin )
56 {
57 ReferenceItem userParam = null;
58 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_USER_PARAMETERS_VALUE, plugin ) )
59 {
60 daoUtil.setString( 1, strParameterKey );
61 daoUtil.executeQuery( );
62
63 if ( daoUtil.next( ) )
64 {
65 userParam = new ReferenceItem( );
66 userParam.setCode( strParameterKey );
67 userParam.setName( daoUtil.getString( 1 ) );
68 userParam.setChecked( Boolean.valueOf( userParam.getName( ) ) );
69 }
70 }
71 return userParam;
72 }
73
74
75
76
77 public void store( ReferenceItem userParam, Plugin plugin )
78 {
79 int nIndex = 0;
80 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE_USER_PARAMETERS, plugin ) )
81 {
82 daoUtil.setString( ++nIndex, userParam.getName( ) );
83 daoUtil.setString( ++nIndex, userParam.getCode( ) );
84
85 daoUtil.executeUpdate( );
86 }
87 }
88
89
90
91
92 public ReferenceList selectAll( Plugin plugin )
93 {
94 ReferenceList listUserParams = new ReferenceList( );
95 try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_ALL, plugin ) )
96 {
97 daoUtil.executeQuery( );
98
99 while ( daoUtil.next( ) )
100 {
101 int nIndex = 0;
102 ReferenceItem userParam = new ReferenceItem( );
103 userParam.setCode( daoUtil.getString( ++nIndex ) );
104 userParam.setName( daoUtil.getString( ++nIndex ) );
105 userParam.setChecked( Boolean.valueOf( userParam.getName( ) ) );
106 listUserParams.add( userParam );
107 }
108 }
109 return listUserParams;
110 }
111 }