We want to write three query for JSP page. Query as below:
1. Upadate column 1 of table 1 by value 1 if the keyword found from column 2 of table 1
note:- here keyword example like '%" + keyword 1 + "%'||' '||[url removed, login to view]||' '||'%" + Keyword 2 + "%'"
Note:- [url removed, login to view] is column 1 of table 3.
2. four Combo box which is dependent on one main combo box which all will fetch the values from database.
like first combo = category and its values = business, eduction, etc.
next four combo box like subject = if business then a, b, c, etc. if education then 1, 2, 3 etc.
Note:- database for category = category table and for subject = subject table which both have
one column only.