public void order(String name, int quantity, String location) throws ClassNotFoundException {
        try {

            prodsQuery = dbc.connect().prepareStatement("INSERT INTO 'items' (name, quantity, location)"
                    + "VALUES (?,?,?);");
            prodsQuery.setString(1, name);
            prodsQuery.setInt(2, quantity);
            prodsQuery.setString(3, location);
            prodsQuery.executeUpdate();
            prodsQuery.close();

            SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");
            String strDate = sdf.format(new Date());
            prodsQuery = dbc.connect().prepareStatement("INSERT INTO 'orders' (name, quantity, date)"
                    + "VALUES (?,?,?);");
            prodsQuery.setString(1, name);
            prodsQuery.setInt(2, quantity);
            prodsQuery.setString(3, strDate);
            prodsQuery.executeUpdate();
            prodsQuery.close();
        } catch (SQLException ex) {
            Logger.getLogger(SuppliersDB.class.getName()).log(Level.SEVERE, null, ex);
        } finally {
            try {
                prodsQuery.close();
            } catch (SQLException ex) {
                Logger.getLogger(SuppliersDB.class.getName()).log(Level.SEVERE, null, ex);
            }
        }
    }