public static String convertList2Str(List<String> list)
    {
        if (list == null || list != null && list.size() == 0)
        {
            return "";
        }
        String out = "";

        for (int i = 0; i < list.size(); i++)
        {
            if (list.get(i) == null)
            {
                continue;
            }
            if (i == (list.size() - 1))
            {
                out += "'" + list.get(i) + "'";
            }
            else
            {
                out += "'" + list.get(i) + "',";
            }
        }
        return out;
    }