I'm not sure on what you are trying to achieve. There is no need for you to code in Java for this plugin.

Please see the screenshots in the plugin page itself. https://marketplace.joget.org/jw/web/userview/mp/mpp/_/vad?id=jdbc_options_binder-v1

Hope this helps.

I wrote wrong title, the JDBC Binder does not work in the list 。

hello,

you can try this code for select option in list builder use bean shell

import org.joget.apps.form.model.*;

import org.joget.apps.form.service.*;

import org.joget.apps.app.service.*;

import org.joget.apps.form.model.*;

import org.joget.apps.form.service.*;

import java.sql.*;

import java.util.*;

import javax.sql.DataSource;

public FormRowSet getData() {

    results = new FormRowSet();

    Connection con = null;

        try {

            DataSource ds = (DataSource) AppUtil.getApplicationContext().getBean("setupDataSource");

            con = ds.getConnection();

            if(!con.isClosed()){

                String sql = "SELECT id,c_name FROM app_fd_sm_plant";

                PreparedStatement stmt = con.prepareStatement(sql);

                ResultSet rs = stmt.executeQuery();

                while (rs.next()) {

                    FormRow row = new FormRow();

                    row.put(FormUtil.PROPERTY_VALUE, rs.getString(1));

                    row.put(FormUtil.PROPERTY_LABEL, rs.getString(1) + " - " + rs.getString(2));

                    results.add(row);

                }

            }

        } catch(Exception ex) {

            System.err.println("Exception: " + ex.getMessage());

        } finally {

            try {

                if(con != null)

                    con.close();

            } catch(SQLException e) {}

        }

    return results;

}

return getData();