I am planning on building an app which finds details of a particular manufacturers vehicle by entering the VIN number of the vehicle and then displaying the relevant details to the user.
I will store each letter and number along with their meanings and descriptions.
To store the above I have thought about a table in SQL and then accessing the rows and columns via JDBC. I have also thought about a switch statement. Bearing in mind the app would have to read each character. Example, the VIN starts with EF, E meaning Europe, F meaning France.
What would be the best and most efficient way or tool to store this information that would be easily accessible through the app?
I have tried searching the web for VIN tables, there are many tables available but hardly any details on the creation of these tables.
The application will be built in Android Studio.
Any feedback appreciated.
Thanks in advance.
Well for starters being very organized is a must with this project, probably includes sorting the years of the cars, manufacturer, location, ect. Now would this be limited to cars? And can you elaborate on what you mean for a switch element?
Sorry I can't be more detailed I just need more information on the project. :)