1 /* 2 * Copyright (c) 2002-2017, 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.pagelinkservice.business; 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 PageLibrary objects 44 */ 45 public final class PageLinkServiceDAO 46 { 47 /** This class implements the Singleton design pattern. */ 48 private static PageLinkServiceDAOservice/business/PageLinkServiceDAO.html#PageLinkServiceDAO">PageLinkServiceDAO _dao = new PageLinkServiceDAO( ); 49 50 /** 51 * Creates a new PageLibraryDAO object. 52 */ 53 private PageLinkServiceDAO( ) 54 { 55 } 56 57 /** 58 * Returns the unique instance of the singleton. 59 * 60 * @return the instance 61 */ 62 static PageLinkServiceDAO getInstance( ) 63 { 64 return _dao; 65 } 66 67 /////////////////////////////////////////////////////////////////////////////////////// 68 //Access methods to data 69 70 /** 71 * The collection of page 72 * @param strPageName the name of the page 73 * @return The collection of field 74 */ 75 Collection selectPageListbyName( String strPageName ) 76 { 77 ArrayList list = new ArrayList( ); 78 String strSQL; 79 80 if ( "".equals( strPageName ) ) 81 { 82 strSQL = " SELECT id_page , name ,description FROM core_page"; 83 } 84 else 85 { 86 strSQL = " SELECT id_page , name ,description FROM core_page WHERE name LIKE'%" + 87 strPageName + "%'"; 88 } 89 90 DAOUtil daoUtil = new DAOUtil( strSQL ); 91 daoUtil.executeQuery( ); 92 93 while ( daoUtil.next( ) ) 94 { 95 PageLinkServiceinkservice/business/PageLinkService.html#PageLinkService">PageLinkService page = new PageLinkService( ); 96 page.setIdPage( daoUtil.getInt( 1 ) ); 97 page.setLabelPage( daoUtil.getString( 2 ) ); 98 page.setDescriptionPage( daoUtil.getString( 3 ) ); 99 list.add( page ); 100 } 101 102 daoUtil.free( ); 103 104 return list; 105 } 106 }