1. Delete the file

    2. Create the WEB-INF folder inside the Web Pages folder

    3. Create the jsp, jspf and resources folders inside the WEB-INF folder

    4. Create the js and CSS folders inside the resources folder

    The new structure of the folders should look like this:

    Figure 43. Folder structure for the template-based project

    The WEB-INF/jsp folder will contain jsp pages and the jspf folder will contain page fragments that will be added to other pages using the following directive:

    Now, we modify the pom.xml file and add the general properties of the application, dependencies on library packages (Spring MVC, Jaybird, JDBC pool, JOOQ) and the properties of the JDBC connection.

    1. <?xml version="1.0" encoding="UTF-8"?>
    2. <project xmlns="http://maven.apache.org/POM/4.0.0"
    3.         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
    4.         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    5.     <modelVersion>4.0.0</modelVersion>
    7.     <groupId>ru.ibase</groupId>
    8.     <artifactId>fbjavaex</artifactId>
    9.     <version>1.0-SNAPSHOT</version>
    10.     <packaging>war</packaging>
    12.     <name>Firebird Java Example</name>
    14.     <properties>
    15.         <endorsed.dir>${project.build.directory}/endorsed</endorsed.dir>
    16.         <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
    17.         <spring.version>4.3.20.RELEASE</spring.version>
    18.         <jackson.version>2.9.7</jackson.version>
    19.         <jooq.version>3.9.2</jooq.version>
    20.         <jstl.version>1.2</jstl.version>
    21.         <javax.servlet.version>3.0.1</javax.servlet.version>
    22.         <jaybird.version>3.0.5</jaybird.version>
    23.         <db.url>jdbc:firebirdsql://localhost/examples</db.url>
    24.         <db.driver>org.firebirdsql.jdbc.FBDriver</db.driver>
    25.         <db.username>SYSDBA</db.username>
    26.         <db.password>masterkey</db.password>
    27.     </properties>
    30.     <dependencies>
    31.         <dependency>
    32.             <groupId>javax</groupId>
    33.             <artifactId>javaee-web-api</artifactId>
    34.             <version>7.0</version>
    35.             <scope>provided</scope>
    36.         </dependency>
    38.         <dependency>
    39.             <groupId>javax.servlet</groupId>
    40.             <artifactId>javax.servlet-api</artifactId>
    41.             <version>${javax.servlet.version}</version>
    42.             <scope>provided</scope>
    43.         </dependency>
    45.         <dependency>
    46.             <groupId>jstl</groupId>
    47.             <artifactId>jstl</artifactId>
    48.             <version>${jstl.version}</version>
    49.         </dependency>
    51.         <!-- Working with JSON -->
    52.         <dependency>
    53.             <groupId>com.fasterxml.jackson.core</groupId>
    54.             <artifactId>jackson-core</artifactId>
    55.             <version>${jackson.version}</version>
    56.         </dependency>
    59.             <groupId>com.fasterxml.jackson.core</groupId>
    60.             <artifactId>jackson-annotations</artifactId>
    61.             <version>${jackson.version}</version>
    62.         </dependency>
    64.         <dependency>
    65.             <groupId>com.fasterxml.jackson.core</groupId>
    66.             <artifactId>jackson-databind</artifactId>
    67.         </dependency>
    69.         <!-- Spring -->
    71.         <dependency>
    72.             <groupId>org.springframework</groupId>
    73.             <artifactId>spring-core</artifactId>
    74.             <version>${spring.version}</version>
    75.         </dependency>
    77.         <dependency>
    78.             <groupId>org.springframework</groupId>
    79.             <artifactId>spring-web</artifactId>
    80.             <version>${spring.version}</version>
    81.         </dependency>
    83.         <dependency>
    84.             <groupId>org.springframework</groupId>
    85.             <artifactId>spring-webmvc</artifactId>
    86.             <version>${spring.version}</version>
    87.         </dependency>
    89.         <dependency>
    90.             <groupId>org.springframework</groupId>
    91.             <artifactId>spring-context</artifactId>
    92.             <version>${spring.version}</version>
    93.         </dependency>
    95.         <dependency>
    96.             <groupId>org.springframework</groupId>
    97.             <artifactId>spring-jdbc</artifactId>
    98.             <version>${spring.version}</version>
    99.         </dependency>
    101.         <!-- JDBC -->
    103.         <dependency>
    104.             <groupId>org.firebirdsql.jdbc</groupId>
    105.             <artifactId>jaybird-jdk18</artifactId>
    106.             <version>${jaybird.version}</version>
    107.         </dependency>
    109.         <!-- Connection pool -->
    111.         <dependency>
    112.             <groupId>commons-dbcp</groupId>
    113.             <artifactId>commons-dbcp</artifactId>
    114.             <version>1.4</version>
    115.         </dependency>
    117.         <!-- jOOQ -->
    119.         <dependency>
    120.             <groupId>org.jooq</groupId>
    121.             <artifactId>jooq</artifactId>
    122.             <version>${jooq.version}</version>
    123.         </dependency>
    125.         <dependency>
    126.             <groupId>org.jooq</groupId>
    127.             <artifactId>jooq-meta</artifactId>
    128.             <version>${jooq.version}</version>
    129.         </dependency>
    131.         <dependency>
    132.             <groupId>org.jooq</groupId>
    134.             <version>${jooq.version}</version>
    135.         </dependency>
    137.         <!-- Testing -->
    138.             <groupId>junit</groupId>
    139.             <artifactId>junit</artifactId>
    140.             <version>4.12</version>
    141.             <type>jar</type>
    142.             <scope>test</scope>
    143.         </dependency>
    145.         <dependency>
    146.             <groupId>org.springframework</groupId>
    147.             <artifactId>spring-test</artifactId>
    148.             <version>${spring.version}</version>
    149.             <scope>test</scope>
    150.         </dependency>
    152.     </dependencies>
    154.     <build>
    156.         <plugins>
    157.             <plugin>
    158.                 <groupId>org.eclipse.jetty</groupId>
    159.                 <artifactId>jetty-maven-plugin</artifactId>
    160.                 <version>9.4.12.v20180830</version>
    161.             </plugin>
    162.             <plugin>
    163.                 <groupId>org.apache.maven.plugins</groupId>
    164.                 <artifactId>maven-compiler-plugin</artifactId>
    165.                 <version>3.8.0</version>
    166.                 <configuration>
    167.                     <source>1.8</source>
    168.                     <target>1.8</target>
    169.                     <compilerArguments>
    170.                         <endorseddirs>${endorsed.dir}</endorseddirs>
    171.                     </compilerArguments>
    172.                 </configuration>
    173.             </plugin>
    174.             <plugin>
    175.                 <groupId>org.apache.maven.plugins</groupId>
    176.                 <artifactId>maven-war-plugin</artifactId>
    177.                 <version>3.2.2</version>
    178.                 <configuration>
    179.                     <failOnMissingWebXml>false</failOnMissingWebXml>
    180.                 </configuration>
    181.             </plugin>
    182.             <plugin>
    183.                 <groupId>org.apache.maven.plugins</groupId>
    184.                 <artifactId>maven-dependency-plugin</artifactId>
    185.                 <version>3.1.1</version>
    186.                 <executions>
    187.                     <execution>
    188.                         <phase>validate</phase>
    189.                         <goals>
    190.                             <goal>copy</goal>
    191.                         </goals>
    192.                         <configuration>
    193.                             <outputDirectory>${endorsed.dir}</outputDirectory>
    194.                             <silent>true</silent>
    195.                             <artifactItems>
    196.                                 <artifactItem>
    197.                                     <groupId>javax</groupId>
    198.                                     <artifactId>javaee-endorsed-api</artifactId>
    199.                                     <version>7.0</version>
    200.                                     <type>jar</type>
    201.                                 </artifactItem>
    202.                             </artifactItems>
    203.                         </configuration>
    204.                     </execution>
    205.                 </executions>
    206.             </plugin>
    207.         </plugins>

    After all the necessary dependencies have been fulfilled, a reload of the POM is recommended, to load all the necessary libraries and avoid errors that might otherwise occur while you are working on the project. This is how it is done in NetBeans:

    fbdevgd30 java 002 en