public List<Item> getItems() {
        List<Item> list = new ArrayList<>();
        Connection con = null;
        Statement stmt = null;
        try {
            DBconnection dbCon = new DBconnection();
            Class.forName(dbCon.getJDBC_DRIVER());

            con = DriverManager.getConnection(dbCon.getDATABASE_URL(),
                    dbCon.getDB_USERNAME(), dbCon.getDB_PASSWORD());

            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery("Select * From item order by itm_id");
        
            while (rs.next()) {
                Item item = new Item();
                item.setId(rs.getLong(1));
                item.setName(rs.getString(2));
                item.setBarcode(rs.getString(3));
                item.setImgBracodePath(rs.getString(4));
                item.setImgPath(rs.getString(5));
                item.setDescription(rs.getString(6));
                item.setAvgUnitCost(rs.getDouble(7));
                item.setSaleRentPrice(rs.getDouble(8));
                item.setMinLimit(rs.getInt(9));
                item.setMaxLimit(rs.getInt(10));
                item.setQuantity(rs.getInt(11));
                item.setIsAvailable(rs.getBoolean(12));
                item.setIsActive(rs.getBoolean(13));
                item.setDeactivationReason(rs.getString(14));
                item.setItemCategory_id(rs.getInt(15));
                list.add(item);
               
            }
        } catch (SQLException | ClassNotFoundException ex) {
            System.err.println("Caught Exception: " + ex.getMessage());
        } finally {
            try {
                if (stmt != null) {
                    stmt.close();
                }
                if (con != null) {
                    con.close();
                }
            } catch (SQLException ex) {
                System.err.println("Caught Exception: " + ex.getMessage());
            }
        }
        System.err.println(list.size());
        return list;
    }