Java EE Web Application Primer: Building Bullhorn: A Messaging App with JSP, Servlets, JavaScript, Bootstrap and Oracle

© Dave Wolf, A.J. Henley 2017

Dave Wolf and A.J. Henley, Java EE Web Application Primer, https://doi.org/10.1007/978-1-4842-3195-1_7

7. The DAO/Repository

Dave Wolf¹  and A. J. Henley²

(1)New York, USA

(2)Washington, D.C., District of Columbia, USA

Bullhorn requires two tables, for users and posts. We’ll create these tables in Oracle and call them Bhuser and Bhpost, respectively. The user table will need the following fields: user name, user email, password, motto, and join date. The posts table will contain fields for post text, post date, and the ID of the user who created the post. Each table will also contain an ID field to uniquely identify each record. We can instruct SQL Developer to construct the tables by running scripts. Simply enter the ...