Advertisement
Guest User

Untitled

a guest
Nov 27th, 2014
130
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.98 KB | None | 0 0
  1. import java.util.ArrayList;
  2. import java.util.List;
  3.  
  4. import org.json.JSONException;
  5.  
  6. public class MrTest {
  7. public static void main(String args[]) throws JSONException
  8. {
  9. ArrayList<String> total_list = new ArrayList<String>();
  10. ArrayList<String> sub_list = new ArrayList<String>();
  11. ArrayList<String> un_common_list = new ArrayList<String>();
  12. total_list.add("Beverages");
  13. total_list.add("Hot");
  14. total_list.add("Sai1");
  15. total_list.add("Sai2");
  16. total_list.add("Sai3");
  17.  
  18.  
  19.  
  20. sub_list.add("Sai1");
  21. sub_list.add("Sai2");
  22. sub_list.add("Sai3");
  23.  
  24.  
  25. boolean inlist=false;
  26. for(int i=0;i<total_list.size();i++)
  27. {
  28. String total_name = total_list.get(i);
  29. for(int k=0;k<sub_list.size();k++)
  30. {
  31. String sub_name = sub_list.get(k);
  32. if(total_name.equals(sub_name))
  33. {
  34. inlist=true;
  35. }
  36. }
  37. if (!inlist){un_common_list.add(total_name);}
  38. inlist=false;
  39. }
  40. StringBuilder query_builder = new StringBuilder();
  41. query_builder.append("Update category SET ");
  42. //System.out.println(sub_list.size());
  43. for(int i=total_list.size();i>=1;i--)
  44. {
  45. if(i!=1)
  46. {
  47. query_builder.append("T"+i);
  48. query_builder.append(" = ");
  49.  
  50. query_builder.append("NULL");
  51. query_builder.append(" , ");
  52. }
  53. else
  54. {
  55. query_builder.append("T"+i);
  56. query_builder.append(" = ");
  57.  
  58. query_builder.append("NULL");
  59.  
  60. }
  61.  
  62. }
  63.  
  64. System.out.println("UncommonList is "+un_common_list);
  65. System.out.println(query_builder);
  66.  
  67. }
  68.  
  69. }
  70.  
  71. Update category SET T5 = NULL , T4 = NULL , T3 = NULL , T2 = NULL , T1 = NULL
  72.  
  73.  
  74. UncommonList is [Beverages, Hot]
  75.  
  76. 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