1  package com.orindasoft.demo.generated.sql;
2  
3  /** 
4  * GetFlights.sql
5  * 
6  * <p>Generated by JDBCWizard./a> build 2776 at 2011/03/07 19:55:48.78 GMT
7  * <p>JDBCWizard./a> is made by Orinda Software Ltd, Dublin, Ireland
8  * <p>Target Database: Oracle 10.2.0
9  * <p> -------------------------------------------------------------------------
10 * <p> WARNING: This code will stop working around the time JDBCWizard./a> expires.
11 * <p> This restriction only exists in the demo version of JDBCWizard./a>.
12 * <p> -------------------------------------------------------------------------
13 * <p> JDBCWizard./a> Tips 17 of 19:
14 * <p> JDBCWizard./a> also runs as an extension to Oracle's JDeveloper 10g
15 * <p> -------------------------------------------------------------------------
16 * 
17 * <p>Copyright Orinda Software 2003-2009
18 * <p>SQL File Name GetFlights.sql
19 * <p>This class represents a row of data returned by the SQL statement below:
20 * <code><pre> 
21 * ----------------------------------------------------------------
22 * SELECT *
23 * FROM   flights f
24 * /* Because we give both parameters the same name the generated code
25 *    will have one parameter which it uses twice.   
26 * WHERE  departure_city = ? /* city string   
27 * OR     arrival_city   = ? /* city String   
28 * ORDER BY departure_time
29 * ---------------------------------------------------------------
30 * </pre></code> 
31 * <p> The following columns were returned by this query:
32 * <table border=1>
33 * <tr><b><td>Column Name</td><td>Oracle Data Type</td><td>Java Data Type</td></b></tr>
34 * <tr><td>departureCity</td><td>VARCHAR2</td><td>String</td></tr>
35 * <tr><td>arrivalCity</td><td>VARCHAR2</td><td>String</td></tr>
36 * <tr><td>airlineName</td><td>VARCHAR2</td><td>String</td></tr>
37 * <tr><td>flightNumber</td><td>NUMBER</td><td>java.math.BigDecimal</td></tr>
38 * <tr><td>departureTime</td><td>DATE</td><td>java.util.Date</td></tr>
39 * <tr><td>arrivalTime</td><td>DATE</td><td>java.util.Date</td></tr>
40 * <tr><td>aircraftType</td><td>VARCHAR2</td><td>String</td></tr>
41 * </table>
42 * @author devteam60@orindabuild.com
43 * @version 1.1
44 */ 
45 public class GetFlightsCursorAttr implements java.io.Serializable
46 {
47    
48   /**
49   * Variable to store departureCity
50   */
51   public String departureCity = null;
52    
53   /**
54   * Variable to store arrivalCity
55   */
56   public String arrivalCity = null;
57    
58   /**
59   * Variable to store airlineName
60   */
61   public String airlineName = null;
62    
63   /**
64   * Variable to store flightNumber
65   */
66   public java.math.BigDecimal flightNumber = null;
67    
68   /**
69   * Variable to store departureTime
70   * @since 4.0.2016 DATE columns are now represented with java.util.Date instead of java.sql.Timestamp
71   */
72   public java.util.Date departureTime = null;
73    
74   /**
75   * Variable to store arrivalTime
76   * @since 4.0.2016 DATE columns are now represented with java.util.Date instead of java.sql.Timestamp
77   */
78   public java.util.Date arrivalTime = null;
79    
80   /**
81   * Variable to store aircraftType
82   */
83   public String aircraftType = null;
84    
85 } // Generated by JDBCWizard./a> 6.0.2776 
86