please need help on sql

[yossi avisror]

i would like to get the sql method
which is run over a col and check for a word
if it in my table.
[This message has been edited by yossi avisror (edited May 18, 2001).]

[Anonymous]

Hello!
you mean something like this:

   public boolean isAiportIdExist(Connection conn,String iataCode)
                   throws PersistenceException
    {
        Statement statement=null ;
        int rowCount;
        try
        {
            super.query= new StringBuffer( "select count(*)")
                         .append(" from AIRPORT ")
                         .append(" where IATACODE = \'")
                         .append(iataCode)
                         .append("\' ")
                         .toString();
            statement = conn.createStatement();
            ResultSet rs = statement.executeQuery(query);
            rowCount = 0;
            while (super.rs.next())
            {
                rowCount=rs.getInt(1);
            }
        }
          catch (SQLException e)
        {
            throw new PersistenceException (e);
        }
        finally
        {
            statement.close();
        }
      return rowCount==0?false:true;
    }

------------------
Benjamin l�onard
www.evisor.com
[This message has been edited by Benjamin Leonard (edited May 21, 2001).]