.list(); for (HistoricActivityInstance historicActivityInstance : instance) { sqlExecutor.delete("delete from act_hi_actinst where id_= #{id}", historicActivityInstance);
public SqlExecuteResult doExecute(SqlInfo sqlInfo) { SqlExecuteResult result = new SqlExecuteResult(); Object executeResult = null; try { switch (sqlInfo.getType().toUpperCase()) { case "SELECT": QueryResultWrapper wrapper = new QueryResultWrapper(); executor.list(sqlInfo.getSql(), wrapper); executeResult = wrapper.getResult(); break; case "INSERT": case "UPDATE": executeResult = executor.update(sqlInfo.getSql()); break; case "DELETE": executeResult = executor.delete(sqlInfo.getSql()); break; default: executor.exec(sqlInfo.getSql()); } result.setSuccess(true); } catch (SQLException e) { throw new SqlExecuteException(e.getMessage(), e, sqlInfo.getSql()); } result.setResult(executeResult); result.setSqlInfo(sqlInfo); return result; } }
default int delete(String sql, Object params) throws SQLException { return delete(new SimpleSQL(sql, params)); }
default int delete(String sql) throws SQLException { return delete(new SimpleSQL(sql)); }
default int delete(String sql) throws SQLException { return delete(new SimpleSQL(sql)); }
default int delete(String sql, Object params) throws SQLException { return delete(new SimpleSQL(sql, params)); }
@Override public int exec() throws SQLException { Map<String, Object> context = null; boolean supportBefore = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_before); boolean supportDone = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_done); if (supportBefore || supportDone) { context = table.getDatabase().getTriggerContextRoot(); context.put("table", table); context.put("database", table.getDatabase()); context.put("param", param); } if (supportBefore) { tableMetaData.on(Trigger.delete_before, context); } SqlRender<Param> render = tableMetaData.getDatabaseMetaData().getRenderer(SqlRender.TYPE.DELETE); SQL sql = render.render(table.getMeta(), param); int size = sqlExecutor.delete(sql); if (supportDone) { context.put("total", size); tableMetaData.on(Trigger.delete_done, context); } return size; }
@Override public int exec() throws SQLException { Map<String, Object> context = null; boolean supportBefore = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_before); boolean supportDone = !triggerSkip && tableMetaData.triggerIsSupport(Trigger.delete_done); if (supportBefore || supportDone) { context = table.getDatabase().getTriggerContextRoot(); context.put("table", table); context.put("database", table.getDatabase()); context.put("param", param); } if (supportBefore) { tableMetaData.on(Trigger.delete_before, context); } SqlRender<Param> render = tableMetaData.getDatabaseMetaData().getRenderer(SqlRender.TYPE.DELETE); SQL sql = render.render(table.getMeta(), param); int size = sqlExecutor.delete(sql); if (supportDone) { context.put("total", size); tableMetaData.on(Trigger.delete_done, context); } return size; }
.list(); for (HistoricActivityInstance historicActivityInstance : instance) { sqlExecutor.delete("delete from act_hi_actinst where id_= #{id}", historicActivityInstance);
public SqlExecuteResult doExecute(SqlInfo sqlInfo) { SqlExecuteResult result = new SqlExecuteResult(); Object executeResult = null; try { switch (sqlInfo.getType().toUpperCase()) { case "SELECT": QueryResultWrapper wrapper = new QueryResultWrapper(); executor.list(sqlInfo.getSql(), wrapper); executeResult = wrapper.getResult(); break; case "INSERT": case "UPDATE": executeResult = executor.update(sqlInfo.getSql()); break; case "DELETE": executeResult = executor.delete(sqlInfo.getSql()); break; default: executor.exec(sqlInfo.getSql()); } result.setSuccess(true); } catch (SQLException e) { throw new SqlExecuteException(e.getMessage(), e, sqlInfo.getSql()); } result.setResult(executeResult); result.setSqlInfo(sqlInfo); return result; } }