I need to create a GUI client for a MySql database. What's the best way to go about this with regards to having different panels for different views and entry forms? Surely I can't create a class for every table or view in the database, so I assume I need to get the number of columns and the names of columns from every result that the server returns and then pass them to the component I'm using, or create components like JTextFields for every column in a table and add them to the contentPane?
Are there any good guides on what GUI's should be like for end user database app's like this? Eg, the "home page" you get after logging in etc. ?