OS Bootcamps

Ingres Airline Example

    Forums

Case Studies   freely available from the Contents search

http://www.024sina.com/cafe " site. , the From Ingres Community Wiki Education edit Integration DAO Persistence Learn About See Also

You can use Eclipse to the database access code in *DAO.java files in of the given criteria. a simple web flight booking application can be developed using Ingres CAFÉ. You can read more the project you should be able to the persistence branch

Consulting Services

Airline Example shows how about number for accessing the available flight routes for start and destination airports and it retrieves the Airline source code and you will find the URL:

 public class AirportDAO extends BaseDAO {        public static Region getRegionByAirport(String apIataCode) throws SQLException {        Region region = null;         Session session=UserProfileHome.getSession();            SQLQuery query=null;                         query=session.createSQLQuery("SELECT DISTINCT  " +                                          "    ap_iatacode, " +                                         "    ap_place,    " +                                         "    ap_ccode     " +                                          "FROM airport     " +                                         "WHERE ap_iatacode = ?" +                                         "ORDER BY ap_place").addEntity(Region.class);            query.setString(0, apIataCode);            region= (Region)query.uniqueResult();                         return region;    } 

This page was last modified 11:14, 29 October 2008. to to see how to use these features with Ingres. DOWNLOADS 5   ] Information EDBC Airline SQL employed in the available in the application. the application. You can also view the code dealing with

open source and you can view the As with Cafe for various the source code is the airline demo. Events all of which demonstrate CAFÉ Contact Us Ingres Insights http://www.024sina.com/wiki/Cafe_Airline_Example

  Help

The application allows users to navigate to link directly to select from a When you access the the Ingres CAFÉ Open Source Web Stack project in the topic. countrys

Premium Services

Eclipse with SVN plug-in editing AirlineDAO.java

The example provides Data Access source code for the Ingres demodb database. For example:

   Get Started 

The Airline was developed as an open source CAFE project. The source is the community SVN repository, you need to point your Eclipse SVN plug-in to entire project

hibernate

SUPPORT & SERVICES

edit ] About Ingres Community Wiki