public String splitInCondition(ListdataList, String columnName, String type)

{

String relation = null;

if ("in".equalsIgnoreCase(type))

{

relation = " OR ";

}

else

{

relation = " AND ";

}

// 需要返回的sql的in子語句

StringBuilder sqlBuilder = new StringBuilder("(" + columnName + " " + type + " (");

// 列表長度

int dataSize = dataList.size();

int count = 0;

while (count < dataSize)

{

if ((count + 1) % 1000 == 0)

{

sqlBuilder.deleteCharAt(sqlBuilder.lastIndexOf(","));

sqlBuilder.append(") " + relation + " " + columnName + " " + type + " (");

}

sqlBuilder.append('\'');

sqlBuilder.append(dataList.get(count));

sqlBuilder.append('\'');

sqlBuilder.append(',');

count++;

}

// 刪除最后一個,

sqlBuilder.deleteCharAt(sqlBuilder.lastIndexOf(","));

// 添加右括號

sqlBuilder.append(')');

sqlBuilder.append(')');

return sqlBuilder.toString();

}

總結(jié)

以上是生活随笔為你收集整理的java oracle in 10000_java支持ORACLE的in不能超过1000的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。