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).

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.

Is this approach ok? I realize it's simple but it's my first real project and I would appreciate a little feedback.

Also, is it too soon to consider reading up on design patterns and database design ?