i've created a java GUI using Netbeans which connects to a derby database. a table from this database is placed in my GUI, containing some text in all its rows. Now, i want to create a search function that will look for a given string of text through this table and output the results somewhere. can anyone please give me some tips on how i might go about doing this?
thanks,
Karan
You may put a radio button or check box next to the column name.
You can also put a drop down list contains option "start by", "end by", "contains" matched to SQL like statement, '%XX', 'XX%' and '%XX' respectively.
You may also make the column name as a button which user can selected the ordering preference - ascending, descending, default.
If you've already pulled the data back into a table, I wouldn't go back to the database. I'd search the model being used to populate the table. That way you're working in memory rather than across a db connection.
Just my 2 krupplenicks on the subject, your mileage may of course vary,
PS.
> If you've already pulled the data back into a table,
> I wouldn't go back to the database. I'd search the
> model being used to populate the table.
Good point. Looks like you are the first one to hack your way through the obfuscated question. I agree, searching the model is the way to go.
