| WebIdUtil.java |
1 /**
2 * Copyright (c) 2000-2009 Liferay, Inc. All rights reserved.
3 *
4 *
5 *
6 *
7 * The contents of this file are subject to the terms of the Liferay Enterprise
8 * Subscription License ("License"). You may not use this file except in
9 * compliance with the License. You can obtain a copy of the License by
10 * contacting Liferay, Inc. See the License for the specific language governing
11 * permissions and limitations under the License, including but not limited to
12 * distribution rights 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 public class WebIdUtil {
40
41 public static String[] getWebIds() throws Exception {
42 if (_webIds != null) {
43 return _webIds;
44 }
45
46 List<String> webIds = new ArrayList<String>();
47
48 Connection con = null;
49 PreparedStatement ps = null;
50 ResultSet rs = null;
51
52 try {
53 con = DataAccess.getConnection();
54
55 ps = con.prepareStatement(_GET_WEB_IDS);
56
57 rs = ps.executeQuery();
58
59 while (rs.next()) {
60 String companyId = rs.getString("companyId");
61
62 webIds.add(companyId);
63 }
64 }
65 finally {
66 DataAccess.cleanUp(con, ps, rs);
67 }
68
69 _webIds = webIds.toArray(new String[webIds.size()]);
70
71 return _webIds;
72 }
73
74 private static final String _GET_WEB_IDS = "select companyId from Company";
75
76 private static String[] _webIds;
77
78 }