public   int  countIPR() {
   int  value =  0 ;
  ResultSet rs= null ;
   try  {
    rs = stmt.executeQuery("SELECT COUNT(*) FROM TABLE1");
     if  (rs.next())  value = rs.getInt( 1 );
  }  catch  (SQLException e) {
    e.printStackTrace();
  } finally {
     try {  if (rs!= null ) rs.close(); } catch (SQLException e2){}
  }
   return  value;
}

 public   boolean  selectByName(String name) {
   boolean  update = false;
  String value = "";
  System.out.println(name);
   int  rows = countIPR();
  ResultSet rs= null ;
   try  {
      rs = stmt.executeQuery("SELECT ID FROM TABLE1 WHERE COL1=\'" + name + "\'");
       if  ( rs.next() ){
        value = rs.getString( 1 );
        update = true;
      }
      // обрати внимание что возвращается первый выбранный
  }  catch  (SQLException e) {
    System.out.println(e.getMessage());
    e.printStackTrace();
   // System.exit(0);
  } finally {
     try {  if (rs!= null ) rs.close(); } catch (SQLException e2){}
  }
   return  update;
}