View Javadoc
1   /*
2    * Copyright (c) 2002-2020, City of 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.plugins.announce.business;
35  
36  import fr.paris.lutece.portal.service.plugin.Plugin;
37  import fr.paris.lutece.util.sql.DAOUtil;
38  
39  import java.util.ArrayList;
40  import java.util.List;
41  
42  public class AnnounceNotifyDAO implements IAnnounceNotifyDAO
43  {
44  
45      private static final String SQL_QUERY_SELECT_ALL = "SELECT id, id_announce FROM announce_notify";
46      private static final String SQL_QUERY_INSERT = "INSERT INTO announce_notify ( id, id_announce) VALUES (?,?)";
47      private static final String SQL_QUERY_DELETE = "DELETE FROM announce_notify WHERE id = ? ";
48  
49      private static final String SQL_QUERY_NEW_PK = "SELECT max( id ) FROM announce_notify";
50  
51      @Override
52      public void insert( AnnounceNotify announce, Plugin plugin )
53      {
54  
55          try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_INSERT, plugin ) )
56          {
57              daoUtil.setInt( 1, newPrimaryKey( plugin ) );
58              daoUtil.setInt( 2, announce.getIdAnnounce( ) );
59  
60              daoUtil.executeUpdate( );
61          }
62      }
63  
64      @Override
65      public void delete( int nIdAnnounce, Plugin plugin )
66      {
67          try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_DELETE, plugin ) )
68          {
69              daoUtil.setInt( 1, nIdAnnounce );
70              daoUtil.executeUpdate( );
71          }
72      }
73  
74      @Override
75      public List<AnnounceNotify> load( Plugin plugin )
76      {
77  
78          List<AnnounceNotify> announceList = new ArrayList<>( );
79          try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_SELECT_ALL, plugin ) )
80          {
81              daoUtil.executeQuery( );
82  
83              AnnounceNotify announceNotify;
84              while ( daoUtil.next( ) )
85              {
86                  announceNotify = new AnnounceNotify( );
87                  announceNotify.setId( daoUtil.getInt( 1 ) );
88                  announceNotify.setIdAnnounce( daoUtil.getInt( 2 ) );
89                  announceList.add( announceNotify );
90              }
91  
92          }
93  
94          return announceList;
95      }
96  
97      public int newPrimaryKey( Plugin plugin )
98      {
99          int nKey = 1;
100         try ( DAOUtil daoUtil = new DAOUtil( SQL_QUERY_NEW_PK, plugin ) )
101         {
102             daoUtil.executeQuery( );
103 
104             if ( daoUtil.next( ) )
105             {
106                 nKey = daoUtil.getInt( 1 ) + 1;
107             }
108         }
109         return nKey;
110     }
111 }