1-(E-teller)关于向T4Table组件返回多个对象的方法_avue table 返回多个值-优快云博客

该博客介绍了如何在Java中构建SQL查询以从数据库获取多个对象，并将这些对象返回给T4Table组件。通过设置查询条件，如日期范围和特定字段值，将查询结果转换为Object数组。在HTML文件中，展示了如何展示查询结果的特定字段，如‘分流结果’和‘诉讼日期’。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1-java文件：

public abstract void setCurrent(List current);

public abstract List getCurrent();

private Object[] result;
    public Object[] getSource()
    {
        query();
        return result;
    }

    public void query()
    {                                                  --------list(0)------ ---------list(1)--------
        String sql = "select * from dun_case_civil t,dun_case_main d where t.caseid =d.caseid and t.caseid "
                + "in (select s.caseid from dun_case_main s where s.casetype='0' and s.distributstatus = '1' )";

String con = null;
Map condition = new HashMap();

if (getRaisestartday() != null)
 {
 condition.put(TableFields.DUN_CASE_MAIN[3], ">=:"
 + (Function.dateToString(getRaisestartday())).substring(0,
 6));
 con = " and to_number(d.raiseday) >="
 + (Function.dateToString(getRaisestartday())).substring(0,
 6);
 }
 if (getRaiseEndDay() != null)
 {
 condition
 .put(TableFields.DUN_CASE_MAIN[3] + " ", "<=:"
 + (Function.dateToString(getRaiseEndDay()))
 .substring(0, 6));

con = " and to_number(d.raiseday) <="
 + (Function.dateToString(getRaiseEndDay())).substring(0, 6);
 }
 if (getCardno() != null)
 {
 condition.put(TableFields.DUN_CASE_MAIN[0], "like %" + getCardno()
 + "%");

con = " and d.cardno like %" + getCardno() + "%";
}

        if (con != null)
        {
            sql += con + ")";
        } else
        {
            sql += ")";
        } //list是存放List的List
            List list = getCommonManager().executeSQLQuery(sql);

result = new Object[list.size()];
 for (int i = 0; i < result.length; i++)
 {
 result[i] = list.get(i);
 }
 }

2-html文件

分流结果
<span jwcid="@InsertText"

value="ognl:current.get(0).casetypeView" />

诉讼日期
<span jwcid="@InsertText"

value="ognl:current.get(1).litigatedayView" />