Oracle批量插入数据SQL语句太长出错:无效的主机/绑定变量名

        @Override
	public int insertAllAuditSjxmfw(String sjxmdm, List<ZWXMZD> list) {
		sjxmManagerDao2.deleteAuditSjxmfw(sjxmdm, null);
		int num = 200;
		if (list.size() <= num) {
			sjxmManagerDao2.insertAllAuditSjxmfw(sjxmdm, list);
		} else {
			int times = (int) Math.ceil(list.size() / Double.valueOf(num));
			for (int i = 0; i < times; i++) {
				System.out.println("分批插入:"+ i);
				sjxmManagerDao2.insertAllAuditSjxmfw(sjxmdm, list.subList(i * num, Math.min((i + 1) * num, list.size())));
			}
		}
		return 1;
	}
posted @ 2019-09-16 15:55  ^sun^  阅读(398)  评论(0编辑  收藏  举报