Fatworm 2014:JDBC Taste
Introduction
According to my experience, only few students had experience using database systems or JDBC. If you are not familiar with JDBC, you may make bad design decision later, such as unnecessary class wrappers, crashing schema representation. Therefore, before you take action, I make this jdbc-taste in order to force you to know how your Fatworm will work in real world.
In this taste, you have three models called person, joke and comment. A person can tell a joke, upvote a joke, or comment on others' jokes. The code is easy to read, and all the instructions are just in the comments of each java file. Have a good time with this taste.
Requirement
You can grep all "TODO" in the project. They are mainly in Sqlite Data Access Objects, and a schema practice lies in the CreateTablesTask. Complete all these functions.
I think some of you may have already mastered in JDBC. Since the purpose for this taste is to give you some experience with JDBC, you can have two options to finish this taste.
Tips
Since this is the first time I design this taste, there may be some mistakes. If you find something wrong, directly post it in group. Any comment is welcome.