@Override
	public List<Computer> getListComputers(int offset, int recordsPerPage)
			throws InstantiationException, IllegalAccessException,
			ClassNotFoundException, SQLException {

		List<Computer> ComputerList = new ArrayList<Computer>();
		ResultSet rs = null;
		Statement stmt = null;
		Connection cn = null;

		cn = ConnectionFactory.open();
		stmt = cn.createStatement();
		constraint= "";
		rs = stmt.executeQuery("select c.id,c.name, c.introduced, c.discontinued, cie.name from computer c LEFT OUTER JOIN company cie ON c.company_id= cie.id ORDER BY c.name LIMIT "+ offset + ", " + recordsPerPage);

		// création de la liste de computers
		try {
			while (rs.next()) {
				Computer c = new Computer();
				c.setId(rs.getInt(1));
				c.setName(rs.getString(2));
				c.setIntroduced(rs.getDate(3));
				c.setDiscontinued(rs.getDate(4));
				c.setCompanyName(rs.getString(5));
				ComputerList.add(c);
			}
			rs.close();
			
		} catch (SQLException e) {
			e.printStackTrace();
		}
		stmt.close();
		return ComputerList;
	}