怎么把字符串逗号相隔的都加上双引号

[ajdkjalj]

我获取了一个字符串"1,2,3,4",因为我想拼成sql语句的where条件 where id in ("1","2","3","4"),我要怎么处理才能达到效果

[podd]

截取成数组传进去就行了

[podd]

可以用正则

[nayi_224]

System.out.println("where id in (\"" + "1111,2,33,4".replaceAll(",", "\",\"") + "\"),");

[Silly-77]

		String s = "1,2,3,4";
		//将,替换为","  \是转译
		s.replaceAll(",", "\",\"");
		StringBuffer sb = new StringBuffer(s);
		//在字符串前面插入"
		sb.insert(0,"\"");
		//在字符串末尾追加"
		sb.append("\"");

输出结果为："1,2,3,4"

如果使用mybatis的话，有更便捷的方式的

	<insert id="insRolesById" parameterType="java.util.List">
		insert into roles_menus (roleid,menuid) values
		<foreach collection="param2" item="roleList"  open="(" close=")" separator="),(" >
	  		#{param1},#{roleList}
	  	</foreach>
	</insert>

输出结果为：insert into roles_menus (roleid,menuid) values (1,2),(1,3),(1,3)