How to Update a table based on object values?
Posted on 2006-06-15
I have some objects that are from this class:
private String emailaddress;
private String TypeCode;
private String SubCode;
private String emailaddressnew;
private Date DateTime;
I populated an array of these objects as Email array.
These Email array will be used to update the following table:
EMAIL_TEXT Varchar2(100) not null PK
Based on the TypeCode value of the object, I will need to update certain fields of the table.
But before this I will have to make sure that the email address even exists in the table.
It is possible that certain email addresses will not be in the table --- in this case I will simply have to do a insert into this table with some object values and appropriate values.
So, if the email address does not exists in the table, do a insert
if the email address exists in the table, do a update.
Need some help on logic and jdbc illustration on this...