Page History

import org.joget.apps.form.model.*;
import org.joget.apps.form.service.*;
import java.sqlorg.joget.apps.app.service.*;
import orgjava.apache.commons.collections.SequencedHashMapsql.*;
import java.util.*;

public FormRowSet test() {
	import javax.sql.*;

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 the SELECT 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;
}con.close();
return test()f;