title: Personal project in Java, how to approach the database access?
body: <p>My first project in java is going to be a program (eventually I have to create a GUI interface but for now CLI would do) to keep track of my books (something similar to what libraries have only a simpler). 
  I need to be able to insert, update, remove, show all books, update, search(by name or author or date). </p>
  
  <p>For the design I was thinking one main class Library which will have all of the above as methods that connect to the db and retrieve the data.</p>
  
  <p>Is this approach ok? I realize it's simple but it's my first real project and I would appreciate a little feedback. </p>
  
  <p>Also, is it too soon to consider reading up on design patterns and database design ? </p>