Fatworm 2013: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.
1. You finish all the blanks, and make it pass all tests. Send your code via email before 5:00 March 22th. 2. If you are already familiar with JDBC and confident in yourself, you can meet me at SEIEE building 3-404 at 5:00 p.m March 22th. If you can correctly answer my questions, you can also be regarded as being passed.
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.