Creating Java WebApp and JDBC

Last updated: 2025-09-14

J-Framework Web project simplifies building Java database driven web applications based on JSF and PrimeFaces and JDBC. This example will create CRUD (Create, Read, Update, Delete) operations of Person information.

Steps:

  1. Create Maven project with the following pom.xml:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/pom.xml[]

If you are using Eclipse, be sure to refresh your project (select your project→ right click→ Maven→ Update Project)

  1. Create database script file and place at src/main/resources/script.sql with the following contents:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/src/main/resources/script.sql[]

  1. [Optional] Create config file at src/main/resources/config.properties with the following contents:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/src/main/resources/config.properties[]

  1. Create Model class at src/main/java/com/app/person/Model.java with the following contents:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/src/main/java/com/app/person/Model.java[]

  1. Create DataAccess class at src/main/java/com/app/person/DataAccess.java with the following contents:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/src/main/java/com/app/person/DataAccess.java[]

  1. Create controller (JSF Managed Bean) at src/main/java/com/app/person/Controller.java with the following contents:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/src/main/java/com/app/person/Controller.java[]

  1. Create JSF XHTML Page at src/main/webapp/index.xhtml class with the following contents:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/src/main/webapp/full.xhtml[]

  1. Create App class at src/main/java/com/app/App.java with the following contents:

Unresolved include directive in modules/6.x.x/pages/frameworks/jk-framework/jk-framework-webstack/java-web-jsf-jdbc-tutorial.adoc - include::inc/jdbc/src/main/java/com/app/App.java[]

Thats it, now run your App class, in few seconds your browser will open and you should see something like this:

Output

Full example source-code can be found at https://github.com/smartapi-com/j-framework-web-jdbc