View Javadoc
1   /*
2    * Copyright (c) 2002-2018, 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.plugins.appointment.business.portlet;
35  
36  import fr.paris.lutece.portal.business.portlet.Portlet;
37  import fr.paris.lutece.util.sql.DAOUtil;
38  
39  /**
40   * this class provides Data Access methods for AppointmentPortlet objects
41   * 
42   * @author Laurent Payen
43   *
44   */
45  public final class AppointmentFormPortletDAO implements IAppointmentFormPortletDAO
46  {
47      // //////////////////////////////////////////////////////////////////////////
48      // Constants
49      private static final String SQL_QUERY_SELECT = "SELECT id_portlet, id_form FROM appointment_form_portlet WHERE id_portlet = ? ";
50      private static final String SQL_QUERY_INSERT = "INSERT INTO appointment_form_portlet ( id_portlet, id_form ) VALUES ( ? , ?)";
51      private static final String SQL_QUERY_DELETE = "DELETE FROM appointment_form_portlet WHERE id_portlet = ? ";
52      private static final String SQL_QUERY_UPDATE = "UPDATE appointment_form_portlet SET id_form = ? WHERE id_portlet = ? ";
53  
54      // /////////////////////////////////////////////////////////////////////////////////////
55      // Access methods to data
56  
57      /**
58       * Insert a new record in the table.
59       *
60       * @param portlet
61       *            The Instance of the Portlet
62       */
63      @Override
64      public void insert( Portlet portlet )
65      {
66          DAOUtil daoUtil = null;
67          try
68          {
69              if ( portlet instanceof AppointmentFormPortlet )
70              {
71                  AppointmentFormPortlet p = (AppointmentFormPortlet) portlet;
72                  daoUtil = new DAOUtil( SQL_QUERY_INSERT );
73                  daoUtil.setInt( 1, p.getId( ) );
74                  daoUtil.setInt( 2, p.getIdAppointmentForm( ) );
75                  daoUtil.executeUpdate( );
76              }
77          }
78          finally
79          {
80              if ( daoUtil != null )
81              {
82                  daoUtil.free( );
83              }
84          }
85      }
86  
87      /**
88       * Delete record from table
89       *
90       * @param nPortletId
91       *            The identifier of the Portlet
92       */
93      @Override
94      public void delete( int nPortletId )
95      {
96          DAOUtil daoUtil = null;
97          try
98          {
99              daoUtil = new DAOUtil( SQL_QUERY_DELETE );
100             daoUtil.setInt( 1, nPortletId );
101             daoUtil.executeUpdate( );
102         }
103         finally
104         {
105             if ( daoUtil != null )
106             {
107                 daoUtil.free( );
108             }
109         }
110     }
111 
112     /**
113      * Update the record in the table
114      *
115      * @param portlet
116      *            The reference of the portlet
117      */
118     @Override
119     public void store( Portlet portlet )
120     {
121         DAOUtil daoUtil = null;
122         try
123         {
124             if ( portlet instanceof AppointmentFormPortlet )
125             {
126                 AppointmentFormPortlet p = (AppointmentFormPortlet) portlet;
127                 daoUtil = new DAOUtil( SQL_QUERY_UPDATE );
128                 daoUtil.setInt( 1, p.getIdAppointmentForm( ) );
129                 daoUtil.setInt( 2, p.getId( ) );
130                 daoUtil.executeUpdate( );
131             }
132         }
133         finally
134         {
135             if ( daoUtil != null )
136             {
137                 daoUtil.free( );
138             }
139         }
140     }
141 
142     /**
143      * load the data of dbpagePortlet from the table
144      * 
145      * @return portlet The instance of the object portlet
146      * @param nIdPortlet
147      *            The identifier of the portlet
148      */
149     @Override
150     public Portlet load( int nIdPortlet )
151     {
152         AppointmentFormPortlet portlet = new AppointmentFormPortlet( );
153         DAOUtil daoUtil = null;
154         try
155         {
156             daoUtil = new DAOUtil( SQL_QUERY_SELECT );
157             daoUtil.setInt( 1, nIdPortlet );
158             daoUtil.executeQuery( );
159             if ( daoUtil.next( ) )
160             {
161                 portlet.setId( daoUtil.getInt( 1 ) );
162                 portlet.setIdAppointmentForm( daoUtil.getInt( 2 ) );
163             }
164         }
165         finally
166         {
167             if ( daoUtil != null )
168             {
169                 daoUtil.free( );
170             }
171         }
172         return portlet;
173     }
174 }