This page shows two ways how to fill separatorlist or Formlist
Java
To do this, all we have to do is the same step shown above, except in step 2 ... instead of the above code, put this code, with a small detail, the class Teste is a DAO class created earlier (click here to see how do that) [Fig. Class DAO]
public Response actionIndex() throws IOException, IllegalArgumentException, IllegalAccessException{
Page_home model = new Page_home();
model.load();
Page_homeView view = new Page_homeView();
/*----#start-code(index)----*/
Teste teste = new Teste();
List<Teste> lista_teste = teste.findAll();
ArrayList<Page_home.Separatorlist_1> lista_final = new ArrayList<>();
for(Teste lista: lista_teste) {
Page_home.Separatorlist_1 separa = new Page_home.Separatorlist_1();
separa.setMae(new Pair(lista.getMae(),lista.getMae()));
separa.setPai(new Pair(lista.getPai(),lista.getPai()));
separa.setIdade(new Pair(lista.getIdade()+"",lista.getIdade()+""));
separa.setNome(new Pair(lista.getNome(),lista.getNome()));
lista_final.add(separa);
}
model.setSeparatorlist_1(lista_final);
/*----#end-code----*/
view.setModel(model);
return this.renderView(view);
}
SQL
Step 1: First of all, create your application and connect to your database, create your page and put a separator list [Fig. 1]
Step 2: Then, click "JAVA" and your controller put this code below, specify your connection name [ex. teste_isac_pg_1] and your select [ex. SELECT nome as nome, pai as nome_de_pai, mae as nome_da_mae, idade as idade FROM public.teste]
public class Insert_fotoController extends Controller {
public Response actionIndex() throws IOException, IllegalArgumentException, IllegalAccessException{
Insert_foto model = new Insert_foto();
model.load();
Insert_fotoView view = new Insert_fotoView();
/*----#start-code(index)----*/
model.loadSeparatorlist_1(Core.query("teste_isac_pg_1","SELECT nome as nome, pai as nome_de_pai, mae as nome_da_mae, idade as idade FROM public.teste "));
/*----#end-code----*/
view.setModel(model);
return this.renderView(view);
}
/*----#start-code(custom_actions)----*/
/*----#end-code----*/
}
and voilá [Fig. 2]... it's show the data is stored in test database[Fig. 3]