how to inject load binder bean shell values into custom html ?
Confluence User - 18 May, 2020
I've written a load binder using bean shell. In this code, I'm fetching values from local DB and inserting into form fields.
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 org.apache.commons.collections.SequencedHashMap;
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.FormData;
import org.joget.apps.form.model.FormRow;
import org.joget.apps.form.model.FormRowSet;
public FormRowSet getData() {
FormRowSet results = null;
if (results == null) {
results = new FormRowSet();
results.setMultiRow(true);
Connection con = null;
try {
//wait okay
Class.forName("com.mysql.jdbc.Driver").newInstance();
con = DriverManager.getConnection("jdbc:mysql://localhost:3306/joget", "root", "root");
if(!con.isClosed()){
String sql = "SELECT id, address, state, pin, cmanager, DATE_FORMAT(date, '%M %d, %Y') FROM address NATURAL JOIN cmanager WHERE Id = #form.bd1.value#;";
PreparedStatement stmt = con.prepareStatement(sql);
ResultSet rs = stmt.executeQuery();
while (rs.next()) {FormRow row = new FormRow();
row.put("id", (rs.getString(1) != null)?rs.getString(1):"");
row.put("address", (rs.getString(2) != null)?rs.getString(2):"");
row.put("state", (rs.getString(3) != null)?rs.getString(3):"");
row.put("pincode", (rs.getString(4) != null)?rs.getString(4):"");
row.put("manager", (rs.getString(5) != null)?rs.getString(5):"");
row.put("date", (rs.getString(6) != null)?rs.getString(6):"");
results.add(row);
}
}
} catch(Exception ex) {
System.err.println("------------------>Beanshell Error" + ex.getMessage());
} finally {
try {
if(con != null)
con.close();
} catch(SQLException e) {}
}
}
return results;
}
return getData();
}
return test();
As this code is getting inserted into form fields.
But I also want to insert the same values into custom HTML. Is it possible to insert the values into custom HTML using bean shell? Suggest me what changes do I need to make in the code to insert the values into HTML tags ?
Thankyou !!!
forms;beanshell;html;customcode