Well, there are all sorts of problems here. The first error is pretty clear: the variable "dbStatement" isn't declared anywhere. Most of the rest are pointing out an admirable burst of imagination on your part. Despite how lovely it might be, the java.sql.ResultSet interface does not sport member variables corresponding to each of your column names. You have to call the methods of this interface to access the data. You would probably benefit greatly from reading this tutorial on using JDBC. There are some other problems, too: local variables (like "validity") can't be declared public; and the class classHistory, not shown here, doesn't have a constructor with an argument list corresponding to the one you've shown here. But those error messages, again, are fairly clear -- you just have to read them.