resultsStatement = conn.prepareStatement(resultsQueryString); JDBCUtil.bindNTimes(resultsStatement, batchIds, 1);
resourceIdSubArray.length); ps = conn.prepareStatement(transformedQuery); JDBCUtil.bindNTimes(ps, resourceIdSubArray, 1); ps.execute(); ps.close();
insertStatement = conn.prepareStatement(insertQueryString); JDBCUtil.bindNTimes(insertStatement, batchIds, 1);
insertImplicitStatement = conn.prepareStatement(insertImplicitQueryString); insertImplicitStatement.setInt(1, groupId); JDBCUtil.bindNTimes(insertImplicitStatement, resourceIdsToAdd, 2); insertImplicitStatement.executeUpdate();
deleteImplicitStatement = conn.prepareStatement(deleteImplicitQueryString); deleteImplicitStatement.setInt(1, groupId); JDBCUtil.bindNTimes(deleteImplicitStatement, resourceIdsArray, 2); deleteImplicitStatement.executeUpdate(); deleteExplicitStatement = conn.prepareStatement(deleteExplicitQueryString); deleteExplicitStatement.setInt(1, groupId); JDBCUtil.bindNTimes(deleteExplicitStatement, resourceIdsArray, 2); deleteExplicitStatement.executeUpdate(); } catch (SQLException sqle) {
insertExplicitStatement = conn.prepareStatement(insertExplicitQueryString); insertExplicitStatement.setInt(1, groupId); JDBCUtil.bindNTimes(insertExplicitStatement, resourceIdsToAdd, 2); insertExplicitStatement.executeUpdate(); } catch (SQLException sqle) {
insertImplicitStatement = conn.prepareStatement(insertImplicitQueryString); insertImplicitStatement.setInt(1, implicitRecursiveGroupId); JDBCUtil.bindNTimes(insertImplicitStatement, ArrayUtils.unwrapCollection(resourceIdsToAdd), 2); insertImplicitStatement.executeUpdate();
defUpdateStmt.setLong(i++, collectionInterval); JDBCUtil.bindNTimes(defUpdateStmt, measurementDefinitionIds, i); defUpdateStmt.executeUpdate(); schedUpdateStmt.setLong(i++, collectionInterval); JDBCUtil.bindNTimes(schedUpdateStmt, measurementDefinitionIds, i++); schedUpdateStmt.executeUpdate();