How is it best to work with the table?



  • I'll explain the cars. I have a table in CSV with a lot of poles and lines. First columns (for a sorting filter) - Type (light, jeep, cargo), producer (VAZ, Porsch, Ford), followed by columns with parameters - Volume, Prize, Colour, etc. The program will need filter mode and selection mode. Let's say there's 90 lines of each type, in each type, for 10 positions of each manufacturer.

    Filter mode: all unique Types are taken from the table and transmitted to Spinner. After selection on the rolling list, e.g. light, in the second Spinner, all manufacturers with a Tip column light.

    Selection mode: all unique Types are taken from the table and transmitted to Spinner. The Type is selected and certain parameters from other columns are applied. This is followed by a selection from the table of criteria. I've been doing the job once, but it's been a colossal way. Now I want a better approach.

    I see the solution: to create a class of vehicles with fields for all columns. When activated, the table will be counted and a collection of all the lines of the table shall be established in the vehicle facility. In the classroom, create some functions of refilled rubber collections, unique lists, etc. Well, the results are on the list. Tell me what methods and what better use is? It's just masses, hash, mop, as fast as filtering/selecting, etc.



  • Go. http://mobilesiri.com/android-sqlite-database-tutorial-using-android-studio/ and https://developer.android.com/training/basics/data-storage/databases.html Or find Russian textbooks for using SQLite in Android.

    The point is, you don't need to invent a bike from scratch. Loading CSV in the bud and having all the power of SQL enquiries, rapid indexing and cashing.




Suggested Topics

  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2
  • 2