Oracle database, query increases RowBounds limit the number of query entries, default is 0 to 1000
private final static int rowLimit = 1000; //Limit the number of queries private final static RowBounds QUERY_LIMIT=new RowBounds(0,rowLimit); public List<T> select(String sqlID, T t) throws DBException, RecordNotFoundException { List<T> ret; try { if ("".equals(sqlID) || (null == sqlID)) { ret = getSqlSession().selectList(t.getMapperName() + SELECT, t,QUERY_LIMIT); } else { ret = getSqlSession().selectList(t.getMapperName() + MAPPER + sqlID, t,QUERY_LIMIT); } } catch (Exception e) { LOGGER.error(e.getMessage(), e); LOGGER.debug(t.toString()); throw new DBException(e); } if (ret == null && checkNull) { throw new RecordNotFoundException(t.getTableName()); } return ret; }The above is the implementation code for Mybatis RowBounds to limit the number of query items introduced by the editor. I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to everyone in time. Thank you very much for your support to Wulin.com website!