Java and PostgreSQL Web Application Part 7

Introduction

Welcome to Part 7 of the multiple-series that explains how to build a Java PostgreSQL web application from scratch with ECLIPSE, Spring Data, Tomcat, and other databases. Part 6 discussed how to use the handler to link information in a database and then display table records on the home page of your web application. Let’s proceed with using handlers to add different features to your web application.

Prerequisites

• Read and practice the examples shown in Parts 1 through 6 of the multiple-series tutorial. Here are the links:

• Java and PostgreSQL web Application PART 1

• Java and PostgreSQL web Application PART 2
• Java and PostgreSQL web Application PART 3
• Java and PostgreSQL web Application PART 4
• Java and PostgreSQL web Application PART 5
• Java and PostgreSQL web Application PART 6

Coding the Java and PostgreSQL Web Application’s Feature

Here in Part 7, you’ll continue to learn how to use handlers to add features. Specifically, you’ll find out how to create and insert records into the database for your web application.

Creating New Record in Java and PostgreSQL Web Application

Enter the controller class CarsController to make a view and a couple of handlers. They’ handlers will be used to generate a new database table record.

Use this code here:

Based on the code above, the _createcar name for your application’s view will be returned.

You also added the object Cars that is empty.

Also, we put the empty Cars object because it’s new.

• Now that you have a view file, create a file JSP to go with it. Call it “create_car.jsp”. Use this code to accomplish that:

• You can handle the values in forms automatically with the <%@ taglib prefix="form" uri="http://www.springframework.org/tags/form"%> Spring framework tag for your forms. Use the code below to get that done:

Here’s some more information about what you just achieved with the above code:

• The object now has the values saved to it since the ModelAttribute specifically states the name of the attribute that is to be saved.

• You’re all prepared to finish adding the functionality to create a new record because “save” is the setting for the action of the form. A handler must be created for it now. Earlier in today’s lesson, you already created one handler for your application, so this would be the second one.

• Access the controller class CarsController again, and add this code:

• The above code sets the annotation @RequestMapping like this @RequestMapping(value = "/save", method = RequestMethod.POST) because the form has the value.

• In addition, don’t forget that the “cars” annotation for @ModelAttribute has to be specified in your form.

• Next, the Spring model-view-controller (MVC) is able to read the object values of Cars cars instantly when the object Cars cars is indicated.

NOTE: A variety of methods have been specified in Java and PostgreSQL web Application PART 5.

• Here’s a method that was reviewed in Part 5 of this multiple-series tutorial:

• Use this code: service.save(cars); to make a function call in the controller class.

• Save the database record.

• Input the code: return "redirect:/"; to get back to your index.jsp home page.

• Save it.

• Execute the application to test it out.

• Your result should resemble this one below:

• To carry out the database function INSERT, and then redirect immediately to the home page and show the updated records, press the button Save.

• The result should be something like this:

• Confirm the success of the action with the operation SELECT while in a PostgreSQL shell.

• Your result should resemble this:

Conclusion

This completes Part 7 of PostgreSQL web application that explains how to create a web application from scratch with Java using ECLIPSE IDE, Spring Data JPA, Spring MVC, Tomcat and PostgreSQL as the database. In this tutorial, you learned how to configure the class controller to create a new record and insert it into a PostgreSQL database. You used handlers to add this feature. As a refresher, refer to the Prerequisites section for this multiple-series tutorial, which includes links to Parts 1 through 6. Also, review this lesson again any time you want, and then proceed to Part 8 of Java and PostgreSQL Web Application.