public String QuerySQL(String xmlStr) { String outstr = ""; Document doc; Element rootNode; String intStr = Basic.decode(xmlStr); try { Reader reader = new StringReader(intStr); SAXBuilder ss = new SAXBuilder(); doc = ss.build(reader); rootNode = doc.getRootElement(); String SqlStr = "select " + rootNode.getAttributeValue("fieldStr"); SqlStr = SqlStr + " from " + rootNode.getAttributeValue("tableStr"); SqlStr = SqlStr + " where (1=1) " + rootNode.getAttributeValue("whereStr"); DBTable datatable = new DBTable(); RecordSet rs = datatable.queryData(SqlStr); String[] fieldArr = rootNode.getAttributeValue("fieldStr").split(","); outstr = "<queryDataS success=\"true\">"; while (rs.next()) { outstr = outstr + "<queryData"; for (int i = 0; i < fieldArr.length; i++) { outstr = outstr + " " + fieldArr[i].trim() + "=\"" + rs.getString(fieldArr[i].trim()) + "\""; } outstr = outstr + "/>"; } outstr = outstr + "</queryDataS>"; } catch (JDOMException ex) { outstr = "<queryDataS success=false>"; outstr = outstr + ex.getMessage() + "</queryDataS>"; } return Basic.encode(outstr); }