Advertisement
Guest User

Untitled

a guest
Dec 20th, 2014
128
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.71 KB | None | 0 0
  1. //size of input obj is around 15K
  2. public generateQuery(List<DBObj> objs){
  3.  
  4. StringBuffer sb = new StringBuffer();
  5. sb.append(SOMEINSERTQUERYPREFIX)
  6.  
  7. for(DBObj obj : objs){
  8. //add some prefix
  9. sb.append(append(checkNULLforDBInsert(obj.getF1())).append(" , ");
  10. sb.append(checkNULLforDBInsert(obj.getField2())).append(" , ");
  11. sb.append(checkNULLforDBInsert(obj.getField3())).append(" , ");
  12. //app sufix
  13. }
  14.  
  15. }
  16.  
  17.  
  18. private String checkNULLforDBInsert(String str)
  19. {
  20.  
  21. if (str == null || str.toLowerCase().equals("null"))
  22. {
  23.  
  24. return "null";
  25. } else {
  26. //suspecting this for leak
  27. return "'" + str + "'";
  28. }
  29.  
  30. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement