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_15

15. How to Create Database Tables for Bullhorn

Dave Wolf¹  and A. J. Henley²

(1)New York, USA

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

Scripts for creating the database tables are included with the source code for Bullhorn . I usually recommend saving SQL scripts in a folder within your project called SQL Scripts so you can easily recreate the database on other systems.

To create a table in a database , you code the table name followed by the field names and data types, as shown in Listing 15-1. The POSTID and BHUSERID fields in the code listing are generated by the database.

You can create the tables by running ...