How to remove an Element from XML by confirming Attribute of that element

[sezanawa]

Hi guys

I have an XML file where i have all users DB. Now i want to remove a user from that XML file. I want to check an user id attribute which is uniqe with existing users in XML file, if its the same user then delete this user from XML file and save the changes in XML file.

here is my XML file:
[HTML]
<?xml version="1.0" encoding="UTF-8"?>
<users>
<user id="zahid" password="X8UrUN79avT27LYwUESiliAV328=" name="Zahid Nawaz" phone="9599808" email="[e-mail]" role="Tnr+vPuuAAsix8heVWD4mioCgLQ=" />
<user id="Admin" name="alpha beta" password="fEqNCco3Yq9h5ZUglD3CZJT4lBs=" phone="456782656" email="[e-mail]" role="Tnr+vPuuAAsix8heVWD4mioCgLQ=" />
<user id="Guest" name="beta alpha" password="+ml3yZuAnbaOHFaIjsOL0ARxmzk=" phone="8765432" email="[e-mail]" role="+s6D7jAUvcj5ggPMlOLokiJFLpA=" />
<user id="Guest1" name="unknown unknown" password="+ml3yZuAnbaOHFaIjsOL0ARxmzk=" phone="123122112" email="[e-mail]" role="+s6D7jAUvcj5ggPMlOLokiJFLpA=" /></users>

[/HTML]


for example i want to delete a user which have user id= Guest.

How can i do it in Java. Any code example please. i am using JDOM document and SAXBuilder for parsing.

Waiting for your replay.

Thanks in Advance

Best regard

[sezanawa]

Hi,

Well after waiting a week where nobody has written back me. I started digging into XML, Jdom library. There i find very simple solution for deleting an element from XML file by confirming its attribute value.here i am posting my solution.

public boolean removeUserByID(String id){
        String fileName = "C:/users.xml";
        SAXBuilder builder = new SAXBuilder();
        Document doc = builder.build(fileName );
        Element root = doc.getRootElement();
        Iterator userListe = root.getChildren("user").iterator();
        while (userListe.hasNext()) {
            Element eUser = (Element) userListe.next();
            if(eUser.getAttribute("id").getValue().equals(id)){
 
                root.removeContent(eUser);
                saveInFile(fileName, doc);
                return true;
            }
        }
        return false;
    }
 
 
 public String saveList(String fileName, Document doc) {
        try {
            FileOutputStream fos = new FileOutputStream(fileName);
            XMLOutputter out = new XMLOutputter();
            out.output(doc, fos);
            return "true";
 
        } catch (Exception e) {
            return "false";
        }
    }
 

So its the whole code to delete and save back in xml file

bye