package day01;
public class Demo6 {
public static void main(String[] args) {
String a = "张三,李四,王五";
String b = getName(a);
System.out.println("b:"+b);
String sq = "SELECT * FROM USER WHERE NAME IN "+b+" ";
// SELECT * FROM USER WHERE NAME IN ('张三','李四','王五')
}
// 获取字符串,组合成sql条件的字符串
private static String getName(String username){
StringBuffer sb=new StringBuffer();
String[] arr = username.split(",");
for (int i = 0; i < arr.length; i++) {
if(sb.length()>0){
sb.append(",");
}
sb.append("'").append(arr[i]).append("'");
}
if(sb.length()<=0) sb.append("''");
return "("+sb.toString()+")";
}
}
【java 字符串SQ】字符串SQ中IN的用法(152)
最新推荐文章于 2024-10-17 10:27:13 发布