BUILDING A CLEAN CRUD WRAPPER FOR ORACLE SQL IN JAVA

If you are currently working on a Database Design and Development assignment, you know the pain of transforming a database from 1NF to 3NF. But after the normalization nightmare comes another challenge: connecting your Java application to your Oracle database. When Java developers sit down at their IDEs like JetBrains or NetBeans to write their CRUD operations like Create, Read, Update, Delete, they soon find that their code is a mess. They are copying and pasting their database connection string into a lot of different methods, failing to close database connections that cause timeout exceptions, and concatenating strings to build SQL queries that leave themselves vulnerable to SQL injection attacks. Today, we’re going to solve this problem once and for all by creating a clean and secure object-oriented programming interface to our Oracle database using standard Java JDBC. THE PROBLEM: THE COPY-PASTE ANTI-PATTERN Here is what a standard, messy database call looks like when you put ever