public Item getItem(String name) {
        try {
            Statement st = dbc.connect().createStatement();
            String sql = ("SELECT * FROM orders WHERE name=" + "'"+name+"'");
            ResultSet rs = st.executeQuery(sql);
            item = null;
            if (rs.next()) {
                int quantity = rs.getInt("quantity");
                String location = rs.getString("location");
                item = new Item(name, quantity, location);
            }
            rs.close();
            st.close();
           
        } catch (ClassNotFoundException ex) {
            Logger.getLogger(ItemsDB.class.getName()).log(Level.SEVERE, null, ex);
        } catch (SQLException ex) {
            Logger.getLogger(ItemsDB.class.getName()).log(Level.SEVERE, null, ex);
        }
         return item;
    }