Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.util.ArrayList;
- import java.util.List;
- import org.json.JSONException;
- public class MrTest {
- public static void main(String args[]) throws JSONException
- {
- ArrayList<String> total_list = new ArrayList<String>();
- ArrayList<String> sub_list = new ArrayList<String>();
- ArrayList<String> un_common_list = new ArrayList<String>();
- total_list.add("Beverages");
- total_list.add("Hot");
- total_list.add("Sai1");
- total_list.add("Sai2");
- total_list.add("Sai3");
- sub_list.add("Sai1");
- sub_list.add("Sai2");
- sub_list.add("Sai3");
- boolean inlist=false;
- for(int i=0;i<total_list.size();i++)
- {
- String total_name = total_list.get(i);
- for(int k=0;k<sub_list.size();k++)
- {
- String sub_name = sub_list.get(k);
- if(total_name.equals(sub_name))
- {
- inlist=true;
- }
- }
- if (!inlist){un_common_list.add(total_name);}
- inlist=false;
- }
- StringBuilder query_builder = new StringBuilder();
- query_builder.append("Update category SET ");
- //System.out.println(sub_list.size());
- for(int i=total_list.size();i>=1;i--)
- {
- if(i!=1)
- {
- query_builder.append("T"+i);
- query_builder.append(" = ");
- query_builder.append("NULL");
- query_builder.append(" , ");
- }
- else
- {
- query_builder.append("T"+i);
- query_builder.append(" = ");
- query_builder.append("NULL");
- }
- }
- System.out.println("UncommonList is "+un_common_list);
- System.out.println(query_builder);
- }
- }
- Update category SET T5 = NULL , T4 = NULL , T3 = NULL , T2 = NULL , T1 = NULL
- UncommonList is [Beverages, Hot]
- Update category SET T5 = NULL , T4 = NULL , T3 = NULL where T2 = 'Hot' AND T1 = 'Beverages'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement