StringBuffer sql = new StringBuffer();
for(int i=0;i<listSP.length;i++){
if(listSP.length==i+1){
sql.append("'"+listSP[i]+"'");
}else{
sql.append("'"+listSP[i]+"',");
}
}
sql.append("from spinfo sp where sp.spCode in ("+sql.toString()+")");
这是打印出来的SQL:
from spinfo sp where sp.spCode in ('10159339,10159333')
要怎么样改才能这样:from spinfo sp where sp.spCode in ('10159339','10159333')
急救!!!!!!!!!!!!!!!1
for(int i=0;i<listSP.length;i++){
if(listSP.length==i+1){
sql.append("'"+listSP[i]+"'");
}else{
sql.append("'"+listSP[i]+"',");
}
}
sql.append("from spinfo sp where sp.spCode in ("+sql.toString()+")");
这是打印出来的SQL:
from spinfo sp where sp.spCode in ('10159339,10159333')
要怎么样改才能这样:from spinfo sp where sp.spCode in ('10159339','10159333')
急救!!!!!!!!!!!!!!!1
if(listSP.length==i+1){
sql.append(",'"+listSP[i]+"'");
}else{
sql.append(",'"+listSP[i]+"',");
}
}String newsql = "from spinfo sp where sp.spCode in ("+sql.substring(1).toString()+")";
if (listSP.length == i + 1) {
sql.append("'" + listSP[i] + "'");
} else {
sql.append("'" + listSP[i] + "',");
}
}