String 对象是不可继承的,一旦定义一个字符串后,其字符串长度是不可变的。所以,在对字符串进行连接的时候,首先要把String对象转换成StringBuffer,然后在StringBuffer的缓存区进行连接,最后才把连接串赋给String对象。因此,在组合SQL语句的时候,如果需要反复进行字符串连接,不如把String换成StringBuffer。
StringBuffer SQL
=
new
StringBuffer(
"
SELECT * FROM
"
);
SQL.append( " table WHERE flag = 0 AND (rid = ' " );
for ( int i = 0 ; i < rids.length; i ++ ){
SQL.append(rids[i]);
SQL.append( " ' OR rid = ' " );SQL
}
SQL.replace( SQL.lastIndexOf( " OR rid = ' " ), SQL.length(), " ) " );
SQL.append( " table WHERE flag = 0 AND (rid = ' " );
for ( int i = 0 ; i < rids.length; i ++ ){
SQL.append(rids[i]);
SQL.append( " ' OR rid = ' " );SQL
}
SQL.replace( SQL.lastIndexOf( " OR rid = ' " ), SQL.length(), " ) " );