getFieldList()-获取OA表单全部字段

//获取OA表单字段
    public void getFieldList()
    {
        RecordSet rs=new RecordSet();
        String workflowid="";
        if(isNotBlank(I("workflowid")))
        {
            workflowid=I("workflowid");
        }

        if(isBlank(workflowid))
        {
            if(this.isNotBlank(I("requestid")))
            {
                String sql="select * from workflow_requestbase where requestid="+I("requestid");
                rs.executeQuery(sql);
                if(rs.next())
                {
                    workflowid=rs.getString("WORKFLOWID");
                }

            }
        }

        RecordSet rs2 = new RecordSet();
        StringBuilder sb=new StringBuilder();
        String cmdText="select * from workflow_billfield WHERE BILLID IN(select ID from workflow_bill WHERE TABLENAME IN(select TABLENAME from workflow_bill where ID IN(select FORMID from workflow_base where id="+(workflowid)+")))";
        rs.executeQuery(cmdText);
        StringBuilder sb2=new StringBuilder();
        sb.append("<script type='text/javascript'>");
        while (rs.next())
        {
            String LABELNAME="";
            rs2.executeQuery("select * from HtmlLabelInfo WHERE INDEXID="+rs.getString("FIELDLABEL"));
            if(rs2.next())
            {
                LABELNAME=rs2.getString("LABELNAME");
            }



            String FIELDNAME=rs.getString("FIELDNAME");
            String ID = rs.getString("ID");
            String var="var "+(FIELDNAME)+"='field"+(ID)+"';";
            sb.append(var);
            sb.append("console.log('"+LABELNAME+"===>"+FIELDNAME+"==>field"+ID+"');");
        }
        sb.append("console.log('"+cmdText+"');");
        sb.append("</script>");
        out.println(sb.toString());
    }