string
String str = "" ;
if ( str. length ( ) > 0 ) {
str+= ",'" + departs. get ( i) . getId ( ) + "'" ;
} else {
str= "'" + departs. get ( i) . getId ( ) + "'" ;
}
完整
String str = "" ;
for ( int i = 0 ; i < departs. size ( ) ; i++ ) {
if ( departs. get ( i) . getOrgType ( ) . equals ( "4" ) ) {
if ( str. length ( ) > 0 ) {
str+= ",'" + departs. get ( i) . getId ( ) + "'" ;
} else {
str= "'" + departs. get ( i) . getId ( ) + "'" ;
}
}
if ( departs. get ( 0 ) . getOrgType ( ) . equals ( "4" ) ) {
stStudentWrapper. inSql ( "st_class" , str) ;
}
另外一种String拼接
String departIds1 = "'" + StringUtils. join ( departIds, "','" ) + "'" ;
完整
public List< DepartListVo> getLists ( ) {
LoginUser sysUser = ( LoginUser) SecurityUtils. getSubject ( ) . getPrincipal ( ) ;
List< SysDepart> departs = sysDepartService. queryUserDeparts ( sysUser. getId ( ) ) ;
List< String> departIds = new ArrayList < > ( ) ;
for ( SysDepart sysDepart : departs) {
departIds. add ( sysDepart. getId ( ) ) ;
}
String departIds1 = "'" + StringUtils. join ( departIds, "','" ) + "'" ;
List< DepartListVo> tt = stProfessionMapper. getLists ( departIds1) ;
return tt;
}
StringBuffer
StringBuffer s = new StringBuffer ( ) ;
for ( int i = 0 ; i < departs. size ( ) ; i++ ) {
if ( departs. get ( i) . getOrgType ( ) . equals ( "3" ) ) {
s. append ( departs. get ( i) . getId ( ) ) ;
s. append ( "," ) ;
}
}
if ( departs. get ( 0 ) . getOrgType ( ) . equals ( "3" ) ) {
stStudentWrapper. in ( "profession" , s. toString ( ) ) ;
}