parsing a fixed-width flat file to sql fields

[clintsy]

I need to parse a plain text file (1,000's of records) into an arraylist (or similar collection) that can be dumped into SQL fields. I know the field lengths but i don't know how to forward...

 

[Marco Schmidt]

clintsy:

I need to parse a plain text file (1,000's of records) into an arraylist (or similar collection) that can be dumped into SQL fields. I know the field lengths but i don't know how to forward...

Do you mean copying the data into a database?

Create a PreparedStatement stat with "insert into" in it. The exact
syntax depends on the table structure.

Then for each input line:
- Split the input string into several strings using String.substring.
- Call trim() on the strings to remove trailing whitespace.
- Copy fields into the PreparedStatement object with the correct index
and set method, e.g. stat.setString(index, value);
- Call the executeUpdate method of stat.

BTW: Please make your newsclient use no more than about 80 characters
per line!

Regards,
Marco