10th August
DB schema: add flag and terminate parent_id
configure multi data source (write configure xml)
define web services for front-end
11st August
define the Request and Response xml
think about QueryDAO and QueryService
XML --JAXB--> Request ---WebMethod---> Response ---JAXB---> XML
WebMethod: do DB queries and wrap results
12nd August
Implement QueryDao and think about final evaluation (my contribution and why this logic)
13rd August
Implement WebService
14th August
Review codes
1. use batch sql to decrease DB price
2. different responds and requests
3. use StringBuilder not String
4. use namedJdbcTemplate to inject parameters
5. use RowMapper to generate List, not RowBackHandler
6. change the date type to int, create index to make query faster
Plan 16th August
1. Fix all bugs and modified the program.
2. Think about how to make measurements to catch abnormal things.
3. Prepare for final evaluation