For a detailed description open the included MS-Word file PROJECT20170102.DOCX.
This is just a brief summary:
Write Java software to import structured text files into MySQL database. There are 17 file types and up to 18 files to import into 18 database tables.
The import is straightforward: every file is mapped to a table of the same name and the data is arranged in a simple way:
Each text line represents a DB record (unless it is a header row, and it is skipped) and each field has a fixed location and width. Except for one field, all fields are mapped ‘as-is’ One field is translated. The software that you will submit is a Java application that accepts a directory name and imports all the contained files into the database.
The project should be delivered as a portable Netbeans 8 project with all source code included, Java, SQL or whatever. A single project should include the library and the main module.
The base package name should bae [url removed, login to view]
The class that contains the interface is [url removed, login to view] and it is the class with the main() method.
The library and application should support Windows and Linux operating systems. In 99%, if you take care to always use [url removed, login to view], and never use the symbol “\\” then you will be fine. NOTE: If I do not wish to find any “\\” in the code I will ask you to change it before accepting anything.
For the DB access Use JPA 2.1, either EclipseLink or Hibernate implementation.
Make sure that your tables support Hebrew OEM 862 encoding (This is only important for one table)
Your delivery should consist on:
• MySQL script file to create the 18 tables into a database called ‘backoffice’. The names of the tables are provided in section 4 The Files.
• Netbeans 8 project with the name DiscountDataImporter with everything that is needed to build and run the application.
• The submitted architecture and code are expected to professional grade with clear, modular and object oriented design. I will reject ugly code.