WebIdUtil.java |
1 /** 2 * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved. 3 * 4 * Permission is hereby granted, free of charge, to any person obtaining a copy 5 * of this software and associated documentation files (the "Software"), to deal 6 * in the Software without restriction, including without limitation the rights 7 * to use, copy, modify, merge, publish, distribute, sublicense, and/or sell 8 * copies of the Software, and to permit persons to whom the Software is 9 * furnished to do so, subject to the following conditions: 10 * 11 * The above copyright notice and this permission notice shall be included in 12 * all copies or substantial portions of the Software. 13 * 14 * THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR 15 * IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, 16 * FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE 17 * AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER 18 * LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, 19 * OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE 20 * SOFTWARE. 21 */ 22 23 package com.liferay.portal.upgrade.v4_3_0.util; 24 25 import com.liferay.portal.kernel.dao.jdbc.DataAccess; 26 27 import java.sql.Connection; 28 import java.sql.PreparedStatement; 29 import java.sql.ResultSet; 30 31 import java.util.ArrayList; 32 import java.util.List; 33 34 /** 35 * <a href="WebIdUtil.java.html"><b><i>View Source</i></b></a> 36 * 37 * @author Brian Wing Shun Chan 38 * 39 */ 40 public class WebIdUtil { 41 42 public static String[] getWebIds() throws Exception { 43 if (_webIds != null) { 44 return _webIds; 45 } 46 47 List<String> webIds = new ArrayList<String>(); 48 49 Connection con = null; 50 PreparedStatement ps = null; 51 ResultSet rs = null; 52 53 try { 54 con = DataAccess.getConnection(); 55 56 ps = con.prepareStatement(_GET_WEB_IDS); 57 58 rs = ps.executeQuery(); 59 60 while (rs.next()) { 61 String companyId = rs.getString("companyId"); 62 63 webIds.add(companyId); 64 } 65 } 66 finally { 67 DataAccess.cleanUp(con, ps, rs); 68 } 69 70 _webIds = webIds.toArray(new String[webIds.size()]); 71 72 return _webIds; 73 } 74 75 private static final String _GET_WEB_IDS = "select companyId from Company"; 76 77 private static String[] _webIds; 78 79 }