I haven't read all your code, still I can try and give you few hints:
1. Why do you include com.mysql.xxx ...
Usually you need java.sql.xxx alternatives. ( xxx is Connection and Statement )
2. Consider separating sql queries from visualization -
make a class that will query you database for the information and will have getters and another class that will contain the GUI code and will use the getters of the first class - this will make it easier to read your code and fix bugs/mistakes (If you are not in a hurry read about Model-View-Controller).
Sorry, I don't have time right now to supply a working code fragment...
|