Alguem pode me ajudar como eu posso ler do arquivo xml os int e colocar no arquivo csv?
public static void main(String argv[]) {
int peso = 0;
float pesoHulk = 0;
float altura = 0;
try {
File fXmlFile = new File("/home/kati/Dropbox/UTFPR/Introdução a bancos de dados/db201702/01 - Modelos de dados e XML/marvel_simplificado.xml");
DocumentBuilderFactory dbFactory = DocumentBuilderFactory.newInstance();
DocumentBuilder dBuilder = dbFactory.newDocumentBuilder();
Document doc = dBuilder.parse(fXmlFile);
doc.getDocumentElement().normalize();
System.out.println("Root element :" + doc.getDocumentElement().getNodeName());
NodeList nList = doc.getElementsByTagName("hero");
System.out.println("----------------------------");
//Criando o diretório dadosMarvel
File dadosMarvel = new File("/home/kati/Dropbox/UTFPR/Introdução a bancos de dados/db201702/01 - Modelos de dados e XML");
dadosMarvel.mkdir();
//Criando arquivo csv em dados tabulares
FileWriter herois = new FileWriter("/home/kati/Dropbox/UTFPR/Introdução a bancos de dados/db201702/01 - Modelos de dados e XML/dadosMarvel/herois.csv");
PrintWriter gravar_herois = new PrintWriter(herois);
FileWriter herois_good = new FileWriter("/home/kati/Dropbox/UTFPR/Introdução a bancos de dados/db201702/01 - Modelos de dados e XML/dadosMarvel/herois_good.csv");
PrintWriter gravar_herois_good = new PrintWriter(herois_good);
FileWriter herois_bad = new FileWriter("/home/kati/Dropbox/UTFPR/Introdução a bancos de dados/db201702/01 - Modelos de dados e XML/dadosMarvel/herois_bad.csv");
PrintWriter gravar_herois_bad = new PrintWriter(herois_bad);
for (int temp = 0; temp < nList.getLength(); temp++) {
Node nNode = nList.item(temp);
System.out.println("\nCurrent Element :" + nNode.getNodeName());
if (nNode.getNodeType() == Node.ELEMENT_NODE) {
Element eElement = (Element) nNode;
System.out.println("ID : " + eElement.getAttribute("id"));
System.out.println("Name : " + eElement.getElementsByTagName("name").item(0).getTextContent());
gravar_herois.printf(eElement.getAttribute("id") + ", " + eElement.getElementsByTagName("name").item(0).getTextContent() + ", "
+ eElement.getAttribute("popularity") + ", " + eElement.getElementsByTagName("alignment").item(0).getTextContent() + ", "
+ eElement.getElementsByTagName("gender").item(0).getTextContent() + ", " + eElement.getAttribute("height_m") + ", "
+ eElement.getAttribute("weight_kg") + ", " + eElement.getElementsByTagName("hometown").item(0).getTextContent() + ", "
+ eElement.getAttribute("intelligence") + ", " + eElement.getAttribute("strength") + ", " + eElement.getAttribute("durability") + ", "
+ eElement.getAttribute("energy_Projection") + ", " + eElement.getAttribute("fighting_Skills") + "\n");
herois.close();
Arquivo XML:
<?xml version="1.0" encoding="utf-8"?>
<universe name="Marvel Universe">
<hero id="1">
<name>Spider Man</name>
<popularity>1</popularity>
<alignment>Good</alignment>
<gender>Male</gender>
<height_m>2</height_m>
<weight_kg>76</weight_kg>
<hometown>USA</hometown>
<intelligence>4</intelligence>
<strength>4</strength>
<speed>3</speed>
<durability>3</durability>
<energy_Projection>1</energy_Projection>
<fighting_Skills>4</fighting_Skills>
</hero>