Firebird Documentation IndexFirebird 3.0 Developer's Guide → Creating an Application with jOOQ and Spring MVC
Firebird Home Firebird Home Prev: The ResultFirebird Documentation IndexUp: Firebird 3.0 Developer's GuideNext: Organising the Folder Structure

Chapter 7: Creating an Application with jOOQ and Spring MVC

Table of Contents

Organising the Folder Structure
Coding the Configuration
Start-up Code—WebInitializer
Generating classes for jOOQ
jOOQ Classes
Dependency Injection
Configuring IoC Containers for Dependency Injection
Creating SQL Queries Using jOOQ
The jOOQ DSL
Named and Unnamed Parameters
Returning Values from SELECT Queries
Other Types of Queries
Stored Procedures with jOOQ
Working with Transactions
Explicit Transactions
Writing the Application Code
Creating the Primary Modules
CustomerManager Class
Customer Controller Class
Creating Secondary Modules
Invoice Items
InvoiceManager Class
Invoice Controller Class
Displaying the Invoices
The Result
Source Code

This chapter will describe how to create a web application in the Java language using the Spring MVC framework, the jOOQ library and a Firebird sample database.

To make development easier, you can use one of the popular IDEs for Java (NetBeans, IntelliJ IDEA, Eclipse, JDeveloper and others). I used NetBeans.

For testing and debugging purposes, we will also need to install one of the web servers or application servers (Apache Tomcat or GlassFish). We are basing our project on the Maven web application templates.

Prev: The ResultFirebird Documentation IndexUp: Firebird 3.0 Developer's GuideNext: Organising the Folder Structure
Firebird Documentation IndexFirebird 3.0 Developer's Guide → Creating an Application with jOOQ and Spring MVC