I am trying to insert values from a .csv file into a MySQL database from a GUI. I cannot seem to accomplish this. I keep getting a null pointer exception where I set the connection properties in my main method. I also cannot seem to figure out how to use the importData() method after setting my variables in my GUI. I currently have that method called in the main method. I would appreciate any help anyone can give me. Thank you. Here is my code:
If an exception is been thrown in your connect() method you're completely ignoring the exception, only printing the trace and returning null.
That is indeed asking for trouble. The returned connection should in no way be null. You know, if you invoke/access some object reference which is actually null, you'll see NullPointerExceptions flying around. And that would happen when you call Connection#createStatement().
(didn't you notice the printed trace from connect() by the way?)
subject: NullPointerException when trying to connect to MySQL Database