sql用中in java代码拼接

 

 String[] flagStr3 = {application, "服务部长", "产品部长", "服务部长", "产品部长", "代表处企业业务部部长", "地区部长"};

                    StringBuilder sb = new StringBuilder();
                  for (int i = 0; i < flagStr.length; i++) {
                        sb.append("'" + flagStr[i] + "'");//拼接单引号,到数据库后台用in查询.  
                        sb.append(",");
                    }
                    String str =    (sb.substring(0,sb.length()-1)).toString();//把最后多余的","去掉
                    emMap.put("role_name", sb);

sql用$