public class QueryManager {
  static ResourceBundle res = ResourceBundle.getBundle("DBProperties");
  Database database1 = new Database();
  QueryDataSet qDS1 = new QueryDataSet();
  String query = "SELECT A.ses, A.usr, A.iph, A.ipa FROM sess as A";
  static String where;

  boolean prepareQuery() {
    try {
      database1.setConnection(new com.borland.dx.sql.dataset.
                              ConnectionDescriptor(res.getString("connect"),
          res.getString("user"), res.getString("password"), false,
          res.getString("driver")));
    }
    catch (Exception e) {
      e.printStackTrace();
      return false;
    }
    return true;
  }

  String executeQuery(String xmlUserPropertyes) {
    if (prepareQuery()) {
      try {
        Document doc = parseXml(xmlUserPropertyes, false);
        visit(doc,  0 , false);
        qDS1.setQuery(new com.borland.dx.sql.dataset.QueryDescriptor(database1,
            query + where, null, true, Load.ALL));
        database1.openConnection();
        qDS1.open();
        qDS1.executeQuery();
       // Проверка лигитимности сессии ********************
        if(qDS1.rowCount()>  0 ) System.out.println("Сессия лигитимна");
                       else System.out.println("Сессия не лигитимна");
      //**********************************************
        qDS1.close();
        database1.closeConnection();
      }
      catch (Exception e) {
        e.printStackTrace();
      }
    }
    return "Yes";
  }

  public static Document parseXml(String xml, boolean validating) {
    try {
      // Create a builder factory
      DocumentBuilderFactory factory = DocumentBuilderFactory.newInstance();
      factory.setValidating(validating);

      // Create the builder and parse the file
      Document doc = factory.newDocumentBuilder().parse(new InputSource(new
          StringReader(xml)));
      return doc;
    }
    catch (SAXException e) {
      // A parsing error occurred; the xml input is not valid
    }
    catch (ParserConfigurationException e) {
    }
    catch (IOException e) {
    }
    return null;
  }

  // This method visits all the nodes in a DOM tree
  public static void visit(Node node, int level, boolean ses) {
    // Process node

    // If there are any children, visit each one
    NodeList list = node.getChildNodes();

    for (int i =  0 ; i < list.getLength(); i++) {
      // Get child node
      Node childNode = list.item(i);
      if (list.item(i).getNodeName().equals("ses")) {
        visit(childNode, level +  1 , true);
      }
      if (ses) {
        if (list.item(i).getNodeName().equals("#text")) {
          where = " WHERE A.ses = '" + list.item(i).toString() + "' ";
          visit(childNode, level +  1 , false);
        }

      }
      // Visit child node
      visit(childNode, level +  1 , false);

    }
  }
}

// Это шаблон 
//<pattern>
//    <row>
//      <ses> 212 </ses>
//      <usr> 2 </usr>
//      <ip1> 192 . 168 . 0 . 11 </ip1>
//      <ip2> 192 . 168 . 0 . 11 </ip2>
//    </row>
//  </pattern>
Document doc1 = parseXmlFile("pattern.xml", false);
    NodeList list = doc1.getElementsByTagName("row");
    Element element = (Element)list.item( 0 );
    
    // Create another document
    Document doc2 = parseXmlFile("infilename2.xml", false);
    
    // Make a copy of the element subtree suitable for inserting into doc2
    Node dup = doc2.importNode(element, true);
    
    // Insert the copy into doc2
    doc2.getDocumentElement().appendChild(dup);