code: @Override
  	public List<RecordParam> getAll () throws DatabaseException {
      	SqlPreparedStatementWrapper psGetAll = null;
          try {
          	psGetAll = DbSQL.getSingleton().getPreparedStatement("param.ps.getall");
  			List<RecordParam> result = new ArrayList<>();
  			try (ResultSet rs = psGetAll.getPs().executeQuery()) {
  				while (rs.next()) {
  					result.add(new RecordParam(rs.getLong(PARAMID), rs.getString(SITE), rs.getString(TYPE),  
  							rs.getString(NAME), rs.getInt(USED), rs.getString(FLAGS), rs.getString(VALUES)));
  				}
  			}
  			
  			return result;
  		} catch (SQLException e) {
  			throw new DatabaseException(e);
  		} finally {
  			DbSQL.getSingleton().releasePreparedStatement(psGetAll);
  		}
      }
docs: /* (non-Javadoc)
  @see org.parosproxy.paros.db.paros.TableParam#getAll()