XmlElement whereElement_1 = new XmlElement("where");
XmlElement ifElement_1 = new XmlElement("if");
ifElement_1.addAttribute(new Attribute("test",
"startIndex != null and pageSize != null"));
ifElement_1.addElement(new TextElement(
"rownum <= (${startIndex} + ${pageSize})"));
whereElement_1.addElement(ifElement_1);
element.addElement(whereElement_1);
element.addElement(new TextElement(")"));