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 vehicleincidentreportapplication;
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: vehicleRowSet
069: .setDataSourceName("java:comp/env/jdbc/VIR_ApacheDerby");
070: vehicleRowSet
071: .setCommand("SELECT ALL \"VIR\".\"VEHICLE\".\"STATEID\", \r\n \"VIR\".\"VEHICLE\".\"LICENSEPLATE\", \r\n \"VIR\".\"VEHICLE\".\"MAKE\", \r\n \"VIR\".\"VEHICLE\".\"MODEL\", \r\n \"VIR\".\"VEHICLE\".\"COLOR\", \r\n \"VIR\".\"STATE\".\"STATEID\", \r\n \"VIR\".\"STATE\".\"STATENAME\" \r\nFROM VIR.VEHICLE\r\n INNER JOIN \"VIR\".\"STATE\" ON \"VIR\".\"VEHICLE\".\"STATEID\" = \"VIR\".\"STATE\".\"STATEID\"\r\nWHERE \"VIR\".\"VEHICLE\".\"STATEID\" LIKE ?\r\n AND \"VIR\".\"VEHICLE\".\"LICENSEPLATE\" LIKE ?\r\n AND \"VIR\".\"VEHICLE\".\"MAKE\" LIKE ?\r\n AND \"VIR\".\"VEHICLE\".\"MODEL\" LIKE ?\r\n AND \"VIR\".\"VEHICLE\".\"COLOR\" LIKE ? ");
072: vehicleRowSet.setTableName("VEHICLE");
073: stateRowSet
074: .setDataSourceName("java:comp/env/jdbc/VIR_ApacheDerby");
075: stateRowSet.setCommand("SELECT * FROM VIR.STATE");
076: stateRowSet.setTableName("STATE");
077: ownerRowSet
078: .setDataSourceName("java:comp/env/jdbc/VIR_ApacheDerby");
079: ownerRowSet
080: .setCommand("SELECT ALL \"VIR\".\"OWNER\".\"STATEID\", \r\n \"VIR\".\"OWNER\".\"LICENSEPLATE\", \r\n \"VIR\".\"OWNER\".\"EMPLOYEEID\", \r\n \"VIR\".\"VEHICLE\".\"STATEID\", \r\n \"VIR\".\"VEHICLE\".\"LICENSEPLATE\", \r\n \"VIR\".\"VEHICLE\".\"MAKE\", \r\n \"VIR\".\"VEHICLE\".\"MODEL\", \r\n \"VIR\".\"VEHICLE\".\"COLOR\", \r\n \"VIR\".\"STATE\".\"STATEID\", \r\n \"VIR\".\"STATE\".\"STATENAME\" \r\nFROM VIR.OWNER, \"VIR\".\"VEHICLE\"\r\n INNER JOIN \"VIR\".\"STATE\" ON \"VIR\".\"VEHICLE\".\"STATEID\" = \"VIR\".\"STATE\".\"STATEID\"\r\nWHERE \"VIR\".\"OWNER\".\"STATEID\" = \"VIR\".\"STATE\".\"STATEID\"\r\n AND \"VIR\".\"OWNER\".\"EMPLOYEEID\" = ? ");
081: ownerRowSet.setTableName("OWNER");
082: passwordRowSet
083: .setDataSourceName("java:comp/env/jdbc/VIR_ApacheDerby");
084: passwordRowSet.setCommand("SELECT * FROM VIR.PASSWORD");
085: passwordRowSet.setTableName("PASSWORD");
086: employeeRowSet
087: .setDataSourceName("java:comp/env/jdbc/VIR_ApacheDerby");
088: employeeRowSet.setCommand("SELECT * FROM VIR.EMPLOYEE");
089: employeeRowSet.setTableName("EMPLOYEE");
090: }
091:
092: private CachedRowSetXImpl vehicleRowSet = new CachedRowSetXImpl();
093:
094: public CachedRowSetXImpl getVehicleRowSet() {
095: return vehicleRowSet;
096: }
097:
098: public void setVehicleRowSet(CachedRowSetXImpl crsxi) {
099: this .vehicleRowSet = crsxi;
100: }
101:
102: private CachedRowSetXImpl stateRowSet = new CachedRowSetXImpl();
103:
104: public CachedRowSetXImpl getStateRowSet() {
105: return stateRowSet;
106: }
107:
108: public void setStateRowSet(CachedRowSetXImpl crsxi) {
109: this .stateRowSet = crsxi;
110: }
111:
112: private CachedRowSetXImpl ownerRowSet = new CachedRowSetXImpl();
113:
114: public CachedRowSetXImpl getOwnerRowSet() {
115: return ownerRowSet;
116: }
117:
118: public void setOwnerRowSet(CachedRowSetXImpl crsxi) {
119: this .ownerRowSet = crsxi;
120: }
121:
122: private CachedRowSetXImpl passwordRowSet = new CachedRowSetXImpl();
123:
124: public CachedRowSetXImpl getPasswordRowSet() {
125: return passwordRowSet;
126: }
127:
128: public void setPasswordRowSet(CachedRowSetXImpl crsxi) {
129: this .passwordRowSet = crsxi;
130: }
131:
132: private CachedRowSetXImpl employeeRowSet = new CachedRowSetXImpl();
133:
134: public CachedRowSetXImpl getEmployeeRowSet() {
135: return employeeRowSet;
136: }
137:
138: public void setEmployeeRowSet(CachedRowSetXImpl crsxi) {
139: this .employeeRowSet = crsxi;
140: }
141:
142: // </editor-fold>
143:
144: /**
145: * <p>Construct a new session data bean instance.</p>
146: */
147: public SessionBean1() {
148: }
149:
150: /**
151: * <p>This method is called when this bean is initially added to
152: * session scope. Typically, this occurs as a result of evaluating
153: * a value binding or method binding expression, which utilizes the
154: * managed bean facility to instantiate this bean and store it into
155: * session scope.</p>
156: *
157: * <p>You may customize this method to initialize and cache data values
158: * or resources that are required for the lifetime of a particular
159: * user session.</p>
160: */
161: @Override
162: public void init() {
163: // Perform initializations inherited from our superclass
164: super .init();
165: // Perform application initialization that must complete
166: // *before* managed components are initialized
167: // TODO - add your own initialiation code here
168:
169: // <editor-fold defaultstate="collapsed" desc="Managed Component Initialization">
170: // Initialize automatically managed components
171: // *Note* - this logic should NOT be modified
172: try {
173: _init();
174: } catch (Exception e) {
175: log("SessionBean1 Initialization Failure", e);
176: throw e instanceof FacesException ? (FacesException) e
177: : new FacesException(e);
178: }
179:
180: // </editor-fold>
181: // Perform application initialization that must complete
182: // *after* managed components are initialized
183: // TODO - add your own initialization code here
184: this .loggedIn = false;
185: }
186:
187: /**
188: * <p>This method is called when the session containing it is about to be
189: * passivated. Typically, this occurs in a distributed servlet container
190: * when the session is about to be transferred to a different
191: * container instance, after which the <code>activate()</code> method
192: * will be called to indicate that the transfer is complete.</p>
193: *
194: * <p>You may customize this method to release references to session data
195: * or resources that can not be serialized with the session itself.</p>
196: */
197: @Override
198: public void passivate() {
199: }
200:
201: /**
202: * <p>This method is called when the session containing it was
203: * reactivated.</p>
204: *
205: * <p>You may customize this method to reacquire references to session
206: * data or resources that could not be serialized with the
207: * session itself.</p>
208: */
209: @Override
210: public void activate() {
211: }
212:
213: /**
214: * <p>This method is called when this bean is removed from
215: * session scope. Typically, this occurs as a result of
216: * the session timing out or being terminated by the application.</p>
217: *
218: * <p>You may customize this method to clean up resources allocated
219: * during the execution of the <code>init()</code> method, or
220: * at any later time during the lifetime of the application.</p>
221: */
222: @Override
223: public void destroy() {
224: }
225:
226: /**
227: * <p>Return a reference to the scoped data bean.</p>
228: */
229: protected ApplicationBean1 getApplicationBean1() {
230: return (ApplicationBean1) getBean("ApplicationBean1");
231: }
232:
233: private boolean loggedIn;
234:
235: private String loggedInUserName;
236:
237: private Integer loggedInUserId;
238:
239: public boolean isNotLoggedIn() {
240: return !loggedIn;
241: }
242:
243: public boolean isLoggedIn() {
244: return loggedIn;
245: }
246:
247: public void setLoggedIn(boolean loggedIn) {
248: this .loggedIn = loggedIn;
249: }
250:
251: public String getLoggedInUserName() {
252: return loggedInUserName;
253: }
254:
255: public void setLoggedInUserName(String loggedInUserName) {
256: this .loggedInUserName = loggedInUserName;
257: }
258:
259: public Integer getLoggedInUserId() {
260: return loggedInUserId;
261: }
262:
263: public void setLoggedInUserId(Integer loggedInUserId) {
264: this .loggedInUserId = loggedInUserId;
265: }
266:
267: public String getWelcomeMessage() {
268: String result = "";
269: if (this .loggedIn) {
270: result = "Welcome " + this .loggedInUserName;
271: }
272: return result;
273: }
274:
275: private String incident;
276:
277: public String getIncident() {
278: return incident;
279: }
280:
281: public void setIncident(String incident) {
282: this.incident = incident;
283: }
284: }
|