@Override
    public List<SupplierEntity> findAllSupplier() throws SupplierException {
        String query;
        List<SupplierEntity> list = new ArrayList<SupplierEntity>();
        try {
            query = " SELECT * FROM supplier";
            conn = getConnection();
            sth = conn.prepareStatement(query);
            res = sth.executeQuery();
            while (res.next()) {
                SupplierEntity entity = new SupplierEntity();
                entity.setSupplier_id(res.getString("supplier_id"));
                entity.setSupplier_name(res.getString("supplier_name"));
                entity.setSupplier_address(res.getString("supplier_address"));
                entity.setSupplier_phone(res.getString("supplier_phone"));
                entity.setSupplier_email(res.getString("supplier_email"));
                entity.setSupplier_lastmodif(res.getString("supplier_lastmodif"));
                list.add(entity);
            }
            return list;
        } catch (SQLException e) {
            throw new SupplierException(e.getMessage());
        } finally {
            try {
                if (sth != null) {
                    sth.close();
                }
                if (conn != null) {
                    conn.close();
                }
            } catch (SQLException e) {
            } catch (Exception e) {
            }
        }
    }