I have build a stand alone application using Java that processes text of my interest in some way that for now is irelevant.
What I want to do know is the following, when I have a new string of text to be processed I first need to search whether this string exists in my Database. If it does then no processing will have to be made to that string. If it does not exist then my application will have to process the string and add a new entry to the data base table.
This SQL code then will be implemented in Eclipse and my java app to manage.
An example in order to make things more clear.
Lets say that we have the string "dog"
I need to search for this string in the table of the database (all columns).
- If there is no "dog" entry then do some processing and store the string in the DB.
- If there is a "dog" found in the DB then proceed to the next string, for example "cat" and do the same for all the new entries that I have to check on whether or not are present in my DB.
I am using DBVisualizer pro to make some tests of my own but this are not so promising for now