java 解析xml 并导入数据库dom4j文档格式.docx
- 文档编号:16634507
- 上传时间:2022-11-25
- 格式:DOCX
- 页数:22
- 大小:21.04KB
java 解析xml 并导入数据库dom4j文档格式.docx
《java 解析xml 并导入数据库dom4j文档格式.docx》由会员分享,可在线阅读,更多相关《java 解析xml 并导入数据库dom4j文档格式.docx(22页珍藏版)》请在冰豆网上搜索。
/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.0"
encoding="
utf-8"
>
ACCESOS>
item>
SOCIO>
NUMERO>
00045050<
/NUMERO>
REPOSICION>
0<
/REPOSICION>
NOMBRE>
MOISESMORENO<
/NOMBRE>
TURNOS>
LU>
T1<
/LU>
MA>
T2<
/MA>
MI>
T3<
/MI>
JU>
T4<
/JU>
VI>
T5<
/VI>
SA>
T6<
/SA>
DO>
T7<
/DO>
/TURNOS>
/SOCIO>
/item>
00045051<
RUTHPENA<
S1<
S2<
S3<
S4<
S5<
S6<
S7<
/ACCESOS>
1、
package
myxml;
import
javax.xml.parsers.*;
org.w3c.dom.*;
org.apache.crimson.tree.*;
org.xml.sax.SAXException;
java.io.*;
public
class
DomParserDemo{
private
Document
doc;
public
DomParserDemo()
throws
Exception{
DocumentBuilderFactory
factory=DocumentBuilderFactory.newInstance();
DocumentBuilder
builder=factory.newDocumentBuilder();
String
source="
e:
/jhb1117/classes/xmldoc/candidate.xml"
doc=builder.parse(source);
}
void
showDocument()
{
//get
all
<
person>
NodeList
personList=doc.getElementsByTagName(XMLTagDir.NODE_PERSON);
//"
PERSON"
也可
,本文中为数据词典
for(int
i=0;
i<
personList.getLength();
i++)
//节点从0开始
Element
person=(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();
getNodeValue(Element
person,String
nodeName){
nameList=person.getElementsByTagName(nodeName);
name=(Element)nameList.item(0);
Text
text=(Text)name.getFirstChild();
value=text.getNodeValue();
return
value;
saveDocument(String
path)
IOException
FileWriter
fw=new
FileWriter(path);
XmlDocument
xmldoc=(XmlDocument)doc;
xmldoc.write(fw);
fw.close();
static
main(String
args[]){
try{
DomParserDemo
doc=new
DomParserDemo();
doc.showDocument();
//
path="
/houjie/JavaAdvance/dist/xmldoc/parseOut.xml"
/jhb1117/classes/xmldoc/jhbparseOut.xml"
doc.saveDocument(path);
System.out.print("
file
saved"
}catch(Exception
e){
e.printStackTrace();
}
2、
/**
*
p>
Title:
/p>
Description:
Copyright:
Copyright
(c)
2002<
Company:
@author
xxy
@version
1.0
*/
DomCreateDemo
DomCreateDemo()
doc=builder.newDocument();
createDocument(){
if(doc==null)
return;
peopleElement=doc.createElement(XMLTagDir.NODE_PEOPLE);
i=1;
=3;
i++){
personElement=doc.createElement(XMLTagDir.NODE_PERSON);
personElement.setAttribute("
PERSONID"
"
E"
+i);
//one
person
include
several
tags
text=null;
nameElement=doc.createElement(XMLTagDir.NODE_NAME);
text=doc.createTextNode("
myName"
nameElement.appendChild(text);
personElement.appendChild(nameElement);
addressElement=doc.createElement(XMLTagDir.NODE_ADDRESS);
myAddress"
addressElement.appendChild(text);
personElement.appendChild(addressElement);
telElement=doc.createElement(XMLTagDir.NODE_TEL);
myTel"
telElement.appendChild(text);
personElement.appendChild(telElement);
faxElement=doc.createElement(XMLTagDir.NODE_FAX);
myFax"
faxElement.appendChild(text);
personElement.appendChild(faxElement);
emailElement=doc.createElement(XMLTagDir.NODE_EMAIL);
myEmail"
emailElement.appendChild(text);
personElement.appendChild(emailElement);
peopleElement.appendChild(personElement);
doc.appendChild(peopleElement);
IOException
FileWriter
fout=new
XmlDocument
xmldoc.write(fout);
fout.close();
main(String[]
args)
doc
=
new
DomCreateDemo();
doc.createDocument();
doc
created"
/jhb1117/classes/xmldoc/jhbcreateOut.xml"
//
/houjie/JavaAdvance/dist/xmldoc/createOut.xml"
3、
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- java 解析xml 并导入数据库dom4j 解析 xml 导入 数据库 dom4j