Page History

...

In this tutorial, we'll show you how to make a BeanShell Form Validator. This validator makes sure only values from another table are allowed. Simply put, it acts as a reverse duplicate value checker. We'll have two forms in our example app—one for inputting valid values (Form 1) and another (Form 2) where the validator will be added.

App Structure

Image RemovedImage Added

Figure 1: Form 1 Fields

Figure 2: Form 1 Details

Image RemovedImage Added

Figure 3: Form 2 Fields

...

Code Block

firstline	1
title	BeanShell
linenumbers	true

import org.joget.apps.form.service.FormUtil;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.sql.DataSource;
import org.joget.apps.app.service.AppUtil;
import org.joget.apps.form.model.Element;
import org.joget.apps.form.model.Form;
import org.joget.apps.form.model.FormData;
import org.joget.commons.util.LogUtil;

public boolean validate(Element element, FormData formData, String[] values) {
    boolean result = true;
 
    //get field values from form data object
    Form form = FormUtil.findRootForm(element);
    String locNameStringnameString = "locationNamename";
    Element locNameFieldnameField = FormUtil.findElement(locNameStringnameString, form, formData);
 
    if (locNameFieldnameField!=null) {
        //get value of fields
        String locNameValuenameValue = FormUtil.getElementPropertyValue(locNameFieldnameField, formData);
        Connection con = null;
        try {
            // retrieve connection from the default datasource
            DataSource ds = (DataSource)AppUtil.getApplicationContext().getBean("setupDataSource");
            con = ds.getConnection();
          
            // execute SQL query
            if(!con.isClosed()) {
                PreparedStatement stmt = con.prepareStatement("SELECT * FROM app_fd_test_tableInfo WHERE NOT EXISTS (SELECT 1 FROM app_fd_test_tableInfo WHERE c_field1=?)");
                stmt.setObject(1, locNameValuenameValue);
                ResultSet rs = stmt.executeQuery();
                if (rs.next()) {
                    result = false;
                }else{
                    result = true;
                }

            }
        } catch(Exception e) {
            LogUtil.error("Sample app - Form 1", e, "Error loading user data in load binder");
        } finally {
            //always close the connection after used
            try {
                if(con != null) {
                    con.close();
                }
            } catch(SQLException e) {/* ignored */}
        }
    }else{
        result = false;
    }
 
    return result;
}

//call validate method with injected variable
return validate(element, formData, values);