@GET
    @Path("getRetailProductList")
    @Produces("application/json")
    public Response getRetailProductList(@QueryParam("countryID") Long countryID) {
        System.out.println("RESTful: getRetailProductList() called with countryID " + countryID);
        try {
            List<RetailProduct> list = new ArrayList<>();
            String stmt = "";
            PreparedStatement ps;
            Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/islandfurniture-it07?zeroDateTimeBehavior=convertToNull&user=root&password=12345");

            if (countryID == null) {
                stmt = "SELECT i.ID as id, i.NAME as name, rp.IMAGEURL as imageURL, i.SKU as sku, i.DESCRIPTION as description, i.TYPE as type, i.CATEGORY as category FROM retailproductentity rp, itementity i where rp.ID=i.ID and i.ISDELETED=FALSE;";
                ps = conn.prepareStatement(stmt);
            } else {
                stmt = "SELECT i.ID as id, i.NAME as name, rp.IMAGEURL as imageURL, i.SKU as sku, i.DESCRIPTION as description, i.TYPE as type, i.CATEGORY as category, ic.RETAILPRICE as price FROM retailproductentity rp, itementity i, item_countryentity ic where rp.ID=i.ID and i.id=ic.ITEM_ID and i.ISDELETED=FALSE and ic.COUNTRY_ID=?;";
                ps = conn.prepareStatement(stmt);
                ps.setLong(1, countryID);
            }

            ResultSet rs = ps.executeQuery();
            while (rs.next()) {
                RetailProduct rp = new RetailProduct();

                rp.setSKU(rs.getString("sku"));
                rp.setId(rs.getLong("id"));
                rp.setImageUrl(rs.getString("imageURL"));
                rp.setType(rs.getString("type"));
                rp.setDescription(rs.getString("description"));
                rp.setCategory(rs.getString("category"));
                rp.setName(rs.getString("name"));

                if (countryID != null) {
                    rp.setPrice(rs.getDouble("price"));
                }


                list.add(rp);
            }
            GenericEntity<List<RetailProduct>> entity = new GenericEntity<List<RetailProduct>>(list) {
            };
            return Response
                    .status(200)
                    .header("Access-Control-Allow-Origin", "*")
                    .header("Access-Control-Allow-Headers", "origin, content-type, accept, authorization")
                    .header("Access-Control-Allow-Credentials", "true")
                    .header("Access-Control-Allow-Methods", "GET, POST, PUT, DELETE, OPTIONS, HEAD")
                    .header("Access-Control-Max-Age", "1209600")
                    .entity(entity)
                    .build();
        } catch (Exception ex) {
            ex.printStackTrace();
            return Response.status(Response.Status.NOT_FOUND).build();
        }
    }