Skip to main content

The DAO/Repository

  • Chapter
  • First Online:
  • 1594 Accesses

Abstract

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 text seen in Listing 7-1 in SQL Developer inside a new SQL worksheet.

This is a preview of subscription content, log in via an institution.

Buying options

eBook
USD   19.99
Price excludes VAT (USA)
  • Available as EPUB and PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD   24.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Learn about institutional subscriptions

Author information

Authors and Affiliations

Authors

Rights and permissions

Reprints and permissions

Copyright information

© 2017 Dave Wolf, A.J. Henley

About this chapter

Check for updates. Verify currency and authenticity via CrossMark

Cite this chapter

Wolf, D., Henley, A.J. (2017). The DAO/Repository. In: Java EE Web Application Primer. Apress, Berkeley, CA. https://doi.org/10.1007/978-1-4842-3195-1_7

Download citation

Publish with us

Policies and ethics