How do I insert Unique values in MySQL using using Java

Question

I have to display two lists, where li lists the old values and newli lists the new values. Based on this requirement, How do I insert unique values in mysql using java?

List<String> li =new ArrayList<String>();
        li.add("abcd");
        li.add("efgh");
        li.add("ijkl");
        List<String> newli=new ArrayList<String>();
        newli.add("mnop");
        newli.add("qrst");
        newli.add("uvwx");
        newli.add("yz");
        newli.add("abcd");

            Iterator it = newli.iterator();
            while(it.hasNext()){
                String str=(String) it.next();
                if(str.equals(li))
                {
                    System.out.println("This element Already present");
                    break;
                }
                else
                    System.out.println(str);


            }
            System.out.println("Already present");
        }

pmckeown · Accepted Answer · 2014-04-08 07:51:48Z

1

Set<String> uniqueSet = new HashSet<String>(li);
uniqueSet.addAll(newLi);

That will give you all the unique values from the two lists in one Set.

answered Apr 8, 2014 at 7:51

pmckeown

4,4894 gold badges34 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How do I insert Unique values in MySQL using using Java

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related