批量操作 ~~~ @Resource(name = "sqlSessionDao") private Dao dao; //批量插入 List<TfNList> list = new ArrayList(); TfNList n1 = new TfNList(); n1.setListId("111"); n1.setListName("測試"); list.add(n1); TfNList n2 = new TfNList(); n2.setListId("112"); n2.setListName("測試2"); list.add(n2); dao.insertBatch(list); //批量插入另一種寫法 dao.insertBatch(new ArrayList(){{ add(new TfNList(){{ setListId("111"); setListName("測試"); }}); add(new TfNList(){{ setListId("112"); setListName("測試2"); }}); }}); //批量更新 List<TfNList> list = new ArrayList(); TfNList n1 = new TfNList(); n1.setListId("111").asCondition(); n1.setListName("測試"); list.add(n1); TfNList n2 = new TfNList(); n2.setListId("112").asCondition(); n2.setListName("測試2"); list.add(n2); dao.updateBatch(list); //批量更新另一種寫法 dao.updateBatch(new ArrayList(){{ add(new TfNList(){{ setListId("111").asCondition();; setListName("測試"); }}); add(new TfNList(){{ setListId("112").asCondition();; setListName("測試2"); }}); }}); //設置條件時，調用每個實體類asCondition()方法是一種方式，還有另外一種方法，可指定條件列，方法定義如下： updateBatch(List<? extends BaseEntity> list, String... conditionColumns); //用法如下 dao.updateBatch(list, "LIST_ID", "CUST_TYPE"); //批量刪除 List<TfNList> list = new ArrayList(); TfNList n1 = new TfNList(); n1.setListId("111").asCondition(); list.add(n1); TfNList n2 = new TfNList(); n2.setListId("112").asCondition(); list.add(n2); dao.deleteBatch(list); //批量刪除另一種寫法 dao.deleteBatch(new ArrayList(){{ add(new TfNList(){{ setListId("111").asCondition();; }}); add(new TfNList(){{ setListId("112").asCondition();; }}); }}); //技巧：此種寫法目的是減少遍歷次數，某些值可不用事先設置，在BatchEachHandler里進行處理即可，insertBatch內部循環時會回調BatchEachHandler dao.insertBatch(list, new BatchEachHandler<TfNList>(){ @Override public void onEach(TfNList n){ n.setCreateTime(new Date()); } }); //另外也可自定義sql進行批量處理 void executeBatch(String statementId, List<?> list); void executeBatch(String statementId, List<?> list, BatchEachHandler batchEachHandler); ~~~