Hands-On Design Patterns with Java

Load

The loading process is usually straightforward. The specifics will be unique to the system and the selected core database or other data repository. Typically, this will involve the following steps:

1. Open the database
2. Write new records
3. Close the database

Here is an example statement for step 1, Open the database:

. . . Connection con = null;con = csvParser.getConnection("jdbc:oracle:thin:PACKT/ETL@localhost:1500:leadsDB");. . .

Writing the records involves the process of inserting them into the current database. Here is an example:

. . . INSERT INTO Leads (leadName, leadPhone, leadEmail, leadAddress, leadCity, leadState, leadZip) VALUES ('Neo Anderson', '000-000-0000', '[e-mail]', '1 White Rabbit Trail', 'Zion', 'MZ', ...