Take a look at the House Module

[jentle]

You can take the house module as a template to develop other module

• add house table using db/house.sql
• specify you database username and password in resource/housing.properites
• deploy in your tomcat 7.0
• visit localhost:8080/HousingSys/a/or/house
  you can page query and edit the house. You can easily extend to other entities

METION:
The id field may change to int and auto_increament because the jdbc do not auto_insert id. When you save the entity, you should not specify the id yourself