Joget DX 8 Stable Released
The stable release for Joget DX 8 is now available, with a focus on UX and Governance.
...
Code Block |
---|
import org.joget.apps.form.model.*; import org.joget.apps.form.service.*; import java.sql.*; import org.apache.commons.collections.SequencedHashMap; import java.util.*; import javax.sql.DataSource; public FormRowSet testgetRecords() { FormRowSet f = new FormRowSet(); f.setMultiRow(true); //Get Joget's current datasource configs DataSource ds = (DataSource) ClassAppUtil.forName("com.mysql.jdbc.Driver"getApplicationContext().newInstancegetBean("setupDataSource"); con = DriverManagerds.getConnection("jdbc:mysql://localhost:3307/jwdb?characterEncoding=UTF-8", "database username", "database password"); if (!con.isClosed()) { //Get the URL parameter String recordId = "#requestParam.id#"; // Get the url parameter //Here you can query from one or multiple tables using JOIN etc String sql = "SELECT * FROM testyour_table_name WHERE id=?"; // Here you can query from one or multiple tables using JOIN etc PreparedStatement stmt = con.prepareStatement(sql); stmt.setString(1, recordId); //Execute SQL statement ResultSet rs = stmt.executeQuery(); //Get value from columns of record(s) while (rs.next()) { FormRow r1 = new FormRow(); r1.put("gridColumn1", rs.getString(1)); r1.put("gridColumn1gridColumn2", rs.getString(2)); r1.put("gridColumn1gridColumn3", rs.getString(3)); f.add(r1); } } return f; } return testgetRecords(); |
Store Binder -> Bean Shell Form Binder
...
Correct Grid design should look like this:
part Part of load binder beanshell script :
Code Block | ||
---|---|---|
| ||
import org.joget.apps.form.model.FormRow; import org.joget.apps.form.model.FormRowSet; FormRowSet f = new FormRowSet(); f.setMultiRow(true); FormRow r1 = new FormRow(); r1.put("gridColumn1", your_value); r1.put("gridColumn2", your_value); r1.put("gridColumn3", your_value); f.add(r1); FormRow r2 = new FormRow(); r2.put("gridColumn1", your_value); r2.put("gridColumn2", your_value); r2.put("gridColumn3", your_value); f.add(r2); return f; |