1 /*
2 * Copyright (c) 2002-2014, Mairie de Paris
3 * All rights reserved.
4 *
5 * Redistribution and use in source and binary forms, with or without
6 * modification, are permitted provided that the following conditions
7 * are met:
8 *
9 * 1. Redistributions of source code must retain the above copyright notice
10 * and the following disclaimer.
11 *
12 * 2. Redistributions in binary form must reproduce the above copyright notice
13 * and the following disclaimer in the documentation and/or other materials
14 * provided with the distribution.
15 *
16 * 3. Neither the name of 'Mairie de Paris' nor 'Lutece' nor the names of its
17 * contributors may be used to endorse or promote products derived from
18 * this software without specific prior written permission.
19 *
20 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
21 * AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
22 * IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE
23 * ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT HOLDERS OR CONTRIBUTORS BE
24 * LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
25 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF
26 * SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS
27 * INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN
28 * CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE)
29 * ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE
30 * POSSIBILITY OF SUCH DAMAGE.
31 *
32 * License 1.0
33 */
34 package fr.paris.lutece.portal.business.right;
35
36 import fr.paris.lutece.util.sql.DAOUtil;
37
38 import java.util.ArrayList;
39 import java.util.Collection;
40
41
42 /**
43 * This class provides Data Access methods for Level objects
44 */
45 public final class LevelDAO implements ILevelDAO
46 {
47 // Constants
48 private static final String SQL_QUERY_NEW_PK = " SELECT max( id_level ) FROM core_level_right ";
49 private static final String SQL_QUERY_SELECT = " SELECT id_level, name FROM core_level_right WHERE id_level = ?";
50 private static final String SQL_QUERY_INSERT = " INSERT INTO core_level_right ( id_level, name ) VALUES ( ?, ? )";
51 private static final String SQL_QUERY_DELETE = " DELETE FROM core_level_right WHERE id_level = ?";
52 private static final String SQL_QUERY_UPDATE = " UPDATE core_level_right SET id_level = ?, name = ? WHERE id_level = ?";
53 private static final String SQL_QUERY_SELECTALL = " SELECT id_level , name FROM core_level_right ORDER BY id_level";
54
55 ///////////////////////////////////////////////////////////////////////////////////////
56 //Access methods to data
57
58 /**
59 * Generates a new primary key
60 * @return The new primary key
61 */
62 int newPrimaryKey( )
63 {
64 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_NEW_PK );
65 daoUtil.executeQuery( );
66
67 int nKey;
68
69 if ( !daoUtil.next( ) )
70 {
71 // if the table is empty
72 nKey = 1;
73 }
74
75 nKey = daoUtil.getInt( 1 ) + 1;
76
77 daoUtil.free( );
78
79 return nKey;
80 }
81
82 /**
83 * Insert a new record in the table.
84 * @param level The level object
85 */
86 public synchronized void insert( Level level )
87 {
88 level.setId( newPrimaryKey( ) );
89
90 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT );
91 daoUtil.setInt( 1, level.getId( ) );
92 daoUtil.setString( 2, level.getName( ) );
93
94 daoUtil.executeUpdate( );
95 daoUtil.free( );
96 }
97
98 /**
99 * load the data of Level from the table
100 * @param nIdLevel The indentifier of the object Level
101 * @return The Instance of the object Level
102 */
103 public Level load( int nIdLevel )
104 {
105 Level level = null;
106 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT );
107 daoUtil.setInt( 1, nIdLevel );
108 daoUtil.executeQuery( );
109
110 if ( daoUtil.next( ) )
111 {
112 level = new Level( );
113 level.setId( daoUtil.getInt( 1 ) );
114 level.setName( daoUtil.getString( 2 ) );
115 }
116
117 daoUtil.free( );
118
119 return level;
120 }
121
122 /**
123 * Delete a record from the table
124 * @param nIdLevel The indentifier of the object Level
125 */
126 public void delete( int nIdLevel )
127 {
128 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE );
129 daoUtil.setInt( 1, nIdLevel );
130
131 daoUtil.executeUpdate( );
132 daoUtil.free( );
133 }
134
135 /**
136 * Update the record in the table
137 * @param level The instance of the Level to update
138 */
139 public void store( Level level )
140 {
141 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_UPDATE );
142 int nLevelId = level.getId( );
143 daoUtil.setInt( 1, nLevelId );
144 daoUtil.setString( 2, level.getName( ) );
145 daoUtil.setInt( 3, nLevelId );
146
147 daoUtil.executeUpdate( );
148 daoUtil.free( );
149 }
150
151 /**
152 * Returns a list of all the right level
153 * @return A collection of right level objects
154 */
155 public Collection<Level> selectLevelsList( )
156 {
157 Collection<Level> levelList = new ArrayList<Level>( );
158 DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECTALL );
159 daoUtil.executeQuery( );
160
161 while ( daoUtil.next( ) )
162 {
163 Level level = new Level( );
164 level.setId( daoUtil.getInt( 1 ) );
165 level.setName( daoUtil.getString( 2 ) );
166 levelList.add( level );
167 }
168
169 daoUtil.free( );
170
171 return levelList;
172 }
173 }