切割字符串为数组作为字符串参数传入sql中的两种方式
方式一: ‘XX1’,‘XX2’,‘XX2’,
##此方式需要切割最后一个,
String reviewReportIds="1,2,3,4,5";
String[] reviewReportAttr = reviewReportIds.slipt(",");
String reviewReportId = "";
for(int i=0;i<reviewReportAttr.length;i++){
reviewReportId+= "'"+reivewReportAttr[i]+"',"
}
if(reviewReport!="" && reviewReport.length>0){
reviewReportId=reviewReportId.substring(0,reviewReportId.length-1);
}
方式二: ‘XX1’,‘XX2’,‘XX2’
##此种情况为主动查询出多条数据,进行指定字段的拼接
String studentIdAttr = "";
for(Student student : StudentList){
String studentId = student.getId();
if(studentIdAttr!="" && studentIdAttr.length>0){
studentIdAttr += "'"+studentId+"'";
}else{
studentIdAttr += "'"+studentId+"',";
}
}