Flushing BufferedReader

[Roy Sin]

hi,
i wuz just wondering if there is a way to really determine the end of file.
For e.g.
i have a text file containing data
a,a
b,b
c,c
d,d
e,e
the data should end at the char "e" but if i put 2 spaces below the "e". The program will continue till the spaces are read too...
here is my sample code. i am adding data into the database

  
while ((line = br.readLine()) != null)
{
    StringTokenizer in = new StringTokenizer(line,dl);
     while (in.hasMoreTokens())
     {
         lineRead = in.nextToken();
         info.addElement(lineRead);
     }
     max = info.size();
     for (int i = 0; i < (max - 1);i ++)
     {
          if (i==0)
          {
              sql = "(" + info.elementAt(i) + ",";
          }
          else if (i == (max -1))
          {
              sql = sql + info.elementAt(i) + ");";
          }
     else 
          {
              sql = sql + info.elementAt(i) + ",";
          }
       }
       st.executeUpdate("insert into table values" + sql);
}

my table will then show
a|a
b|b
c|c
d|d
e|e
e|e
e|e
how to get rid of this ??? hhheeelllppp !!!
thanks...
Roy

[Steve Deadsea]

The easiest way I see would be to ignore lines that are made of just spaces.
Instead of

while ((line = br.readLine()) != null)

try

while ((line = br.readLine()) != null && !line.trim().equals(""))

[Roy Sin]

Thanks for ur help...