/** * Executes a prepared query that was generated using generatePreparedQuery. * * @param prep the prepared statement * @param min the lower values * @param max the upper values * @return the result set */ public ResultSet getResult(PreparedStatement prep, int[] min, int[] max) throws SQLException { long[][] ranges = getMortonRanges(min, max); int len = ranges.length; Long[] from = new Long[len]; Long[] to = new Long[len]; for (int i = 0; i < len; i++) { from[i] = ranges[i][0]; to[i] = ranges[i][1]; } prep.setObject(1, from); prep.setObject(2, to); len = min.length; for (int i = 0, idx = 3; i < len; i++) { prep.setInt(idx++, min[i]); prep.setInt(idx++, max[i]); } return prep.executeQuery(); }
/** * Executes a prepared query that was generated using generatePreparedQuery. * * @param prep the prepared statement * @param min the lower values * @param max the upper values * @return the result set */ public ResultSet getResult(PreparedStatement prep, int[] min, int[] max) throws SQLException { long[][] ranges = getMortonRanges(min, max); int len = ranges.length; Long[] from = new Long[len]; Long[] to = new Long[len]; for (int i = 0; i < len; i++) { from[i] = new Long(ranges[i][0]); to[i] = new Long(ranges[i][1]); } prep.setObject(1, from); prep.setObject(2, to); len = min.length; for (int i = 0, idx = 3; i < len; i++) { prep.setInt(idx++, min[i]); prep.setInt(idx++, max[i]); } return prep.executeQuery(); }
/** * Executes a prepared query that was generated using generatePreparedQuery. * * @param prep the prepared statement * @param min the lower values * @param max the upper values * @return the result set */ public ResultSet getResult(PreparedStatement prep, int[] min, int[] max) throws SQLException { long[][] ranges = getMortonRanges(min, max); int len = ranges.length; Long[] from = new Long[len]; Long[] to = new Long[len]; for (int i = 0; i < len; i++) { from[i] = Long.valueOf(ranges[i][0]); to[i] = Long.valueOf(ranges[i][1]); } prep.setObject(1, from); prep.setObject(2, to); len = min.length; for (int i = 0, idx = 3; i < len; i++) { prep.setInt(idx++, min[i]); prep.setInt(idx++, max[i]); } return prep.executeQuery(); }
/** * Executes a prepared query that was generated using generatePreparedQuery. * * @param prep the prepared statement * @param min the lower values * @param max the upper values * @return the result set */ public ResultSet getResult(PreparedStatement prep, int[] min, int[] max) throws SQLException { long[][] ranges = getMortonRanges(min, max); int len = ranges.length; Long[] from = new Long[len]; Long[] to = new Long[len]; for (int i = 0; i < len; i++) { from[i] = Long.valueOf(ranges[i][0]); to[i] = Long.valueOf(ranges[i][1]); } prep.setObject(1, from); prep.setObject(2, to); len = min.length; for (int i = 0, idx = 3; i < len; i++) { prep.setInt(idx++, min[i]); prep.setInt(idx++, max[i]); } return prep.executeQuery(); }
long[][] ranges = getMortonRanges(min, max); StringBuffer buff = new StringBuffer("SELECT * FROM ("); for (int i = 0; i < ranges.length; i++) {