Newbie: Simple Update Query JDBC problem

From: James Kyle (jameskyle_at_shaw.ca)
Date: 01/26/04 

Date: Mon, 26 Jan 2004 01:15:05 GMT

Hi,
I am new to java and am on my way to learning but presently I am looking for
your opinion on a solution.

The problem is as follows;

   I have a comma separated text file consisting of a key field (customer
number) and lets say one data field (new_phone#).
   Utilizing that .csv file as input I would like a java program to read an
oracle database by the same key field (ora_customer#) and then populate a
JTable with the data if it is different. (showing KEY FIELD, new_phone#,
ora_old_phone#).

   I have a JDBC driver for both the comma separated file and the oracle
table, so that is not the problem. I just don't know the best way to
approach this. Read the CSV file into a vector and then use the csv
customer number as part of the select statement ?

If anyone knows how to do this or knows of a tutorial that does something
just like this please let me know. (I haven't seen any that utilize 2
different datasources).

Thanks

Relevant Pages

  • Re: Newbie: Simple Update Query JDBC problem
    ... > I am new to java and am on my way to learning but presently I am looking ... > I have a comma separated text file consisting of a key field ... Read the CSV file into a vector and then use the csv ... This way you can iterate through the map and the ResultSet at the same ...
    (comp.lang.java.databases)
  • Re: request for CSV converter program
    ... > you to convert a CSV file to another CSV file with fewer columns and ... than a Java program. ... be more inclined to use a BASH script or REXX or one of the Linux utilities. ... There are many script-type languages out there that do a very good job with ...
    (comp.lang.java.programmer)
  • Re: Download erstellen mit Java
    ... dann werde doch mal etwas konkreter. ... Kennst du Java überhaupt, weißt ... du was ein CSV File ist... ...
    (de.comp.lang.java)
  • Deleting contents of file
    ... I am currently devloping a java application where the application when ... it is launched reads in a CSV file and then populates that data into a ... within the CSV file. ...
    (comp.lang.java.help)
  • Re: Importing Address Book contacts
    ... > possibility to import Address Book contacts in java. ... > Also by drag & dropping. ... With MS Outlook Express you can 'export' it as a csv file. ...
    (comp.lang.java.programmer)