How to retrieve both Elements & Attributes at the sametime in XPath

<?xml version="1.0" encoding="iso-8859-1" ?>

<organisation>

<employee>

<personal id="10000" password="abc123">John Smith</personal>

<personal id="20000" password="def123">Adam Jones</personal>

<personal id="30000" password="ghi123">Jade Brown</personal>

<personal id="40000" password="jkl123">Larry Dolton</personal>

<personal id="50000" password="mno123">Rodney White</personal>

<personal id="60000" password="pqr123">George Green</personal>

.....

</employee>

</organization>

Some of the XPath statements attempted are as follows:

( i ) java.util.List employeePersonalDetail = XPath.selectNodes(EmployeeXMLDocument, "/organization/employee/personal");

Iterator iterator = employeePersonalDetail.iterator();

while (iterator.hasNext())

System.out.println(((org.jdom.Element)iterator.next()).getTextNormalize());

Output

John Smith

Adam Jones

Jade Brown

Larry Dolton

Rodney White

George Green

( ii ) java.util.List employeePersonalDetail = XPath.selectNodes(EmployeeXMLDocument, "/organization/employee/personal/@id*")

Iterator iterator = employeePersonalDetail.iterator();

while (iterator.hasNext())

System.out.println(((org.jdom.Attribute)iterator.next()).getValue);

Output

10000

20000

30000

40000

50000

60000

( iii ) java.util.List employeePersonalDetail = XPath.selectNodes(EmployeeXMLDocument, "/organization/employee/personal/@password*")

Iterator iterator = employeePersonalDetail.iterator();

while (iterator.hasNext())

System.out.println(((org.jdom.Attribute)iterator.next()).getValue);

Output

abc123

def123

ghi123

jkl123

mno123

pqr123

( iv ) java.util.List employeePersonalDetail = XPath.selectNodes(EmployeeXMLDocument, "/organization/employee/personal/@id* | /organization/employee/personal/@password")

Iterator iterator = employeePersonalDetail.iterator();

while (iterator.hasNext())

System.out.println(((org.jdom.Attribute)iterator.next()).getValue);

Output

10000

20000

30000

40000

50000

60000

abc123

def123

ghi123

jkl123

mno123

pqr123

However, I would like to get the following output instead:

10000

abc123

20000

def123

30000

ghi123

40000

jkl123

50000

mno123

60000

pqr123

( v ) java.util.List employeePersonalDetail = XPath.selectNodes(EmployeeXMLDocument, "/organization/employee/personal | /organization/employee/personal/@id*");

Iterator iterator = employeePersonalDetail.iterator();

while (iterator.hasNext()) {

System.out.println(((org.jdom.Element)area_iterator.next()).getTextNormalize());

System.out.println(((org.jdom.Attribute)area_iterator.next()).getValue());

}

Output

Exception in thread "main" java.lang.ClassCastException: org.jdom.Element cannot be cast to org.jdom.Attribute.

I would like to get the following output though:

John Smith

10000

Adam Jones

20000

Jade Brown

30000

Larry Dolton

40000

Rodney White

50000

George Green

60000

I would like to stay away from having to use transformation as much as possible due to lack of knowledge in that area.

I would very much appreciated if you could help with achieving XPath searches ( iv ) and ( v ).

Many thanks,

Jack