Java Programming and Database Interaction
Description
The course is oriented to give the knowledge on how to design and to program a Java application of desktop that manages a database. Advanced programming and design themes are addressed to facilitate the use of objects and variables, allowing scalability. The use of exceptions at the lowest abstraction level is envisaged in order to make the code easy to maintain. It is intended in this way that the student obtains a solid knowledge of Java and the interaction with databases.
Contents
Logical data model. Standardization. Physical design. The SQL language. SQL-DML and SQL-DDL. Implementation of a database using MySQL.
Exceptions in Java. Concept. Blocks Try and Catch. JDBC API. The JDBC Driver, concept, features and main classes. Application View and Business View. Business View: Class Design to map Relational Model Tables (Base Classes). Classes middleware or mapping-core package: how to code the complexity of exceptions and communication with the database outside the Application View to facilitate reuse of the code.
Creating the Application View with JFrame, JInternalFrame and Advanced Menus with Java Swing. IDM (Insert, Delete and Modify) operations separating the Business View from the Application View.
Requirements and Conditions
12 weeks (3 months) with an estimated time of dedication for the student of 4-6 hours per week.
Professionals, technicians and computer enthusiasts.
Basic and solid computer skills required.
20 participants.
