001: /*
002: * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS HEADER.
003: *
004: * Copyright 1997-2007 Sun Microsystems, Inc. All rights reserved.
005: *
006: * The contents of this file are subject to the terms of either the GNU
007: * General Public License Version 2 only ("GPL") or the Common
008: * Development and Distribution License("CDDL") (collectively, the
009: * "License"). You may not use this file except in compliance with the
010: * License. You can obtain a copy of the License at
011: * http://www.netbeans.org/cddl-gplv2.html
012: * or nbbuild/licenses/CDDL-GPL-2-CP. See the License for the
013: * specific language governing permissions and limitations under the
014: * License. When distributing the software, include this License Header
015: * Notice in each file and include the License file at
016: * nbbuild/licenses/CDDL-GPL-2-CP. Sun designates this
017: * particular file as subject to the "Classpath" exception as provided
018: * by Sun in the GPL Version 2 section of the License file that
019: * accompanied this code. If applicable, add the following below the
020: * License Header, with the fields enclosed by brackets [] replaced by
021: * your own identifying information:
022: * "Portions Copyrighted [year] [name of copyright owner]"
023: *
024: * Contributor(s):
025: *
026: * The Original Software is NetBeans. The Initial Developer of the Original
027: * Software is Sun Microsystems, Inc. Portions Copyright 1997-2007 Sun
028: * Microsystems, Inc. All Rights Reserved.
029: *
030: * If you wish your version of this file to be governed by only the CDDL
031: * or only the GPL Version 2, indicate your decision by adding
032: * "[Contributor] elects to include this software in this distribution
033: * under the [CDDL or GPL Version 2] license." If you do not indicate a
034: * single choice of license, a recipient has the option to distribute
035: * your version of this file under either the CDDL, the GPL Version 2 or
036: * to extend the choice of license to its licensees as provided above.
037: * However, if you add GPL Version 2 code and therefore, elected the GPL
038: * Version 2 license, then the option applies only if the new code is
039: * made subject to such option by the copyright holder.
040: */
041:
042: package travelcenter;
043:
044: import com.sun.rave.web.ui.appbase.AbstractSessionBean;
045: import com.sun.sql.rowset.CachedRowSetXImpl;
046: import javax.faces.FacesException;
047:
048: /**
049: * <p>Session scope data bean for your application. Create properties
050: * here to represent cached data that should be made available across
051: * multiple HTTP requests for an individual user.</p>
052: *
053: * <p>An instance of this class will be created for you automatically,
054: * the first time your application evaluates a value binding expression
055: * or method binding expression that references a managed bean using
056: * this class.</p>
057: */
058: public class SessionBean1 extends AbstractSessionBean {
059: // <editor-fold defaultstate="collapsed" desc="Managed Component Definition">
060: private int __placeholder;
061:
062: /**
063: * <p>Automatically managed component initialization. <strong>WARNING:</strong>
064: * This method is automatically generated, so any user-specified code inserted
065: * here is subject to being replaced.</p>
066: */
067: private void _init() throws Exception {
068: personRowSet
069: .setDataSourceName("java:comp/env/jdbc/TRAVEL_ApacheDerby");
070: personRowSet.setCommand("SELECT * FROM TRAVEL.PERSON");
071: personRowSet.setTableName("PERSON");
072: tripRowSet
073: .setDataSourceName("java:comp/env/jdbc/TRAVEL_ApacheDerby");
074: tripRowSet
075: .setCommand("SELECT ALL \"TRAVEL\".\"TRIP\".\"TRIPID\", \n \"TRAVEL\".\"TRIP\".\"PERSONID\", \n \"TRAVEL\".\"TRIP\".\"DEPDATE\", \n \"TRAVEL\".\"TRIP\".\"DEPCITY\", \n \"TRAVEL\".\"TRIP\".\"DESTCITY\", \n \"TRAVEL\".\"TRIP\".\"TRIPTYPEID\", \n \"TRAVEL\".\"TRIP\".\"LASTUPDATED\", \n \"TRAVEL\".\"TRIPTYPE\".\"NAME\" \nFROM TRAVEL.TRIP\n INNER JOIN \"TRAVEL\".\"TRIPTYPE\" ON \"TRAVEL\".\"TRIP\".\"TRIPTYPEID\" = \"TRAVEL\".\"TRIPTYPE\".\"TRIPTYPEID\"\nWHERE \"TRAVEL\".\"TRIP\".\"PERSONID\" = ? ");
076: tripRowSet.setTableName("TRIP");
077: flightRowSet
078: .setDataSourceName("java:comp/env/jdbc/TRAVEL_ApacheDerby");
079: flightRowSet
080: .setCommand("SELECT ALL \"TRAVEL\".\"FLIGHT\".\"TRIPID\", \n \"TRAVEL\".\"FLIGHT\".\"FLIGHTID\", \n \"TRAVEL\".\"FLIGHT\".\"DIRECTION\", \n \"TRAVEL\".\"FLIGHT\".\"FLIGHTNUM\", \n \"TRAVEL\".\"FLIGHT\".\"DEPTIME\", \n \"TRAVEL\".\"FLIGHT\".\"DEPAIRPORT\", \n \"TRAVEL\".\"FLIGHT\".\"ARRTIME\", \n \"TRAVEL\".\"FLIGHT\".\"ARRAIRPORT\", \n \"TRAVEL\".\"FLIGHT\".\"AIRLINENAME\", \n \"TRAVEL\".\"FLIGHT\".\"BOOKINGSTATUS\", \n \"TRAVEL\".\"FLIGHT\".\"LASTUPDATED\" \nFROM TRAVEL.FLIGHT\nWHERE \"TRAVEL\".\"FLIGHT\".\"TRIPID\" = ? ");
081: flightRowSet.setTableName("FLIGHT");
082: carrentalRowSet
083: .setDataSourceName("java:comp/env/jdbc/TRAVEL_ApacheDerby");
084: carrentalRowSet
085: .setCommand("SELECT ALL \"TRAVEL\".\"CARRENTAL\".\"TRIPID\", \n \"TRAVEL\".\"CARRENTAL\".\"CARRENTALID\", \n \"TRAVEL\".\"CARRENTAL\".\"PROVIDER\", \n \"TRAVEL\".\"CARRENTAL\".\"CITY\", \n \"TRAVEL\".\"CARRENTAL\".\"PICKUPDATE\", \n \"TRAVEL\".\"CARRENTAL\".\"RETURNDATE\", \n \"TRAVEL\".\"CARRENTAL\".\"CARTYPE\", \n \"TRAVEL\".\"CARRENTAL\".\"RATE\", \n \"TRAVEL\".\"CARRENTAL\".\"BOOKINGSTATUS\", \n \"TRAVEL\".\"CARRENTAL\".\"LASTUPDATED\" \nFROM TRAVEL.CARRENTAL\nWHERE \"TRAVEL\".\"CARRENTAL\".\"TRIPID\" = ? ");
086: carrentalRowSet.setTableName("CARRENTAL");
087: hotelRowSet
088: .setDataSourceName("java:comp/env/jdbc/TRAVEL_ApacheDerby");
089: hotelRowSet
090: .setCommand("SELECT ALL \"TRAVEL\".\"HOTEL\".\"TRIPID\", \n \"TRAVEL\".\"HOTEL\".\"HOTELID\", \n \"TRAVEL\".\"HOTEL\".\"HOTELNAME\", \n \"TRAVEL\".\"HOTEL\".\"CHECKINDATE\", \n \"TRAVEL\".\"HOTEL\".\"CHECKOUTDATE\", \n \"TRAVEL\".\"HOTEL\".\"GUESTS\", \n \"TRAVEL\".\"HOTEL\".\"BOOKINGSTATUS\", \n \"TRAVEL\".\"HOTEL\".\"LASTUPDATED\" \nFROM TRAVEL.HOTEL\nWHERE \"TRAVEL\".\"HOTEL\".\"TRIPID\" = ? ");
091: hotelRowSet.setTableName("HOTEL");
092: personRowSet1
093: .setDataSourceName("java:comp/env/jdbc/TRAVEL_ApacheDerby");
094: personRowSet1
095: .setCommand("SELECT ALL \"TRAVEL\".\"PERSON\".\"PERSONID\", \n \"TRAVEL\".\"PERSON\".\"NAME\", \n \"TRAVEL\".\"PERSON\".\"JOBTITLE\", \n \"TRAVEL\".\"PERSON\".\"FREQUENTFLYER\", \n \"TRAVEL\".\"PERSON\".\"LASTUPDATED\" \nFROM TRAVEL.PERSON\nWHERE \"TRAVEL\".\"PERSON\".\"PERSONID\" = ? ");
096: personRowSet1.setTableName("PERSON");
097: }
098:
099: private CachedRowSetXImpl personRowSet = new CachedRowSetXImpl();
100:
101: public CachedRowSetXImpl getPersonRowSet() {
102: return personRowSet;
103: }
104:
105: public void setPersonRowSet(CachedRowSetXImpl crsxi) {
106: this .personRowSet = crsxi;
107: }
108:
109: private CachedRowSetXImpl tripRowSet = new CachedRowSetXImpl();
110:
111: public CachedRowSetXImpl getTripRowSet() {
112: return tripRowSet;
113: }
114:
115: public void setTripRowSet(CachedRowSetXImpl crsxi) {
116: this .tripRowSet = crsxi;
117: }
118:
119: private CachedRowSetXImpl flightRowSet = new CachedRowSetXImpl();
120:
121: public CachedRowSetXImpl getFlightRowSet() {
122: return flightRowSet;
123: }
124:
125: public void setFlightRowSet(CachedRowSetXImpl crsxi) {
126: this .flightRowSet = crsxi;
127: }
128:
129: private CachedRowSetXImpl carrentalRowSet = new CachedRowSetXImpl();
130:
131: public CachedRowSetXImpl getCarrentalRowSet() {
132: return carrentalRowSet;
133: }
134:
135: public void setCarrentalRowSet(CachedRowSetXImpl crsxi) {
136: this .carrentalRowSet = crsxi;
137: }
138:
139: private CachedRowSetXImpl hotelRowSet = new CachedRowSetXImpl();
140:
141: public CachedRowSetXImpl getHotelRowSet() {
142: return hotelRowSet;
143: }
144:
145: public void setHotelRowSet(CachedRowSetXImpl crsxi) {
146: this .hotelRowSet = crsxi;
147: }
148:
149: private CachedRowSetXImpl personRowSet1 = new CachedRowSetXImpl();
150:
151: public CachedRowSetXImpl getPersonRowSet1() {
152: return personRowSet1;
153: }
154:
155: public void setPersonRowSet1(CachedRowSetXImpl crsxi) {
156: this .personRowSet1 = crsxi;
157: }
158:
159: // </editor-fold>
160:
161: /**
162: * <p>Construct a new session data bean instance.</p>
163: */
164: public SessionBean1() {
165: }
166:
167: /**
168: * <p>This method is called when this bean is initially added to
169: * session scope. Typically, this occurs as a result of evaluating
170: * a value binding or method binding expression, which utilizes the
171: * managed bean facility to instantiate this bean and store it into
172: * session scope.</p>
173: *
174: * <p>You may customize this method to initialize and cache data values
175: * or resources that are required for the lifetime of a particular
176: * user session.</p>
177: */
178: public void init() {
179: // Perform initializations inherited from our superclass
180: super .init();
181: // Perform application initialization that must complete
182: // *before* managed components are initialized
183: // TODO - add your own initialiation code here
184:
185: // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
186: // Initialize automatically managed components
187: // *Note* - this logic should NOT be modified
188: try {
189: _init();
190: } catch (Exception e) {
191: log("SessionBean1 Initialization Failure", e);
192: throw e instanceof FacesException ? (FacesException) e
193: : new FacesException(e);
194: }
195:
196: // </editor-fold>
197: // Perform application initialization that must complete
198: // *after* managed components are initialized
199: // TODO - add your own initialization code here
200: }
201:
202: /**
203: * <p>This method is called when the session containing it is about to be
204: * passivated. Typically, this occurs in a distributed servlet container
205: * when the session is about to be transferred to a different
206: * container instance, after which the <code>activate()</code> method
207: * will be called to indicate that the transfer is complete.</p>
208: *
209: * <p>You may customize this method to release references to session data
210: * or resources that can not be serialized with the session itself.</p>
211: */
212: public void passivate() {
213: }
214:
215: /**
216: * <p>This method is called when the session containing it was
217: * reactivated.</p>
218: *
219: * <p>You may customize this method to reacquire references to session
220: * data or resources that could not be serialized with the
221: * session itself.</p>
222: */
223: public void activate() {
224: }
225:
226: /**
227: * <p>This method is called when this bean is removed from
228: * session scope. Typically, this occurs as a result of
229: * the session timing out or being terminated by the application.</p>
230: *
231: * <p>You may customize this method to clean up resources allocated
232: * during the execution of the <code>init()</code> method, or
233: * at any later time during the lifetime of the application.</p>
234: */
235: public void destroy() {
236: }
237:
238: /**
239: * <p>Return a reference to the scoped data bean.</p>
240: */
241: protected ApplicationBean1 getApplicationBean1() {
242: return (ApplicationBean1) getBean("ApplicationBean1");
243: }
244: }
|