将查询到的数据插入到表中

//zxj 添加分配关系，需要说明的是分配关系是和公司，可能会存在联系人为空的，不应该和联系人有关系啊 if(accountList != null && accountList.size() > 0){ StringBuilder addAssignSql = new StringBuilder(); addAssignSql.append(" insert into hp_assignment(case_pk,account_pk,has_dialup,created_date,contact_id) "); addAssignSql.append(" select ? as case_pk, ha.pk_id as account_pk, 0 as has_dialup, getdate() as created_date, isnull(hc.pk_id,0) "); addAssignSql.append(" from hp_accounts ha left join hp_contacts hc on ha.code = hc.account_pk where ha.pk_id = ? order by account_pk desc "); List<Object[]> paramsList = new ArrayList<Object[]>(); for(AccountVO account : accountList){ paramsList.add(new Object[]{conditions.getCase_id(), account.getCode_sinodb()}); } getCommonDAO().batchUpdate(addAssignSql.toString(),paramsList); }