您好,欢迎访问三七文档
当前位置:首页 > 建筑/环境 > 电气安装工程 > java 解析xml 并导入数据库(dom4j )
java解析xml并导入数据库(dom4j)importjava.io.File;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.util.Iterator;importjava.util.List;importorg.dom4j.Document;importorg.dom4j.Element;importorg.dom4j.io.SAXReader;publicclassTestXMLImport{/***@paramargs*/publicstaticvoidmain(String[]args){Stringsql=insertintoT_XML(NUMERO,REPOSICION,NOMBRE,TURNOS)values(?,?,?,?);Connectionconn=null;PreparedStatementpstmt=null;try{conn=DbUtil.getConnection();pstmt=conn.prepareStatement(sql);Documentdoc=newSAXReader().read(newFile(D:/share/JavaProjects/drp/test_xmlImport/xml/test01.XML));ListitemList=doc.selectNodes(/ACCESOS/item/SOCIO);for(Iteratoriter=itemList.iterator();iter.hasNext();){Elementel=(Element)iter.next();Stringnumero=el.elementText(NUMERO);Stringreposicion=el.elementText(REPOSICION);Stringnombre=el.elementText(NOMBRE);ListturnosList=el.elements(TURNOS);StringBuffersbString=newStringBuffer();for(Iteratoriter1=turnosList.iterator();iter1.hasNext();){ElementturnosElt=(Element)iter1.next();Stringlu=turnosElt.elementText(LU);Stringma=turnosElt.elementText(MA);Stringmi=turnosElt.elementText(MI);Stringju=turnosElt.elementText(JU);Stringvi=turnosElt.elementText(VI);Stringsa=turnosElt.elementText(SA);Stringdoo=turnosElt.elementText(DO);sbString.append(lu+,+ma+,+mi+,+ju+,+vi+,+sa+,+doo);}pstmt.setString(1,numero);pstmt.setString(2,reposicion);pstmt.setString(3,nombre);pstmt.setString(4,sbString.toString());pstmt.addBatch();}pstmt.executeBatch();System.out.println(将XML导入数据库成功!);}catch(Exceptione){e.printStackTrace();}finally{DbUtil.close(pstmt);DbUtil.close(conn);}}}---------------------------------------------------------------------------------------------------------------------------------?xmlversion=1.0encoding=utf-8?ACCESOSitemSOCIONUMERO00045050/NUMEROREPOSICION0/REPOSICIONNOMBREMOISESMORENO/NOMBRETURNOSLUT1/LUMAT2/MAMIT3/MIJUT4/JUVIT5/VISAT6/SADOT7/DO/TURNOS/SOCIO/itemitemSOCIONUMERO00045051/NUMEROREPOSICION0/REPOSICIONNOMBRERUTHPENA/NOMBRETURNOSLUS1/LUMAS2/MAMIS3/MIJUS4/JUVIS5/VISAS6/SADOS7/DO/TURNOS/SOCIO/item/ACCESOS1、packagemyxml;importjavax.xml.parsers.*;importorg.w3c.dom.*;importorg.apache.crimson.tree.*;importorg.xml.sax.SAXException;importjava.io.*;publicclassDomParserDemo{privateDocumentdoc;publicDomParserDemo()throwsException{DocumentBuilderFactoryfactory=DocumentBuilderFactory.newInstance();DocumentBuilderbuilder=factory.newDocumentBuilder();Stringsource=e:/jhb1117/classes/xmldoc/candidate.xml;doc=builder.parse(source);}publicvoidshowDocument(){//getallpersonNodeListpersonList=doc.getElementsByTagName(XMLTagDir.NODE_PERSON);//PERSON也可,本文中为数据词典for(inti=0;ipersonList.getLength();i++)//节点从0开始{Elementperson=(Element)personList.item(i);System.out.print(XMLTagDir.NODE_NAME+:);System.out.println(getNodeValue(person,XMLTagDir.NODE_NAME));System.out.print(XMLTagDir.NODE_ADDRESS+:);System.out.println(getNodeValue(person,XMLTagDir.NODE_ADDRESS));System.out.print(XMLTagDir.NODE_TEL+:);System.out.println(getNodeValue(person,XMLTagDir.NODE_TEL));System.out.print(XMLTagDir.NODE_FAX+:);System.out.println(getNodeValue(person,XMLTagDir.NODE_FAX));System.out.print(XMLTagDir.NODE_EMAIL+:);System.out.println(getNodeValue(person,XMLTagDir.NODE_EMAIL));System.out.println();}}publicStringgetNodeValue(Elementperson,StringnodeName){NodeListnameList=person.getElementsByTagName(nodeName);Elementname=(Element)nameList.item(0);Texttext=(Text)name.getFirstChild();Stringvalue=text.getNodeValue();returnvalue;}publicvoidsaveDocument(Stringpath)throwsIOException{FileWriterfw=newFileWriter(path);XmlDocumentxmldoc=(XmlDocument)doc;xmldoc.write(fw);fw.close();}publicstaticvoidmain(Stringargs[]){try{DomParserDemodoc=newDomParserDemo();doc.showDocument();//Stringpath=e:/houjie/JavaAdvance/dist/xmldoc/parseOut.xml;Stringpath=e:/jhb1117/classes/xmldoc/jhbparseOut.xml;doc.saveDocument(path);System.out.print(filesaved);}catch(Exceptione){e.printStackTrace();}}}2、packagemyxml;importjavax.xml.parsers.*;importorg.w3c.dom.*;importorg.apache.crimson.tree.*;importjava.io.*;/***pTitle:/p*pDescription:/p*pCopyright:Copyright(c)2002/p*pCompany:/p*@authorxxy*@version1.0*/publicclassDomCreateDemo{privateDocumentdoc;publicDomCreateDemo()throwsException{DocumentBuilderFactoryfactory=DocumentBuilderFactory.newInstance();DocumentBuilderbuilder=factory.newDocumentBuilder();doc=builder.newDocument();}publicvoidcreateDocument(){if(doc==null)return;ElementpeopleElement=doc.createElement(XMLTagDir.NODE_PEOPLE);for(inti=1;i=3;i++){ElementpersonElement=doc.createElement(XMLTagDir.NODE_PERSON);personElement.setAttribute(PERSONID,E+i);//onepersonincludeseveraltagsTexttext=null;ElementnameElement=doc.createElement(XMLTagDir.NODE_NAME);text=doc.createTextNode(myName+i);nameElement.appendChild(text);personElement.appendChild(nameElement);ElementaddressElement=doc.createElement(XMLTagDir.NODE_ADDRESS);text=doc.c
本文标题:java 解析xml 并导入数据库(dom4j )
链接地址:https://www.777doc.com/doc-4128530 .html