title: get rows of data from jdbc ResultSet
body: <p>I am trying to work with sqlite in Java using jdbc-sqlite. As I am not used to working with strongly typed languages, I expected to be able to make a SELECT query and the get the data returned in a list of rows.</p>
  
  <p>It then occured to me that collections in java can only hold objects of the same type, so this is probably why it is not readily possible.</p>
  
  <p>So how would I do this? Will I actually have to loop through all rows and then cast types in order to maintain polymorphism? Or will I need to harcode every single operation that uses data from a table/join? This seems to me absolutely insane.</p>
  
  <p>So, in short: How can I retrieve my data as rows?</p>