mybatis RowBounds 限制查询条数详解数据库

oracle 数据库，查询增加RowBounds限制查询条数，默认是0到1000条

	private final static int rowLimit = 1000; 
	 
	//限制查询条数 
	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; 
 
	}